Skip to end of banner
Go to start of banner

Employment Process

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Version History

« Previous Version 2 Current »

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.

 Click here to expand...
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

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

  • No labels