Departures Export Data Definition (POST_STAY_EXPORT)

The Departures Export is automatically generated and transmitted to the application server during the End of Day procedure in OPERA. But this export can be manually run by selecting Miscellaneous>File Export>General or Configuration>External>Export Files. This export file is available on-demand to allow for external and local resources to produce more up to the minute information in case of an emergency.

File transfer can be completed via the OPERA OXI_HUB Interface, with an HTTP address that is set up for the export file (see Export Files for details).

Views Used by this Export

General Reservations Export View: EXP_GENERAL_RESV_VIEW - Export view for reservation details. This view requires the Pre-Export procedure EXP_GENERAL_RESV_PKG.CREATE_EXPORT(‘PS’) to populate data.


Pre-Export Procedure


The ‘PS’ parameter  is required; this parameter indicates that this export requires post stay data.

Explanation of the Procedure

The pre-export procedure EXP_GENERAL_RESV_PKG.CREATE_EXPORT(Type, Export_bucket_type, from_Date, to_date) is used to get data for the reservations that fall within the from date and to date range.  The procedure extracts the data required and stores it in a temporary table. The view reads from this table and creates the export data.  The temporary table is deleted after the export is completed.

Parameters used for the procedure:

Type. . Export type. This procedure is used for different exports. Based on the type of export the data will be retrieved.

Parameters that can be used are:

‘PS’ – Post Stay export

‘PA’ – Pre Arrival export.

‘GV1’ – GV1_EXPORT Gold passport export.

‘GL1’ -  GL1_EXPORT – Airline Guests export

‘GH’ – GST HIST EXPORT  - Guest History Export

If no parameter is specified, the export will look at all reservations.  This is not recommended.

Export bucket type.  Default used is ‘DEFAULT’ bucket type.  The revenue bucket information calculated as part of this view will be based on this bucket type.

From Date and To date. Start date and end date of the export.

Default is pms_p.business_date.

Post-Export Procedure

exp_create_data.delete_report_table – Cleans up the data added by the Pre-Export procedure.

Parameter Form


Input parameters:

From Date.  Start date of export.

To Date. End date of export.

Export Bucket Type. Bucket type to be used for the export.

Export Type. Type of Export (PA,PS,GL1,GV1, GH).

Filter Conditions


File Name Formula


File Extension Formula


POST_STAY_EXPORT File Header and Detail Data

See the Departures Export File Header and Detail Data

See Also