Skip to end of banner
Go to start of banner

Uniform (crew onboard) view

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Current »

Summary

A view that will show the crew's uniform size and information about their current activities

Keywords

Uniform

Category

Crew List View

Description

The view shows the crew's uniform size and information about their current activities.

View Sample

Main Data Selection

All crew members who have current sea service activity.

SQL statement

 Click here to expand...
CREATE VIEW dbo.PW001SRV136
AS

SELECT p01.PIN,
       p01.[NAME]           AS 'Full Name',
       p01.firstname        AS 'First Name',
       p01.MIDDLENAME       AS 'Middle Name',
       p01.lastname         AS 'Last Name',
       org.[NAME]           AS 'Organization',
       r.[NAME]             AS 'Rank',
       p01.pantskirtsize    AS 'Pant/Skirt Size',
       p01.shirtblousesize  AS 'Shirt/Blouse Size',
       p01.shoesize         AS 'Shoe Size',
       p01.ppe_boilersuite  AS 'Boiler Suit',
       VSL.NAME             AS 'Vessel Name',
       pos.name             AS 'Position',
       p03.DATEFROM         AS 'Date From',
       p03.TODATEESTIMATED  AS 'Estimated End Date',
       dep.name             AS 'Department',
       P01.CLIENT              NUMORGID,
       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

Full Name

Personal Details > Personal > Full Name

First Name

Personal Details > Personal > First Name

Middle Name

Personal Details > Personal > Middle Name

Last Name

Personal Details > Personal > Last Name

Organization

Personal Details > Employment > Organization’s Name

Rank

Personal Details > Employment > Rank

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

Vessel Name

Datagroups > Activity > Current Activity > Vessel Name

Position

Datagroups > Activity > Current Activity > Position

Date From

Datagroups > Activity > Current Activity > Date From

Estimated End Date

Datagroups > Activity > Current Activity > Estimated End Date

Department

Datagroups > Activity > Current Activity > Department

NUMORGID

Personal Details > Employment > Organization’s NUMORGID

EMPLOYMENTSTARTDATE

Personal Details > Employment > Employment Start Date

EMPLOYMENTENDDATE

Personal Details > Employment > Employment End Date

Start Page

N/A

  • No labels