Versions Compared

Version Old Version 4 New Version 5
Changes made by

Viktoria Karakiko

Viktoria Karakiko

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Crew members existing in the Adonis crew list but not found in the Otalio crew list are disembarked. The disembarkation date is set to the current date.

  • In case a crew member’s department or position got changed, the system closes the current activity=Today() -1d and creates a new sea-service activity linked to the new department and position code.

  • If a crew member is not available in the Adonis database, the system adds a crew member as well as creates a sea-service activity (datefrom=embarkation.ActualDate, DateTo=Null, TodateEstimated=disembarkation.ScheduledDate).

Field Mapping

Otalio

Adonis

Comments

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-20240314-150259.pngImage Added

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.EMPLOYMENTSTARTDATE

Assign to EMPLOYMENTSTARTDATE to make the person active

disembarkation.scheduledDate

P03.ESTIMATEDENDDATE

disembarkation.actualDate

P03.DATETO

operationalPosition.Code

Find code from pw001c000_XREF where XREF_CODE=operationalPosition.Code and Interface_xref='OTALIO' and TABLE_REF=2
If 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'

Housekeeping

The section covers the download, installation, and configuration procedures of the Otalio Master plugin.

...