...
Rows/ Columns Specification
| Code Block |
|---|
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 |
Row/Column | Description/ Location in APM |
|---|---|
| The Vessel from the Organization Structure. |
| The Department from the Organization Structure. |
| The Position Name from the Organization Structure. |
| The Position Code from the Organization Structure. |
| The Min Safe manning from the Organization Structure set on the selected Position. |
| The Company Required manning from the Organization Structure set on the selected Position. |
...