Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Travel And Expense Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AE_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.

Target Column Business Definition Database Data Type Source Name Source Column
ADVANCE_STATUS   VARCHAR2(1)    
ADVANCE_STATUS_DESC   VARCHAR2(4000)    
AFFILIATION_KEY   NUMBER    
AUTHORIZATION System generated code identifying the authorization. The prefix is defined by the client for system ID TRAVAUTH in the table fobfseq. VARCHAR2(8)

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(30)

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(30)

FTRBAUTH

CREATE_SOURCE

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

FTRBAUTH

CREATE_USER

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

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(1)

FTRBAUTH

REQUEST_STATUS

AUTHORIZATION_STATUS_DATE Date and time the status was updated. DATE

FTRBAUTH

STATUS_DATE

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

FTRBAUTH

USER_ID

CURRENT_DATE SYSDATE. DATE

FUNCTION

SYSDATE

DELEGATE_UID   NUMBER    
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA

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

NA

NA

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

NA

NA

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

FTRBAUTH

EMAIL_ADDRESS

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

FTRBAUTH

FTPBPORT_ID

REPORT_NAME Owner assigned expense report name. VARCHAR2(60)

FTRBAUTH

NAME

REVIEW_SUBMIT_DATE   TIMESTAMP(6)    
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   VARCHAR2(25)    
TRAVELER_AFFILIATION_DESC   VARCHAR2(255)    
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA



Ver: