Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
ADVANCE_CLEARED
|
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')
|
AFFILIATION_KEY
|
Affiliation KEY
|
Unique internal identification number of the affiliation record.
|
NUMBER
|
FTRBREMB
|
FTTVAFFL_ID
|
AUTHORIZATION
|
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
|
AUTHORIZATION_KEY
|
Authorization KEY
|
Unique internal identification number of the authorization record.
|
NUMBER
|
FTRBAUTH
|
ID
|
AUTHORIZED_TOTAL
|
Authorized Total
|
Total amount of all expenses that were authorized regardless of status.
|
NUMBER
|
FUNCTION
|
MEKFUNC.F_AUTHORIZED_TOTAL(PORTFOLIO_KEY, '%', '%')
|
AUTHORIZED_TOTAL_NONREIMBURSE
|
Authorized Total Nonreimburse
|
Total amount of all reimbursable expenses for the request authorization.
|
NUMBER
|
FUNCTION
|
MEKFUNC.F_AUTHORIZED_TOTAL(PORTFOLIO_KEY, '%', 'N')
|
AUTHORIZED_TOTAL_REIMBURSE
|
Authorized Total Reimburse
|
Total amount of all reimbursable expenses for the request authorization.
|
NUMBER
|
FUNCTION
|
MEKFUNC.F_AUTHORIZED_TOTAL(PORTFOLIO_KEY, '%', 'Y')
|
BUSINESS_PURPOSE_NAME
|
Business Purpose Name
|
Name assigned to the business purpose. As an example, Recruiting Visit, Faculty Conference, Monthly Expenses, Business Meeting.
|
VARCHAR2(63)
|
FTTVPURP
|
NAME
|
CURRENCY_DESC
|
Currency Description
|
Currency code description or title.
|
VARCHAR2(255)
|
GTVCURR
|
GTVCURR_TITLE
|
CURRENCY_KEY
|
Currency KEY
|
Unique internal identification number of the currency record.
|
NUMBER
|
FTRBREMB
|
FTTVCURR_ID
|
DELEGATE_ID
|
Delegate ID
|
User-defined or system generated one-up number of the delegate.
|
VARCHAR2(63)
|
FUNCTION SPRIDEN
|
MGKFUNC.F_GET_PERSON_INFO SPRIDEN_ID
|
DELEGATE_NAME
|
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
|
DELEGATE_UID
|
Delegate UID
|
Personal identification number of the user who submitted this request for traveler review.
|
NUMBER
|
FTRBREMB
|
SENT_TO_TRAVELER_BY
|
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
|
ENCUMBRANCE_NUMBER
|
Encumbrance Number
|
Generated encumbrance number used to post an authorization in the portfolio.
|
VARCHAR2(63)
|
FTPBPORT
|
FGBENCH_NUM
|
MULTI_SOURCE
|
Multi Source
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
MULTI_SOURCE_DESC
|
Multi Source Description
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
ORIGINAL_APPROVER_ID
|
Original Approver ID
|
User-defined or system generated one-up number of the workflow approver.
|
VARCHAR2(63)
|
FUNCTION
|
MAKFUNC.F_GET_PERSON_INFO
|
ORIGINAL_APPROVER_NAME
|
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
|
ORIGINAL_APPROVER_UID
|
Original Approver UID
|
Personal identification number of the workflow approver for this request.
|
NUMBER
|
FTOBPROF
|
APPROVER_PIDM
|
OWNER_ADDRESS_NUMBER
|
Owner Address Number
|
Sequence used to identify different addresses within the same address type.
|
NUMBER
|
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(63)
|
FTRBREMB
|
OWNER_ADDRESS_TYPE_CODE
|
OWNER_EMAIL
|
Owner Email
|
Email address of the expense owner as contact information for workflow approvals.
|
VARCHAR2(255)
|
FTRBREMB
|
EMAIL_ADDRESS
|
OWNER_ENTITY_IND
|
Owner Entity Indicator
|
Indicates whether the expense owner is a person or an organization.
|
VARCHAR2(1)
|
FUNCTION
|
MAKFUNC.F_GET_ENTITY_IND
|
OWNER_ID
|
Owner ID
|
User-defined or system generated one-up number of the expense owner.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
OWNER_NAME
|
Owner Name
|
Combination of the person's last, first, and middle initial into one value.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
OWNER_UID
|
Owner UID
|
Personal identification number of the expense owner.
|
NUMBER
|
FTRBREMB
|
OWNER_PIDM
|
PAYEE_ADDRESS_NUMBER
|
Payee Address Number
|
Sequence used to identify different addresses within the same address type.
|
NUMBER
|
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(63)
|
FTRBREMB
|
PAYEE_ADDRESS_TYPE_CODE
|
PAYEE_ENTITY_IND
|
Payee Entity Indicator
|
Indicates whether the payee is a person or an organization.
|
VARCHAR2(1)
|
FUNCTION
|
MAKFUNC.F_GET_ENTITY_IND
|
PAYEE_ID
|
Payee ID
|
User-defined or system generated one-up number of the person to be reimbursed.
|
VARCHAR2(63)
|
FUNCTION
|
MAKFUNC.F_GET_PERSON_INFO
|
PAYEE_NAME
|
Payee Name
|
Combination of the person's last, first, and middle initial into one value.
|
VARCHAR2(255)
|
FUNCTION
|
MAKFUNC.F_GET_PERSON_INFO
|
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
|
FTRBREMB
|
PAYEE_PIDM
|
PAY_AMOUNT_NOT_SUBMITTED
|
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')
|
PAY_AMOUNT_SUBMITTED
|
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')
|
PAY_CURRENCY_EXCHANGE_RATE
|
Pay Currency Exchange Rate
|
Conversion rate to base currency amount.
|
NUMBER
|
FTRBREMB
|
PAY_TO_BASE_EXCHNG_RATE
|
PORTFOLIO
|
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
|
Portfolio KEY
|
Unique internal identification number of the portfolio record.
|
NUMBER
|
FTRBREMB
|
FTPBPORT_ID
|
PORTFOLIO_NAME
|
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
|
PORTFOLIO_STATUS
|
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
|
PORTFOLIO_TYPE
|
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
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
REIMBURSEMENT
|
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_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(63)
|
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(63)
|
FTRBREMB
|
CREATE_SOURCE
|
REIMBURSEMENT_CREATE_USER
|
Reimbursement Create User
|
Banner ID of the person who created this new record.
|
VARCHAR2(63)
|
FTRBREMB
|
CREATE_USER
|
REIMBURSEMENT_DATA_ORIGIN
|
Reimbursement Data Origin
|
Source system that created or updated the data.
|
VARCHAR2(63)
|
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
|
FTRBREMB
|
ID
|
REIMBURSEMENT_STATUS
|
Reimbursement Status
|
Reimbursement request status.
|
VARCHAR2(63)
|
FTRBREMB
|
REQUEST_STATUS
|
REIMBURSEMENT_STATUS_DATE
|
Reimbursement Status Date
|
Date and time the status was updated.
|
DATE
|
FTRBREMB
|
STATUS_DATE
|
REIMBURSEMENT_STATUS_DESC
|
Reimbursement Status Description
|
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
|
REIMBURSEMENT_USER_ID
|
Reimbursement User ID
|
Unique identification code of the user who entered or last touched the transaction.
|
VARCHAR2(63)
|
FTRBREMB
|
USER_ID
|
REIMBURSE_CURRENCY
|
Reimburse Currency
|
Currency code used to indicate the base currency in which to be reimbursed.
|
VARCHAR2(63)
|
FTTVCURR
|
CURRENCY_CODE
|
REPORT_NAME
|
Report Name
|
Owner assigned expense report name.
|
VARCHAR2(63)
|
FTRBREMB
|
NAME
|
REVIEW_SUBMIT_DATE
|
Review Submit Date
|
Date on which the authorization was submitted for traveler review.
|
DATE
|
FTRBREMB
|
SENT_TO_TRAVELER_DATE
|
TOTAL_NONREIMBURSE_SUBMITTED
|
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')
|
TOTAL_NONREIMB_NOT_SUBMITTED
|
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')
|
TOTAL_NOT_SUBMITTED
|
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, '%', '%')
|
TOTAL_REIMBURSE_NOT_SUBMITTED
|
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')
|
TOTAL_REIMBURSE_SUBMITTED
|
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')
|
TOTAL_SUBMITTED
|
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, '%', '%')
|
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
|
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
|
TRAVELER_AFFILIATION_DESC
|
Traveler Affiliation Description
|
Traveler affiliation description.
|
VARCHAR2(255)
|
FTTVAFFL
|
DESCRIPTION
|
WIRE_AMOUNT
|
Wire Amount
|
Wire transfer transaction amount.
|
NUMBER
|
FTRBREMB
|
WIRE_BASE_AMOUNT
|
WIRE_DATE
|
Wire Date
|
Date which the wire transfer transaction occurs.
|
DATE
|
FTRBREMB
|
WIRE_DATE
|
WIRE_REFERENCE_NUMBER
|
Wire Reference Number
|
Associated reference number for the wire transfer transaction.
|
VARCHAR2(63)
|
FTRBREMB
|
WIRE_REF_NUM
|
WIRE_REIMBURSEMENT_IND
|
Wire Reimbursement Indicator
|
Indicates whether reimbursement is paid to the traveler using a bank wire transfer.
|
VARCHAR2(1)
|
FTRBREMB
|
PAY_BY_WIRE_IND
|