Importing Catering Events

Events

• "EVT_Unique_ID_Event" CSV column value is stored in ”ORIG_EVENT_ID" column (Table: GEM$EVENT).

• The Rental Code corresponding to the Rental Amount will be "CUSTOM" always.

• For Master/Sub/Alternate Event imports, consider the following:

  • Master Event should be placed in CSV before the Sub/Alternate Event.

  • The above should be imported in sequence.

• Events won’t be imported for Out Of Order Function Space.

• Events will be imported for Blocks which have "BLK_Event_Attendees" populated in Blocks.csv.

• Return to Inventory status Events should not be imported for active Blocks.

Table 24-5 Events

Column	Description	Max Data Length	Sample Data	Mandatory
EVT_Unique_ID_Event	Unique ID value for Event in the uploaded csv files for Data type "Events" within an Import cycle.	200	Ex: (5010, 5011)
EVT_Block_ID	The Business Block ID.	200	Ex: (400010)
EVT_Type	The Event type of the Event.	8	Ex: (MTG)
EVT_Name	The Event Name of the Event.	60	Ex: (Meeting)
EVT_Status	The Event Status of the Event.	8	Ex: (INQ)
EVT_Start_Date	The Event Start Date. The format must be 'YYYYMMDD.'	DATE	Ex: (20210121)
EVT__End_Date	The Event End Date. The format must be 'YYYYMMDD.'	DATE	Ex: (1500)
EVT_Start_Time	The Event Start Time. The format must be 'HH24MI.'	TIME	Ex: (1500)
EVT_End_Time	The Event End Time. The format must be 'HH24MI.'	TIME	Ex: (1500)
EVT_Expected_Attendees	The Expected number of people attending the Event.		Ex: (20)
EVT_Guaranteed_Attendees	The Guaranteed number of people attending the Event.		Ex: (15)
EVT_Actual_Attendees	The Actual number of people attending the Event.		Ex: (10)
EVT_Space	Reserved Function Space for the Event	8	Ex: (CORA)
EVT_Shareable_YN	This flag indicates whether the Shareable Function Space would be booked as Exclusive or Shareable. This flag should be populated for a Shareable Function Space only.	1	Ex: (Y)
EVT_Master_YN	This flag indicates whether the Event is a Master Event. This flag should be populated if Master/Sub/Alternate Events are to be Imported.	1	Ex: (N)
EVT_Master_Event_Link_ID	Linked Master Event ID. This column should be populated if Master/Sub/Alternate Events are to be Imported.	200	Ex: (5012)
EVT_Link_Type	Event link type like ALTERNATE/SUB EVENT will be stored. This column should be populated if Master/Sub/Alternate Events are to be Imported.	20	Ex: (ALTERNATE)
EVT_Setup_Style	Function Space Setup. This column should be populated when "EVT_Space" is provided.	8	Ex: (CONF)
EVT_Setup_Time	Setup Time in Minutes.		Ex: (15)
EVT_Tear_Down_Time	Teardown Time in Minutes.		Ex: (15)
EVT_Rental_Amount	Rental Amount for the Event.		Ex: (105)
EVT_Display_Doorcard_YN	Display Doorcard Y/N.	1	Ex: (Y)
EVT_Doorcard	Doorcard Signage	50	Ex: (Adam's and Jill's Reception)
EVT_Loud_Event	This flag indicated whether it’s a Noisy Event.	1	Ex: (N)
EVT_Do_Not_Move	Don't move Flag.	1	Ex: (N)
EVT_NOTE1	Event Note 1.	2000	Ex: (Guest book at Entrance)
EVT_NOTE2	Event Note 2.	2000	Ex: (Guest book at Entrance)
EVT_NOTE3	Event Note 3.	2000	Ex: (Guest book at Entrance)
EVT_Forecast_Revenue_YN	This flag indicates, even though resources may be booked, only the forecasted values will drive reporting revenue.	1	Ex: (N)
EVT_Forecast_Revenue_Type_1	The Forecast Revenue Type 1 of the Event.	8	Ex: (BEV)
EVT_Forecast_Total_Revenue_1	The Forecasted Revenue 1 of the Event.		Ex: (20)
EVT_Forecast_Revenue_Type_2	The Forecasted Revenue 2 of the Event.	8	Ex: (FOOD)
EVT_Forecast_Total_Revenue_2	The Forecasted Revenue 2 of the Event.		Ex: (30)
EVT_Forecast_Revenue_Type_3	The Forecast Revenue Type 3 of the Event.	8	Ex: (RENTAL)
EVT_Forecast_Total_Revenue_3	The Forecasted Revenue 3 of the Event.		Ex: (100)
EVT_Forecast_Revenue_Type_4	The Forecast Revenue Type 4 of the Event.	8	Ex: (MISC)
EVT_Forecast_Total_Revenue_4	The Forecasted Revenue 4 of the Event.		Ex: (25)