Summary	This view is used to track the Employment Process of the crew.
Keywords	Employment Process
Category	Crew List View

Description

This view is used to track the Employment Process of the crew. Its purpose is to see at what stage all the newly hired crew members are currently located and to check when they are ready for planning onboard.

The view is based on the customized fields in the Personal Details.

View Sample

Main Data Selection

All the persons in the system.

SQL statement

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

CREATE VIEW dbo.VIEWID as
select 
	P01.PIN,	
	P01.ALTERNATIVEPIN  as 'ALTERNATIVE PIN',
	P01.EmploymentStartDate,
	P01.EmploymentEndDate,
	P01.CLIENT Numorgid,
	P01.NAME 'Full Name',
	P01.FIRSTNAME 'First Name',
	P01.MIDDLENAME 'Middle Name',
	P01.LASTNAME 'Last Name',
	P01.SEX 'Gender',
	P01.NATIONALITY 'Nationality',
	p01.Rank                AS 'Current Rank',
	ORG.NAME 'Organization',
	U1.applic 'Application Received',
	u2.TRAIN_STAR 'Training Started',
	u3.TRAIN_COMP 'Training Completed',
	u4.avplan 'Available for Planning'

from PW001P01 P01
--copmany name
LEFT JOIN PWORG ORG ON  P01.CLIENT = ORG.NUMORGID
--Application Received
LEFT JOIN PW001P0U U1 ON U1.PIN=P01.PIN 
--Training Started
LEFT JOIN PW001P0U U2 ON U2.PIN=P01.PIN 
--Training Completed
LEFT JOIN PW001P0U U3 ON U3.PIN=P01.PIN 
--Available Planning
LEFT JOIN PW001P0U U4 ON U4.PIN=P01.PIN

Columns Specification

Column	Description/ Location in APM

Column	Description/ Location in APM
PIN	Personal Details > Personal > PIN
Alternative PIN	Personal Details > Personal > Alternative PIN
Numorgid	Personal Details > Employment > Organization’s No
EmploymentStartDate	Personal Details > Employment > Employment Start Date
EmploymentEndDate	Personal Details > Employment > Employment End Date
Full Name	Personal Details > Personal > Full Name
First Name	Personal Details > Personal > First Name
Middle Name	Personal Details > Personal > Middle Name
Last Name	Personal Details > Personal > Last Name
Gender	Personal Details > Personal > Gender
Nationality	Personal Details > Personal > Nationality
Organization	Personal Details > Employment > Organization’s Name
Current Rank	Personal Details > Employment > Current Rank
Application Received	Personal Details > Employment > Customised fields.
Training Started	Personal Details > Employment > Customised fields.
Training Completed	Personal Details > Employment > Customised fields.
Available for Planning	Personal Details > Employment > Customised fields.

Start Page

N/A