TSA04 Export

The TSA04 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 set up for the actual export file itself (see Export Files for details).

Select the TSA04 Export to view information about rooms by room class from table rep_manager for business date = business date -1.

The business date is the date for which the End of Day process is being done. So the data contained in the export file will be two days older when compared to the current business date. For example, if the End of Day is run for the date of the 20th, the data in the file will be for the 19th, and the current business date will be the 21st.

tsa04_export_file_details

Export File Details Sample Setup

FILE_TYPE: TSA04

FILE_GROUP_ID: MISC

FILE_TYPE_DESC: TSA04 Export

SOURCE_VIEW_CODE: EXP_TSA04_VW

FILE_NAME: 'TSA04_'||pms_p.resort||'_'||to_char(sysdate,'YYYYMMDD')

FILE_EXTENSION: 'csv'

COL_SEPERATOR: COMMA

WHERE_CLAUSE: business_date=to_char(pms_p.business_date-1,'DD-MM-YY')

ZIP_FILE_NAME: TSA04EXPORTZIP

TSA04 File Header and Detail Data

See the TSA04 Export File Header and Details.