Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Finance Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AF_GRANT_EVENT_STATUS

Description Source composite view contains grant events status periods and associated information.
Key & Frequency One row per grant id per grant event per grant event sequence number.

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
APPROVER_UID Approver UID System generated unique internal identification number assigned to this person. NUMBER(8)  

GOBEACC

GOBEACC_PIDM

APPROVER_USER_ID Approver User ID Person's user identification who approved the event. VARCHAR2(30)  

FRREVNG

FRREVNG_APPROVED_BY_USER_ID

CURRENT_DATE Current Date System current date (sysdate) or date the data was extracted. DATE  

NA

SYSDATE

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

NA

NA

EVENT_DUE_DATE Event Due Date   DATE      
EVENT_SEQUENCE_NUMBER Event Sequence Number   NUMBER      
EVENT_STATUS Event Status   VARCHAR2(1)      
EVENT_STATUS_ACTIVITY_DATE Event Status Activity Date   DATE      
EVENT_STATUS_DATE Event Status Date   DATE      
EVENT_STATUS_USER_ID Event Status User ID   VARCHAR2(30)      
GRANT_EVENT Grant Event User-defined event identification assigned to the grant. VARCHAR2(6)  

FRREVNG

FRREVNG_EVNT_CODE

GRANT_EVENT_DUE_DATE Grant Event Due Date Due date for the event to be satisfied or performed. DATE  

FRREVNG

FRREVNG_DUE_DATE

GRANT_EVENT_SEQUENCE_NUMBER Grant Event Sequence Number System-generated one-up number related to grant events. NUMBER(3)  

FRREVNG

FRREVNG_SEQ_NUM

GRANT_EVENT_STATUS Grant Event Status Event status. (S)atisfied, (C)anceled, or (P)ending. VARCHAR2(1)  

FRREVNG

FRREVNG_STATUS_IND

GRANT_EVENT_STATUS_ACTIVITY_DATE Grant Event Status Activity Date Date record was inserted or updated. DATE  

FRBEVNG

FRREVNG_ACTIVITY_DATE

GRANT_EVENT_STATUS_DATE Grant Event Status Date Date when the grant event was satisfied, performed or canceled. DATE  

FRREVNG

FRREVNG_STATUS_DATE

GRANT_EVENT_STATUS_USER_ID Grant Event Status User ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(30)  

FRBEVNG

FRREVNG_USER_ID

GRANT_ID Grant ID Unique user-defined or system generated one-up number for this grant. VARCHAR2(9)  

FRREVNG

FRREVNG_GRNT_CODE

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

RESPONSIBLE_PERSON_UID Responsible Person UID System generated unique internal identification number assigned to this person. NUMBER(8)  

GOBEACC

GOBEACC_PIDM

RESPONSIBLE_USER_ID Responsible User ID Person's responsible user identification for satisfying the event. VARCHAR2(30)  

FRREVNG

FRREVNG_RESPONSIBLE_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: