Description | The Crew Inspector plugin is designed to import data from the Crew Inspector platform. |
Latest Version | 2023.30.1.1 |
Release Date | |
Download Path | |
Type | Replicator Plugin |
| Table of Contents | ||||||
|---|---|---|---|---|---|---|
|
Data Flow
Adonis is the master system with regard to maintaining crew data.The information is one-directional and flows from CrewInpector to Adonis
Crew Personal Details
...
...
IssuedBy
...
issuer
...
TEGUCIGALPA
...
...
If not Null or ““ then 006 else leave ““
...
200
...
Issuecountry
...
issuer_country
...
HND
...
CI needs to use a standard 2 letter code
...
| Status | ||||
|---|---|---|---|---|
|
from PW001C23 Table
...
If not Null or ““ then 004, 006 else leave ““
...
200
...
DocumentScanBase64
...
Base64 - Not provided by CI
...
...
DocumentFileName
...
Disregard this, we can’t import just a filename.
...
...
If not Null or ““ then 014 else leave ““
...
200
...
Comments
...
Not provided by CI
...
...
If not Null or “then 006 else leave ““
...
200
Medical Data
/AUS_CU_Medical
Crew Inspector
Sample Value
Description/Comments
XREF
Importance
Error / Text
Solution
Interface
CREWINSP
Find the Interface from PW001C112.CODE
PW001C112
| Status | ||||
|---|---|---|---|---|
|
001
200
ExternalPIN
seaman_id
114476
| Status | ||||
|---|---|---|---|---|
|
001
200
ExternalDocID
cert_id
42
| Status | ||||
|---|---|---|---|---|
|
001
200
ExternalDocType
cert_stcw_code
Reg IV-2
PW001C06
| Status | ||||
|---|---|---|---|---|
|
001,002
201
DateFrom
from_date
14.02.2023
008
200
ExpiryDate
to_date
14.06.2025
If not Null or ““ then 008,009 else leave ““
200
IssuedBy
issuer
HONDURAS
If not Null or “then 006 else leave ““
200
Issuecountry
issuer_country
HND
CI needs to use a standard 2 letter code
If not Null or ““ then 004, 006 else leave ““
200
DocumentScanBase64
Base64 - Not provided by CI
200
DocumentFileName
Disregard this, we can’t import just a filename.
If not Null or “then 014 else leave ““
200
Comments
Not provided by CI
If not Null or “then 006 else leave ““
Crew Inspector Field | Sample Value | Description/Comments | XREF | Importance | Error/Text | Solution | Interface | CREWINSP | Find the Interface from PW001C112.CODE | General Codes > Miscellaneous > Interfaces |
| 001, 002 | 201, 203 | ExternalPIN | seaman_id | 1725108 | PW001P01_XREF |
| 001, 002, 012 | 200; 203, 201 | FirstName | seaman_name | SILVIA YANETH |
| 001, 004, 006 | 200 | MiddleName | middle_name |
| If not Null or ““ then 004, 006 else leave ““ | 200 | LastName | seaman_surname | BANEGAS CARDENAS |
| 001, 004, 006 | 200 | CallingName | calling_name | SILVIA |
| If not Null or ““ then 004, 006 else leave ““ | 200 | SuffixName | Not provided by CI |
| If not Null or ““ then 004, 006 else leave ““ | 200 | Initials | Not provided by CI |
| If not Null or ““ then 004, 006 else leave ““ | 200 | Title | Not provided by CI |
| If not Null or ““ then 015 else leave ““ | 200 | Gender | sex | M |
| 001, 006, 016 | 200 | ExternalMaritalStatus | marital_status | Single | General Codes > Family > Marital Status Codes |
| If not Null or ““ then 002 else leave “ | 203, 201 | Nationality | seaman_country | ESP | CI needs to use a standard 2 letter code |
| 001, 004, 006 | 200 | NativeLangauge | Not provided by CI |
| If not Null or ““ then 004, 006 else leave ““ | 200 | BirthDate | pp_dob | 08.11.1988 | DD.MM.YYYY |
| If not Null or ““ then 008 else leave ““ | 200 | PlaceOfBirth | pp_pob | VILLAJOYOSA - ALICANTE |
| If not Null or ““ then 004, 006 else leave ““ | 200 | ||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CountryOfBirth | pp_country_code | ESP | CI needs to use a standard 2 letter code | PWCOUNTRY |
| If not Null or ““ then 004, 006 else leave ““ | 200 | ExternalHairColor | Not provided by CI | PW001C05 |
| If not Null or ““ then 002 else leave ““ | 200 | ExternalEyeColor | Not provided by CI | PW001C05 | If not Null or ““ then 002 else leave “ | 200 | Height | Not provided by CI |
| If not Null or ““ then 006 else leave “ | 200 | Weight | Not provided by CI |
| If not Null or ““ then 006 else leave “ | 200 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
HomeAirport | primary_airport | IBIZA Airport | CI needs to define the XREF codes in the General Codes > Travel > Aiport | PW001C48 |
| If not Null or ““ then 006 else leave “ | 200 | TravelTime | Not provided by CI |
| If not Null or ““ then 006 else leave “ | 200 | HomeAirport2 | Not provided by CI |
| If not Null or ““ then 006 else leave “ | 200 | TravelTime2 | Not provided by CI |
| If not Null or ““ then 006 else leave “ | 200 | ExternalRank | rank_id | 75 | PW001C02 | If not Null or ““ then 002 else leave “ | 200 | ExternalContractType | contract_type | PW001C32 | If not Null or ““ then 002 else leave “ | 200 | AddressLine1 | primary_address | "C/ DEL FARO, 3 - P06- 6º\r\nSAN ANTONIO IBIZA SPAIN" |
| 001, 006 | 200 | AddressLine2 | Not provided by CI |
| If not Null or ““ then 006 else leave “ | 200 | AddressLine3 | Not provided by CI |
| If not Null or ““ then 006 else leave “ | 200 | AddressCountry | seaman_country | ESP | CI needs to use a standard 2 letter code |
| If not Null or ““ then 006 else leave ““ | 200 | AddressPostcode | primary_postal_index | 07820 |
| If not Null or ““ then 004, 006 else leave ““ | 200 | AddressPlace | Not provided by CI |
| If not Null or ““ then 006 else leave ““ | 200 | primary_email |
| If not Null or ““ then 005, 006 else leave ““ | 200 | Mobile | primary_mobile | 600227138 |
| If not Null or ““ then 006 else leave ““ | 200 | Telephone | Not provided by CI |
| If not Null or ““ then 006 else leave ““ | 200 | Organization |
| 2335 | vessel ID can be linked |
| 001 | 200 |
Activities Data
...
/AUS_CU_Activities
...
Crew Inspector Field
...
Sample Value
...
Description/Comments
...
XREF
...
Importance
...
Error / Text
...
Solution
...
Interface
...
CREWINSP
...
Find the Interface from PW001C112.CODE
...
PW001C112
...
| Status | ||||
|---|---|---|---|---|
|
...
001
...
200
...
ExternalPIN
...
seaman_id
...
114476
...
PW001P01_XREF
...
| Status | ||||
|---|---|---|---|---|
|
...
001
...
200
...
ExternalActivityID
...
id
...
1642608
...
| Status | ||||
|---|---|---|---|---|
|
...
001
...
201
...
ExternalActivityCode
...
ONB
...
If all imported activites are ONB, then we can just flag all ONB
...
| Status | ||||
|---|---|---|---|---|
|
...
001,002
...
SignOn
...
on_date
...
03.03.2019
...
DD.MM.YYYY
...
| Status | ||||
|---|---|---|---|---|
|
...
008
...
200
...
SignOff
...
off_date
...
15.04.2019
...
DD.MM.YYYY
...
...
008
...
200
...
SignOffEstimated
...
...
008
...
200
...
Onboard
...
Not provided by CI
...
...
VesselIMO
...
vessel_imo_no
...
9842774
...
| Status | ||||
|---|---|---|---|---|
|
...
001, 003, 006
...
200
...
ExternalPositionCode
...
rank_id
...
662
...
PW001C02
...
...
201
...
Comments
...
Not provided by CI
...
...
If not Null or “then 006 else leave ““
...
200
Competence Data
...
/AUS_CU_Competence
...
Crew Inspector Field
...
Sample Value
...
Description/Comments
...
XREF
...
Importance
...
Error/Text
...
Solution
...
Interface
...
CREWINSP
...
Find the Interface from PW001C112.CODE
...
PW001C112
...
| Status | ||||
|---|---|---|---|---|
|
...
001
...
200
...
ExternalPIN
...
seaman_id
...
114476
...
| Status | ||||
|---|---|---|---|---|
|
...
001
...
200
...
ExternalDocID
...
cert_id
...
233
...
| Status | ||||
|---|---|---|---|---|
|
...
001, 019
...
200
...
ExternalDocType
...
cert_stcw_code
...
A-V/2, A-V
...
PW001C06
...
| Status | ||||
|---|---|---|---|---|
|
...
001, 002
...
200
...
DocumentNo
...
licence_number
...
CGECH-3347
...
| Status | ||||
|---|---|---|---|---|
|
...
001
...
200
...
DateFrom
...
from_date
...
31.08.2022
...
| Status | ||||
|---|---|---|---|---|
|
...
001, 008
...
200
...
DateTo
...
to_date
...
31.08.2027
...
...
if (Dateto=Null or ““) { Leave Null or ““
} else if (ExpiryDate=Null or ““) then {013
} else {008, 009
}
If DateTo is Not Null AND ExpiryDate is Null then copy the DateTo to ExpiryDate.
...
200
...
ExpiryDate
...
to_date
...
| Status | ||||
|---|---|---|---|---|
|
...
IssueBy
...
issuer
...
TEGUCIGALPA
...
...
If not Null or ““ then 006 else leave ““
...
200
...
IssuePlace
...
Not provided by CI
...
...
If not Null or ““ then 006 else leave ““
...
200
...
ValidInCountry
...
issuer_country
...
HND
...
CI needs to use a standard 2 letter code
...
...
If not Null or ““ then 004, 006 else leave ““
...
200
...
DocumentScanBase64
...
Base64 - Not provided by CI
...
...
DocumentFIleName
...
Disregard this, we can’t import just a filename.
...
...
If not Null or ““ then 014 else leave ““
...
200
...
Comments
...
Not provided by CI
...
...
If not Null or ““ then 006 else leave ““
...
200
Travel Data
...
/AUS_CU_Travel
...
Crew Inspector Field
...
Sample Value
...
Description/Comments
...
XREF
...
Importance
...
Error/Text
...
Solution
...
Interface
...
CREWINSP
...
Find the Interface from PW001C112.CODE
...
PW001C112
...
| Status | ||||
|---|---|---|---|---|
|
...
001
...
200
...
ExternalPIN
...
seaman_id
...
114476
...
| Status | ||||
|---|---|---|---|---|
|
...
001
...
200
...
ExternalDocID
...
cert_id
...
105
...
| Status | ||||
|---|---|---|---|---|
|
...
001
...
200
...
ExternalDocType
...
cert_stcw_code
...
PW001C06
...
| Status | ||||
|---|---|---|---|---|
|
...
001, 002
...
201
...
DateFrom
...
from_date
...
22.11.2022
...
| Status | ||||
|---|---|---|---|---|
|
from PW001C23 Table
...
001, 008
...
200
...
DateTo
...
to_date
...
22.11.2027
...
| Status | ||||
|---|---|---|---|---|
|
from PW001C23 Table
...
If not Null or ““ then 008, 009 else leave ““
...
200
...
DocumentNo
...
licence_number
...
035851
...
| Status | ||||
|---|---|---|---|---|
|
from PW001C23 Table
...
001, 006
...
200
...
IssuedWhere
...
issuer_country_name
...
HONDURAS
...
...
If not Null or ““ then 006 else leave ““
...
200
Adonis | Comment | |
|---|---|---|
seaman_id | External id used to identify the pin. The seamans id is stored in PW001P01_XREF linking it to the Adonis Pin | |
seaman_name | First Name | |
middle_name | Middle Name | |
seaman_surname | Surname | |
calling_name | Calling Name | |
sex | Sex | |
marital_status | Marital Status | Xref codes defined in General Codes > Family > Marital Status Codes |
seaman_country | Nationality | 2 character country code |
pp_dob | Birth day | |
pp_pob | Place of Birth | |
pp_country_code | Country of birth | 2 character country code |
primary_airport | Airport | Expecting the standard 3 char airport code, from CrewInpector, if this can not be provided the end user need to define xref codes in the general codes airports |
rank_id | Rank | xref codes defined in General Codes > personnel Details > Ranks. |
contract_type | Contract | Xref codes defined in General Codes > Personnel Details > Contract Types |
primary_address | Address Line 1 | |
seaman_country | Address Country | 2 character country code |
primary_postal_index | Postcode | |
primary_email | ||
primary_mobile | mobile |
Activities Data
From CrewInspector, we only receive onboard / sea service activities.
Crew Inspector Field | Adonis | Comment |
|---|---|---|
seaman_id | External id used to identify the pin. The seamans id is stored in PW001P01_XREF linking it to the Adonis Pin | |
id | This is the Crewinspectors unique id identifying an “activity” | The activity sequence nr is found using the xref table PW001P00_XREF if exist the activity exist and will be updated if not it will be created. |
on_date | Datefrom | |
off_date | DateTo | Crew inpector does not provide estimated end date or a flag that the person is still onboard. |
vessel_imo_no | The IMO number is used to find the correct vessel in the organization structure. | |
rank_id | This need to be valid rank in the rank table. Once the rank is found the system uses to find the proper position | xref codes defined in General Codes > personnel Details > Ranks. |
Various Documents
| Info |
|---|
In CrewInspector the travel book, competences and medical certificates are all stored in the same table. The CrewInspector fields are similar for all these datagroups. |
Competence Data
Crew Inspector Field | Adonis | Comment |
|---|---|---|
seaman_id | External id used to identify the pin. The seamans id is stored in PW001P01_XREF linking it to the Adonis Pin | |
cert_id | This is the Crewinspectors unique id identifying an “Competence” | The competence sequence nr is found using “cert_id” in the xref table PW001P00_XREF. If the competence exists, it will be updated; if not, it will be created. |
cert_stcw_code | Competence Code | xref codes defined in General Codes > Competence > Competences |
licence_number | Document No | |
from_date | Date From | |
to_date | Date To | |
to_date | Expiry Date | The crew inpector to date is both used for the expiry date and the date to. |
issuer | Issue By | |
issuer_country | Valid in country | 2 character country code |
Travel Data
Crew Inspector Field | Adonis | Comment |
|---|---|---|
seaman_id | External id used to identify the pin. The seamans id is stored in PW001P01_XREF linking it to the Adonis Pin | |
cert_id | This is the Crewinspectors unique id identifying an “Travel Book” | The travelbook sequence nr is found using “cert_id” in the xref table PW001P00_XREF. If the travelbook exists, it will be updated; if not, it will be created. |
cert_stcw_code | Travel Book Code | xref codes defined in General Codes > Travel> Travel Books |
from_date | Date From | |
to_date | Date To | |
licence_number | Document No | |
issuer_country_name | IssuedWhere | |
issuer | IssuedBy | |
issuer_country | IssueCountry | 2 character country code |
Medical Data
Crew Inspector | Adonis | Comment |
|---|---|---|
seaman_id | External id used to identify the pin. The seamans id is stored in PW001P01_XREF linking it to the Adonis Pin | |
cert_id | This is the Crewinspectors unique id identifying an “Medical Certificate” | The Medical Certificate sequence nr is found using “cert_id” in the xref table PW001P00_XREF. If the Medical Certificae exists, it will be updated; if not, it will be created. |
cert_stcw_code | Medical Certificate Code | xref codes defined in General Codes > Medical > Medical Certificates |
from_date | Date From | |
to_date | Date To | |
issuer | IssueBy | |
issuer_country | Issue Country | 2 character country code |
Housekeeping
The section covers the download, installation, and configuration procedures of the Crew Inspector plugin.
...