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) |
Parent topic: About Data Import