Composite View Target: AE_STATUS

Go To View:	RETURN TO BANNER COMP META DATA REPORTS LIST
	Neu Schedule Data Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AE_STATUS_HISTORY

Description Contains status and status date history as the authorization / reimbursement request migrates through various stages of completion.
Key & Frequency One row per authorization or reimbursement per change in status.

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column

AUTHORIZATION_KEY Authorization KEY Unique internal identification number of the authorization record. NUMBER(19)
FTRRSTHS

FTRBAUTH_ID

CURRENT_DATE Current Date SYSDATE DATE
FUNCTION

SYSDATE

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

NA

MESSAGE Message Indicates an action taken on the document for any of the status indicators. As an example, the invoice API for a reimbursement or the encumbrance API for an authorization may fail. That message needs to be recorded so that some form of action may be taken. VARCHAR2(4000)
FTRRSTHS

MESSAGE

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

NA

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

NA

REIMBURSEMENT_KEY Reimbursement KEY Unique internal identification number of the reimbursement record. NUMBER(19)
FTRRSTHS

FTRBREMB_ID

STATUS Status Request status. VARCHAR2(1)
FTRRSTHS

STATUS

STATUS_DATE Status Date Date and time the status was updated. DATE
FTRRSTHS

STATUS_DATE

STATUS_HISTORY_ACTIVITY_DATE Status History Activity Date Date information for this record in the table was entered or last updated. DATE
FTRRSTHS

ACTIVITY_DATE

STATUS_HISTORY_DATA_ORIGIN Status History Data Origin Source system that created or updated the data. VARCHAR2(30)
FTRRSTHS

DATA_ORIGIN

STATUS_HISTORY_KEY Status History KEY Unique internal identification number of the status history record. NUMBER(19)
FTRBAUTH

ID

STATUS_HISTORY_USER_ID Status History User ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(30)
FTRRSTHS

USER_ID

ZONE_VALUE 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 status and status date history as the authorization / reimbursement request migrates through various stages of completion.
Key & Frequency	One row per authorization or reimbursement per change in status.

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
AUTHORIZATION_KEY	Authorization KEY	Unique internal identification number of the authorization record.	NUMBER(19)	FTRRSTHS	FTRBAUTH_ID
CURRENT_DATE	Current Date	SYSDATE	DATE	FUNCTION	SYSDATE
DOMAIN_VALUE	Domain Value	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA
MESSAGE	Message	Indicates an action taken on the document for any of the status indicators. As an example, the invoice API for a reimbursement or the encumbrance API for an authorization may fail. That message needs to be recorded so that some form of action may be taken.	VARCHAR2(4000)	FTRRSTHS	MESSAGE
MIF_DESC	MIF Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA
MIF_VALUE	MIF Value	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA
REIMBURSEMENT_KEY	Reimbursement KEY	Unique internal identification number of the reimbursement record.	NUMBER(19)	FTRRSTHS	FTRBREMB_ID
STATUS	Status	Request status.	VARCHAR2(1)	FTRRSTHS	STATUS
STATUS_DATE	Status Date	Date and time the status was updated.	DATE	FTRRSTHS	STATUS_DATE
STATUS_HISTORY_ACTIVITY_DATE	Status History Activity Date	Date information for this record in the table was entered or last updated.	DATE	FTRRSTHS	ACTIVITY_DATE
STATUS_HISTORY_DATA_ORIGIN	Status History Data Origin	Source system that created or updated the data.	VARCHAR2(30)	FTRRSTHS	DATA_ORIGIN
STATUS_HISTORY_KEY	Status History KEY	Unique internal identification number of the status history record.	NUMBER(19)	FTRBAUTH	ID
STATUS_HISTORY_USER_ID	Status History User ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)	FTRRSTHS	USER_ID
ZONE_VALUE	Zone Value	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA