Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Common Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AG_EVENT_INVITEE

Description Contains records pertaining to invitees.

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

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

GERATTD

GERATTD_ATTENDANCE_IND

 
CURRENT_DATE System current date (sysdate) or date the data was extracted.    

NA

SYSDATE

 
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

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

NA

NA

 
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

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

NA

NA

 
MIF_VALUE Institution value for the record 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

 
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

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

NA

NA

 


Ver: 8.3