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_STATUS
|
Advance status is (O)utstanding, (R)econciled, or over(D)ue.
|
VARCHAR2(63)
|
FTRBAUTH
|
ADVANCE_STATUS
|
NO
|
NO
|
ADVANCE_STATUS_DESC
|
Advance status description.
|
VARCHAR2(255)
|
CALCULATION
|
CASE WHEN A.ADVANCE_STATUS = 'O' THEN 'OUTSTANDING' WHEN A.ADVANCE_STATUS = 'R' THEN 'RECONCILED' WHEN A.ADVANCE_STATUS = 'D' THEN 'OVERDUE' ELSE 'UNKNOWN' END
|
NO
|
NO
|
AFFILIATION_KEY
|
Unique internal identification number of the affiliation record.
|
NUMBER
|
FTRBAUTH
|
FTTVAFFL_ID
|
NO
|
NO
|
AUTHORIZATION
|
System generated code identifying the authorization. The prefix is defined by the client for system ID TRAVAUTH in the table fobfseq.
|
VARCHAR2(63)
|
FTRBAUTH
|
DOC_CODE
|
NO
|
NO
|
AUTHORIZATION_ACTIVITY_DATE
|
Date information for this record in the table was entered or last updated.
|
DATE
|
FTRBAUTH
|
ACTIVITY_DATE
|
NO
|
NO
|
AUTHORIZATION_COMMENT
|
Free-form comment for the authorization.
|
VARCHAR2(4000)
|
FTRBAUTH
|
USER_COMMENT
|
NO
|
NO
|
AUTHORIZATION_COMPLETE_USER
|
Banner ID of the person who completed this reimbursement.
|
VARCHAR2(63)
|
FTRBAUTH
|
COMPLETE_USER
|
NO
|
NO
|
AUTHORIZATION_CREATE_DATE
|
Date and time when the new reimbursement record was created.
|
DATE
|
FTRBAUTH
|
CREATE_DATE
|
NO
|
NO
|
AUTHORIZATION_CREATE_SOURCE
|
Source system that created the data.
|
VARCHAR2(63)
|
FTRBAUTH
|
CREATE_SOURCE
|
NO
|
NO
|
AUTHORIZATION_CREATE_USER
|
Banner ID of the person who created this new record.
|
VARCHAR2(63)
|
FTRBAUTH
|
CREATE_USER
|
NO
|
NO
|
AUTHORIZATION_DATA_ORIGIN
|
Source system that created or updated the data.
|
VARCHAR2(63)
|
FTRBAUTH
|
DATA_ORIGIN
|
NO
|
NO
|
AUTHORIZATION_DESC
|
Authorization request description.
|
VARCHAR2(255)
|
FTRBAUTH
|
DESCRIPTION
|
NO
|
NO
|
AUTHORIZATION_KEY
|
Unique internal identification number of the authorization record.
|
NUMBER
|
FTRBAUTH
|
ID
|
NO
|
NO
|
AUTHORIZATION_STATUS
|
Authorization request status.
|
VARCHAR2(63)
|
FTRBAUTH
|
REQUEST_STATUS
|
NO
|
NO
|
AUTHORIZATION_STATUS_DATE
|
Date and time the status was updated.
|
DATE
|
FTRBAUTH
|
STATUS_DATE
|
NO
|
NO
|
AUTHORIZATION_STATUS_DESC
|
Authorization 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
|
AUTHORIZATION_USER_ID
|
Unique identification code of the user who entered or last touched the transaction.
|
VARCHAR2(63)
|
FTRBAUTH
|
USER_ID
|
NO
|
NO
|
AUTHORIZED_TOTAL
|
Total amount of all expenses for the authorization 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
|
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
|
FTRBAUTH
|
SENT_TO_TRAVELER_BY
|
NO
|
NO
|
ENCUMBRANCE_NUMBER
|
Generated encumbrance number used to post an authorization in the portfolio.
|
VARCHAR2(63)
|
FTPBPORT
|
FGBENCH_NUM
|
NO
|
NO
|
FISCAL_PERIOD
|
Unique identifier for a period within a fiscal year. Generally a fiscal period would be a value between 00 and 14.
|
VARCHAR2(63)
|
FUNCTION
|
SELECT DISTINCT(SUBSTR(FISCAL_PERIOD1,63)) FROM MFT_FISCAL_PERIOD F WHERE TRANSACTION_DATE BETWEEN PERIOD_START_DATE AND PERIOD_END_DATE
|
NO
|
NO
|
FISCAL_YEAR
|
Unique identifier or code for the fiscal year.
|
VARCHAR2(63)
|
FUNCTION
|
SELECT DISTINCT(SUBSTR(FISCAL_YEAR,1,63)) FROM MFT_FISCAL_PERIOD F WHERE TRANSACTION_DATE BETWEEN PERIOD_START_DATE AND PERIOD_END_DATE
|
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
|
MGKFUNC.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
|
ORIGNAL_APPROVER_NAME
|
Combination of the workflow approver's last, first, and middle initial into one value.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
OUTSTANDING_ADVANCE_AMOUNT
|
Total of outstanding advance amounts that have not been cleared for this authorization.
|
NUMBER
|
FTRBAUTH
|
OUTSTANDING_ADVANCE_AMOUNT
|
NO
|
NO
|
OWNER_EMAIL
|
Email address of the expense owner as contact information for workflow approvals.
|
VARCHAR2(255)
|
FTRBAUTH
|
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 when the funding source is saved as part of the profile.
|
NUMBER
|
FTRBAUTH
|
OWNER_PIDM
|
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
|
FTRBAUTH
|
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
|
REPORT_NAME
|
Owner assigned expense report name.
|
VARCHAR2(255)
|
FTRBAUTH
|
NAME
|
NO
|
NO
|
REVIEW_SUBMIT_DATE
|
Date on which the authorization was submitted for traveler review.
|
DATE
|
FTRBAUTH
|
SENT_TO_TRAVELER_DATE
|
NO
|
NO
|
TOTAL_NONREIMBURSE_SUBMITTED
|
Total amount of all non-reimbursable expense items for reimbursement requests within this authorization. This includes (A)pproved, (C)ompleted and ready to pay, (S)ubmitted and (P)aid reimbursement requests.
|
NUMBER
|
FUNCTION
|
MEKFUNC.F_TOTAL_SUBMITTED(PORTFOLIO_KEY, '%', 'N')
|
NO
|
NO
|
TOTAL_NONREIMB_NOT_SUBMITTED
|
Total amount of all non-reimbursable expense items for all reimbursement requests within this authorization that are (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 all reimbursement requests within this authorization that are (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_PAID
|
Total amount of all reimbursement expense requests for this authorization that are in process and are waiting to be paid. This includes request statuses of (A)pproved, (S)ubmitted, or (C)ompleted and ready to pay.
|
NUMBER
|
FUNCTION
|
MEKFUNC.F_TOTAL_REIMBURSE_NOT_PAID(PORTFOLIO_KEY, '%')
|
NO
|
NO
|
TOTAL_REIMBURSE_NOT_SUBMITTED
|
Total amount of all reimbursable expense items for all reimbursement requests within this authorization. This includes (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_PAID
|
Total amount of all reimbursement expense requests for this authorization that have been paid.
|
NUMBER
|
FUNCTION
|
MEKFUNC.F_TOTAL_REIMBURSE_PAID(PORTFOLIO_KEY, '%')
|
NO
|
NO
|
TOTAL_REIMBURSE_SUBMITTED
|
Total amount of all reimbursable expense items for all reimbursement requests within this authorization. This includes (A)pproved, (C)ompleted and ready to pay, (S)ubmitted and (P)aid reimbursement requests.
|
NUMBER
|
FUNCTION
|
MEKFUNC.F_TOTAL_SUBMITTED(PORTFOLIO_KEY, '%', 'Y')
|
NO
|
NO
|
TOTAL_SUBMITTED
|
Total amount of all expense items for all reimbursement requests within this authorization. This includes (A)pproved, (C)ompleted and ready to pay, (S)ubmitted and (P)aid reimbursement requests. This includes reimbursable and non-reimbursable 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
|
FTRBAUTH
|
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
|