| Target Column | 
Business Name | 
Business Definition | 
Database Data Type | 
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
 
 | 
| 
BEGIN_EVENT_RULE
 | 
Begin Event Rule 
 | 
Indicates when the event starts compared to the grant begin or end date in the grant period.
 | 
VARCHAR2(63)
 | 
 FRBEVNG
 
 | 
 FRBEVNG_BEG_DATE_IND
 
 | 
| 
BEGIN_EVENT_RULE_DESC
 | 
Begin Event Rule Description 
 | 
Begin event description.
 | 
VARCHAR2(255)
 | 
 FUNCTION
 
 | 
 SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'FRBEVNG_BEG_DATE_IND' AND VALUE = BEGIN_EVENT_RULE
 
 | 
| 
BILL_FORMAT
 | 
Bill Format 
 | 
Billing format used.
 | 
VARCHAR2(63)
 | 
 FRBEVNG
 
 | 
 FRBEVNG_BFRM_CODE
 
 | 
| 
BILL_FORMAT_DESC
 | 
Bill Format Description 
 | 
Billing format description
 | 
VARCHAR2(255)
 | 
 FRVBFRM
 
 | 
 FRVBFRM_DESC
 
 | 
| 
BILL_FORMAT_TYPE
 | 
Bill Format Type 
 | 
Billing format type.  (B)ill or (R)eport.
 | 
VARCHAR2(255)
 | 
 FRVBFRM
 
 | 
 FRVBFRM_TYPE_IND
 
 | 
| 
BILL_FORMAT_TYPE_DESC
 | 
Bill Format Type Description 
 | 
Billing format type description.
 | 
VARCHAR2(255)
 | 
 CALCULATION
 
 | 
 DECODE(FRVBFRM_TYPE_IND)
 
 | 
| 
EVENT_END_DATE
 | 
Event End Date
 | 
End date to use when calculating recurring grant event periods.
 | 
DATE
 | 
 FRBEVNG
 
 | 
 FRBEVNG_DATE_TO
 
 | 
| 
EVENT_FREQUENCY
 | 
Event Frequency 
 | 
Frequency at which this event is run for the grant.   (M)onthly, (B)i-Weekly, (Q)uarterly, (S)emi-Annually, (W)eekly or (A)nnually.
 | 
VARCHAR2(63)
 | 
 FRBEVNG
 
 | 
 FRBEVNG_FREQ_IND
 
 | 
| 
EVENT_FREQUENCY_DESC
 | 
Event Frequency Description 
 | 
Event frequency description.
 | 
VARCHAR2(255)
 | 
 FUNCTION
 
 | 
 SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'FRBEVNG_FREQ_IND' AND VALUE = EVENT_FREQUENCY
 
 | 
| 
EVENT_START_DATE
 | 
Event Start Date 
 | 
Start date to use when calculating recurring grant event periods.
 | 
DATE
 | 
 FRBEVNG
 
 | 
 FRBEVNG_DATE_FROM
 
 | 
| 
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)
 | 
 FRBEVNG
 
 | 
 FRBEVNG_EVNT_CODE
 
 | 
| 
GRANT_EVENT_ACTIVITY_DATE
 | 
Grant Event Activity Date 
 | 
Date record was inserted or updated.
 | 
DATE
 | 
 FRBEVNG
 
 | 
 FRBEVNG_ACTIVITY_DATE
 
 | 
| 
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_EVENT_DESC
 
 | 
| 
GRANT_EVENT_USER_ID
 | 
Grant Event User ID 
 | 
Unique identification code of the user who entered or last touched the transaction.
 | 
VARCHAR2(63)
 | 
 FRBEVNG
 
 | 
 FRBEVNG_USER_ID
 
 | 
| 
GRANT_ID
 | 
Grant ID 
 | 
Unique user-defined or system generated one-up number for this grant.
 | 
VARCHAR2(63)
 | 
 FRBEVNG
 
 | 
 FRBEVNG_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
 
 | 
| 
NOTIFICATION_DAYS
 | 
Notification Days
 | 
Number of days after the begin date that the event occurs.
 | 
NUMBER
 | 
 FRBEVNG
 
 | 
 FRBEVNG_NUM_OF_DAYS
 
 | 
| 
NUMBER_OF_DAYS_REMINDER
 | 
Number Of Days Reminder 
 | 
Number of days before the event is due that Banner will send a user reminder to satisfy that event.
 | 
NUMBER
 | 
 FRBEVNG
 
 | 
 FRBEVNG_NUM_OF_DAYS_REMINDER
 
 | 
| 
PAYMENT_METHOD
 | 
Payment Method 
 | 
Payment method of fixed or cost used for billing events.
 | 
VARCHAR2(63)
 | 
 FRBEVNG
 
 | 
 FRBEVNG_PMT_METHOD_TYPE_IND
 
 | 
| 
PAYMENT_METHOD_DESC
 | 
Payment Method Description 
 | 
Payment method description.
 | 
VARCHAR2(255)
 | 
 FUNCTION
 
 | 
 DECODE(FRBEVNG_PMT_METHOD_TYPE_IND)
 
 | 
| 
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 SPRIDEN
 
 | 
 MGKFUNC.F_GET_PERSON_INFO SPRIDEN_ID
 
 | 
| 
RESPONSIBLE_PERSON_NAME
 | 
Responsible Person Name 
 | 
Responsible person's name.
 | 
VARCHAR2(255)
 | 
 FUNCTION SPRIDEN
 
 | 
 MGKFUNC.F_GET_PERSON_INFO SPRIDEN_LAST_NAME || SPRIDEN_FIRST_NAME || SPRIDEN_MI
 
 | 
| 
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 
 | 
Responsible user identification for satisfying the first event status.
 | 
VARCHAR2(63)
 | 
 FRREVNG
 
 | 
 FRREVNG_RESPONSIBLE_USER_ID
 
 |