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

Version 1 Next »

Summary

This SQL selection finds all the people that are missing Department references in the booking request.

Keywords

Flight Booking, Crewlink

Category

SQL Statement

Please remember to add labels to the article. Only the labels from the lit are allowed: /wiki/spaces/PnP/pages/4523197124

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

  • No labels