Function Space Configuration Export Data Definitions

There are 3 exports for Function Space Configuration, all generated during the night Audit on a weekly basis: Function Space Configuration (SPACE_CONFIG_EXPORT), Function Room Linking (SPACE_LINKS_EXPORT) and Function Room Setup (SPACE_SETUP_EXPORT). To run any 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. These exports collectively contain the Function Space configuration details.

Note: All transactions in the Function Space Configuration Exports are recorded as INS (Insert). The export file will be generated regardless if records exist in the exports or not. For an export generated with no records, the file will contain only a trailer.

FUNCTION_SPACE_CONFIG File Details

This export contains the configuration information for each function space.

COL_NAME	COL_LENGTH	COL_TYPE	FUNCTION
RECORD_TYPE	1	FUNCTION	4
SOURCE_SYSTEM	10	FUNCTION	OPERA
PROPERTY_CODE	5	FUNCTION	Resort
BUSINESS_DATE	10	FUNCTION	Business date (MM-DD-YYYY)
ROOM	15	ROOM	Function Space Code
DESCRIPTION	25	ROOM	Function Space Name
COMBO_YN	1	ROOM	Combo Space Y or N
AREA_F	9	ROOM	Area of the Function Space in Feet
AREA_M	9	ROOM	Area of the Function Space in Meters
MEETINGROOM_TYPE	10	ROOM	Meeting Room Type
END_DATE	10	FUNCTION	Out or Order / Service End Date
BEGIN_DATE	10	FUNCTION	Out of Order / Service Begin Date
ROOM_STATUS	2	FUNCTION	Out of Order (OO) or Out of Service (OS)
REASON_CODE	10	FUNCTION	Out or Order / Out of Service Reason Code

Note: Past Out of Order records will be included in this export if the End Date is within 7 days prior of the OPERA Business Date. Additionally, any deleted OO/OS records will not be included in the Export.

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:

SPACE_CONFIG_EXPORT = FS_N_SCPPL_D07195.TXT

Horizontal Rule

FUNCTION_SPACE_LINKS File Details

This export contains the linking information for function space and their combos.

COL_NAME	COL_LENGTH	COL_TYPE	FUNCTION
RECORD_TYPE	1	FUNCTION	5
SOURCE_SYSTEM	10	FUNCTION	OPERA
PROPERTY_CODE	5	FUNCTION	Resort
BUSINESS_DATE	10	FUNCTION	Business Date (MM-DD-YYYY)
COMBO_ELEMENT	15	ROOM$COMBO	Unique code given to an Individual Function Space (a room that cannot be divided)
COMBO_ROOM	15	ROOM$COMBO	Unique code given to a Combo Function Space (a room that can be divided into more than 1 room)

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:

SPACE_LINKS_EXPORT = SL_N_SCPPL_D07195.TXT

Horizontal Rule

FUNCTION_SPACE_SETUP File Details

This export contains the configured setup information for each function space.

COL_NAME	COL_LENGTH	COL_TYPE	FUNCTION
RECORD_TYPE	1	FUNCTION	6
SOURCE_SYSTEM	10	FUNCTION	OPERA
PROPERTY_CODE	5	FUNCTION	Resort
BUSINESS_DATE	10	FUNCTION	Business Date (MM-DD-YYYY)
SETUP_CODE	10	ROOM$SETUP	Setup Style
ROOM	15	ROOM$SETUP	Function Space Code
OCC_MIN	6	ROOM$SETUP	Minimum Occupancy for the Setup Style
OCC_MAX	6	ROOM$SETUP	Maximum Occupancy for the Setup Style
SETUP_TIME	4	ROOM$SETUP	Setup Minutes
SETDOWN_TIME	4	ROOM$SETUP	Tear Down Minutes
SETUP_CODE_DESC	30	FUNCTION	Setup Style description

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:

SPACE_SETUP_EXPORT = SS_N_SCPPL_D07195.TXT