Missing required competences (onboard and planned)
Summary | Shows crew with current or next planned activity with missing or expired required competencies. Based on the requirements profile. |
---|---|
Keywords | Competence, requirements profile |
Description
Shows crew with current or next planned activity with missing or expired required competencies.
The view is based on the requirements profile.
View Sample
Main data selection
Selection of the view is based on crews having current or next planned activity with missing or expired required competencies.
SQL Statement
Fields/Columns Specification
Column | Description/ Location in APM |
|
---|---|---|
PIN | Personal Details > Personal > Personal Identification Number |
|
NAME | Personal Details > Personal > Full Name |
|
ACTIVITY | Datagroups > Activity > Current/Planned Activity > Activity Name |
|
START DATE | Datagroups > Activity > Current/Planned Activity > Start Date |
|
ESTIMATED END | Datagroups > Activity > Current Activity > Estimated End Date |
|
ORGANIZATION | Personal Details > Employment > Organization |
|
DEPARTMENT | Datagroups > Activity > Current/Planned Activity > Department |
|
VESSEL | Datagroups > Activity > Current/Planned Activity > Vessel Name |
|
DOC CODE | Datagroups > Competence > Expired competence > Doc Code |
|
DOC NAME | Datagroups > Competence > Expired competence > Doc Name |
|
ISSUED DATE | Datagroups > Competence > Expired competence > Issued Date |
|
EXPIRY DATE | Datagroups > Competence > Expired competence > Expiry Date |
|
NUMORGID | Personal Details > Employment > Organizations NUMORGID |
|
EMPLOYMENT START DATE | Personal Details > Employment > Employment Start Date |
|
EMPLOYMENT END DATE | Personal Details > Employment > Employment End Date |
|
Start Page
N/A