Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Common Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: EVENT_INVITEE - Event Invitee

Description Contains records pertaining to invitees.
Key & Frequency One row per person_uid, per function_code and per event_identification.
Recommended Search Columns EVENT_IDENTIFICATION, FUNCTION_CODE, INVITEE_UID

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ADDRESS_TYPE The type of address.    

GERATTD

GERATTD_ATYP_CODE

 
ADDRESS_TYPE_DESC The description of the type of address.    

STVATYP

STVATYP_DESC

 
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 
ATTENDANCE_IND Indicator to display whether or not the invitee actually attended the function.    

GERATTD

GERATTD_ATTENDANCE_IND

 
DEFAULT_EVENT_TYPE This column specifies the default event type code.    

GTVFUNC

GTVFUNC_ETYP_CODE

 
DEFAULT_EVENT_TYPE_DESC This column specifies the default event type description.    

STVETYP

STVETYP_DESC

 
EVENT_IDENTIFICATION Internal event identification number.    

GERATTD

GERATTD_EVNT_CRN

 
FEE_PAID_IND Fee Paid Indicator.    

GTVFEES

GTVFEES_PAID_IND

 
FEE_STATUS Fee Status Code for the invitee.    

GERATTD

GERATTD_FEES_CODE

 
FEE_STATUS_DATE Date fee status was last updated or modified for the invitee.    

GERATTD

GERATTD_FEE_DATE

 
FEE_STATUS_DESC Fee Status description for the invitee.    

CALCULATION

NVL(GERATTD_FEES_DESC, GTVFEES_DESC)

 
FUNCTION_CODE This field specifies the function code.    

GERATTD

GERATTD_FUNC_CODE

 
FUNCTION_DESC This field specifies the function description.    

GTVFUNC

GTVFUNC_DESC

 
INVITEE_COMMENT Comment for the invitee.    

FUNCTION

GOKODSF.F_TRIM_LONGS

 
INVITEE_UID Internal system generated number associated with the person invited to the function.    

GERATTD

GERATTD_PIDM

 
INVOLVED_IND Indicator to display any involvement for the invitee.    

GERATTD

GERATTD_INVOLVE_IND

 
MENU Menu Code for the invitee.    

GERATTD

GERATTD_MENU_CODE

 
MENU_DESC Menu Code description for the invitee.    

GTVMENU

GTVMENU_DESC

 
MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied.    

NA

NA

 
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

 
NAME_TAG_NAME Name tag name for the invitee.    

GERATTD

GERATTD_NAME_TAG_NAME

 
NUMBER_OF_TICKETS_REQUESTED Number of tickets requested by the invitee.    

GERATTD

GERATTD_TICKET_CNT

 
PLACE_CARD_NAME Place card name for the invitee.    

GERATTD

GERATTD_PLACE_CARD_NAME

 
PLAN_TO_ATTEND_IND Indicator for whether or not person plans to attend function.    

GTVRSVP

GTVRSVP_PLAN_TO_ATTEND_IND

 
PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 
RSVP RSVP Code for the invitee.    

GERATTD

GERATTD_RSVP_CODE

 
RSVP_DATE Date RSVP for the invitee was entered.    

GERATTD

GERATTD_RSVP_DATE

 
RSVP_DESC RSVP Code description for the invitee.    

GTVRSVP

GTVRSVP_DESC

 


Ver: 8.3