Versions Compared

Version Old Version 1 New Version 2
Changes made by

Daria Chebotaieva

Daria Chebotaieva

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Page Properties

Summary

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

Keywords

Flight Booking, Crewlink

Category

SQL Statement

Note

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.

...

Expand
titleSQL statement
Code Block
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.