TSA02 Export

The TSA02 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 TSA02 Export to view information about the reservation that had an action of CHECK IN on reservation 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.

tsa02_export_file_details

Export File Details Sample Setup

FILE_TYPE: TSA02

FILE_GROUP_ID: MISC

FILE_TYPE_DESC: TSA02 Export

SOURCE_VIEW_CODE: EXP_TSA02_VW

FILE_NAME: 'TSA02_'||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: TSA02EXPORTZIP

TSA02 File Header and Detail Data

See the TSA02 Export File Header and Details.