Add a Lookup Table

You can create a lookup table for reference from a service type(s) or reimbursement term(s).

  1. Access the Add Lookup page.
    • Select Go To > Contract Loading > Lookup Table Management. The Lookup Table Management page opens.
    • Click the Add Lookup Table link. The Add Lookup Table page opens.
  2. Select the Table Type.
    • The type of table you select determines the fields that display on this page.
    • For more information about table types, refer to Lookup Table Types.
  3. Type the Table Name.
    • You cannot create a table with the same name and effective date of any lookup table in your facility.
    • If you create a procedure lookup table with the same name as an existing lookup table but different effective date, the new table is assigned the same code type as the original table.
    • Click Check Name to compare the name you typed to the lookup tables in your facility or facility group.
  4. Optionally, select an Effective date range.

Note: This field is not available if you selected CDM as your table type.

  1. Select the Code Type.
    • This field is only available if you selected Procedure Lookup or Provider Specialty Percentage Lookup as your table type.
    • For Provider Specialty Percentage Lookup tables, the code type allows you to select Provider Type or Provider Specialty.
    • For Procedure Lookup tables, the code type allows you to select the type of procedure code.
  2. Select the Procedure Type.

Note: Procedure type options are only available if you selected Procedure Lookup as your table type.

  1. Click Add.

The following table describes the fields on the Add Lookup Table page. For FinThrive users only, the source information is given for some fields, in the format: “Table.Field.” The URL for this page is lookup_table_add.asp.

Field

Description

Code Type

For procedure lookup tables, the type of code included in the table; For Provider Specialty Percentage Lookup tables, the code type allows you to select Provider Type or Provider Specialty.

Source: CLTABLE1.CODETYPE (facility-specific)

GLTABLE1.CODETYPE (universal)

Effective

Date range when the lookup table is effective

Location

Indicates whether the table is universal or facility-specific, which determines where the table is stored; if facility-specific, indicates the facility

Procedure Type

For procedure lookup tables, the type of procedure included in the table

Source: CLTABLE1.TYPE (facility-specific)

GLTABLE1.TYPE (universal)

If you select CCI edit codes, you will not be able to add schedule data to that table.

Table Name

Name of the lookup table

Source:

Procedure Lookup Tables:

CLTABLE1.NAME (facility-specific)

GLTABLE1.NAME (universal)

DRG Weight Tables:

CLDRGWT.NAME (facility-specific)

GLDRGWT.NAME (universal)

Modifier Tables:

CLMOD.NAME (facility-specific)

Table Type

Type of lookup table. For more information, refer to Lookup Table Types.

Source for Procedure Tables: CLTABLE1 (facility-specific)

GLTABLE1 (universal)

DRG Weight Tables: CLDRGWT (facility-specific)

GLDRGWT (universal)

Modifier Tables:

CLMOD (facility-specific)

  • Lookup Table Management displays the Lookup Table Management page. For more information, refer to Manage Lookup Tables .