Versions Compared

Version Old Version 2 New Version Current
Changes made by

Helen Ustych

Daria Chebotaieva

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Page Properties

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

Expand
Code Block
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

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