Versions Compared

Version Old Version 1 New Version Current
Changes made by

Anna Zelenskaya

Daria Chebotaieva

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents
minLevel1
maxLevel1
typeflat
separatorpipe
Page Propertiesshow-if
groupIdse45c9fb3-68ab-4c08-972a-bdd4f555637e
users
matchUsingany

This section is only visible for the Adonis employees.

Customer

The view was originally created for Eckero Group

Summary

The view shows if there are any competence documents with not verified scans: where the

...

‘Validity of

...

Scan’ in set to

...

'N'

Keywords

...

Personal Details, Employment

Category

Crew List View

Description

The view shows if there are any competence documents with not valid scans: where the “Validity ‘Validity of Scan” Scan’ in set to “N” 'N' for the employed crew/ staff.

View Sample

...

Mail data selection

All crew members employed under the current organization and units below that have at least one Competence document (Travel, Medical, Competence) without invalid without valid scan.

SQL Statement

VIEWID should be substituted with the id of the crew list view that you are creating in your system e.g. PW001SRV13 etc.

Expand
Code Block
CREATE VIEW dbo.PW001SRV13 AS

Select
	p.PIN,
	p.CLIENT NUMORGID,
	p.EMPLOYMENTSTARTDATE,
	p.EMPLOYMENTENDDATE,
	p.NAME,
	(SELECT NAME from PW001C02 WHERE CODE = p.RANK) 'RANK',
	c.CODE 'COMPETENCE CODE',
	(SELECT TEXT FROM PW001C06 WHERE CODE=c.CODE) 'COMPETENCE TEXT',
	c.CNUMBER 'COMPETENCE NUMBER',
	c.DATEFROM 'ISSUE DATE',
	Isnull(c.EXPIRYDATE,c.DATETO) 'EXPIRY DATE',
	c.CHANGETIME 'LASTUPDATED',
	Isnull((SELECT LOGINNAME FROM PWLOGINSESSION WHERE SESSIONID=c.SESSIONID),
			(SELECT LOGIN_NAME FROM PWSECURITY_USERS WHERE USERID=c.CHANGEDBY)) 'LASTUPDATEDBY',
	Case When SCANVALIDITY = 1 Then 'Y' else 'N' End 'VALIDITYOFSCAN'
From PW001P01 p
join PW001P05 c on p.PIN=c.PIN and c.scanneddocno is not null and c.SCANVALIDITY<>1

Field Specification

Column

Description/ Location in APM

PINPin

PIN

Full Name

Full name of the person in Perosonal Details.

First Name

First name of the person in Perosonal Details.

Last Name

Last name of the person in Perosonal Details.

Middle Name

Middle Employment Start Date

Select from Personal Details > Employment > Employment State > Start

Format dd/mm/yyyy

Employment End Date

Select from Personal Details > Employment > Employment State > End

Format dd/mm/yyyy

Name

Full name of the person in Perosonal Personal Details.

Organizaton

Current employment organization of the person in Perosonal Details.

Format: L_F_M

Rank

Current Rank of the person in Perosonal Personal Details.

Document TypeCompetence Code

The type code of the competence document without scan record linked to the selected crew.

Document CodeCompetence Text

The code name of the competence document record linked to the selected crew.

Document NameCompetence Number

The name number of the competence document record linked to the selected crew.

Issued Date Issued

The date issued from of the competence document record linked to the selected crew.

Expiry Date

The expert expiry date of the competence document record linked to the selected crew.

Comments

The comments added to the document record linked to the selected crew.

Additional Information

...

Last Updated

Date / time last update action was done to this competence document

Last Updated By

Login name who did last update action to this competence document

Validity of Scan

'N'

Start Page

N/A