Crew on Sick - Historical
Summary | Shows all the crew with historical sick activities. |
---|---|
Keywords | Activities, Sick Period |
Category | Crew List View |
Description
The view shows all the crew with historical sick activities.
View Sample
SQL statement
Columns Specification
Column | Description/ Location in APM |
---|---|
PIN | Personal Details > Personal > PIN |
NAME | Personal Details > Personal > Full Name |
LASTNAME | Personal Details > Personal > Lastname |
FIRSTNAME | Personal Details > Personal > Firstname |
NATIONALITY | Personal Details > Personal > Nationality (ISO 3166-1 Alpha-2 code) |
ORGANIZATION | Personal Details > Employment > Organization/Company |
GENDER | Personal Details > Personal > Gender |
BIRTHDATE | Personal Details > Personal > Birthdate |
BIRTH COUNTRY | Personal Details > Personal > Birth Country name |
ACTIVITY START | Datagroups > Activities > Date From |
ACTIVITY END | Datagroups > Activities > Date To |
DAYS | Datagroups > Activities > Days |
VESSEL | Datagroups > Activities > Vessel name |
DEPARTMENT | Datagroups > Activities > Department name |
CONTRACT START | Personal Details > Employment > Contract Start |
CONTRACT END | Personal Details > Employment > Contract Expiry |
SORT | Personal Details > Employment > Rank Sort Number |
RANK | Personal Details > Employment > Rank |
EMPLOYMENTSTARTDATE | Personal Details > Employment > Start |
EMPLOYMENTENDDATE | Personal Details > Employment > End |