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

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 Local Source Local Target
ADVANCE_STATUS   VARCHAR2(1)       NO
ADVANCE_STATUS_DESC   VARCHAR2(4000)       NO
AFFILIATION_KEY   NUMBER       NO
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

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

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

FTRBAUTH

CREATE_SOURCE

NO

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

FTRBAUTH

CREATE_USER

NO

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

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

FTRBAUTH

REQUEST_STATUS

NO

NO
AUTHORIZATION_STATUS_DATE Date and time the status was updated. DATE

FTRBAUTH

STATUS_DATE

NO

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

FTRBAUTH

USER_ID

NO

NO
CURRENT_DATE SYSDATE. DATE

FUNCTION

SYSDATE

NO

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

NA

NA

NO

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

NA

NA

NO

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

NA

NA

NO

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

FTRBAUTH

EMAIL_ADDRESS

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

FTRBAUTH

FTPBPORT_ID

NO

NO
REPORT_NAME Owner assigned expense report name. VARCHAR2(60)

FTRBAUTH

NAME

NO

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

NA

NA

NO

NO


Ver: