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

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