Column Mapping

Column Mapping

Within Column Mapping you can takes fields from the CAIRS database and associate a custom field name.  For example, in CAIRS the field is called Directory Building Name, however in your 411 system it is called Common Building Name.  Within Column Mapping, you can have CAIRS change the field name when the interface is completed.

  1. Click the System Admin
  2. In the Navigation pane, click the plus sign (+) next to Data Sync Center to expand the menu items.
  3. Click 411 Interface.
  4. The list of existing template populates to the right, within the list, click on the template to modify.
  5. Within the Show ribbon group, click on the Column Mapping button. Within the window complete the following fields, required fields are marked with an asterisk:
    • Sort Index * – this is the position of the where the field appears in the file, a sort position of 1 means the field will be listed first. Type-in the numeric sort position
    • Table Name * – click the field to access a dropdown arrow, click the arrow to access a list of the following tables that are in your CAIRS database:
    • Configured Directory Line
    • Number Plan Main
    • Number Plan Listing – Directory Number
    • Set Device
    • Subscriber
    • Building
    • Connectivity
    • Switch – Specific Class of Service
    • Class of Service Name
    • Organization Path
    • Directory Line Multiple Listing
    • Listing Subscriber

Once you select the table, the field name column displays only the fields that pertain to the table.  For example, if you select the Subscriber Main table, the field names will pertain to only the information for a subscriber, such as first name, last name, rank, grade, etc.

    • Field Name * – click the field to access a dropdown arrow, click the arrow to access a list of the fields that pertain to the table selected.
    • Custom Name – type-in the custom field name, for example, if the CAIRS field name is connection, you can use this field to change the name to cable when the file generates.
  1. Within the Actions ribbon group, click Save (to save and stay) to continue adding information for the interface, or click Save & Close (to save and exit) to return to the 411 Interface list.