Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
BEGIN_EVENT_RULE	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	Bill Format	Billing format used.	VARCHAR2(4)		FRBEVNG	FRBEVNG_BFRM_CODE
BILL_FORMAT_DESC	Bill Format Description	Billing format description	VARCHAR2(35)		FRVBFRM	FRVBFRM_DESC
BILL_FORMAT_TYPE	Bill Format Type	Billing format type. (B)ill or (R)eport.	VARCHAR2(1)		FRVBFRM	FRVBFRM_TYPE_IND
BILL_FORMAT_TYPE_DESC	Bill Format Type Description	Billing format type description.	VARCHAR2(6)		CALCULATION	DECODE(FRVBFRM_TYPE_IND)
CURRENT_DATE	Current Date	System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DOMAIN_VALUE	Domain Value	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)		NA	NA
EVENT_END_DATE	Event End Date		DATE
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(1)		FRBEVNG	FRBEVNG_FREQ_IND
EVENT_NUMBER_OF_DAYSNOTIFICATION_DAYS	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	Event Start Date		DATE
EVENT_TYPE	Event Type		VARCHAR2(1)
GRANT_END_EVENT_DATEEVENT_END_DATE	Grant End Event Dateevent End Date	End date to use when calculating recurring grant event periods.	DATE		FRBEVNG	FRBEVNG_DATE_TO
GRANT_EVENT	Grant Event	User-defined event identification assigned to the grant.	VARCHAR2(6)		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(35)		FRBEVNG	FRBEVNG_ALTERNATE_EVNT_DESC
GRANT_EVENT_DESC	Grant Event Description	Grant event description.	VARCHAR2(35)		FRVEVNT	FRVEVNT_DESC
GRANT_EVENT_FULL_DESC	Grant Event Full Description	Grant event description and alternate description.	VARCHAR2(70)		CALCULATION	FRVEVNT_DESC || FRBEVNG_ALTERNATE_EVNT_DESC
GRANT_EVENT_TYPE	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	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	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	Grant Start Event Dateevent Start Date	Start date to use when calculating recurring grant event periods.	DATE		FRBEVNG	FRBEVNG_DATE_FROM
MIF_DESC	MIF Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)		NA	NA
MIF_VALUE	MIF Value	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)		NA	NA
NOTIFICATION_DAYS	Notification Days		NUMBER
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(3)		FRBEVNG	FRBEVNG_NUM_OF_DAYS_REMINDER
PAYMENT_METHOD	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	Payment method description.	VARCHAR2(5)		CALCULATION	DECODE(FRBEVNG_PMT_METHOD_TYPE_IND)
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(30)		FRREVNG	FRREVNG_RESPONSIBLE_USER_ID
ZONE_VALUE	Zone Value	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: