| Target Column | 
Business Name | 
Business Definition | 
Database Data Type | 
Source Name | 
Source Column | 
| 
ADDRESS_TYPE
 | 
Address Type 
 | 
The type of address.
 | 
VARCHAR2(63)
 | 
 GERATTD
 
 | 
 GERATTD_ATYP_CODE
 
 | 
| 
ADDRESS_TYPE_DESC
 | 
Address Type Description 
 | 
The description of the type of address.
 | 
VARCHAR2(255)
 | 
 STVATYP
 
 | 
 STVATYP_DESC
 
 | 
| 
ADMINISTRATIVE_GROUP
 | 
Administrative Group 
 | 
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
 | 
VARCHAR2(255)
 | 
 NA
 
 | 
 NA
 
 | 
| 
ATTENDANCE_IND
 | 
Attendance Indicator 
 | 
Indicator to display whether or not the invitee actually attended the function.
 | 
VARCHAR2(63)
 | 
 GERATTD
 
 | 
 GERATTD_ATTENDANCE_IND
 
 | 
| 
DEFAULT_EVENT_TYPE
 | 
Default Event Type 
 | 
This column specifies the default event type code.
 | 
VARCHAR2(63)
 | 
 GTVFUNC
 
 | 
 GTVFUNC_ETYP_CODE
 
 | 
| 
DEFAULT_EVENT_TYPE_DESC
 | 
Default Event Type Description 
 | 
This column specifies the default event type description.
 | 
VARCHAR2(255)
 | 
 STVETYP
 
 | 
 STVETYP_DESC
 
 | 
| 
EVENT_IDENTIFICATION
 | 
Event ID 
 | 
Internal event identification number.
 | 
VARCHAR2(63)
 | 
 GERATTD
 
 | 
 GERATTD_EVNT_CRN
 
 | 
| 
FEE_PAID_IND
 | 
Fee Paid Indicator 
 | 
Fee Paid Indicator.
 | 
VARCHAR2(63)
 | 
 GTVFEES
 
 | 
 GTVFEES_PAID_IND
 
 | 
| 
FEE_STATUS
 | 
Fee Status 
 | 
Fee Status Code for the invitee.
 | 
VARCHAR2(63)
 | 
 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(255)
 | 
 CALCULATION
 
 | 
 NVL(GERATTD_FEES_DESC, GTVFEES_DESC)
 
 | 
| 
FUNCTION_CODE
 | 
Function Code 
 | 
This field specifies the function code.
 | 
VARCHAR2(63)
 | 
 GERATTD
 
 | 
 GERATTD_FUNC_CODE
 
 | 
| 
FUNCTION_DESC
 | 
Function Description 
 | 
This field specifies the function description.
 | 
VARCHAR2(255)
 | 
 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
 | 
 GERATTD
 
 | 
 GERATTD_PIDM
 
 | 
| 
INVOLVED_IND
 | 
Involved Indicator 
 | 
Indicator to display any involvement for the invitee.
 | 
VARCHAR2(63)
 | 
 GERATTD
 
 | 
 GERATTD_INVOLVE_IND
 
 | 
| 
MENU
 | 
Menu 
 | 
Menu Code for the invitee.
 | 
VARCHAR2(63)
 | 
 GERATTD
 
 | 
 GERATTD_MENU_CODE
 
 | 
| 
MENU_DESC
 | 
Menu Description 
 | 
Menu Code description for the invitee.
 | 
VARCHAR2(255)
 | 
 GTVMENU
 
 | 
 GTVMENU_DESC
 
 | 
| 
MULTI_SOURCE
 | 
Multi Source 
 | 
Institution value for the record when the optional multi-institution facility feature has been applied.
 | 
VARCHAR2(63)
 | 
 NA
 
 | 
 NA
 
 | 
| 
MULTI_SOURCE_DESC
 | 
Multi Source Description 
 | 
Institution description when the optional multi-institution facility feature has been applied.
 | 
VARCHAR2(255)
 | 
 NA
 
 | 
 NA
 
 | 
| 
NAME_TAG_NAME
 | 
Name Tag Name 
 | 
Name tag name for the invitee.
 | 
VARCHAR2(255)
 | 
 GERATTD
 
 | 
 GERATTD_NAME_TAG_NAME
 
 | 
| 
NUMBER_OF_TICKETS_REQUESTED
 | 
Number Of Tickets Requested 
 | 
Number of tickets requested by the invitee.
 | 
VARCHAR2(63)
 | 
 GERATTD
 
 | 
 GERATTD_TICKET_CNT
 
 | 
| 
PLACE_CARD_NAME
 | 
Place Card Name 
 | 
Place card name for the invitee.
 | 
VARCHAR2(255)
 | 
 GERATTD
 
 | 
 GERATTD_PLACE_CARD_NAME
 
 | 
| 
PLAN_TO_ATTEND_IND
 | 
Plan To Attend Indicator 
 | 
Indicator for whether or not person plans to attend function.
 | 
VARCHAR2(63)
 | 
 GTVRSVP
 
 | 
 GTVRSVP_PLAN_TO_ATTEND_IND
 
 | 
| 
PROCESS_GROUP
 | 
Process Group 
 | 
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
 | 
VARCHAR2(255)
 | 
 NA
 
 | 
 NA
 
 | 
| 
RSVP
 | 
RSVP 
 | 
RSVP Code for the invitee.
 | 
VARCHAR2(63)
 | 
 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(255)
 | 
 GTVRSVP
 
 | 
 GTVRSVP_DESC
 
 |