Summary	The view shows all the enclosed document codes existing in Enclosed Documents datagroup for all the crew
Keywords	Enclosed
Category	Crew List View

Description

This crew list view shows all the enclosed document codes existing in Enclosed Documents datagroup for all the crew.

View Sample

Main Data Selection

The view shows all the enclosed document code records from Enclosed Documents datagroup, no other conditions applied.

SQL statement

CREATE VIEW dbo.PW001SRV14 as
select 
P01.PIN,
P01.NAME,
C02.NAME AS RANK,
DOC.DESCRIPTION,
DOC.DOCTYPE CODE,
C45.NAME SCAN,
DOC.SOURCEDOC 'FILE NAME',
P01.EMPLOYMENTSTARTDATE,
P01.EMPLOYMENTENDDATE,
P01.CLIENT NUMORGID

FROM PW001P01OLE SCAN
LEFT JOIN PW001P01 P01 ON P01.PIN=SCAN.PIN
LEFT JOIN PW001OLEDOCS DOC ON SCAN.DOCNO=DOC.DOCNO
LEFT JOIN PW001C45 C45 ON C45.CODE=DOC.DOCTYPE
LEFT JOIN PW001C02 C02 ON C02.CODE=P01.RANK

Columns Specification

Column	Description/ Location in APM

Column	Description/ Location in APM
PIN	PIN
NAME	NAME
RANK	Rank name from Current Rank (Personal Details)
DESCRIPTION	Description of the Enclosed document
CODE	Enclosed document code
SCAN	Enclosed document name
FILE NAME	Name of the enclosed file

Start Page

N/A

Adonis HR Reports, Views and Similar

Scans/ Eclosed Documents Overview