Catering Events Export Data Definition

There are 2 exports for Catering Events. The 1st is run using a parameter form (CAT_EV_INITIAL_EXP), the 2nd is automatically generated during the Night Audit (2_CAT_EV_EXP) and is based on that day’s transactions. To run either of these exports manually: from S&C select Miscellaneous > Export Files, from PMS select Miscellaneous > File Export > General or from Configuration select External > Export Files.

Note: The Catering Events Export captures all changes based on the Business Date the change is made. The Business Date must be within 5 days of the System Date for changes to be considered for the Export. The export file will be generated regardless if records exist in the export or not. For an export generated with no records, the file will contain only a trailer. The trailer record shows the number of records and System Date when the export file was generated.

The intention of this export is to send defined Event information based on the following conditions:

Creating a new event will trigger an INS in the export.
Changing any field in an Event will trigger an UPD record in the export.
Adding or deleting a resource that changes the event revenue will trigger an UPD record in the export.
Changing the date of an Event will trigger an UPD record in the export.
Deleting an Event will trigger a DEL record in the export and the revenues will be reported as zeros.
Note: When an INS and DEL happen on the same Business Date, no record will be in the Export. When INS and UPD happen on the same Business Date, only an INS record will be in the Export.

2_CAT_EV_EXP & CAT_EV_INITIAL_EXP File Details

COL_NAME	COL_LENGTH	COL_TYPE	Function
RECORD_TYPE	1	FUNCTION	2
SOURCE_SYSTEM	10	FUNCTION	OPERA
PROPERTY_CODE	5	FUNCTION	Resort
BUSINESS_DATE	10	FUNCTION	Business Date (MM-DD-YYYY)
TRANSACTION_TYPE	3	FUNCTION	Indicates if record is Insert, Update, or Delete.
BOOK_ID	15	GEM$EVENT	Business Block ID
COMPANY_NAME_ID	15	FUNCTION	Company ID
EVENT_ID	15	GEM$EVENT	Event ID
EV_STATUS	5	GEM$EVENT	Event Status
EV_TYPE	5	GEM$EVENT	Event Type Code
TOTAL_CAT_REV	17	FUNCTION	Total revenue the function will generate.
TOTAL_CAT_REV_NET	17	FUNCTION	Net Total Catering Revenue
CAT_REV_GROUP1	17	FUNCTION	Revenue Generated for the Revenue Types linked to the Revenue Group configured as sequence 1.
CAT_REV_GROUP1_NET	17	FUNCTION	Net is based on Configured percentages stored with Rev Types.
CAT_REV_GROUP2	17	FUNCTION	Revenue Generated for the Revenue Types linked to the Revenue Group configured as sequence 2.
CAT_REV_GROUP2_NET	17	FUNCTION	Net is based on Configured percentages stored with Rev Types.
CAT_REV_GROUP3	17	FUNCTION	Revenue Generated for the Revenue Types linked to the Revenue Group configured as sequence 3.
CAT_REV_GROUP3_NET	17	FUNCTION	Net is based on Configured percentages stored with Rev Types.
CAT_REV_GROUP4	17	FUNCTION	Revenue Generated for the Revenue Types linked to the Revenue Group configured as sequence 4.
CAT_REV_GROUP4_NET	17	FUNCTION	Net is based on Configured percentages stored with Rev Types.
CAT_REV_GROUP5	17	FUNCTION	Revenue Generated for the Revenue Types linked to the Revenue Group configured as sequence 5.
CAT_REV_GROUP5_NET	17	FUNCTION	Net is based on Configured percentages stored with Rev Types.
CAT_REV_GROUP6	17	FUNCTION	Revenue Generated for the Revenue Types linked to the Revenue Group configured as sequence 6.
CAT_REV_GROUP6_NET	17	FUNCTION	Net is based on Configured percentages stored with Rev Types.
MEAL_PERIOD	5	FUNCTION	Meal Type mapped to the Event Type
START_DATE	10	GEM$EVENT	Start date for this event (MM-DD- YYYY).
END_DATE	10	GEM$EVENT	End date for this event (MM-DD- YYYY).
START_TIME	5	GEM$EVENT	Start time for this event (HH:MM).
END_TIME	5	GEM$EVENT	End time for this event (HH:MM).
ROOM	15	GEM$EVENT	Function Space Code
ATTENDEES	6	GEM$EVENT	Expected/Forecasted attendees for this event.
GUARANTEED	6	GEM$EVENT	Guaranteed Attendees
ACTUAL_ATTENDEES	6	GEM$EVENT	Actual Attendees
ROOM_SETUP	10	GEM$EVENT	Setup Style Code
MASTER_EVENT_ID	15	GEM$EVENT	Master Event ID for Sub Events
EVENT_LINK_TYPE	10	GEM$EVENT	Indicates if the Event is an alternate event.
EVENT_LINK_ID	10	GEM$EVENT	Master Event ID for Alternate Events.
FORECAST_YN	1	GEM$EVENT	Indicates if Use Forecast Revenue Only flag is checked for the event.

Naming Convention

The file naming convention for this export is as follows:

2 Character Record Identifier + Initial/Non-Initial Indicator + 5 Character Property Code + Number the day is in the year.TXT

Using a business date of 07/14/07 and resort = SCPPL, the file names will be:

2_CAT_EV_EXP = CE_N_SCPPL_D07195.TXT

CAT_EV_INITIAL = CE_I_SCPPL_D07195.TXT