Versions Compared

Old Version 5

changes.mady.by.user Sigrid Kviteberg

Saved on

compared with

New Version Current

changes.mady.by.user Anna Myroshnychenko

Saved on

Key

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

...

  1. Create a stored procedure dbo.sp_signoff_expiry_competence.

    The stored procedure dbo.sp_signoff_expiry_competence executes the update statement which sets the Expiry date for the competences with P05.EXPIRYDATE IS NULL AND P05.DATEFROM < P03.DATETO and P05.DATEFROM > P03. DATEFROM (P03 is Seservice Seaservice activity linked to SignOff crewchange and P03.Disembarkation has XREF), (P05 is competence record which has XREF).

  2. Create a job 'Competence to expire' which

    The job will be executed the dbo.sp_signoff_expiry_competence each 10 min by default, It is possible to change the default values by editing the script. The XREF interface must be added from GCT and proper Disembarkation and Competence codes should be marked by this interface.

...