Edit a Lookup Table

Based on your user authorization, you may be able to edit some details of lookup tables in your facility.

Note: The table must be currently checked out to you. For instructions, refer to Check Out/Check In a Lookup Table.

  1. Access the Edit Lookup Table page.
    • Select Go To > Contract Loading > Lookup Table Management. The Lookup Table Management page opens.
    • To reduce the number of listed tables, enter your selection criteria and click Refresh View.
    • Click a link in the Table Name column for a table you have checked out. The Edit Lookup Table page opens.

Note: The Edit Lookup Table page opens differently for each table type.

  1. Edit the lookup table data. Depending on the implementation stage and status and active status of the table, some data is unavailable for editing.
    • For lookup tables with associated rate schedules, the rate schedule appears at the bottom of the page. For more information about modifying a rate schedule, refer to Add or Edit Schedule Data in a Table.
    • For DRG lookup tables, the latest version of the DRG description displays. To view descriptions for all versions, click a link in the DRG column.
  2. Click Update.

Note: During the CDM table import process, any special characters (“'\!@#$%^&*+={}[]|:;?`~") in the description column are replaced with a space and any description over 50 characters is truncated to 50 characters.

During the CDM table import process, it is important to note the following:

  • Any special characters (“'\!@#$%^&*+={}[]|:;?`~") in the description column are replaced with a space

  • Any description over 50 characters is truncated to 50 characters

  • The following fields are used for Pricing Transparency requirements and not for Modeling CDM changes:

    • NDC Number - (optional/not a required field) Can be any number up to 11 digits, but do not include dashes “-“. If it is less than 11 digits, leading zeroes (0's) are added to the beginning of the number when imported.

    • Drug Unit of Measurement - (optional/not a required field) If the item or service is a drug, indicates the unit value that corresponds to the established standard charge.

    • Drug Type of Measurement - (optional/not a required field) The measurement type that corresponds to the established standard charge for drugs as defined by the NDC. The only applicable values are the following:

      • GR (grams)

      • ME (milligrams)

      • ML (milliliters)

      • UN (unit)

      • F2 (international unit)

      • EA (each)

      • GM (gram)

        Note: Only one value is accepted.

    • Standard Billing Units - (optional/not a required field) Some drugs have a standard number of billing units. For example, Drug A is billed 10 units as a base number of units. When a value is entered here, this value is used as the line item Unit instead of 1, when a pseudo claim is created for repricing.

    • Setting - (optional/not a required field) Options are IP, OP, or Both. Items with a setting of Both or are left Blank, are sent to the price transparency processing as both IP and OP claims and shown as two separate lines on the pricing transparency file. The only exception is for room and bed revenue codes 022 – 219, which are IP only.