Pax Crew query

The query can be used for ‘GAR report’ / 'GENDEC report' used as an order report in many locations.

The report will sort based on Order Number e.g. AMS-100 followed by Crew Type and finally Surname. In the case of an order report such as a GenDec or manifest the sort will be Crew Type followed by Surname, in alphabetical order.

Contents:

Filters

Filters are shared with the Orders query.

Filter

Description

Mandatory

Filter

Description

Mandatory

Administration

Filters on Administration. Single or multiple Administrations can be selected.

YES

Fbo location

Filters on FBO location. Single or multiple FBO locations can be selected.

NO

Handling station

Filter by Handling station. See Handling station (Glossary).

 

  • Arrival or departure date time (UTC) on or after / Arrival or departure date time (UTC) before

  • Arrival or departure date time (LT) on or after / Arrival or departure date time (LT) before

Filter by date and time in UTC or LT of an order’s arrival or departure, use both on or after and before to create a data range. Note: ‘Arrival or departure date time’ UTC and LT filters cannot be used together.

For OTC’s the start/end date/times are considered if data provider settings IncludeOtcOrdersByStartDate or IncludeOtcOrdersByEndDate are set to 'TRUE'.

NO

Transaction date LT on or after / Transaction date LT before

Filter between order transaction on or after date and order transaction before date (last calculated date), use both on or after and before to create a data range.

NO

Invoice date on or after / Invoice date before

Filter between Invoice on or after date and Invoice before date, use both on or after and before to create a data range.

NO

  • Batch Settled Timestamp (UTC) on or after / Batch Settled Timestamp (UTC) before: 

  • Batch Settled Timestamp (LT) on or after / Batch Settled Timestamp (LT) before

Filter by date and time in UTC or LT of batch settled timestamp in an order, use both on or after and before to create a data range.. See Online Payments (Administration).

Note: ‘Batch Settled Timestamp’ UTC and LT filters cannot be used together.

NO

  • Payment Timestamp (UTC) on or after / Payment Timestamp (UTC) before

  • Payment Timestamp (LT) on or after / Payment Timestamp (LT) before

Filter by date and time of payment timestamps in an order, use both on or after and before to create a data range.

Note: ‘Payment Timestamp’ UTC and LT filters cannot be used together.

NO

Debtor or operator

Filter by contact present on an order’s debtor or operator field.

NO

Debtor

Filters on an order’s debtor contact.

NO

Operator

Filters on an order’s Operator contact.

NO

Debtor's order number

Filter on an order’s ‘Debtor’s order number’.

 

NO

Aircraft type

Filter by an order’s aircraft type.

NO

Aircraft registration

Filter by an order’s aircraft registration.

NO

Entry period

Filters on entry periods. See Entry periods (Back office).

NO

Order

Filters on the Order ID. The Order ID can be found in the Classic screens when on Order page, in the browser address bar after ‘Orderid=’, e.g.

NO

Invoice

Filters on the Invoice ID. The Invoice ID can be found in the Classic screen when on Invoice page, in the browser address bar after ‘Invoiceid=’, e.g.

NO

Entry

Filters on the Entry ID. The Entry ID can be found in the Classic screen when on entry page, in the browser address bar after ‘Entryid=’, e.g.

NO

Data provider settings

The following ‘Data provider settings’ can be set in Reports (Administration) for the query of a report. All settings must be separated by a semi-colon ';'. If not specified the default settings apply.

Settings are shared with the Orders query. Pax Crew query specific settings are highlighted in green.

Setting

Type

Default

Description

Setting

Type

Default

Description

IncludedCrewTypes

String

BLANK

Comma separated list of Crewtypes
This setting can hold a list of crew types that should be returned. Note that 'PAX' is a crew type too. The names are not case sensitive. If the option is not used, all types are returned.

IncludedDirections

String

Both

This setting can reduce the returned crew and/or PAX to the inbound or outbound PAX only. By default both are returned. Options are:

  • In

  • Out

  • Both

ReturnDistinctRecords

Boolean

FALSE

If set to true the report generates one line for the arriving and departing crew if they are the same. Setting this option to false will create two rows, one for each flight leg.

RecalculateOrders

Boolean

TRUE

Recalculates all open orders that match the filter. This will make sure that any orders that are not yet invoiced are up to date. Each order is normally recalculated and stored when viewed in the order screen. An order may be out of date since it was last viewed, for example if a price agreement has been changed since. 

Setting RecalculateOrders to false will speed up the report and is generally safe. It may also prevent that the report fails due to a calculation error; for example when some orders have invalid data that need correction.

CurrencyForReporting

CurrencyCode

Order default currency

This setting allows you to specify a currency that will be used to express the amounts in the report. FBO One will convert the Order Amount Incl. VAT, Amount Excl VAT and VAT Amount from the Order currency to this currency. 

When this setting is not used, FBO One always uses the Order Default currency to display the above amounts.

  • For old orders it might happen that an exchange rate is not defined in the past. FBO One will use the most recent exchange rate that exists in the Exchange Rates table.

  • Using a currency code that doesn't exist in the Exchange Rate table will return an error.

  • The amounts in any of the other columns, such as "Amount Excl VAT in booked currency" are not converted to the CurrencyForReporting.

ReplaceCommas

Boolean

TRUE

Whether to replace commas inside custom values with underscores. The custom values are shown as a comma separated list. Setting this to TRUE, guarantees commas inside custom values won’t interfere with the separators of the list and allow to reliably check if a certain value is assigned to an order using a formula in the report.

IncludeCancelledOrders

Boolean

TRUE

If cancelled orders should be included in the report.

ExtraDaysInFuture

Integer

0

This allows to add some days to the 'before' parameter. Note: Extra days are added to the following filters only: Arrival or departure date time, Transaction Date and Invoice date. Useful for daily reports that should span more than the default single day.

IncludeOtcOrdersByStartDate

Boolean

FALSE

When set to true, it allows to add OTC orders which do not have flight legs into a order report based on the arrival/departure filter. The Arrival/Departure date filter will match on OTC order start time fields.

IncludeOtcOrdersByEndDate

Boolean

FALSE

When set to true, it allows to add OTC orders which do not have flight legs into a order report based on the arrival/departure filter. The Arrival/Departure date filter will match on OTC order end time fields.

IncludeOrdersInStage

String

FrontAndBackOffice

Whether or not orders in a particular stage should be included in the report. If not specified, orders being in front or in back office stage will be included. Possible values: Quote, FrontOffice, BackOffice, FrontAndBackOffice

Columns

Column

Description

Example

Column

Description

Example

Additional travel document

Additional travel document name for the Crew/Pax. See ‘Additional travel document' field in Crew/Pax order tab. See also 'Name’ field in Travel Documents (Administration).

VISA

Additional travel document expiry date

Additional travel document expiry date of the Crew/Pax. See 'Additional travel document expiry date' field in Crew/Pax order tab.

01-Jan-25

Additional travel document issuing country

Additional travel document country of issue description of the Crew/Pax. See ‘Additional travel document country of issue' field in Crew/Pax order tab. See also 'Description’ field in Countries (Administration).

Belize

Additional travel document issuing country ISO 2

Additional travel document country code of the Crew/Pax. See ‘Additional travel document country of issue' field in Crew/Pax order tab. See also 'Unofficial 2 letter code’ field in Countries (Administration).

BZ

Additional travel document issuing country ISO 3

Additional travel document country ISO of the Crew/Pax. See ‘Additional travel document country of issue' field in Crew/Pax order tab. See also ‘ISO Alpha 3 Code’ field in Countries (Administration).

BLZ

Additional travel document number

Additional travel document number of the Crew/Pax. See 'Additional travel document number' field in Crew/Pax order tab.

123123

Actual arrival date time UTC

The most actual arrival date time in UTC, for the flight leg the Crew/Pax is added to.

  • If an arrival flight leg this may be the STA, ETA or ATA.

  • If a departure flight leg this may be ATA at the ‘To’/'Destination' station, taken from CFMU/FlightAware. Will be blank if not linked to CFMU/FlightAware.

05-Jul-20 12:21

Actual departure date time UTC

The most actual departure date time in UTC, for the flight leg the Crew/Pax is added to.

  • If an arrival flight leg this may be the ATD from the ‘From’/'Origin' station, taken from CFMU/FlightAware. Will be blank if not linked to CFMU/FlightAware.

  • If a departure flight leg this may be the STD, ETD or ATD

05-Jul-20 11:08

Address

Resident address of the Crew/Pax. See 'Address' field in Crew/Pax order tab.

Westminster, London SW1A 1AA

Arrival station ICAO

The arrival station ICAO code, for the flight leg the Crew/Pax is added to.

  • If an arrival flight leg, this will be the Handling Station ICAO for the order.

  • If departing flight leg, this will be the ‘To’/'Destination' station ICAO.

EGKB

Arrival station name

The arrival station name, for the flight leg the Crew/Pax is added to.

  • If an arrival flight leg, this will be the Handling Station name for the order.

  • If a departing flight leg, this will be the ‘To’/'Destination' station name.

Biggin Hill

Country

Nationality country description of the Crew/Pax. See ‘Nationality' field in Crew/Pax order tab. See also 'Description’ field in Countries (Administration).

United Kingdom

Country code

Nationality country code of the Crew/Pax. See ‘Nationality' field in Crew/Pax order tab. See also 'Unofficial 2 letter code’ field in Countries (Administration).

GB

Country display name

Nationality country name of the Crew/Pax. See ‘Nationality' field in Crew/Pax order tab. See also ‘Description’ and 'Unofficial 2 letter code’ fields in Countries (Administration).

United Kingdom (GB)

Country ID

Nationality country’s unique ID in GUID format.

b8dfe58f-fcd4-4e57-804d-70da92d1082b

Country ISO code

Nationality country ISO of the Crew/Pax. See ‘Nationality' field in Crew/Pax order tab. See also ‘ISO Alpha 3 Code’ field in Countries (Administration).

GBP

CrewCount

Crew count for the applicable flight leg the crew member is on.

1

CrewCountIn

Crew count for the arrival leg.

If the crew member is on the departure leg this will be blank.

1

CrewCountOut

Crew count for the departure leg.

If the crew member is on the arrival leg this will be blank.

2

Crew type

Crew type of the Crew/Pax. See ‘Crew/Pax type' field in Crew/Pax order tab. See also 'Name’ field in Crew types (Administration).

PIC

CrewMemberID

Crew/Pax's unique ID in GUID format.

24de54ba-7ed0-4367-a18b-a69914791bb4

CrewTypeName

This column is no longer used and is for backward compatibility only.

 

Date of birth

Date of birth of the Crew/Pax. See 'Date of birth' field in Crew/Pax order tab.

01-Jan-80

DateOfIssue

Date of issue of the travel document for the Crew/Pax. See 'Date of issue' field in Crew/Pax order tab.

10-Jun-2015

Departure station ICAO

The departure station ICAO code, for the flight leg the Crew/Pax is added to.

  • If an arrival flight leg, this will be the ‘From’/'Origin' station ICAO.

  • If a departing flight leg, this will be the Handling Station ICAO for the order.

EGVN

Departure station name

The departure station name, for the flight leg the Crew/Pax is added to.

  • If an arrival flight leg, this will be the ‘From’/'Origin' station name.

  • If a departing flight leg, this will be the Handling Station name for the order.

Brize Norton

Email

Email address of the Crew/Pax. See 'Email' field in Crew/Pax order tab.

queen@royal.uk

FirstName

First name of the Crew/Pax. See 'First name' field in Crew/Pax order tab.

Elizabeth 

Flight number

Flight number of the flight leg the Crew/Pax is added to. See ‘Flight number' field for the flight leg.

RRR748

FlightType

Flight type of the flight leg the Crew/Pax is added to. See ‘Flight type' field for the flight leg.

Royal

ForeNames

First name and middle name of the Crew/Pax. See ‘First name' and 'Middle name’ field in Crew/Pax order tab.

Elizabeth Alexandra Mary

Gender

Gender of the Crew/Pax. See 'Gender' field in Crew/Pax order tab.

Female

InboundOriginSystemId

Origin system ID for the imported inbound flight leg using Stonefield FIDS. See StonefieldConfiguration.

RX020005072019103639A

InboundOriginSystemIdLastSeenAtUtc

Most recent inbound flight leg import time using Stonefield FIDS. See StonefieldConfiguration.

05-Jul-19

InboundOriginSystemLastRow

JSON import data for inbound flight leg from Stonefield FIDS. See StonefieldConfiguration.

{"Registration":"ZZ336","Aircraft":"A330","Callsign":"RRR748","ADEP":"EGVN","ADES":"EGKB","From_To":"EGVN", "EdmATD_ATA_Date":"2019-07-05T00:00:00Z", "ATD_ATA":"1221", "EdmSignificant_Date":"2019-07-05T00:00:00Z", "Significant_Time":"1221", "Category":"A", "Touch_and_Gos":"0", "Parking":"BH APR", "POB":"1", "Notes":"TWR / DAY STOP / 0 PAX", "ID":"RX020005072019103639A", "Approaches":"  "}

InboundOriginSystemNotes

Imported inbound flight leg system notes from Stonefield FIDS. See StonefieldConfiguration.

TWR / DAY STOP / 0 PAX

Is arrival

Indicates if the flight leg the Crew/Pax is added to is the arrival leg.

TRUE

Is departure

Indicates if the flight leg the Crew/Pax is added to is the departure leg.

FALSE

License

License of the Crew/Pax. See 'License' field in Crew/Pax order tab.

LI1234

MiddleName

Middle name of the Crew/Pax. See 'Middle name' field in Crew/Pax order tab.

Alexandra Mary

Name

Full name (First, Middle and Surname) of the Crew/Pax. See ‘First name', ‘Middle name’ and 'Last name’ field in Crew/Pax order tab.

Elizabeth Alexandra Mary Windsor

NonTransitPaxCount

Non transit passenger count for the applicable flight leg the crew member is on.

1

NonTransitPaxCountIn

Non transit passenger count for the arrival leg.

If the pax member is on the departure leg this will be blank.

1

NonTransitPaxCountOut

Non transit passenger count for the departure leg.

If the pax member is on the departure leg this will be blank.

1

Operator

The Operator name for the order the Crew/Pax is added to. See 'Name' field in the organization detail page.

Royal Air Force

Order ID

Order’s unique ID in GUID format.

063dab99-ef9f-4179-bfa1-4977dfa24c0b

Order key

The Order key the Crew/Pax is added to.

FBO-42489

Order state

The Order workflow and current state the Crew/Pax is added to.

Accounting | Invoiced

OrderNumber

The order number the Crew/Pax is added to. Primary orders will show as 0.

0

OutboundOriginSystemId

Origin system ID for the imported outbound flight leg using Stonefield FIDS. See StonefieldConfiguration.

RX000422112020012117D

OutboundOriginSystemIdLastSeenAtUtc

Most recent outbound flight leg import time using Stonefield FIDS. See StonefieldConfiguration.

22-Nov-20

OutboundOriginSystemLastRow

JSON import data for outbound flight leg from Stonefield FIDS. See StonefieldConfiguration.

{"Registration":"ZZ336", "Aircraft":"A330", "Callsign":"RRR748", "ADEP":"EGKB", "ADES":"EGVN", "From_To":"EGKB", "EdmATD_ATA_Date":"2020-11-22T00:00:00Z", "ATD_ATA":"1146", "EdmSignificant_Date":"2020-11-22T00:00:00Z", "Significant_Time":"1146", "Category":"D", "Touch_and_Gos":"0", "Parking":"BH APR M", "POB":"1","Notes":"TWR DEP / CREW", "ID":"RX000422112020012117D", "Approaches":"  "}

OutboundOriginSystemNotes

Imported outbound flight leg system notes from Stonefield FIDS. See StonefieldConfiguration.

TWR DEP / CREW

Passport number

Passport number of the Crew/Pax. See 'Passport number' field in Crew/Pax order tab.

GB12345678

PassportCountryCode

Passport country of issue code of the Crew/Pax. See ‘Passport country of issue' field in Crew/Pax order tab. See also 'Unofficial 2 letter code’ field in Countries (Administration).

GB

PassportCountryDisplayName

Passport country of issue name of the Crew/Pax. See ‘Passport country of issue' field in Crew/Pax order tab. See also ‘Description’ and 'Unofficial 2 letter code’ fields in Countries (Administration).

United Kingdom (GB)

PassportCountryID

Passport country of issue country’s unique ID in GUID format.

b8dfe58f-fcd4-4e57-804d-70da92d1082b

PassportCountryISOCode

Passport country of issue ISO of the Crew/Pax. See ‘Passport country of issue' field in Crew/Pax order tab. See also ‘ISO Alpha 3 Code’ field in Countries (Administration).

GBP

PassportCountryName

Passport country of issue description of the Crew/Pax. See ‘Passport country of issue' field in Crew/Pax order tab. See also 'Description’ field in Countries (Administration).

United Kingdom

PassportExpiryDate

Passport expiry date of the Crew/Pax. See 'Passport expiry date' field in Crew/Pax order tab.

10-Jun-25

PaxCount

Pax count for the applicable flight leg the crew member is on.

1

PaxCountIn

Pax count for the arrival leg.

If the pax member is on the departure leg this will be blank.

2

PaxCountOut

Pax count for the departure leg.

If the pax member is on the departure leg this will be blank.

1

PaxCrewCount

Pax and Crew count combined for the applicable flight leg the pax/crew member is on.

2

PaxCrewCountIn

Pax and Crew count for the arrival leg.

If the pax/crew member is on the departure leg this will be blank.

1

PaxCrewCountOut

Pax and Crew count for the departure leg.

If the pax/crew member is on the departure leg this will be blank.

2

Place of birth

Place of birth of the Crew/Pax. See 'Place of birth' field in Crew/Pax order tab.

London

PlaceOfIssue

Place of issue of the travel document for the Crew/Pax. See 'Place of issue' field in Crew/Pax order tab.

London

Registration

Aircraft registration of the order the Crew/Pax is added to. See ‘Aircraft registration' field in the order.

NPXDS

Remarks

Free text remarks for the Crew/Pax. See 'Remarks' field in Crew/Pax order tab.

The Queen

Surname

Surname of the Crew/Pax. See 'Last name' field in Crew/Pax order tab.

Windsor

TravelDocumentCode

Travel document code for the Crew/Pax. See ‘Travel document type' field in Crew/Pax order tab. See also 'Code’ field in Travel Documents (Administration).

P

TravelDocumentName

Travel document name for the Crew/Pax. See ‘Travel document type' field in Crew/Pax order tab. See also 'Name’ field in Travel Documents (Administration).

Passport

TransitPaxCount

Transit passenger count for the applicable flight leg the crew member is on.

1

TransitPaxCountIn

Transit passenger count for the arrival leg.

If the pax member is on the departure leg this will be blank.

2

TransitPaxCountOut

Transit passenger count for the departure leg.

If the pax member is on the departure leg this will be blank.

1

Type of travel

The type of travel for the crew/pax. See ‘Type of travel' field in Crew/Pax order tab.

Normal