Target Column	Business Definition	Database Data Type	Source Name	Source Column
BEGIN_EVENT_RULE	Indicates when the event starts compared to the grant begin or end date in the grant period.	VARCHAR2(2)	FRBEVNG	FRBEVNG_BEG_DATE_IND
BILL_FORMAT	Billing format used.	VARCHAR2(4)	FRBEVNG	FRBEVNG_BFRM_CODE
BILL_FORMAT_DESC	Billing format description	VARCHAR2(35)	FRVBFRM	FRVBFRM_DESC
BILL_FORMAT_TYPE	Billing format type. (B)ill or (R)eport.	VARCHAR2(1)	FRVBFRM	FRVBFRM_TYPE_IND
BILL_FORMAT_TYPE_DESC	Billing format type description.	VARCHAR2(6)	CALCULATION	DECODE(FRVBFRM_TYPE_IND)
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
EVENT_END_DATE		DATE
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(1)	FRBEVNG	FRBEVNG_FREQ_IND
EVENT_NUMBER_OF_DAYSNOTIFICATION_DAYS	Number of days after the begin date that the event occurs.	NUMBER(3)	FRBEVNG	FRBEVNG_NUM_OF_DAYS
EVENT_START_DATE		DATE
EVENT_TYPE		VARCHAR2(1)
GRANT_END_EVENT_DATEEVENT_END_DATE	End date to use when calculating recurring grant event periods.	DATE	FRBEVNG	FRBEVNG_DATE_TO
GRANT_EVENT	User-defined event identification assigned to the grant.	VARCHAR2(6)	FRBEVNG	FRBEVNG_EVNT_CODE
GRANT_EVENT_ACTIVITY_DATE	Date record was inserted or updated.	DATE	FRBEVNG	FRBEVNG_ACTIVITY_DATE
GRANT_EVENT_ALTERNATE_DESC	Grant event alternate description.	VARCHAR2(35)	FRBEVNG	FRBEVNG_ALTERNATE_EVNT_DESC
GRANT_EVENT_DESC	Grant event description.	VARCHAR2(35)	FRVEVNT	FRVEVNT_DESC
GRANT_EVENT_FULL_DESC	Grant event description and alternate description.	VARCHAR2(70)	CALCULATION	FRVEVNT_DESC || FRBEVNG_ALTERNATE_EVNT_DESC
GRANT_EVENT_TYPE	Event type used to categorize if the event is just an (E)vent, (R)eport, (P)MS or a (B)ill.	VARCHAR2(1)	FRVEVNT	FRVEVNT_TYPE_IND
GRANT_EVENT_USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)	FRBEVNG	FRBEVNG_USER_ID
GRANT_ID	Unique user-defined or system generated one-up number for this grant.	VARCHAR2(9)	FRBEVNG	FRBEVNG_GRNT_CODE
GRANT_START_EVENT_DATEEVENT_START_DATE	Start date to use when calculating recurring grant event periods.	DATE	FRBEVNG	FRBEVNG_DATE_FROM
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA
NOTIFICATION_DAYS		NUMBER
NUMBER_OF_DAYS_REMINDER	Number of days before the event is due that Banner will send a user reminder to satisfy that event.	NUMBER(3)	FRBEVNG	FRBEVNG_NUM_OF_DAYS_REMINDER
PAYMENT_METHOD	Payment method of fixed or cost used for Billing events.	VARCHAR2(1)	FRBEVNG	FRBEVNG_PMT_METHOD_TYPE_IND
PAYMENT_METHOD_DESC	Payment method description.	VARCHAR2(5)	CALCULATION	DECODE(FRBEVNG_PMT_METHOD_TYPE_IND)
RESPONSIBLE_PERSON_UID	System generated unique internal identification number assigned to this person.	NUMBER	GOBEACC	GOBEACC_PIDM
RESPONSIBLE_USER_ID	Responsible user identification for satisfying the first event status.	VARCHAR2(30)	FRREVNG	FRREVNG_RESPONSIBLE_USER_ID
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA

Ver: