Siebel Loyalty Administration Guide > Getting Started with Siebel Loyalty > Defining Lists of Values for Siebel Loyalty >

Defining Loyalty Airport and City Codes


Airline companies must define airport codes for all airports that flights arrive at and depart from. You can select these codes in the From Airport and To Airport drop-down lists when you define products.

Optionally, airline companies can define codes for cities, so they can create promotions based on flights between cities, not just based on flights between individual airports. To create promotions based on flights between cities, after creating the city codes, you must map them to airport codes at the program level; you can also map zones to the airport codes, as described in Mapping Zones and Cities to Airports.

Defining Airport Codes

The following procedure describes how to define airport codes.

To define airport codes

  1. Navigate to the Administration - Data screen, List of Values view.
  2. Query for the Type LOY_AIRPORT_CODE_CD.
  3. Add one record with this Type value for each airport your flights arrive at or depart from.
  4. Click Clear Cache.

    NOTE:  New values do not go into effect unless you click Clear Cache.

Defining City Codes

The following procedure describes how to define city codes.

To define city codes

  1. Navigate to the Administration - Data screen, List of Values view.
  2. Query for the Type LOY_CITY_CD.
  3. Add one record with this Type value for each city your flights arrive at or depart from.
  4. Click Clear Cache.

    NOTE:  New values do not go into effect unless you click Clear Cache.

Siebel Loyalty Administration Guide Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.