Composite View Target: AE

Go To View:	RETURN TO COMPOSITE VIEW 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

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

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

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(8)
FTRBAUTH

OWNER_PIDM

PORTFOLIO_KEY Unique internal identification number of the portfolio record. NUMBER(19)
FTRBAUTH

FTPBPORT_ID

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

NAME

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

ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)
NA

NA

Ver: 8.2

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
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(19)	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
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
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(8)	FTRBAUTH	OWNER_PIDM
PORTFOLIO_KEY	Unique internal identification number of the portfolio record.	NUMBER(19)	FTRBAUTH	FTPBPORT_ID
REPORT_NAME	Owner assigned expense report name.	VARCHAR2(60)	FTRBAUTH	NAME
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
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA