Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ADVANCE_STATUS	Advance Status		VARCHAR2(1)
ADVANCE_STATUS_DESC	Advance Status Description		VARCHAR2(4000)
AFFILIATION_KEY	Affiliation KEY		NUMBER
AUTHORIZATION	Authorization	System generated code identifying the authorization. The prefix is defined by the client for system ID TRAVAUTH in the table fobfseq.	VARCHAR2(8)		FTRBAUTH	DOC_CODE
AUTHORIZATION_ACTIVITY_DATE	Authorization Activity Date	Date information for this record in the table was entered or last updated.	DATE		FTRBAUTH	ACTIVITY_DATE
AUTHORIZATION_COMMENT	Authorization Comment	Free-form comment for the authorization.	VARCHAR2(4000)		FTRBAUTH	USER_COMMENT
AUTHORIZATION_COMPLETE_USER	Authorization Completion User	Banner ID of the person who completed this reimbursement.	VARCHAR2(30)		FTRBAUTH	COMPLETE_USER
AUTHORIZATION_CREATE_DATE	Authorization Create Date	Date and time when the new reimbursement record was created.	DATE		FTRBAUTH	CREATE_DATE
AUTHORIZATION_CREATE_SOURCE	Authorization Create Source	Source system that created the data.	VARCHAR2(30)		FTRBAUTH	CREATE_SOURCE
AUTHORIZATION_CREATE_USER	Authorization Create User	Banner ID of the person who created this new record.	VARCHAR2(30)		FTRBAUTH	CREATE_USER
AUTHORIZATION_DATA_ORIGIN	Authorization Data Origin	Source system that created or updated the data.	VARCHAR2(30)		FTRBAUTH	DATA_ORIGIN
AUTHORIZATION_DESC	Authorization Description	Authorization request description.	VARCHAR2(255)		FTRBAUTH	DESCRIPTION
AUTHORIZATION_KEY	Authorization KEY	Unique internal identification number of the authorization record.	NUMBER(19)		FTRBAUTH	ID
AUTHORIZATION_STATUS	Authorization Status	Authorization request status.	VARCHAR2(1)		FTRBAUTH	REQUEST_STATUS
AUTHORIZATION_STATUS_DATE	Authorization Status Date	Date and time the status was updated.	DATE		FTRBAUTH	STATUS_DATE
AUTHORIZATION_USER_ID	Authorization User ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)		FTRBAUTH	USER_ID
CURRENT_DATE	Current Date	SYSDATE	DATE		FUNCTION	SYSDATE
DELEGATE_UID	Delegate UID		NUMBER
DOMAIN_VALUE	Domain Value	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA
MIF_DESC	MIF Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)		NA	NA
MIF_VALUE	MIF Value	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)		NA	NA
OUTSTANDING_ADVANCE_AMOUNT	Outstanding Advance Amount		NUMBER
OWNER_EMAIL	Owner Email	Email address of the expense owner as contact information for workflow approvals.	VARCHAR2(128)		FTRBAUTH	EMAIL_ADDRESS
OWNER_UID	Owner UID	Personal identification number of the expense owner when the funding source is saved as part of the profile.	NUMBER(8)		FTRBAUTH	OWNER_PIDM
PORTFOLIO_KEY	Portfolio KEY	Unique internal identification number of the portfolio record.	NUMBER(19)		FTRBAUTH	FTPBPORT_ID
REPORT_NAME	Report Name	Owner assigned expense report name.	VARCHAR2(60)		FTRBAUTH	NAME
REVIEW_SUBMIT_DATE	Review Submit Date		TIMESTAMP(6)
TRANSACTION_DATE	Transaction Date	Date used to post the invoice into the ledgers for payment, determining the fiscal year and posting period. Represents the create date of the reimbursement.	DATE		FTRBAUTH	TRANSACTION_DATE
TRAVELER_AFFILIATION	Traveler Affiliation		VARCHAR2(25)
TRAVELER_AFFILIATION_DESC	Traveler Affiliation Description		VARCHAR2(255)
ZONE_VALUE	Zone Value	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: