Previous Topic

Next Topic

HSK STATUS EXP Data Definition

The Housekeeping Export can be configured to automatically generate and transmit 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 local resources to produce more up to the minute information. The file transfer from Opera to the database is completed by using the Opera OXI_HUB Interface, with an HTTP address that can be configured 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

Housekeeping Export

exp_create_data.get_hotel_code(pms_p.resort)||lpad(to_char(pms_p.business_date,'DDD'),3,'0')

 

The file name includes the HOTEL_CODE (from the Property Details screen). If Hotel Code is null, the Property Code (RESORT) is used.

'txt'

Export File Details

COL_NAME

COL_LENGTH

COL_TYPE

FORMULA

ATTENDANT_ID

12

VARCHAR2

 

ATTENDANT_NAME

30

VARCHAR2

 

BLANK

6

VARCHAR2

' '

BLANK

12

VARCHAR2

' '

BLANK

30

VARCHAR2

' '

BLANK

6

VARCHAR2

' '

BLANK

3

VARCHAR2

' '

BLANK

1

VARCHAR2

' '

BLANK

1

VARCHAR2

' '

BLANK

1

VARCHAR2

' '

JOB_TITLE_CODE

30

VARCHAR2

 

ROOM

30

VARCHAR2

 

BLOCK_CODE

20

VARCHAR2

 

TIME_IN

10

VARCHAR2

 

BLANK

3

VARCHAR2

' '

TIME_OUT

10

VARCHAR2

 

BLANK

30

VARCHAR2

' '

BLANK

2

VARCHAR2

' '

BLANK

5

VARCHAR2

' '

BLANK

5

VARCHAR2

' '

BLANK

5

VARCHAR2

' '

BLANK

5

VARCHAR2

' '

BLANK

6

VARCHAR2

' '

BLANK

1

VARCHAR2

' '

BLANK

2

VARCHAR2

' '

BLANK

2

VARCHAR2

' '

BLANK

2

VARCHAR2

' '

BLANK

2

VARCHAR2

' '

BLANK

2

VARCHAR2

' '

BLANK

2

VARCHAR2

' '

BLANK

2

VARCHAR2

' '

BLANK

1

VARCHAR2

' '

BLANK

9

VARCHAR2

' '

BLANK

1

VARCHAR2

' '

BLANK

9

VARCHAR2

' '

BLANK

1

VARCHAR2

' '

BLANK

9

VARCHAR2

' '

BLANK

6

VARCHAR2

' '

BLANK

2

VARCHAR2

' '

BLANK

1

VARCHAR2

' '

BLANK

2

VARCHAR2

' '

BLANK

6

VARCHAR2

' '

BLANK

5

VARCHAR2

' '

BLANK

6

VARCHAR2

' '

BLANK

2

VARCHAR2

' '

BLANK

10

VARCHAR2

' '

BLANK

5

VARCHAR2

' '

BLANK

5

VARCHAR2

' '

BLANK

1

VARCHAR2

' '

BLANK

9

VARCHAR2

' '

BLANK

1

VARCHAR2

' '

BLANK

9

VARCHAR2

' '

BLANK

5

VARCHAR2

' '

BLANK

9

VARCHAR2

' '

BLANK

9

VARCHAR2

' '

BLANK

1

VARCHAR2

' '

BLANK

15

VARCHAR2

' '

BLANK

13

VARCHAR2

' '

BLANK

80

VARCHAR2

' '

See Also