Please remember to add labels to the article. Only the labels from the lit are allowed: /wiki/spaces/PnP/pages/4523197124
Description
A view that will show the crew's uniform size and information about their current activities
View Sample
Main Data Selection
All crew who has current sea service activity.
SQL statement
Columns Specification
Column | Description/ Location in APM |
---|---|
PIN | Personal Details > Personal > Personal Identification Number |
LAST NAME | Personal Details > Personal > Last Name |
FIRST NAME | Personal Details > Personal > First Name |
MIDDLE NAME | Personal Details > Personal > Middle Name |
FULL NAME | Personal Details > Personal > First Name + Middle Name + Last Name |
Pant/Skirt Size | Personal Details > Other > Uniform Size > Pant/Skirt Size |
Shirt/Blouse Size | Personal Details > Other > Uniform Size > Shirt/Blouse Size |
Shoe Size | Personal Details > Other > Uniform Size > Shoe Size |
Boiler Suit | Personal Details > Other > Personal Protective Equipment > Boiler Suit |
Date From | Datagroups > Activity > Current Activity > Date From |
Estimated End Date | Datagroups > Activity > Current Activity > Estimated End Date |
Vessel Name | Datagroups > Activity > Current Activity > Vessel Name |
Position | Datagroups > Activity > Current Activity > Position |
Rank | Personal Details > Employment > Rank |
Department | Datagroups > Activity > Current Activity > Department |
Next Sign On Date | Datagroups > Activity > Next Planned Activity > Date From |
Future Vessel | Datagroups > Activity > Next Planned Activity > Vessel Name |
NUMORGID | Personal Details > Employment > Organization’s NUMORGID |
Organization | Personal Details > Employment > Organization’s Name |
EMPLOYMENTSTARTDATE | Personal Details > Employment > Employment Start Date |
EMPLOYMENTENDDATE | Personal Details > Employment > Employment End Date |
Start Page
Link to the documentation on the related Start Page Tile.