Exclusions Field Descriptions

Field Name	Field Description
Fare Class/Family	This is an editable field that is not required and defaults to blank when the screen is first opened. You can type up to eight alphanumeric characters; the first character must be an alpha. User defined groups (UDGs) may be employed in this field. Click the Fare Class field label to select or create a UDG using the UDG dialog box. Fare families may be typed. For example, type F- to find fare classes that begin with the letter F. This field may be used to exclude a specific fare class or a group of fare classes (using user defined groups). Multiple single entries of fare classes, UDGs, or a combination of fare classes and UDGs may be coded in this field. Entries must be separated by a comma (for example, F, Y, +first class fares, J). This field allows for a maximum of 255 characters. Fare Family Positional Match You can match to a fare family where the alphanumeric characters listed are in specific positions. A symbol is used to match to a designated position of one or more alphanumeric characters within the fare class. Additional alphanumeric characters may or may not follow the designated alphanumeric characters. Option 1 – Whole Number Exclamation point (!) Numbers are applied as a single unit and will be treated as a whole number in the match process. Example: W!!M1! will match W21M1A or W2AM1B7 but will not match W21M17 or W2AM17B (‘W’ must be in position 1, ‘M’ must be in position 4, ‘1’ must be position 5. ‘1’ must remain a whole number; therefore, position 6 must be an alpha character). Having the ‘7’ in position 6 changes the ‘1’ to ‘17’. Option 2 – Position Only Ampersand (&) Numbers are matched as individual characters, each based on its position. Example: W&&M1& will match W21M1A, W2AM1B7, W21M17, or W2AM17B but will not match W21MA1 or W2AMB1 (‘W’ must be in position 1, ‘M’ must be in position 4, ‘1’ must be position 5. ‘1’ does not have to remain a whole number; therefore, position 6 may be an alpha or numeric character). Having the ‘7’ in position 6 does not impact the ‘1’ in position 5, each are matched individually.
Location 1 / Location 2	This is an editable field that is not required and defaults to blank when the screen is first opened. This field allows for a maximum of 255 characters. Multiple, comma separated locations may be typed. UDGs may be employed in this field. Click the Location 1 or Location 2 field labels to select a UDG or create a UDG using the UDG dialog box. When the Source is International, location codes for city, airport, nation, and IATA zone may be used. When the Source is US/CA, location codes for city, airport, and nation may be used. When the Source is Add-on location codes for city, airport, nation, and IATA zone may be used. This field may be used to exclude the specified market or groups of markets. City, airport, nation, and IATA zone code indicators are not needed and assumed. For example, if you wish to indicate C (City) LON, you just type LON.
Bi-Directional	This field displays when the Source is International. Check this box to reduce your query to exclude markets in which the code indicated in the Location 1 field is also Location 2 and where the code indicated in Location 2 is also Location 1. This box is only enabled after an entry is made in the Location 1 field. Once this box has been checked, the Location 2 field is disabled.
Also as Loc 2	This check box only displays when the Scope is US/CA. The query excludes fares to/from the city entered in the Location 1 field. If LAX is coded in Location 1 field and the Also as Loc 2 box is checked, the query excludes fares where LAX is the first city shown in the market pair and fares where LAX is the second city shown. This box is only enabled after an entry has been coded in the Location 1 field. Once this box has been checked, the Location 2 field is disabled. If Also as Loc 2 is checked, you cannot access the UDG Groups dialog box by clicking the Location 2 field label and this field is disabled.
Market UDG	This is an editable field that is not required and defaults to blank when the screen is first opened. This field can only contain a UDG. Multiple UDG entries separated by commas are allowed (for example, +DFWHOU, MYMARKETS). This field allows for up to a maximum of 255 characters. Click the Market UDG field label to select or create a UDG using the UDG dialog box. When your scope is International, the market UDG will be an international market group. When your scope is US/CA, the market UDG, will be a US/CA market group. When your scope is Add-ons, the market UDG will be an Add-on market group.
Routing	This is an editable field that is not required and defaults to blank when the screen is first opened. This field accepts up to 255 characters. Multiple, comma separated routing numbers, UDGs, or a combination of routing numbers and UDGs may be typed in this field. UDGs may be employed in this field. Click the Routing field label to select or create a UDG using the UDG dialog box. This field may be used to exclude fares holding the specified routing number(s).
Add-on Zone	This field displays when the Scope is Add-on. Multiple entries, separated by commas, are allowed. This field allows for up to a maximum of 255 characters. Add-on zones consists of three numeric characters identifying arbitraries with the coded zone number. A hyphen (-) may also be used to indicate a match on all numbers from 0–9 in that position of the add-on zone number. Only one or two hyphens may be coded in a number; hyphens may not be used in all three positions.
Rule	This is an editable field that is not required and defaults to blank when the screen is first opened. This field displays when the Scope is International, or US/CA. UDGs may be entered in this field. Click the Rule field label to select or create a UDG using the UDG dialog box. You can enter one or more rule numbers, a UDG, or both. This field may be used to exclude fares holding the specified rule number(s). A rule consists of four alphanumeric characters. This field accepts up to 255 alphanumeric characters. This field will also accept a hyphen (-) in any position of the rule to indicate that it applies to all letter/numbers in that position. -1- - will match to 2100, 3105, or 100, but not on 1411 or 10 A- - - will match to A700 or A210, but not on 2A00 or 0A10 -23- will match to 4231 or 1234, but not on 2300 or 0123
Footnote	This is an editable field that is not required and defaults to blank when the screen is first opened. UDGs may be entered in this field. Click the Footnote field label to select or create a UDG using the UDG dialog box. This field allows for up to a maximum of 255 characters. Multiple, comma separated footnotes, UDGs, or both can be typed in this field. This field may be used to exclude fares holding the specified footnote(s).
Only Un-Footnoted	The default value for this check box is unchecked. This field may be used to exclude fares that do not hold a footnote. Once this box has been checked, the Footnote field becomes disabled.
Find Footnote	This field may only be used when a value is present in the Footnote field. By Itself— This option is used to exclude only fares that hold the specified footnote and no other footnote. In Combination— This option is only available for US/CA domestic and add-on tariffs and is used to limit the query to only fares that hold the specified footnote in combination with it and either of the directional footnotes F or T. By Itself & In Combination— This option is only available for US/CA domestic and add-ons tariffs and used to limit search to fares that hold only the specified footnote and fares that hold the specified footnote in combination with it and either of the directional footnotes F or T.
Include Un-Footnoted	The default value for this check box is unchecked. This field may only be used when a value is present in the Footnote field. This field may be used to exclude fares that do not hold a footnote.
Fare Type	This is an editable field that is not required and defaults to blank when the screen is first opened. This field allows for up to a maximum of 255 characters. Multiple, comma separated fare type codes may be typed in this field. Click the Fare Type field label to open the Fare Type dialog box, which allows you to select from a list of valid fare types. This field may be used to exclude fares that match the specified fare type.
OW/RT	This is not required and defaults to blank when the screen is first opened. This field may be used to exclude fares that are one-way or round-trip. 1— Indicates one-way fares 2— Indicates round-trip fares
Batch ID	This is not a required field for queries for source Master; however, it is required for source Transaction. This field accepts up to seven characters, where the first two are alphanumeric (generally a carrier code or ATPCO Batch ID) and the last five are numeric (indicating the batch number). Separate multiple entries in this field with commas.
Currency	This is an editable field that is not required and defaults to blank when the screen is first opened. This field may be used to exclude fares that hold the specified currency code.
Effective Date	This is an editable field that is not required and defaults to blank when the screen is first opened. The default value is DDMMMYY (the date format, if you want to manually enter a date), which selects all fares with any effective date. Click the Calendar button to select a date from the Calendar dialog box. This field may be used to exclude fares that hold the specified effective date.
GFS Date	This field only displays when the Source is Master. This is an editable field that is not required and defaults to blank when the screen is first opened. The default value is DDMMMYY (the date format, if you want to manually enter a date), which selects all fares with any GFS date. Click the Calendar button to select a date from the Calendar dialog box. This field may be used to exclude fares that hold the specified GFS date.
FAN	This is an editable field and defaults to blank when the screen is first opened. Type a valid filing advice number (FAN). This field is required for non-ATPCO users when a GFS date is provided. This field may be used to exclude fares that were filed with the specified GFS filing advice. The field accepts three alphanumeric characters.
Include Cancels	This field only displays when the Source is Master. The default value for this check box is checked. This field may be used to exclude fares that have been cancelled but that have not yet purged from the database.
Click the button, at the bottom of the Exclusions group box to display the following fields:
In Effect On Date Min	This is an editable field that is not required and defaults to blank when the screen is first opened. The default value is DDMMMYY (the date format, if you want to manually enter a date). Click the Calendar button to select a date from the Calendar dialog box. This field may be used to exclude fare sequences that hold effective dates no earlier than the specified date. This field must be used with the In Effect On Max field to create a date range.
In Effect On Date Max	This is an editable field that is not required and defaults to blank when the screen is first opened. The default value is DDMMMYY (the date format, if you want to manually enter a date). Click the Calendar button to select a date from the Calendar dialog box. This field may be used to exclude fare sequences that hold effective dates no later than the specified date. This field must be used with the In Effect On Min field to create a date range. If you are trying to isolate to a one day, then the In Effect On Date Min and Max needs to be the same date.
Last Sale Date	This is an editable field that is not required and defaults to blank when the screen is first opened. The default value is DDMMMYY (the date format, if you want to manually enter a date). Click the Calendar button to select a date from the Calendar dialog box. This field may be used to exclude fare sequences that hold last sale dates no later than the specified date.
Discontinue Date	This field only displays when the Source is Master. This is an editable field that is not required and defaults to blank when the screen is first opened. The default value is DDMMMYY (the date format, if you want to manually enter a date). Click the Calendar button to select a date from the Calendar dialog box. This field may be used to exclude fare sequences that hold discontinue dates no later than the specified date.
Mileage Min/Max	This is an editable field that is not required and defaults to blank when the screen is first opened. These fields may be used to exclude fares that hold mileage values above the value specified in the Mileage Min field or below the specified value in the Max field. These fields must be used together so that the query will correctly search for a mileage range.
Fare Amount Min/Max	This is an editable field that is not required and defaults to blank when the screen is first opened. These fields may be used to exclude fares that hold fare amounts above the value specified in the Fare Amount Min field or below the specified value in the Max field. These fields must be used together so that the query will correctly search for a fare range.
Use Post Tax Amount	The default value for this check box is unchecked. This field displays only when the Scope is US/CA. Checking this box prompts the query to use post tax amount for calculations.
Validated	This field only displays when the Source is Transaction. The default value for this check box is checked. This field may be used to exclude fare transactions that have been validated.
Validated With Warnings	This field only displays when the Source is Transaction. The default value for this check box is checked. This field may be used to exclude fare transactions that have been validated.
Validated With Errors	The default value for this check box is checked. This field displays only when the Source is Transaction. This field may be used to exclude fare transactions that have been validated.
Applied	The default value for this check box is unchecked. This field displays only when the Source is Transaction. This field may be used to exclude fare transactions that have been applied against the Fare Master.
Applied With Warnings	The default value for this check box is unchecked. This field displays only when the Source is Transaction. This field may be used to exclude fare transactions that have been applied against the Fare Master but returned with warning messages.