Skip to end of banner
Go to start of banner

People missing department in the booking request

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 SQL selection finds all the people that are missing Department references in the booking request.

Keywords

Flight Booking, Crewlink

Category

SQL Statement

Description

This SQL selection finds all the people that are missing Department references in the booking request. It picks up the Department from the person's activity linked to that booking.

Selection

Crew members missing Department references in the booking request

SQL statement

 SQL statement
select arr.PIN,
		arr.BOOKING_STATUS,
		arr.travelRequestID,
		org.NAME as 'Department Name'
from PWCCMCHANGECREWLIST CR 
left join PW001P03 P03 on p03.SEQUENCENO=cr.nextact or p03.SEQUENCENO=cr.CURRENTACT and p03.PIN=cr.pin
right join PWCCMFLIGHTARRANGEMENTS arr on arr.SEQNOM=CR.SEQNO and arr.PIN=cr.PIN
left join PWORG org on org.NUMORGID=dbo.ad_scanorgtree(p03.NuMORGID, 4)
order by PIN

Field Specification

Field

Description

PIN

From the Personal Details

Booking_Status

The status of the booking from PWCCMFLIGHTARRANGEMENTS .

travelRequestID

The Travel Request ID of the booking from PWCCMFLIGHTARRANGEMENTS .

Department Name

The name of the department from activity to which the booking request is linked to.

  • No labels