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