Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
AFFILIATION_KEY	Affiliation KEY		NUMBER
CURRENCY_DESC	Currency Description	Currency code description or title.	VARCHAR2(35)		GUACURR	GTVCURR_TITLE
CURRENCY_KEY	Currency KEY		NUMBER
CURRENT_DATE	Current Date	SYSDATE	DATE		FUNCTION	SYSDATE
DELEGATE_UID	Delegate UID		NUMBER
DIRECT_DEPOSIT_OVERRIDE_IND	Direct Deposit Override Indicator	Indicates if the reimbursement will be paid with a check versus direct deposit when the expense owner is set up for direct deposit. (Y)es, override the direct deposit and pay with a check. (N)o, do not override the direct deposit.	VARCHAR2(1)		FTRBREMB	DIRECT_DEPOSIT_OVERRIDE_IND
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
OWNER_ADDRESS_NUMBER	Owner Address Number	Sequence used to identify different addresses within the same address type.	NUMBER(2)		FTRBREMB	OWNER_ADDRESS_SEQ_NUM
OWNER_ADDRESS_TYPE	Owner Address Type	Unique code used with a sequence number to determine the actual address of the expense owner.	VARCHAR2(2)		FTRBREMB	OWNER_ADDRESS_TYPE_CODE
OWNER_EMAIL	Owner Email	Email address of the expense owner as contact information for workflow approvals.	VARCHAR2(128)		FTRBREMB	EMAIL_ADDRESS
OWNER_UID	Owner UID	Personal identification number of the expense owner.	NUMBER(8)		FTRBREMB	OWNER_PIDM
PAYEE_ADDRESS_NUMBER	Payee Address Number	Sequence used to identify different addresses within the same address type.	NUMBER(2)		FTRBREMB	PAYEE_ADDRESS_SEQ_NUM
PAYEE_ADDRESS_TYPE	Payee Address Type	Unique code use with a sequence number to determine the actual address of the expense payee.	VARCHAR2(2)		FTRBREMB	PAYEE_ADDRESS_TYPE_CODE
PAYEE_UID	Payee UID	Personal identification number of the payee when the funding source is saved as part of the profile. This is who the check will be cut to for the invoice.	NUMBER(8)		FTRBREMB	PAYEE_PIDM
PAY_CURRENCY_EXCHANGE_RATE	Pay Currency Exchange Rate		NUMBER
PORTFOLIO_KEY	Portfolio KEY	Unique internal identification number of the portfolio record.	NUMBER(19)		FTRBREMB	FTPBPORT_ID
REIMBURSEMENT	Reimbursement	System generated code identifying the reimbursement. The prefix is defined by the client for system ID TRAVREIM in the table fobfseq.	VARCHAR2(8)		FTRBREMB	DOC_CODE
REIMBURSEMENT_ACTIVITY_DATE	Reimbursement Activity Date	Date information for this record in the table was entered or last updated.	DATE		FTRBREMB	ACTIVITY_DATE
REIMBURSEMENT_COMMENT	Reimbursement Comment	Free-form comment for the reimbursement.	VARCHAR2(4000)		FTRBREMB	USER_COMMENT
REIMBURSEMENT_COMPLETE_USER	Reimbursement Completion User	Banner ID of the person who completed this reimbursement.	VARCHAR2(30)		FTRBREMB	COMPLETE_USER
REIMBURSEMENT_CREATE_DATE	Reimbursement Create Date	Date and time when the new reimbursement record was created.	DATE		FTRBREMB	CREATE_DATE
REIMBURSEMENT_CREATE_SOURCE	Reimbursement Create Source	Source system that created the data.	VARCHAR2(30)		FTRBREMB	CREATE_SOURCE
REIMBURSEMENT_CREATE_USER	Reimbursement Create User	Banner ID of the person who created this new record.	VARCHAR2(30)		FTRBREMB	CREATE_USER
REIMBURSEMENT_DATA_ORIGIN	Reimbursement Data Origin	Source system that created or updated the data.	VARCHAR2(30)		FTRBREMB	DATA_ORIGIN
REIMBURSEMENT_DESC	Reimbursement Description	Reimbursement request description.	VARCHAR2(255)		FTRBREMB	DESCRIPTION
REIMBURSEMENT_KEY	Reimbursement KEY	Unique internal identification number of the reimbursement record.	NUMBER(19)		FTRBREMB	ID
REIMBURSEMENT_STATUS	Reimbursement Status	Reimbursement request status.	VARCHAR2(1)		FTRBREMB	REQUEST_STATUS
REIMBURSEMENT_STATUS_DATE	Reimbursement Status Date	Date and time the status was updated.	DATE		FTRBREMB	STATUS_DATE
REIMBURSEMENT_USER_ID	Reimbursement User ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)		FTRBREMB	USER_ID
REIMBURSE_CURRENCY	Reimburse Currency	Currency code used to indicate the base currency in which to be reimbursed.	VARCHAR2(4)		FTRBREMB	CURRENCY_CODE
REPORT_NAME	Report Name	Owner assigned expense report name.	VARCHAR2(60)		FTRBREMB	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		FTRBREMB	TRANSACTION_DATE
TRAVELER_AFFILIATION	Traveler Affiliation		VARCHAR2(25)
TRAVELER_AFFILIATION_DESC	Traveler Affiliation Description		VARCHAR2(255)
WIRE_AMOUNT	Wire Amount		NUMBER
WIRE_DATE	Wire Date		TIMESTAMP(6)
WIRE_REFERENCE_NUMBER	Wire Reference Number		VARCHAR2(30)
WIRE_REIMBURSEMENT_IND	Wire Reimbursement Indicator		VARCHAR2(1)
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: