Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADDRESS_TYPE	The type of address.	VARCHAR2(2)	GERATTD	GERATTD_ATYP_CODE
ADDRESS_TYPE_DESC	The description of the type of address.	VARCHAR2(30)	STVATYP	STVATYP_DESC
ATTENDANCE_IND	Indicator to display whether or not the invitee actually attended the function.	VARCHAR2(1)	GERATTD	GERATTD_ATTENDANCE_IND
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DEFAULT_EVENT_TYPE	This column specifies the default event type code.	VARCHAR2(4)	GTVFUNC	GTVFUNC_ETYP_CODE
DEFAULT_EVENT_TYPE_DESC	This column specifies the default event type description.	VARCHAR2(30)	STVETYP	STVETYP_DESC
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA
EVENT_IDENTIFICATION	Internal event identification number.	VARCHAR2(5)	GERATTD	GERATTD_EVNT_CRN
FEE_PAID_IND	Fee Paid Indicator.	VARCHAR2(1)	GTVFEES	GTVFEES_PAID_IND
FEE_STATUS	Fee Status Code for the invitee.	VARCHAR2(5)	GERATTD	GERATTD_FEES_CODE
FEE_STATUS_DATE	Date fee status was last updated or modified for the invitee.	DATE	GERATTD	GERATTD_FEE_DATE
FEE_STATUS_DESC	Fee Status description for the invitee.	VARCHAR2(30)	CALCULATION	NVL(GERATTD_FEES_DESC, GTVFEES_DESC)
FUNCTION_CODE	This field specifies the function code.	VARCHAR2(12)	GERATTD	GERATTD_FUNC_CODE
FUNCTION_DESC	This field specifies the function description.	VARCHAR2(60)	GTVFUNC	GTVFUNC_DESC
INVITEE_COMMENT	Comment for the invitee.	VARCHAR2(4000)	FUNCTION	GOKODSF.F_TRIM_LONGS
INVITEE_UID	Internal system generated number associated with the person invited to the function.	NUMBER	GERATTD	GERATTD_PIDM
INVOLVED_IND	Indicator to display any involvement for the invitee.	VARCHAR2(1)	GERATTD	GERATTD_INVOLVE_IND
MENU	Menu Code for the invitee.	VARCHAR2(10)	GERATTD	GERATTD_MENU_CODE
MENU_DESC	Menu Code description for the invitee.	VARCHAR2(30)	GTVMENU	GTVMENU_DESC
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
NAME_TAG_NAME	Name tag name for the invitee.	VARCHAR2(230)	GERATTD	GERATTD_NAME_TAG_NAME
NUMBER_OF_TICKETS_REQUESTED	Number of tickets requested by the invitee.	VARCHAR2(3)	GERATTD	GERATTD_TICKET_CNT
PLACE_CARD_NAME	Place card name for the invitee.	VARCHAR2(230)	GERATTD	GERATTD_PLACE_CARD_NAME
PLAN_TO_ATTEND_IND	Indicator for whether or not person plans to attend function.	VARCHAR2(1)	GTVRSVP	GTVRSVP_PLAN_TO_ATTEND_IND
RSVP	RSVP Code for the invitee.	VARCHAR2(6)	GERATTD	GERATTD_RSVP_CODE
RSVP_DATE	Date RSVP for the invitee was entered.	DATE	GERATTD	GERATTD_RSVP_DATE
RSVP_DESC	RSVP Code description for the invitee.	VARCHAR2(30)	GTVRSVP	GTVRSVP_DESC
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA

Ver: