Crew Onboard vs Company Required Manning v.2 (previous and next 2 months)
Summary | The view compares the actual number of crew onboard with the number of each Position defined in Organization > Position > Company Required Manning in the date range 2 months before and 2 months after today’s date. |
---|---|
Keywords | Manning, Onboard Crew |
Category | Analytical View |
Description
The view compares the actual number of crew onboard with the number of each Position defined in Organization > Position > Company Required Manning:
View Sample
Main Data Selection
The view checks all the crew that have Onboard (sea-service) Activity on the date within the date range defined in the script: in the date range 2 months before and 2 months after today’s date.
SQL statement
Rows/ Columns Specification
Row/Column | Description/ Location in APM |
---|---|
PIN | PIN (should be hidden) |
NUMORGID | Vessel Organization ID (should be hidden) |
EmploymentStartDate | Employment Start Date (can be hidden) |
EmploymentEndDate | Employment End Date (can be hidden) |
Vessel | Onboard Activity Vessel name |
Department | Onboard Activity Department name |
Position | Onboard Activity Position |
DateSelection | Date inside the date range defined in the script: previous 60 days starding from today |
CompanyRequiredManning | The number of Position according to Company requirements: Organization > Position > Company Required Manning |
TotalCrewOnboard | Total number of the crew that have Onboard Activities on the specific date |
OverManning | Difference between Company Required Manning (CompanyRequiredManning) and actual number of Crew Onbaard (TotalCrewOnboard) - if positive |
UnderManning | Difference between Company Required Manning (CompanyRequiredManning) and actual number of Crew Onbaard (TotalCrewOnboard) - if negative |