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 Name | Personal Details > Employment > Organization’s Name |
Current Rank | Personal Details > Employment > Current Rank |
Numorgid | Personal Details > Employment > Organization’s No |
Document Type | 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 |
NUMORGID | Perosnal Details > Client > NUMORGID |
Embarkation Date | Shows the activity DateFrom of the Embarked activity. If none, then blank. |
Disembarkation Date | Shows the activity DateTo/ToDateEstimated of the Embarked activity. If none, then blank. |
Activty Vessel | Shows the vessel name of the Embarked activity. If none, then blank. |
Activity Department | Shows the department name of the Embarked activity. If none, then blank. |
Activity Position | Showsthe position name of the Embarked activity. If none, then blank. |
Scan status | Shows missing, confirmed, and non confirmed document status. |
VESSEL_NUMORGID | Shows the vessels numorgid of the Embarked activity. If none, then blank. |
Start Page
N/A