Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
ADMINISTRATIVE_GROUP
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
ADVANCE_CLEARED
|
Total amount of the advance cleared for this expense report once it has been submitted.
|
NUMBER
|
CALCULATION
|
MEKFUNC.F_TOTAL_SUBMITTED(R.PORTFOLIO_KEY, '9900ADVC', '%','Y')
|
NO
|
NO
|
AFFILIATION_KEY
|
Unique internal identification number of the affiliation record.
|
NUMBER
|
FTRBREMB
|
FTTVAFFL_ID
|
NO
|
NO
|
AUTHORIZATION
|
System generated code identifying the reimbursement with the prefix as defined by the client for system id TRAVREIM in the table fobfseq.
|
VARCHAR2(63)
|
FTRBAUTH
|
DOC_CODE
|
NO
|
NO
|
AUTHORIZATION_KEY
|
Unique internal identification number of the authorization record.
|
NUMBER
|
FTRBAUTH
|
ID
|
NO
|
NO
|
AUTHORIZED_TOTAL
|
Total amount of all expenses that were authorized regardless of status.
|
NUMBER
|
FUNCTION
|
MEKFUNC.F_AUTHORIZED_TOTAL(PORTFOLIO_KEY, '%', '%')
|
NO
|
NO
|
AUTHORIZED_TOTAL_NONREIMBURSE
|
Total amount of all reimbursable expenses for the request authorization.
|
NUMBER
|
FUNCTION
|
MEKFUNC.F_AUTHORIZED_TOTAL(PORTFOLIO_KEY, '%', 'N')
|
NO
|
NO
|
AUTHORIZED_TOTAL_REIMBURSE
|
Total amount of all reimbursable expenses for the request authorization.
|
NUMBER
|
FUNCTION
|
MEKFUNC.F_AUTHORIZED_TOTAL(PORTFOLIO_KEY, '%', 'Y')
|
NO
|
NO
|
BUSINESS_PURPOSE_NAME
|
Name assigned to the business purpose. As an example, Recruiting Visit, Faculty Conference, Monthly Expenses, Business Meeting.
|
VARCHAR2(63)
|
FTTVPURP
|
NAME
|
NO
|
NO
|
CURRENCY_DESC
|
Currency code description or title.
|
VARCHAR2(255)
|
GTVCURR
|
GTVCURR_TITLE
|
NO
|
NO
|
CURRENCY_KEY
|
Unique internal identification number of the currency record.
|
NUMBER
|
FTRBREMB
|
FTTVCURR_ID
|
NO
|
NO
|
DELEGATE_ID
|
User-defined or system generated one-up number of the delegate.
|
VARCHAR2(63)
|
FUNCTION SPRIDEN
|
MGKFUNC.F_GET_PERSON_INFO SPRIDEN_ID
|
NO NO
|
NO
|
DELEGATE_NAME
|
Combination of the delegate's last, first, and middle initial into one value.
|
VARCHAR2(255)
|
FUNCTION SPRIDEN
|
MGKFUNC.F_GET_PERSON_INFO SPRIDEN_LAST_NAME || SPRIDEN_FIRST_NAME || SPRIDEN_MI
|
NO NO
|
NO
|
DELEGATE_UID
|
Personal identification number of the user who submitted this request for traveler review.
|
NUMBER
|
FTRBREMB
|
SENT_TO_TRAVELER_BY
|
NO
|
NO
|
DIRECT_DEPOSIT_OVERRIDE_IND
|
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
|
NO
|
NO
|
ENCUMBRANCE_NUMBER
|
Generated encumbrance number used to post an authorization in the portfolio.
|
VARCHAR2(63)
|
FTPBPORT
|
FGBENCH_NUM
|
NO
|
NO
|
MULTI_SOURCE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
MULTI_SOURCE_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
ORIGINAL_APPROVER_ID
|
User-defined or system generated one-up number of the workflow approver.
|
VARCHAR2(63)
|
FUNCTION
|
MAKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
ORIGINAL_APPROVER_NAME
|
Combination of the workflow approver's last, first, and middle initial into one value.
|
VARCHAR2(255)
|
FUNCTION
|
MAKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
ORIGINAL_APPROVER_UID
|
Personal identification number of the workflow approver for this request.
|
NUMBER
|
FTOBPROF
|
APPROVER_PIDM
|
NO
|
NO
|
OWNER_ADDRESS_NUMBER
|
Sequence used to identify different addresses within the same address type.
|
NUMBER
|
FTRBREMB
|
OWNER_ADDRESS_SEQ_NUM
|
NO
|
NO
|
OWNER_ADDRESS_TYPE
|
Unique code used with a sequence number to determine the actual address of the expense owner.
|
VARCHAR2(63)
|
FTRBREMB
|
OWNER_ADDRESS_TYPE_CODE
|
NO
|
NO
|
OWNER_EMAIL
|
Email address of the expense owner as contact information for workflow approvals.
|
VARCHAR2(255)
|
FTRBREMB
|
EMAIL_ADDRESS
|
NO
|
NO
|
OWNER_ENTITY_IND
|
Indicates whether the expense owner is a person or an organization.
|
VARCHAR2(1)
|
FUNCTION
|
MAKFUNC.F_GET_ENTITY_IND
|
NO
|
NO
|
OWNER_ID
|
User-defined or system generated one-up number of the expense owner.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
OWNER_NAME
|
Combination of the person's last, first, and middle initial into one value.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
OWNER_UID
|
Personal identification number of the expense owner.
|
NUMBER
|
FTRBREMB
|
OWNER_PIDM
|
NO
|
NO
|
PAYEE_ADDRESS_NUMBER
|
Sequence used to identify different addresses within the same address type.
|
NUMBER
|
FTRBREMB
|
PAYEE_ADDRESS_SEQ_NUM
|
NO
|
NO
|
PAYEE_ADDRESS_TYPE
|
Unique code use with a sequence number to determine the actual address of the expense payee.
|
VARCHAR2(63)
|
FTRBREMB
|
PAYEE_ADDRESS_TYPE_CODE
|
NO
|
NO
|
PAYEE_ENTITY_IND
|
Indicates whether the payee is a person or an organization.
|
VARCHAR2(1)
|
FUNCTION
|
MAKFUNC.F_GET_ENTITY_IND
|
NO
|
NO
|
PAYEE_ID
|
User-defined or system generated one-up number of the person to be reimbursed.
|
VARCHAR2(63)
|
FUNCTION
|
MAKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
PAYEE_NAME
|
Combination of the person's last, first, and middle initial into one value.
|
VARCHAR2(255)
|
FUNCTION
|
MAKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
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
|
FTRBREMB
|
PAYEE_PIDM
|
NO
|
NO
|
PAY_AMOUNT_NOT_SUBMITTED
|
Total amount of all reimbursable expense items including the advance cleared amount for this expense report when the status is either (I)n process, (E)rror, (R)eturned for correction, (N) Pending Review, or (T) Sent for Review.
|
NUMBER
|
CALCULATION
|
MEKFUNC.F_AUTHORIZED_TOTAL (R.PORTFOLIO_KEY, '%', 'Y') + MEKFUNC.F_TOTAL_NOT_SUBMITTED(R.PORTFOLIO_KEY, '%', 'Y','Y')
|
NO
|
NO
|
PAY_AMOUNT_SUBMITTED
|
Total amount of all reimbursable xpense items including the advance cleared amount for this expense report when the status is either (A)pproved, (C)ompleted and ready to pay, (S)ubmitted, (P)aid, or (U)pdated.
|
NUMBER
|
CALCULATION
|
MEKFUNC.F_TOTAL_SUBMITTED(R.PORTFOLIO_KEY, '%', 'Y','Y')
|
NO
|
NO
|
PAY_CURRENCY_EXCHANGE_RATE
|
Conversion rate to base currency amount.
|
NUMBER
|
FTRBREMB
|
PAY_TO_BASE_EXCHNG_RATE
|
NO
|
NO
|
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
|
NO
|
NO
|
PORTFOLIO_KEY
|
Unique internal identification number of the portfolio record.
|
NUMBER
|
FTRBREMB
|
FTPBPORT_ID
|
NO
|
NO
|
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
|
NO
|
NO
|
PORTFOLIO_STATUS
|
Determines if the portfolio is still open for activity or closed to any further activity. Valid values are OPEN, or CLOSED.
|
VARCHAR2(63)
|
FTPBPORT
|
PORTFOLIO_STATUS_ENUM
|
NO
|
NO
|
PORTFOLIO_TYPE
|
Indicates if the portfolio is travel related or non-travel related. Valid hard coded values are TRAVEL, NON-TRAVEL.
|
VARCHAR2(63)
|
FTPBPORT
|
PORTFOLIO_TYPE_ENUM
|
NO
|
NO
|
PROCESS_GROUP
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
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
|
NO
|
NO
|
REIMBURSEMENT_ACTIVITY_DATE
|
Date information for this record in the table was entered or last updated.
|
DATE
|
FTRBREMB
|
ACTIVITY_DATE
|
NO
|
NO
|
REIMBURSEMENT_COMMENT
|
Free-form comment for the reimbursement.
|
VARCHAR2(4000)
|
FTRBREMB
|
USER_COMMENT
|
NO
|
NO
|
REIMBURSEMENT_COMPLETE_USER
|
Banner ID of the person who completed this reimbursement.
|
VARCHAR2(63)
|
FTRBREMB
|
COMPLETE_USER
|
NO
|
NO
|
REIMBURSEMENT_CREATE_DATE
|
Date and time when the new reimbursement record was created.
|
DATE
|
FTRBREMB
|
CREATE_DATE
|
NO
|
NO
|
REIMBURSEMENT_CREATE_SOURCE
|
Source system that created the data.
|
VARCHAR2(63)
|
FTRBREMB
|
CREATE_SOURCE
|
NO
|
NO
|
REIMBURSEMENT_CREATE_USER
|
Banner ID of the person who created this new record.
|
VARCHAR2(63)
|
FTRBREMB
|
CREATE_USER
|
NO
|
NO
|
REIMBURSEMENT_DATA_ORIGIN
|
Source system that created or updated the data.
|
VARCHAR2(63)
|
FTRBREMB
|
DATA_ORIGIN
|
NO
|
NO
|
REIMBURSEMENT_DESC
|
Reimbursement request description.
|
VARCHAR2(255)
|
FTRBREMB
|
DESCRIPTION
|
NO
|
NO
|
REIMBURSEMENT_KEY
|
Unique internal identification number of the reimbursement record.
|
NUMBER
|
FTRBREMB
|
ID
|
NO
|
NO
|
REIMBURSEMENT_STATUS
|
Reimbursement request status.
|
VARCHAR2(63)
|
FTRBREMB
|
REQUEST_STATUS
|
NO
|
NO
|
REIMBURSEMENT_STATUS_DATE
|
Date and time the status was updated.
|
DATE
|
FTRBREMB
|
STATUS_DATE
|
NO
|
NO
|
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
|
NO
|
NO
|
REIMBURSEMENT_USER_ID
|
Unique identification code of the user who entered or last touched the transaction.
|
VARCHAR2(63)
|
FTRBREMB
|
USER_ID
|
NO
|
NO
|
REIMBURSE_CURRENCY
|
Currency code used to indicate the base currency in which to be reimbursed.
|
VARCHAR2(63)
|
FTTVCURR
|
CURRENCY_CODE
|
NO
|
NO
|
REPORT_NAME
|
Owner assigned expense report name.
|
VARCHAR2(63)
|
FTRBREMB
|
NAME
|
NO
|
NO
|
REVIEW_SUBMIT_DATE
|
Date on which the authorization was submitted for traveler review.
|
DATE
|
FTRBREMB
|
SENT_TO_TRAVELER_DATE
|
NO
|
NO
|
TOTAL_NONREIMBURSE_SUBMITTED
|
Total amount of all non-reimbursable expense items for this reimbursement request when the status is either (A)pproved, (C)ompleted and ready to pay, (S)ubmitted or (P)aid.
|
NUMBER
|
FUNCTION
|
MEKFUNC.F_TOTAL_SUBMITTED(PORTFOLIO_KEY, '%', 'N')
|
NO
|
NO
|
TOTAL_NONREIMB_NOT_SUBMITTED
|
Total amount of all non-reimbursable expense items for this reimbursement request when the status is either (I)n process, (E)rror, (R)eturned for correction, (N) Pending Review, or (T) Sent for Review.
|
NUMBER
|
FUNCTION
|
MEKFUNC.F_TOTAL_NOT_SUBMITTED(PORTFOLIO_KEY, '%', 'N')
|
NO
|
NO
|
TOTAL_NOT_SUBMITTED
|
Total amount of all expense items for this reimbursement request when the status is either (I)n process, (E)rror, (R)eturned for correction, (N) Pending Review, or (T) Sent for Review. This includes reimbursable and non-reimbursable expense items.
|
NUMBER
|
FUNCTION
|
MEKFUNC.F_TOTAL_NOT_SUBMITTED(PORTFOLIO_KEY, '%', '%')
|
NO
|
NO
|
TOTAL_REIMBURSE_NOT_SUBMITTED
|
Total amount of all reimbursable expense items for this reimbursement request when the status is either (I)n process, (E)rror, (R)eturned for correction, (N) Pending Review, or (T) Sent for Review.
|
NUMBER
|
FUNCTION
|
MEKFUNC.F_TOTAL_NOT_SUBMITTED(PORTFOLIO_KEY, '%', 'Y')
|
NO
|
NO
|
TOTAL_REIMBURSE_SUBMITTED
|
Total amount of all reimbursable expense items for this reimbursement request when the status is either (A)pproved, (C)ompleted and ready to pay, (S)ubmitted or (P)aid.
|
NUMBER
|
FUNCTION
|
MEKFUNC.F_TOTAL_SUBMITTED(PORTFOLIO_KEY, '%', 'Y')
|
NO
|
NO
|
TOTAL_SUBMITTED
|
Total amount of all expense items for this reimbursement request when the status is either (A)pproved, (C)ompleted and ready to pay, (S)ubmitted or (P)aid. This includes reimbursable and non-reimburseable expense items.
|
NUMBER
|
FUNCTION
|
MEKFUNC.F_TOTAL_SUBMITTED(PORTFOLIO_KEY, '%', '%')
|
NO
|
NO
|
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
|
NO
|
NO
|
TRAVELER_AFFILIATION
|
Traveler affliation used to determine if rebate taxes are used or may be used to quantify travelers for reporting or insurance purposes.
|
VARCHAR2(63)
|
FTTVAFFL
|
AFFILIATION
|
NO
|
NO
|
TRAVELER_AFFILIATION_DESC
|
Traveler affiliation description.
|
VARCHAR2(255)
|
FTTVAFFL
|
DESCRIPTION
|
NO
|
NO
|
WIRE_AMOUNT
|
Wire transfer transaction amount.
|
NUMBER
|
FTRBREMB
|
WIRE_BASE_AMOUNT
|
NO
|
NO
|
WIRE_DATE
|
Date which the wire transfer transaction occurs.
|
DATE
|
FTRBREMB
|
WIRE_DATE
|
NO
|
NO
|
WIRE_REFERENCE_NUMBER
|
Associated reference number for the wire transfer transaction.
|
VARCHAR2(63)
|
FTRBREMB
|
WIRE_REF_NUM
|
NO
|
NO
|
WIRE_REIMBURSEMENT_IND
|
Indicates whether reimbursement is paid to the traveler using a bank wire transfer.
|
VARCHAR2(1)
|
FTRBREMB
|
PAY_BY_WIRE_IND
|
NO
|
NO
|