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

Ver: