1 System Parameters

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

Table 1-1 PAR Group EBORDER UK

PAR Name	PAR Value	Description
Default to FNU on blank UXP_A_FSTN or FIRST_NAME	1	1 – If the First Name is NULL, it default <FIRST_NAME> to FNU 0 – Disable. The First Name field must not be empty.
FIELDS TO STRIP	[element]	Comma Separated XML Field Name(s). These field(s) will be stripped of invalid characters according to Parameter setting “STRIP INVAL CHAR” For example, LAST_NAME,FIRST_NAME,ID_NUM,US_ADDRESS_STREET,US_ADDRESS_CITY,US_ADDRESS_STATE,US_ADDRESS_STATE_ABBR,US_ADDRESS_ZIP
File Output Folder	[path]	Allows output file to be saved to a user-defined folder. For example, C:\temp\apis\enoad
Foreign Voyage Type	[voyage type]	Specify the Foreign Voyage Type options to be displayed in eBorder UK. Use Comma Delimited For example, Foreign to UK, UK to Foreign
Include VOYAGE_NUMBER During Submission		Voyage Number: 1 - Time Stamp, 2 - Cruise external system identifier 0 – NULL/ or <blank>
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 field for <ARRIVE>. Use Comma Delimited values. For example, ARRIVE_DT,ARRIVE_TIME,PORT_NAME
Mandatory Fields For <CARGO>	[element]	Specify the mandatory XML field for <CARGO>. Use comma Delimited values. For example, GENERAL_DESC,CDC_ON_BOARD
Mandatory Fields For <COMP_CERT>	[element]	Specify the mandatory XML field for <COMP_CERT>. Use Comma Delimited values. For example, ISSUED_DT,EXPIRATION_DT,AGENCY
Mandatory Fields For <CONTACT>	[element]	Specify the mandatory XML field for <CONTACT>. Use Comma Delimited value. For example, NAME,PHONE
Mandatory Fields For <CREW>	[element]	Specify the mandatory XML field for <CREW> 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 field for <DEPART>. Use Comma Delimited values For example, DEPART_DT,DEPART_TIME,PORT_NAME
Mandatory Fields For <ISSC>	[element]	Specify the mandatory XML field for <ISSC>. 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 field for <LAST_PORT>. 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 <NEXT_PORT>	[element]	Specify the mandatory XML field for <NEXT_PORT>. Use Comma Delimited values. For example, ARRIVE_DT,ARRIVE_TIME,NEXT_PORT_CODE,SUBSEQUENT_PORT_CODE
Mandatory Fields For <NONCREW>	[element]	Specify the mandatory XML field for <NONCREW>. Use Comma Delimited values. For example, LAST_NAME,FIRST_NAME,BIRTH_DT,GENDER,NATIONALITY,NATIONALITY_CODE,COUNTRY_RESIDENCE,COUNTRY_RESIDENCE_CODE,US_ADDRESS_STREET,US_ADDRESS_CITY,US_ADDRESS_ZIP
Mandatory Fields For <NONCREW> 1	[element]	Specify the mandatory XML field for <NONCREW>. Use Comma Delimited value. 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 field for <NOTICE_DETAILS>. Use Comma Delimited value. 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 field for <PREVIOUS_FOREIGN_PORT_LIST>. 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 field for <REPORTING_PARTY>. Use Comma Delimited values. For example, NAME,EMAIL,COMPANY
Mandatory Fields For <SFTYMGMT_CERT>	[element]	Specify the mandatory XML field for <SFTYMGMT_CERT>. Use Comma Delimited values. For example, ISSUED_DT,EXPIRATION_DT,AGENCY
Mandatory Fields For <VESSEL>	[element]	Specify the mandatory XML field for <VESSEL>. Use comma Delimited. 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 field for <VESSEL_LOC>. Use Comma Delimited value. 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 field for <VOYAGE>. Use comma Delimited. For example, VOYAGE_TYPE
Mandatory First Name 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 ENOAD Manifest submission when expected crew/passenger is chosen during file creation.
Mandatory Gender Field	1	1 - Gender is mandatory for expected crew or passengers 0 – Not mandatory for gender Only crew/passenger records that contain this information is included in ENOAD 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 ENOAD 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 ENOAD 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 ENOAD Manifest submission when expected crew/passenger is chosen during file creation.
Manifest Submission Tracker	[path]	If specified, a Tracker File is created with matching XML File Name; for example, C:\Temp\APIS\Enoad. Else, the default path is C:\Users\Public\Documents\Oracle Hospitality Cruise\eBorderUK
STRIP INVAL CHAR	<ASCII Code>	Comma Separated ASCII Code(s) Specify the non-alphanumeric characters (in ASCII Code) that will be stripped from the passenger/crew records section in the ENOAD Manifest. Specify the fields to which this handling needs to be applied in FIELDS TO STRIP parameter. For example, 33,35,36,37,38,42,61,91,93,94,123,125
Source Column For Record Locator	[value]	Specifies the Database Column Used for <PASSENGER_RECORD_LOCATOR> For example, RES_ACC
UNSUBMITTED NONCREW FIELDS	[element]	Comma Separated XML Field Name(s) Specify the XML elements that should have their value left empty even if the information exists. This should only be done for non-mandatory fields that are known to contain data not formatted to NVMC specifications. For example, US_ADDRESS_STATE_ABBR
eBorderUK Web Service SOAPAction	[website]	Obtain from the relevant website the Web Service SOAP Action for the eBorderUK .
eBorderUK Web Service SOAPHeader	[website]	Obtain from the relevant website the Web Service SOAP Header for the eBorderUK.
eBorderUK Web Service URL	[website]	Obtain from the relevant website the Web Service URL for the eBorderUK.