Summary	A view that will show the crew's uniform size and information about their current activities
Keywords	uniform
Category	Crew List View

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

Click here to expand...

CREATE VIEW dbo.PW001SRV136
AS

SELECT p01.PIN,
       p01.lastname         AS 'Last Name',
       p01.MIDDLENAME       AS 'Middle Name',
       p01.firstname        AS 'First Name',
       p01.[NAME]           AS 'Full Name',
       p01.pantskirtsize    AS 'Pant/Skirt Size',
       p01.shirtblousesize  AS 'Shirt/Blouse Size',
       p01.shoesize         AS 'Shoe Size',
       p01.ppe_boilersuite  AS 'Boiler Suit',
       p03.DATEFROM         AS 'Date From',
       ISNULL(p03.DATETO, p03.TODATEESTIMATED) AS 'Estimated End Date',
       VSL.NAME             AS 'Vessel Name',
       pos.name             AS 'Position',
       r.[NAME]             AS 'Rank',
       dep.name             AS 'Department',
       P01.CLIENT              NUMORGID,
       org.[NAME]           AS 'Organization',
       P01.EMPLOYMENTSTARTDATE,
       P01.EMPLOYMENTENDDATE
FROM   pw001p01 p01
       JOIN PW001P03 p03
            ON  p03.PIN = p01.PIN
            AND p03.DATEFROM <= CONVERT(VARCHAR, GETDATE(), 112)
            AND p03.DATETO IS NULL
            AND p03.PLANNED <> 'Y'
            AND p03.CODE IN (SELECT c12.Code
                             FROM   pw001c12 c12
                             WHERE  c12.OPTIONS LIKE '%S%')
       LEFT JOIN pworg pos
            ON  pos.NUMORGID = dbo.ad_scanorgtree(p03.NUMORGID, 5)
       LEFT JOIN pworg dep
            ON  dep.NUMORGID = dbo.ad_scanorgtree(p03.NUMORGID, 4)
       LEFT JOIN PWORG VSL
            ON  VSL.NUMORGID = dbo.ad_scanorgtree(P03.NUMORGID, 3)
       LEFT JOIN PWORG org
            ON  org.NUMORGID = p01.CLIENT
       LEFT JOIN PW001C02 r
            ON  r.CODE = p01.[RANK]

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.

Uniform view