Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Travel And Expense Reporting View Reports

Banner Operational Data Store
Reporting View Target: AUTHORIZATION

Description Contains information about the request for an authorization, its current status, encumbrance number if generated, expense owner information, and amounts for the authorization as reimbursable and non-reimbursable. When the authorization is associated to requests for reimbursements, the reimbursement amounts are also totaled for reimbursable and non-reimbursable.
Key & Frequency One row per authorization.
Recommended Search Columns FISCAL_YEAR
FISCAL_PERIOD
PORTFOLIO_KEY
OWNER_UID
BUSINESS_PURPOSE_NAME
AUTHORIZATION_KEY
AUTHORIZATION, AUTHORIZATION_STATUS

Target Column Business Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

ADVANCE_STATUS Advance status is (O)utstanding, (R)econciled, or over(D)ue. VARCHAR2(63)

FTRBAUTH

ADVANCE_STATUS

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

AFFILIATION_KEY Unique internal identification number of the affiliation record. NUMBER

FTRBAUTH

FTTVAFFL_ID

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

AUTHORIZATION_ACTIVITY_DATE Date information for this record in the table was entered or last updated. DATE

FTRBAUTH

ACTIVITY_DATE

AUTHORIZATION_COMMENT Free-form comment for the authorization. VARCHAR2(4000)

FTRBAUTH

USER_COMMENT

AUTHORIZATION_COMPLETE_USER Banner ID of the person who completed this reimbursement. VARCHAR2(63)

FTRBAUTH

COMPLETE_USER

AUTHORIZATION_CREATE_DATE Date and time when the new reimbursement record was created. DATE

FTRBAUTH

CREATE_DATE

AUTHORIZATION_CREATE_SOURCE Source system that created the data. VARCHAR2(63)

FTRBAUTH

CREATE_SOURCE

AUTHORIZATION_CREATE_USER Banner ID of the person who created this new record. VARCHAR2(63)

FTRBAUTH

CREATE_USER

AUTHORIZATION_DATA_ORIGIN Source system that created or updated the data. VARCHAR2(63)

FTRBAUTH

DATA_ORIGIN

AUTHORIZATION_DESC Authorization request description. VARCHAR2(255)

FTRBAUTH

DESCRIPTION

AUTHORIZATION_KEY Unique internal identification number of the authorization record. NUMBER

FTRBAUTH

ID

AUTHORIZATION_STATUS Authorization request status. VARCHAR2(63)

FTRBAUTH

REQUEST_STATUS

AUTHORIZATION_STATUS_DATE Date and time the status was updated. DATE

FTRBAUTH

STATUS_DATE

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

AUTHORIZATION_USER_ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(63)

FTRBAUTH

USER_ID

AUTHORIZED_TOTAL Total amount of all expenses for the authorization regardless of status. NUMBER

FUNCTION

MEKFUNC.F_AUTHORIZED_TOTAL(PORTFOLIO_KEY, '%', '%')

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 Total amount of all reimbursable expenses for the request authorization. NUMBER

FUNCTION

MEKFUNC.F_AUTHORIZED_TOTAL(PORTFOLIO_KEY, '%', 'Y')

BUSINESS_PURPOSE_NAME Name assigned to the business purpose. As an example, Recruiting Visit, Faculty Conference, Monthly Expenses, Business Meeting. VARCHAR2(63)

FTTVPURP

NAME

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 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 Personal identification number of the user who submitted this request for traveler review. NUMBER

FTRBAUTH

SENT_TO_TRAVELER_BY

ENCUMBRANCE_NUMBER Generated encumbrance number used to post an authorization in the portfolio. VARCHAR2(63)

FTPBPORT

FGBENCH_NUM

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

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

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

ORIGINAL_APPROVER_ID User-defined or system generated one-up number of the workflow approver. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

ORIGINAL_APPROVER_UID Personal identification number of the workflow approver for this request. NUMBER

FTOBPROF

APPROVER_PIDM

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

OUTSTANDING_ADVANCE_AMOUNT Total of outstanding advance amounts that have not been cleared for this authorization. NUMBER

FTRBAUTH

OUTSTANDING_ADVANCE_AMOUNT

OWNER_EMAIL Email address of the expense owner as contact information for workflow approvals. VARCHAR2(255)

FTRBAUTH

EMAIL_ADDRESS

OWNER_ENTITY_IND Indicates whether the expense owner is a person or an organization. VARCHAR2(1)

FUNCTION

MAKFUNC.F_GET_ENTITY_IND

OWNER_ID User-defined or system generated one-up number of the expense owner. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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 Personal identification number of the expense owner when the funding source is saved as part of the profile. NUMBER

FTRBAUTH

OWNER_PIDM

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 Unique internal identification number of the portfolio record. NUMBER

FTRBAUTH

FTPBPORT_ID

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 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 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-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

REPORT_NAME Owner assigned expense report name. VARCHAR2(255)

FTRBAUTH

NAME

REVIEW_SUBMIT_DATE Date on which the authorization was submitted for traveler review. DATE

FTRBAUTH

SENT_TO_TRAVELER_DATE

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')

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')

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, '%', '%')

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, '%')

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')

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, '%')

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')

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, '%', '%')

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 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. VARCHAR2(255)

FTTVAFFL

DESCRIPTION



Ver: 9.1