Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
APPROVER_ID	Approved ID of the responsible owner for this event.	VARCHAR2(63)	FUNCTION SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_ID	NO NO	NO
APPROVER_NAME	Approval person's name.	VARCHAR2(255)	FUNCTION SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_LAST_NAME || SPRIDEN_FIRST_NAME || SPRIDEN_MI	NO NO	NO
APPROVER_UID	System generated unique internal identification number assigned to this person.	NUMBER	GOBEACC	GOBEACC_PIDM	NO	NO
APPROVER_USER_ID	Person's user identification who approved the event.	VARCHAR2(63)	FRREVNG	FRREVNG_APPROVED_BY_USER_ID	NO	NO
EVENT_DUE_DATE	Due date for the event to be satisfied or performed.	DATE	FRREVNG	FRREVNG_DUE_DATE	NO	NO
EVENT_SEQUENCE_NUMBER	System-generated one-up number related to grant events.	NUMBER	FRREVNG	FRREVNG_SEQ_NUM	NO	NO
EVENT_STATUS	Event status. (S)atisfied, (C)anceled, or (P)ending.	VARCHAR2(63)	FRREVNG	FRREVNG_STATUS_IND	NO	NO
EVENT_STATUS_ACTIVITY_DATE	Date record was inserted or updated.	DATE	FRBEVNG	FRREVNG_ACTIVITY_DATE	NO	NO
EVENT_STATUS_DATE	Date when the grant event was satisfied, performed or canceled.	DATE	FRREVNG	FRREVNG_STATUS_DATE	NO	NO
EVENT_STATUS_DESC	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	NO	NO
EVENT_STATUS_USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	FRBEVNG	FRREVNG_USER_ID	NO	NO
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	NO	NO
EVENT_TYPE_DESC	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	NO	NO
GRANT_EVENT	User-defined event identification assigned to the grant.	VARCHAR2(63)	FRREVNG	FRREVNG_EVNT_CODE	NO	NO
GRANT_EVENT_ALTERNATE_DESC	Grant event alternate description.	VARCHAR2(255)	FRBEVNG	FRBEVNG_ALTERNATE_EVENT_DESC	NO	NO
GRANT_EVENT_DESC	Grant event description.	VARCHAR2(255)	FRVEVNT	FRVEVNT_DESC	NO	NO
GRANT_EVENT_FULL_DESC	Grant event description and alternate description.	VARCHAR2(255)	CALCULATION	FRVEVNT_DESC || FRBEVNG_ALTERNATE_EVNT_DESC	NO	NO
GRANT_ID	Unique user-defined or system generated one-up number for this grant.	VARCHAR2(63)	FRREVNG	FRREVNG_GRNT_CODE	NO	NO
GRANT_SHORT_TITLE	Grant short title or description.	VARCHAR2(255)	FRBGRNT	FRBGRNT_TITLE	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
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	NO NO	NO
RESPONSIBLE_PERSON_NAME	Responsible person's name.	VARCHAR2(255)	FUNCTION SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_LAST_NAME || SPRIDEN_FIRST_NAME || SPRIDEN_MI	NO NO	NO
RESPONSIBLE_PERSON_UID	System generated unique internal identification number assigned to this person.	NUMBER	GOBEACC	GOBEACC_PIDM	NO	NO
RESPONSIBLE_USER_ID	Person's responsible user identification for satisfying the event.	VARCHAR2(63)	FRREVNG	FRREVNG_RESPONSIBLE_USER_ID	NO	NO

Ver: 9.2