Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Finance Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: GRANT_EVENT_STATUS

Description Contains information about grant event periods and their statuses. Reportable fields are event type, event due date, event status and status date, person responsible for the event, and person who approved the event.
Key & Frequency One row per grant ID per grant event per grant event sequence number.
Recommended Search Columns GRANT_ID
GRANT_ID, GRANT_EVENT
GRANT_ID, GRANT_EVENT, EVENT_SEQUENCE_NUMBER
RESPONSIBLE_PERSON_UID

Target Column Business Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

APPROVER_ID Approved ID of the responsible owner for this event. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

APPROVER_NAME Approval person's name. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

APPROVER_UID System generated unique internal identification number assigned to this person. NUMBER

GOBEACC

GOBEACC_PIDM

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

FRREVNG

FRREVNG_APPROVED_BY_USER_ID

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

FRREVNG

FRREVNG_DUE_DATE

EVENT_SEQUENCE_NUMBER System-generated one-up number related to grant events. NUMBER

FRREVNG

FRREVNG_SEQ_NUM

EVENT_STATUS Event status. (S)atisfied, (C)anceled, or (P)ending. VARCHAR2(63)

FRREVNG

FRREVNG_STATUS_IND

EVENT_STATUS_ACTIVITY_DATE Date record was inserted or updated. DATE

FRBEVNG

FRREVNG_ACTIVITY_DATE

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

FRREVNG

FRREVNG_STATUS_DATE

EVENT_STATUS_DESC Event status description. VARCHAR2(255)

FUNCTION

SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'FRREVNG_STATUS_IND' AND VALUE = GRANT_EVENT_STATUS

EVENT_STATUS_USER_ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(63)

FRBEVNG

FRREVNG_USER_ID

EVENT_TYPE Event type used to categorize if the event is just an (E)vent, (R)eport, (P)MS or a (B)ill. VARCHAR2(63)

FRVEVNT

FRVEVNT_TYPE_IND

EVENT_TYPE_DESC Event type description. VARCHAR2(255)

FUNCTION

SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'FRVEVNT_TYPE_IND' AND VALUE = GRANT_EVENT_TYPE

GRANT_EVENT User-defined event identification assigned to the grant. VARCHAR2(63)

FRREVNG

FRREVNG_EVNT_CODE

GRANT_EVENT_ALTERNATE_DESC Grant event alternate description. VARCHAR2(255)

FRBEVNG

FRBEVNG_ALTERNATE_EVENT_DESC

GRANT_EVENT_DESC Grant event description. VARCHAR2(255)

FRVEVNT

FRVEVNT_DESC

GRANT_EVENT_FULL_DESC Grant event description and alternate description. VARCHAR2(255)

CALCULATION

FRVEVNT_DESC || FRBEVNG_ALTERNATE_EVNT_DESC

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

FRREVNG

FRREVNG_GRNT_CODE

GRANT_SHORT_TITLE Grant short title or description. VARCHAR2(255)

FRBGRNT

FRBGRNT_TITLE

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

RESPONSIBLE_PERSON_ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

RESPONSIBLE_PERSON_NAME Responsible person's name. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

RESPONSIBLE_PERSON_UID System generated unique internal identification number assigned to this person. NUMBER

GOBEACC

GOBEACC_PIDM

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

FRREVNG

FRREVNG_RESPONSIBLE_USER_ID



Ver: 8.5