Import Lookup Table Data from a Text File

1. Access the Import 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 checked out to you. The Edit Lookup Table page opens.
   • On the Edit Lookup Table page, click the Import Schedule link. The Import Lookup Table page opens.
2. In Import Type, select Text File.

Note: The fields that display vary, depending on the type of table you are importing.

3. Click Select File. The Uploader dialog box opens.
4. Click Browse. The Choose File window opens.
5. Locate and select the text file from which you want to import lookup codes.
6. Click Open. The filename is loaded into the Upload File field on the Uploader box.
7. Click Select. The import lookup file preview appears.
8. Optionally, select one or more of the Import Instructions.
9. Optionally, specify a code range(s) in Code Filter.
   • If you select a Code Filter option and specify a range of codes, only the codes entered are available for import.
   • Code Filter options vary depending on the code type associated with your lookup table.
10. Click Import.

11. Optionally, click Clear to return all the fields on the page to their default settings.

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.

The following table describes the fields on the Import Lookup Table page.

• Lookup Table Management displays the Lookup Table Management page. For more information, refer to Manage Lookup Tables .
• Add Lookup Table displays the Add Lookup Table page. For more information, refer to Add a Lookup Table.
• Edit Lookup Table displays the Edit Lookup Table page. For more information, refer to Edit a Lookup Table.
• Import Schedule displays the Import Lookup Table Schedule page. For more information, refer to Add or Edit Schedule Data in a Table
• Download Import Template provides a template for creating lookup table import file.