CrewId

PW001P01.PIN

CrewId in the Otalio has format abc123456, so we need to subtract 3 chars at the beginning and create person with Pin number which left.
Image Removed

ProfileId

PW001P01_XREF.XREF_PIN

Otalio is the master database, the system is more transparent if the Otalio ProfileId is used in Adonis as well.

dateOfBirth

BIRTHDATE

placeOfBirth

PLACEOFBIRTH

firstName

FNAME

lastName

LNAME

MiddleName

MNAME

Gender

Gender

Nationality

Nationality

boardCardId

P01.ALTERNATIVEPIN

embarkation.actualDate

P03.DATEFROM

P01.EMPLOYMENTSTARTDATEAssign to EMPLOYMENTSTARTDATE to make the person active

disembarkation.scheduledDate

P03.ESTIMATEDENDDATE

disembarkation.actualDate

P03.DATETOoperationalPosition.Code

Find code from pw001c000_XREF where XREF_CODE=operationalPosition.Code and Interface_xref='OTALIO' and TABLE_REF=2If not found Find C02.CODE WHERE C02.CODE=operationPosition.Code

=> use the code to find the numorgid to be assigned to P03.NUMORGID

operationalDepartment.Code

Find code from pw001c000_XREF where XREF_CODE=operationalDepartment.Code and Interface_xref='OTALIO' and TABLE_REF=3
If not found Find C03.CODE WHERE C03.CODE=operationDepartment.Code
=> use the code to find the numorgid to be assigned to P03.NUMORGID

P03.NUMORGID

SELECT POS.NUMORGID FROM PWORG DEP JOIN PWORGDEP B ON DEP.NUMORGID=B.NUMORGID AND B.DEPCODE=< C03.CODE> AND DEP.NUMORGIDABOVE=<Current Vessel found in repl_site>
JOIN PWORG POS ON POS.NUMORGIDABOVE=DEP.NUMORGID AND dbo.ad_orgPosC02Code(POS.ORGCODE)=<C02.CODE>

reservationId

PW001P00_XREF.SEQUENCENO_XREF=ReservationId, PW001P00_XREF.SEQUENCENO_REF=P03.SEQUENCENO
WHERE INTERFACE_XREF='OTALIO'