Composite View Target: AE

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:

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