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 Name Business Definition Database Data Type Domain Value Source Name Source Column
ADMINISTRATIVE_GROUP Administrative Group Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)  

NA

NA

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

APPROVER_NAME Approver Name Approval person's name. VARCHAR2(255)  

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

GOBEACC

GOBEACC_PIDM

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

FRREVNG

FRREVNG_APPROVED_BY_USER_ID

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

FRREVNG

FRREVNG_DUE_DATE

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

FRREVNG

FRREVNG_SEQ_NUM

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

FRREVNG

FRREVNG_STATUS_IND

EVENT_STATUS_ACTIVITY_DATE Event Status Activity Date Date record was inserted or updated. DATE  

FRBEVNG

FRREVNG_ACTIVITY_DATE

EVENT_STATUS_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 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 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 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 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 Grant Event User-defined event identification assigned to the grant. VARCHAR2(63)  

FRREVNG

FRREVNG_EVNT_CODE

GRANT_EVENT_ALTERNATE_DESC Grant Event Alternate Description Grant event alternate description. VARCHAR2(255)  

FRBEVNG

FRBEVNG_ALTERNATE_EVENT_DESC

GRANT_EVENT_DESC Grant Event Description Grant event description. VARCHAR2(255)  

FRVEVNT

FRVEVNT_DESC

GRANT_EVENT_FULL_DESC Grant Event Full Description Grant event description and alternate description. VARCHAR2(255)  

CALCULATION

FRVEVNT_DESC || FRBEVNG_ALTERNATE_EVNT_DESC

GRANT_ID 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 Grant short title or description. VARCHAR2(255)  

FRBGRNT

FRBGRNT_TITLE

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

NA

NA

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

NA

NA

PROCESS_GROUP 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 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 Name Responsible person's name. VARCHAR2(255)  

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

GOBEACC

GOBEACC_PIDM

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

FRREVNG

FRREVNG_RESPONSIBLE_USER_ID



Ver: 9.0