Page Comparison

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

Email

primary_email

davidbenlloch1@gmail.com

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

vessel_id

2335

vessel ID can be linked

001

200

Interface

CREWINSP

Find the Interface from PW001C112.CODE

PW001C112

001

200

ExternalPIN

seaman_id

114476

001

200

ExternalDocID

cert_id

233

001, 019

200

ExternalDocType

cert_stcw_code

A-V/2, A-V

PW001C06

001, 002

200

DocumentNo

licence_number

CGECH-3347

001

200

DateFrom

from_date

31.08.2022

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

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

Interface

CREWINSP

Find the Interface from PW001C112.CODE

PW001C112

001

200

ExternalPIN

seaman_id

114476

001

200

ExternalDocID

cert_id

105

001

200

ExternalDocType

cert_stcw_code

PW001C06

001, 002

201

DateFrom

from_date

22.11.2022

from PW001C23 Table

001, 008

200

DateTo

to_date

22.11.2027

from PW001C23 Table

If not Null or ““ then 008, 009 else leave ““

200

DocumentNo

licence_number

035851

from PW001C23 Table

001, 006

200

IssuedWhere

issuer_country_name

HONDURAS

If not Null or ““ then 006 else leave ““

200

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

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

Interface

CREWINSP

Find the Interface from PW001C112.CODE

PW001C112

001

200

ExternalPIN

seaman_id

114476

001

200

ExternalDocID

cert_id

42

001

200

ExternalDocType

cert_stcw_code

Reg IV-2

PW001C06

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 ““

200