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