Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
MESSAGE	Indicates an action taken on the document for any of the status indicators. As an example, the invoice API for a reimbursement or the encumbrance API for an authorization may fail. That message needs to be recorded so that some form of action may be taken.	VARCHAR2(4000)	FTRRSTHS	MESSAGE
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
PORTFOLIO	System generated code identifying the portfolio. The prefix is defined by the client for system ID TRAVPORT in the table fobfseq.	VARCHAR2(63)	FTPBPORT	PORTFOLIO_NUMBER
PORTFOLIO_KEY	Unique internal identification number of the portfolio record.	NUMBER	FTRBREMB	FTPBPORT_ID
PORTFOLIO_NAME	Name assigned to the Portfolio. As an example, Office expenses for year 2008 or Recruiting Trip in Southern California.	VARCHAR2(63)	FTPBPORT	NAME
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
REIMBURSEMENT	System generated code identifying the reimbursement. The prefix is defined by the client for system ID TRAVREIM in the table fobfseq.	VARCHAR2(63)	FTRBREMB	DOC_CODE
REIMBURSEMENT_DESC	Reimbursement request description.	VARCHAR2(255)	FTRBREMB	DESCRIPTION
REIMBURSEMENT_KEY	Unique internal identification number of the reimbursement record.	NUMBER	FTRRSTHS	FTRBREMB_ID
REIMBURSEMENT_STATUS	Reimbursement request status.	VARCHAR2(63)	FTRRSTHS	STATUS
REIMBURSEMENT_STATUS_DATE	Date and time the status was updated.	DATE	FTRRSTHS	STATUS_DATE
REIMBURSEMENT_STATUS_DESC	Reimbursement request status description.	VARCHAR2(255)	FUNCTION	SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'REQUEST_STATUS' AND VALUE = REIMBURSEMENT_STATUS
STATUS_CHANGE_HOURS	Amount of time in hours between the prior status date and this status date.	NUMBER	FUNCTION	MEKFUNC.F_STATUS_CHANGE_HOURS(REIMBURSEMENT_KEY, STATUS_DATE, 'R', 'L')
STATUS_CHANGE_HOURS_TOTAL	Amount of time in hours between the first established status date and this status date.	NUMBER	FUNCTION	MEKFUNC.F_STATUS_CHANGE_HOURS(REIMBURSEMENT_KEY, STATUS_DATE, 'R', 'T')
STATUS_HISTORY_ACTIVITY_DATE	Date information for this record in the table was entered or last updated.	DATE	FTRRSTHS	ACTIVITY_DATE
STATUS_HISTORY_DATA_ORIGIN	Source system that created or updated the data.	VARCHAR2(63)	FTRRSTHS	DATA_ORIGIN
STATUS_HISTORY_USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	FTRRSTHS	USER_ID

Ver: 9.1