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

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 Definition Database Data Type Source Name Source Column Local Source Local Target
APPROVER_UID System generated unique internal identification number assigned to this person. NUMBER(8)

GOBEACC

GOBEACC_PIDM

NO

NO
APPROVER_USER_ID Person's user identification who approved the event. VARCHAR2(30)

FRREVNG

FRREVNG_APPROVED_BY_USER_ID

NO

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

NA

SYSDATE

NO

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

NA

NA

NO

NO
EVENT_DUE_DATE   DATE       NO
EVENT_SEQUENCE_NUMBER   NUMBER       NO
EVENT_STATUS   VARCHAR2(1)       NO
EVENT_STATUS_ACTIVITY_DATE   DATE       NO
EVENT_STATUS_DATE   DATE       NO
EVENT_STATUS_USER_ID   VARCHAR2(30)       NO
GRANT_EVENT User-defined event identification assigned to the grant. VARCHAR2(6)

FRREVNG

FRREVNG_EVNT_CODE

NO

NO
GRANT_EVENT_DUE_DATE Due date for the event to be satisfied or performed. DATE

FRREVNG

FRREVNG_DUE_DATE

NO

NO
GRANT_EVENT_SEQUENCE_NUMBER System-generated one-up number related to grant events. NUMBER(3)

FRREVNG

FRREVNG_SEQ_NUM

NO

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

FRREVNG

FRREVNG_STATUS_IND

NO

NO
GRANT_EVENT_STATUS_ACTIVITY_DATE Date record was inserted or updated. DATE

FRBEVNG

FRREVNG_ACTIVITY_DATE

NO

NO
GRANT_EVENT_STATUS_DATE Date when the grant event was satisfied, performed or canceled. DATE

FRREVNG

FRREVNG_STATUS_DATE

NO

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

FRBEVNG

FRREVNG_USER_ID

NO

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

FRREVNG

FRREVNG_GRNT_CODE

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
RESPONSIBLE_PERSON_UID System generated unique internal identification number assigned to this person. NUMBER(8)

GOBEACC

GOBEACC_PIDM

NO

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

FRREVNG

FRREVNG_RESPONSIBLE_USER_ID

NO

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: