System Parameters

This section describes the available Parameters for the CARICOM module and they are accessible in Administration module, System Setup, Parameter.

Table A-3 PAR Group CARICOM

PAR Name PAR Value Description

CARICOM Web Service SOAPAction

[website]

Web Service SOAP Action for the CARICOM System

CARICOM Web Service SOAPHeader

[website]

Web Service SOAP Header for the CARICOM System

CARICOM Web Service URL

[website]

Web Service URL for the CARICOM System

Default to FNU on blank UXP_A_FSTN or FIRST_NAME

1

1 – Enable. If the guest first name is null, it defaults the First Name field as “FNU”

0 – Disable. If disabled, the First Name field cannot be null

File Name of CARICOM PORT Setup File

CARICOMPORTS.xlsx

Support Excel file extension for XLS instead of XLSX.

File Output Folder

[path]

Allows output file to be saved to a user-defined folder. For example, C:\temp\xxxx\Caricom

Include VOYAGE_NUMBER During Submission

 

VOYAGE_NUMBER:

1=Time Stamp,

2=SCR_ITN_ID,

Blank=NULL

Mandatory Birthdate Field

1

1 – Enable the birthdate field as mandatory

0 – Disable birthdate field for guests/crew handling

Mandatory Fields For <ARRIVE>

<element>

Specify the mandatory XML fields for <ARRIVE> element that CARICOM program will check during file creation. Use Comma Delimited Values.

For example, ARRIVE_DT,ARRIVE_TIME,PORT_NAME,CITY,STATE,FACILITY,PLACE

Mandatory Fields For <CARGO>

<element>

Specify the mandatory XML fields for <CARGO> element that CARICOM program checks during file creation. Use Comma Delimited Values.

For example, GENERAL_DESC,CDC_ON_BOARD

Mandatory Fields For <COMP_CERT>

<element>

Specify the mandatory XML fields for <COMP_CERT> element that CARICOM program will check during file creation. Use Comma Delimited Values.

For example, ISSUED_DT,EXPIRATION_DT,AGENCY

Mandatory Fields For <CONTACT>

<element>

Specify the mandatory XML fields for <CONTACT> element that CARICOM program will check for during file creation. Use Comma Delimited Values.

For example, NAME,PHONE

Mandatory Fields For <CREW>

<element>

Specify the mandatory XML fields for <CREW> element that CARICOM program checks during file creation. Use Comma Delimited Values.

For example, POSITION,LAST_NAME,FIRST_NAME,BIRTH_DT,GENDER,NATIONALITY,NATIONALITY_CODE,COUNTRY_RESIDENCE,COUNTRY_RESIDENCE_CODE,ID_TYPE,ID_NUM,ID_COUNTRY,ID_COUNTRY_CODE,EMBARK_COUNTRY,EMBARK_COUNTRY_CODE,EMBARK_STATE,EMBARK_PORT_NAME,EMBARK_PORT_CODE,EMBARK_DATE

Mandatory Fields For <DEPART>

<element>

Specify the mandatory XML fields for <DEPART> element that CARICOM program will check during file creation. Use Comma Delimited Values.

For example, DEPART_DT,DEPART_TIME,PORT_NAME,CITY,STATE,PLACE

Mandatory Fields For <ISSC>

<element>

Specify the mandatory XML fields for <ISSC> element that CARICOM program will check during file creation. Use Comma Delimited Values.

For example, ISSUED_DT,VSP_IMPLEMENTATION,ISSC_TYPE,INTERIM_ISSC,FLAG_ADMINISTRATION,FLAG_ADMINISTRATION_CODE,CSO_NAME,CSO_PHONE

Mandatory Fields For <LAST_PORT>

<element>

Specify the mandatory XML fields for <LAST_PORT> element that CARICOM program checks during file creation. Use Comma Delimited Values.

For example, ARRIVE_DT,DEPARTURE_DT,LAST_PORT_COUNTRY,LAST_PORT_COUNTRY_CODE,LAST_PORT_STATE,LAST_PORT_NAME,LAST_PORT_CODE,LAST_PORT_PLACE

Mandatory Fields For <NEXT_PORT>

<element>

Specify the mandatory XML fields for <NEXT_PORT> element that CARICOM program checks during file creation. Use Comma Delimited Values.

For example, ARRIVE_DT,ARRIVE_TIME,NEXT_PORT_COUNTRY,NEXT_PORT_COUNTRY_CODE,NEXT_PORT_STATE,NEXT_PORT_NAME,NEXT_PORT_CODE,NEXT_PORT_PLACE

Mandatory Fields For <NONCREW>

<element>

Specify the mandatory XML fields for <NONCREW> element that CARICOM program checks during file creation. Use Comma Delimited Values.

For example, LAST_NAME,FIRST_NAME,BIRTH_DT,GENDER,NATIONALITY,NATIONALITY_CODE,COUNTRY_RESIDENCE,COUNTRY_RESIDENCE_CODE,ID_TYPE,ID_NUM,ID_COUNTRY,ID_COUNTRY_CODE,ID_EXPIRATION_DT,US_ADDRESS_STREET,US_ADDRESS_CITY,US_ADDRESS_ZIP

Mandatory Fields For <NONCREW> 1

<element>

Specify the mandatory XML fields for <NONCREW> element that CARICOM program checks during file creation. Use Comma Delimited Values. (Continued)

For example, EMBARK_COUNTRY,EMBARK_COUNTRY_CODE,EMBARK_STATE,EMBARK_PORT_NAME,EMBARK_PORT_CODE,EMBARK_DATE

Mandatory Fields For <NOTICE_DETAILS>

<element>

Specify the mandatory XML fields for <NOTICE_DETAILS> element that CARICOM program checks during file creation. Use Comma Delimited Values

For example, CREATED_DATE_TIME,NOTICE_ID,NOTICE_TRANSACTION_TYPE,NOTICE_TYPE,VERSION

Mandatory Fields For <PREVIOUS_FOREIGN_PORT_LIST>

<element>

Specify the mandatory XML fields for <PREVIOUS_FOREIGN_PORT_LIST> element that CARICOM program checks during file creation. Use Comma Delimited Values.

For example, ARRIVAL_DT,DEPARTURE_DT,PREVIOUS_COUNTRY,PREVIOUS_COUNTRY_CODE,PREVIOUS_PORT_NAME,PREVIOUS_PORT_CODE,PREVIOUS_PLACE

Mandatory Fields For <REPORTING_PARTY>

<element>

Specify the mandatory XML fields for <REPORTING_PARTY> element that CARICOM program checks during file creation. Use Comma Delimited Values.

For example, NAME,EMAIL,COMPANY

Mandatory Fields For <SFTYMGMT_CERT>

<element>

Specify the mandatory XML fields for <SFTYMGMT_CERT> element that CARICOM program checks during file creation. Use Comma Delimited Values.

For example, ISSUED_DT,EXPIRATION_DT,AGENCY

Mandatory Fields For <VESSEL>

<element>

Specify the mandatory XML fields for <VESSEL> element that CARICOM program checks during file creation. Use Comma Delimited Values.

For example, NAME,CALL_SIGN,ID_NUM,ID_TYPE,FLAG,FLAG_CODE,OWNER,OPERATOR,CLASS_SOCIETY,CHARTERER,OCE,OCE_DESC

Mandatory Fields For <VESSEL_LOC>

<element>

Specify the mandatory XML fields for <VESSEL_LOC> element that CARICOM program checks during file creation. Use Comma Delimited Values.

For example, LOCATION_DESC,LAT_HR,LAT_MIN,LAT_SEC,N_S,LONG_HR,LONG_MIN,LONG_SEC,E_W

Mandatory Fields For <VOYAGE>

<element>

Specify the mandatory XML fields for <VOYAGE> element that CARICOM program checks during file creation. Use Comma Delimited Values.

For example, VOYAGE_TYPE

Mandatory First Name Field

1

1 – Mandatory for First Name field for guests/crew handling

0 – Not mandatory

Mandatory Gender Field

1

1 - First Name Mandatory for expected crew or passengers

0 – Not mandatory for First Name

Only crew/passenger records that contain this information is included in CARICOM Manifest submission when expected crew/passenger is chosen during file creation.

Mandatory ID Field

1

1 - Passport (or other form of identification) is mandatory for expected crew or passengers.

0 – Not mandatory for passport

Only crew/passenger records that contain this information is included in CARICOM Manifest submission when expected crew/passenger is chosen during file creation.

Mandatory Last Name Field

1

1 - Last Name is mandatory for expected crew or passengers

0 – Not mandatory for last name

Only crew/passenger records that contain this information is included in CARICOM Manifest submission when expected crew/passenger is chosen during file creation

Mandatory Nationality Field

1

1 - Nationality is mandatory for expected crew or passengers

0 – Not mandatory for nationality

Only crew/passenger records that contain this information is included in CARICOM Manifest submission when expected crew/passenger is chosen during file creation.

Manifest Submission Tracker

 

If Specified, it creates a Tracker File with matching XML file name. Else, it defaults to save the file to C:\Users\Public\Documents\Oracle Hospitality Cruise\CARICOM folder.

Source Column For Record Locator

<value>

Specifies the Database column used for <PASSENGER_RECORD_LOCATOR>

For example, RES_ACC