Missing/Expiring Requirements (Competence, Travel, Medical)
Summary | This view shows missing/expiring Requirements (Competence, Travel, Medical) for the crew currently onboard or planned to embark. |
---|---|
Keywords | Required Documents |
Category | Crew List View |
Description
This view shows missing/expiring Requirements (Competence, Travel, Medical) for the crew currently onboard or planned to embark based on the setup of the Requirements Profile and the Organization Structure > Crew Change for the Vessel Pool.
View Sample
Main Data Selection
All seafarers that have sea-service activity regardless if it's planned or current.
SQL statement
VIEWID
should be substituted with the ID of the crew list view that you are creating in your system e.g. PW001SRV20
etc.
Columns Specification
Column | Description/ Location in APM |
---|---|
PIN | Personal Details > Personal > PIN |
Alternative PIN | Personal Details > Personal > Alternative PIN |
Full Name | Personal Details > Personal > Full Name |
Nationality | Personal Details > Personal > Nationality |
Organization | Personal Details > Employment > Organization’s Name |
Current Rank | Personal Details > Employment > Current Rank |
Numorgid | Personal Details > Employment > Organization’s No |
Document Code | The type of the document: Competence, Medical, Travel. |
Document Code | The code of the document record linked to the selected crew. |
Document Name | The name of the document record linked to the selected crew. |
Document No | The number of the document record linked to the selected crew. |
Document Status | The status of the document record linked to the selected crew. |
Issue Date | The date from of the document record linked to the selected crew. |
Expiry Date | The expert date of the document record linked to the selected crew. |
EmploymentStartDate | Personal Details > Employment > Employment Start Date |
EmploymentEndDate | Personal Details > Employment > Employment End Date |
Start Page
N/A