Stage Financial Statistics

The Data Mart Staged Records functionality allows you to view records that were rejected, and therefore staged, by the system during data upload and conversion from PMS to OXI to ORS/OCIS data marts. These rejected records were staged because they were incomplete or inaccurate. By using the ORS>Data Mart screens you can view these records and their errors, make corrections, and then process them to be uploaded to the appropriate data mart.

Access the Financial Statistics Staged Records screen by selecting ORS>Data Mart>Stage Financial Statistics. This screen displays the property, relevant dates, PMS Confirmation Number and Transaction Code, Market, Status, and Import Date. For specific results, select the Property from the Property LOV and/or the Import Date and select Search.



You have several options for working with staged records from the Reservations Daily Statistics Staged Records screen.

Financial Statistics Error Summary

This screen is accessed from the Financial Statistics Staged Records screen, when Summary is selected. The Error Summary screen lists a description of all the errors that occurred while processing the reservations.


Financial Statistics Staged Record

This screen is accessed from Financial Statistics Staged Records>Edit or from the Error Summary screen when you double-clicked on an error. Here you can change the field highlighted in red, explained in the bottom Error Grid.


See Also