Summary	The view shows details for all the Activities
Keywords	Activities
Category	Crew List View

Description

The view checks all the Activities for all the crew. No limitations on activity type or option. Can be used to check history activities.

View Sample

Main Data Selection

The view checks all the Activities for all the crew. No limitations on activity type or option.

SQL statement

CREATE VIEW dbo.PW001SRV17
AS
SELECT 
P03.PIN,
P01.NAME,
ORG.NAME ORGANIZATION,
VESPOOL.NAME VESSELPOOL,
C12.TEXT ACTIVITY,
CASE WHEN P03.DATETO IS NOT NULL THEN 'HISTORICAL'
	 WHEN PLANNED='Y' THEN 'PLANNED'
	 ELSE 'CURRENT'
	 END TYPE,
P03.DATEFROM,
P03.DATETO,
P03.TODATEESTIMATED 'ESTIMATED END DATE',
P03.DAYS,
VES.NAME VESSEL,
DEP.NAME DEPARTMENT,
POS.NAME POSITION,
C02.NAME RANK,
P03.COMMENTS,
P01.EMPLOYMENTSTARTDATE,
P01.EMPLOYMENTENDDATE,
P01.CLIENT NUMORGID

FROM PW001P03 P03
LEFT JOIN PW001C02 C02 ON C02.CODE=P03.RANK
LEFT JOIN PW001P01 P01 ON P01.PIN=P03.PIN
LEFT JOIN PW001C12 C12 ON C12.CODE=P03.CODE
LEFT JOIN PWORG VES ON VES.NUMORGID = dbo.ad_scanorgtree(P03.NUMORGID, 3)
LEFT JOIN PWORG DEP ON DEP.NUMORGID = dbo.ad_scanorgtree(P03.NUMORGID, 4)
LEFT JOIN PWORG POS ON POS.NUMORGID = dbo.ad_scanorgtree(P03.NUMORGID, 5)
LEFT JOIN PWORG ORG ON ORG.NUMORGID=P01.CLIENT
LEFT JOIN PWORG VESPOOL ON VESPOOL.NUMORGID=VES.NUMORGIDABOVE

Columns Specification

Column	Description/ Location in APM

Column	Description/ Location in APM
PIN	PIN
NAME	Name
ORGANIZATION	Organization name the crew profile is linked to in Personal Deteails
VESSELPOOL	Name of the organization above the vessel
ACTIVITY	Activity name
TYPE	Activity type: Current, Planned or Historical
DATEFROM	Date From
DATETO	Date To
ESTIMATED END DATE	Estimated End Date
DAYS	Nr of days
VESSEL	Vessel name
DEPARTMENT	Department name
POSITION	Position name
RANK	Rank name
COMMENTS	Comments from Activity

Start Page

N/A

Crew List - All Activities