Importing Rooms Management

Out Of Service

Data referenced in this import template is available on the Out of Order by Reason report (hkooobyreason). Available when the Stay Records OPERA Control is active.

Column	Description	Max Data Length	Sample Data	Mandatory
Room	The room for the Out Of Service record. The room must exist in the property.	8	Ex: (101)
Reason_Code	The Out of Service reason. The reason must exist in the property.	8	EX: (BULB)
Begin_Date	The Begin Date of the Out of Service record. The Begin Date has to be equal to or greater than the current business date of the property. The Begin Date cannot be after the End Date. The format must be 'YYYYMMDD	8	Ex: (20230501)
End_Date	The End date of the Out of Service record. The End Date has to be equal to or greater than the Begin Date of the property. The format must be 'YYYYMMDD	8	Ex: (20230510)
Return_Status	The room status the room will be upon being removed from Out Of Service. Valid values are: - DI - CL - IP (when the Inspected Status OPERA Control is active) - PU (when the Pickup Status OPERA Control is active)	2	Ex: (DI)
Repair_Remarks	Any optional remark related to the out of service record.	1000	Ex: (Bathroom Bulb is broken)

Out Of Order

Data referenced in this import template is available on the Out of Order by Reason report (hkooobyreason). Available when the Out Of Order OPERA Control is active.

Note:

Once imported a Room Inventory Synchronization must be performed for the date range of the imported Out of Order records.

Column	Description	Max Data Length	Sample Data	Mandatory
Room	The room for the Out Of Order record. The room must exist in the property.	8	Ex: (101)
Reason_Code	The Ouf of Order reason. The reason must exist in the property.	8	EX: (BULB)
Begin_Date	The Begin Date of the Out of Order record. The Begin Date has to be equal to or greater than the current business date of the property. The Begin Date cannot be after the End Date. The format must be 'YYYYMMDD	8	Ex: (20230501)
End_Date	The End date of the Out of Order record. The End Date has to be equal to or greater than the Begin Date of the property. The format must be 'YYYYMMDD	8	Ex: (20230510)
Return_Status	The room status the room will be upon being removed from Out Of Order. Valid values are: - DI - CL - IP (when the Inspected Status OPERA Control is active) - PU (when the Pickup Status OPERA Control is active)	2	Ex: (DI)
Repair_Remarks	Any optional remark related to the Out of Order record.	1000	Ex: (Bathroom Bulb is broken)

Room Conditions

Data referenced in this import template is available on the Room Conditions report (hkassignroomall). Available when the Room Conditions OPERA Control is active.

Column	Description	Max Data Length	Sample Data	Mandatory
Room	The room for the Room Condition record. The room must exist in the property.	8	Ex: (101)
Assign_Reason	The reason to assign a room condition to the room. The reason must exist in the property.	8	Ex: (CARPET)
Remarks	Any optional remark related to the room condition.	2000	Ex: (Wet Carpet)

Room Maintenance

Unresolved (open) status. Data referenced in this import template is available on the Room Maintenance report (room_maintenance). Available when the Room Maintenance OPERA Control is active.

Column	Description	Max Data Length	Sample Data	Mandatory
Room	The room for the Room Maintenance record. The room must exist in the property.	8	Ex: (101)
Reason	The reason to mark the room for maintenance. The reason must exist in the property.	8	Ex: (WINDOW)
Repair_Remarks	Any remark related to the room maintenance request.	2000	Ex: (Replace Window)

Room Discrepancy

Data referenced in this import template is available on the Room Discrepancy report (hkroomdiscrepancy). Available when the Discrepant Rooms OPERA Control is active.

Column	Description	Max Data Length	Sample Data	Mandatory
Room	The room for the Room Discepancies record. The room must exist in the property.	8	Ex: (101)
HK_Status	The housekeeping status of the room. Valid Values are OCC and VAC.	3	Ex: (VAC)

Guest Service Status

Data referenced in this import template is available on the Housekeeping Details report (hk_details). Available when the Guest Service Status OPERA Control is active.

Column	Description	Max Data Length	Sample Data	Mandatory
Room	The room for the Guest Service Status record. The room must exist in the property.	8	Ex: (101)
Service_Status	The Guest Service Status of the room. Valid values are DND and MUP.	3	Ex: (MUP)

Room Status

Data referenced in this import template is available on the Room Discrepancy (hkroomdiscrepancy) or the Housekeeping Details (hk_details) report.

• IP (when the Inspected Status OPERA Control is active)

• PU (when the Pickup Status OPERA Control is active)

Column	Description	Max Data Length	Sample Data	Mandatory
Room	The room for the Room Status record. The room must exist in the property.	8	Ex: (101)
Status	The status of the room. Valid Values are: DI CL IP (when the Inspected Status OPERA Control is active) PU (when the Pickup Status OPERA Control is active)	2	Ex: (DI)