Backlog Export Data Definition (BACKLOG_EXPORT & BACKLOG_EXPORT

Backlog Export Data Definition (BACKLOG_EXPORT & BACKLOG_EXPORT_DAILY)

The Backlog Export is automatically generated and transmitted to the application server during the Night Audit 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. The file transfer from OPERA to the database is completed by using the OPERA OXI_HUB Interface, with an HTTP address that is setup for the actual export file itself (see Export Files for details).

Select the Backlog Export to view information about the year-to-date production figure for a property. These figures will contain the current year and the two subsequent years data. Room nights and net revenue are listed by status, but the last status is only reported on. These figures are then split by market segment and stay month.

backlog_export_file_details

Export File Details Sample Setup

FILE_TYPE: BACKLOG_EXPORT

FILE_GROUP_ID: MISC

FILE_TYPE_DESC: BackLog Exports

SOURCE_VIEW_CODE: BACKLOG_VIEW

FILE_NAME: resort||'BACKLOG'

FILE_EXTENSION: 'TXT'

COL_SEPERATOR: COMMA

WHERE_CLAUSE: export_id=backlog_blocks.get_last_report_id

RUN_IN_NA_YN: N

COMPRESSDATA_YN: Y

PRE_EXP_PROC: backlog_blocks.create_export_data(pms_p.business_date)

POST_EXP_PROC: backlog_blocks.delete_report_table

BATCH_SEQ: 9

ADD_NEWLINE_YN: Y

NA_FREQUENCY: EOM

ALWAYS_HDRFOOTER_YN: N

FTP_UPLOAD_YN: N

OXI_INTERFACE_ID: ORS

HTTP_UPLOAD_YN: N

AUTO_EXPORT_YN: N

SFTP_YN: Y

BACKLOG_EXPORT File Header and Detail Data

See the Backlog Export File Header and Details.