|
|
|
Pre Arrival Export Data Definition
The Arrivals Export is automatically generated and transmitted to the application server during the Night Audit procedure in Opera. But this export can be manually ran 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).
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.
exp_general_resv_pkg.create_export('PA')
The ‘PA’ parameter is required to indicate this is a Pre-Arrival Export.
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.
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.
exp_create_data.delete_report_table – Cleans up the data added by the Pre-Export procedure.
EXP6
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).
export_id=exp_create_data.get_last_report_id and internal_room_cat_number not like '- %'
'PA'||UPPER(SUBSTR(PROPERTY_CODE,1,5)) - PROPERTY_CODE is the hotel code setup in the property details screen.
'DAT'
Compress Data : 'Y'
Delimiter: '|'
FILE_GROUP_ID |
FILE_TYPE_DESC |
FILE and ZIP_FILE_NAME |
FILE_EXTENSION |
MISC |
Arrivals Export |
'WY_296' |
DAT |
COL_NAME |
COL_LENGTH |
COL_TYPE |
FORMULA |
CONTROL_CHAR |
1 |
FORMULA |
'H' |
CREATION_DATE |
8 |
FORMULA |
TO_CHAR(PMS_P.BUSINESS_DATE,'MMDDYYYY') |
CREATION_TIME |
8 |
FORMULA |
TO_CHAR(SYSDATE,'HH:MI:SS') |
FILE_TYPE |
2 |
FORMULA |
'PA' |
TOTAL_ARRIVAL_RECORDS |
5 |
NUMBER |
|
RECORD_ID |
3 |
FORMULA |
'D|0' |
DEFAULT_MEMBERSHIP_NUMBER |
9 |
FORMULA |
DEFAULT_MEMBER_CARD_NO |
STATUS_TYPE_CD |
2 |
FORMULA |
decode(reservation_status,'CHECKED OUT','IN','CHECKED IN','IN', |
MARSHA_CODE |
5 |
FORMULA |
UPPER(PROPERTY_CODE) |
RATE_CODE |
6 |
FORMULA |
UPPER(RATE_CODE) |
CONFIRMATION_NO |
11 |
NUMBER |
|
CRS_CONFIRMATION_NO |
8 |
FORMULA |
UPPER(CRS_CONFIRMATION_NO) |
GUEST_FIRST_NAME |
20 |
FORMULA |
UPPER(GUEST_FIRST_NAME) |
GUEST_LAST_NAME |
20 |
FORMULA |
UPPER(GUEST_LAST_NAME) |
ARRIVAL_DATE |
10 |
DATE |
|
ROOM_NIGHTS_TOTAL |
3 |
NUMBER |
|
STAY_PREF |
18 |
FORMULA |
UPPER(REPLACE(UDFC38,',',':')||DECODE(UDFC38,NULL,NULL,DECODE |
ROOM_TYPE |
5 |
FORMULA |
UPPER(ROOM_TYPE) |
ROOM |
6 |
FORMULA |
UPPER(ROOM) |
GUEST_STATE_CODE |
3 |
FORMULA |
UPPER(GUEST_STATE_CODE) |
GUEST_POSTAL_CODE |
12 |
FORMULA |
UPPER(GUEST_POSTAL_CODE) |
GUEST_TELEPHONE |
16 |
FORMULA |
EXP_GENERAL_RESV_PKG.GET_CHARS_NUMBERS(GUEST_TELEPHONE) |
GUEST_COUNTRY_CODE |
2 |
FORMULA |
UPPER(GUEST_COUNTRY_CODE) |
CREDIT_CARD_NO |
16 |
VARCHAR2 |
|
DELIMITER |
4 |
FORMULA |
'|||' |
FOOTER |
1 |
FORMULA |
'Z' |
DELIMITER |
1 |
FORMULA |
'' |
DELIMITER |
1 |
FORMULA |
'' |
See Also
