Versions Compared

Version Old Version 2 New Version Current
Changes made by

Daria Chebotaieva

Daria Chebotaieva

Saved on

Key

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

This section is only visible for the Adonis employees.

Customer

The view was originally created for the Adora Cruises.

Page Properties

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.

Image RemovedImage Added

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.

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