Find people without department in the booking request

Owned by Daria Chebotaieva, created
Last updated: Aug 18, 2023
1 Description | 2 Selection | 3 SQL statement | 4 Field Specification

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

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

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.