Previous Topic

Next Topic

Generic Profiles Data Definition

The Generic Profiles 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).

Export File Header

FILE_GROUP_ID

FILE_TYPE_DESC

FILE and ZIP_FILE_NAME

FILE_EXTENSION

MISC

Generic Profiles Export

 

TXT

Export File Details

COL_NAME

COL_LENGTH

COL_TYPE

FORMULA

LAST_RATE

13

NUMBER

 

NAME

20

VARCHAR2

 

CITY

15

VARCHAR2

 

COUNTRY

15

VARCHAR2

 

LAST_STAY

11

DATE

 

VIP_NAME

25

VARCHAR2

 

VIP_STATUS

20

VARCHAR2

 

FIRST

15

VARCHAR2

 

ADDRESS1

15

VARCHAR2

 

ADDRESS2

15

VARCHAR2

 

ADDRESS3

15

VARCHAR2

 

ZIP_CODE

15

VARCHAR2

 

STATE_DESC

20

VARCHAR2

 

COUNTRY_DESC

25

VARCHAR2

 

 See Also