Extractions

Default Extractions

This table contains the default Extractions that are available.

Name

Description

Category

Record Locator

PRN Number

Other

Vendor Locator

Vendor record locator

Passenger First Name

Contains Pax First Name

Name

Passenger Last Name

Contains Pax Last Name

First Phone Field

First Contact

Phone Number

Email Phone  Location

First Email City Code

Email

Email Phone Account Name

First Email Addressee

Email Phone Domain Name

First Email Domain

Email EM location

Pax Email Addressee

Email EM Domain

Pax Email Domain

Address Line 1 & Line 2

Delivery Address

Address

Address City

Delivery Address

Address Post/Zip Code

Delivery Address

TAU Date

Arrange Ticketing Date

Ticket Time Limit

TAW date

Arrange Follow Up Date

Frequent Flyer Carrier Code

Frequent Flyer Carrier Code

Frequent Flyer

Frequent Flyer Number

Frequent Flyer Number

Form of Payment Type - Credit Card

Form of Payment Credit Card

Form of Payment

Form of Payment Card Type

Form of Payment Card Type (vendor)

Form of Payment Card Number

Form of Payment Card Number

Form of Payment Card Expiry

Form of Payment Card Expiry

Form of Payment Type

Will show either S, CK, AGTINV, ETC

Carrier code

Carrier code

Segment Data

Flight Number

Flight Number

Departure Date

Departure Date

Outbound City

Outbound City

Destination City

Destination City

Departure Time

Departure Time

Arrival Time

Arrival Time

Special Service Data

Passport information

Special Service Data

 

Examples of Extraction Usage

The Advanced Cryptic Handler can be used to target specific entries within a PNR, extract data from those entries, and post an entry that is an acceptable Host command.

Notepad extraction

The following is an example of notepad entries that have been used to signify passport data. This data is not recognized as a valid passport command within Host. Queue Control Console can be used to read, extract, and write a command that is in an acceptable SSR DOC format that will be accepted by Host. Using Queue Control Console, you can write a command that will result in:

SSRDOCSIB HK  P/US/000003456/US/0000000/M/20DEC20/TRAVELLER/JACK/JOE -1TRAVELLER/JACKMR

In this scenario, the information needed by the Host exists in two notepads entries:

*P*TP-PP-ABC123456/US/TRAVELLER/JOE/JOHN/EX-19JAN20/CZ-US/NA-US AA 21SEP 0105Z

*P*TP-TSA/DOB-01JAN80/G-M AA 17SEP 0543Z

After setting up a schedule and queue to be monitored, add a Cryptic handler.

  1. Click Add new.

  2. Enter the command:
    SI.P1/SSRDOCSYYHK1/P/
  3. Click the Insert Extraction button. The list of available extractions displays.

  4. Expand Category: NOTEPAD and Insert CE-Country-Passport-Issued-In followed by / followed by inserting CE-Passport-Number followed by / etc. until the sting is completed.

  5. When you select insert, a dialog displays to add a Value.

  6. The value to be populated into this pop up represents the instance that is to be read within the PNR. That is, the first instance, second instance, etc. In the case of this example, the first instance is being used.
  7. The command box would then resemble the following:

Similarly, the user may have a Form of Payment in a notepad format that is not recognize by Host. The user can add a further Cryptic command to the handler to enable the post of a F. command to Host.

Following the same steps, as above, the user would begin the command with F. followed by clicking Insert Extraction, which lists the extractions grid. The user would then select CE-FOP.

This will read a notepad entry of:

*A*FOP-F-VI4242424242424242/D0119 AA 18SEP 0553Z

And post an entry to Host that will translate to:

FOP-VI4XXXXXXXXXXX4242/D0119

Once the user has written the command to ‘Receive by’ and ‘End & Retrieve’ the Configure Handler will resemble the following: