Scans/ Eclosed Documents Overview

Owned by Helen Ustych, created
Last updated: Apr 08, 2024 by Daria Chebotaieva
1 min read
1 Description | 2 View Sample | 3 Main Data Selection | 4 SQL statement | 5 Columns Specification | 6 Start Page

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