1 Description | 2 Main Data Selection | 3 Setup and Configuration | 4 Rows/ Columns Specification

Summary	This analytical view gives an overview of min safe and company-required manning set for each position on a particular vessel under the Setup > Organization Properties.
Keywords	Organization, Position, Manning
Category	Analytical View

Description

This analytical view gives an overview of min safe and company-required manning set for each position on a particular vessel under the Setup > Organization Properties.

Main Data Selection

All the positions added in the Organization Structure.

Setup and Configuration

SQL statement

When using the view remember to replace the '1' value in lines PIN, NUMORGID, EMPLOYMENTSTARTDATE, EMPLOYMENTENDDATE with any existing PIN in your system. This is a work-around since all the analytical views should be by default person-based and PIN, NUMORGID, EMPLOYMENTSTARTDATE, and EMPLOYMENTENDDATE are mandatory fields.

select 
		VES.NAME as Vessel,
		DEP.NAME as Department,
		ORG.NAME as Position, 
		ORG.ORGCODE as Code,
		POS.mbr1 'MIN SAFE MANNING', 
		POS.mbr2 'COMPANY REQUIRED MANNING',
		1 as PIN,
		1 as Name,
		1 as NUMORGID,
		1 as  EMPLOYMENTSTARTDATE,
		1 as EMPLOYMENTENDDATE
from PWORGPOS POS
LEFT JOIN PWORG ORG on POS.NUMORGID=ORG.NUMORGID
LEFT JOIN PWORG AS DEP ON dbo.ad_scanorgtree(POS.numorgid, 4) = DEP.NUMORGID
LEFT JOIN PWORG AS VES ON dbo.ad_scanorgtree(POS.numorgid, 3) = VES.NUMORGID

Fields Definition

Fields Definition in General Codes > Datab Migning Code setup.

View Configuration (Column/Raw/Data Fields)

The screenshot of the configured view from the Analytical Module.

Rows/ Columns Specification

Row/Column	Description/ Location in APM

Row/Column	Description/ Location in APM
`Vessel`	The Vessel from the Organization Structure.
`Department`	The Department from the Organization Structure.
`Position`	The Position Name from the Organization Structure.
`Code`	The Position Code from the Organization Structure.
`MIN SAFE MANNING`	The Min Safe manning from the Organization Structure set on the selected Position.
`COMPANY REQUIRED MANNING`	The Company Required manning from the Organization Structure set on the selected Position.

Adonis HR Reports, Views and Similar

Manning: Min Safe and Company Required