Create a User-Defined Table

You need to create a user-defined table to hold various annual travel pass choices.

Navigation: My Client Groups > Show More > User-Defined Tables
Note: XX is being used a a prefix example. Modify based on your business prefix for other build configurations. For example: If your build uses LCC elsewhere, then amend XX_TRAVEL_PASS_CHOICES to LCC_TRAVEL_PASS_CHOICES
  1. Create a table on the User-Defined Table page.
  2. Select a relevant Ireland Legislative Data Group.
  3. In the Effective As-of Date field, enter the effective date and continue. The main components of the user-defined table are the definition, columns, rows, and values.
    FieldValue
    NAME Enter a relevant name such as XX_TRAVEL_PASS_CHOICES
    Note: Instead of 'XX', add the business prefix which you use in your build structure to signify business configuration. the name should be in uppercase and underlined.
    Unit of Measure Text

    Range or Match

    Match
    Column Name Rate
    Data Type Text
  4. Add the user-defined table values as shown here:
    SequenceTravel Pass Choices
    10 Annual Dublin City Bus Only
    20 Annual Dublin City and Rail Short Hop and Dart
    30 Annual Dart/Commuter Rail, Dublin City Bus, and LUAS
    40 Annual Dart/Commuter Rail
    50 Annual Dublin City Bus and LUAS
    60 Annual LUAS Ticket
    70 All CIE Services
  5. Amend the Sequence under the User-defined table values as shown here along with their effective start and end dates:

    User-defined table values

    Sequence Travel pass choices Value
    10 Annual Dublin City Bus Only 1150
    20 Annual Dublin City and Rail Short Hop and Dart 1400
    39 Annual Dart/Commuter Rail, Dublin City Bus, and LUAS 1550
    40 Annual Dart/Commuter Rail 1400
    50 Annual Dublin City Bus and LUAS 1400
    60 Annual LUAS Ticket 1050
    70 All CIE Services 5200
  6. Save your changes.