Import Lookup Table Data from an Existing Table

Use this procedure to import data into your facility level lookup table from an existing table in one of your accessible facilities.

  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 Existing Table.

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

  3. Select the Location of the source lookup table. If you chose Facility Specific, select the name of the Facility in which the source table is located.
  4. In Table Name, select the name of the table from which you want to import codes. If you select a table name with multiple versions, all versions are listed under Select Table.
  5. Select the table from which you want to import codes.

    6. Note: You may only import codes from one table at a time.

  6. Optionally, select one or more of the Import Instructions.
  7. 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.
  8. Click Import.
  9. Optionally, click Clear to return all the fields on the page to their default settings.

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

Field

Description

Activation Date

Date when the lookup table is available for use in claims processing (repricing)

Source:

Procedure Lookup Tables:

CLTABLE1.ACTIVATION_DT (facility-specific)

GLTABLE1.ACTIVATION_DT (universal)

DRG Weight Tables:

CLDRGWT.ACTIVATION_DT (facility-specific)

GLDRGWT.ACTIVATION_DT (universal)

Modifier Tables:

CLMOD.ACTIVATION_DT (facility-specific)

Active Status

Indicates the purpose and progress of the lookup table

Source:

Procedure Tables:

CLTABLE1.ACTIVE (facility-specific)

GLTABLE1.ACTIVE (universal)

DRG Weight Tables

CLDRGWT.ACTIVE (facility-specific)

GLDRGWT.ACTIVE (universal)

Modifier Tables:

CLMOD.ACTIVE (facility-specific)

APC Code From

The beginning Ambulatory Payment Classification (APC) code in a range of APC codes

APC Code To

The ending Ambulatory Payment Classification (APC) code in a range of APC codes

Code Filter

A code range to select. Code Filter options vary depending on the code type associated with your lookup table.

Note: Ranges are not allowed for ICD-10 or Other codes.

Created

Date, time and user information of when the lookup table was created

Source:

Procedure Lookup Tables:

CLTABLE1.CDATE_TIME+CORG+CUSER (facility-specific)

GLTABLE1.CDATE_TIME+CORG+CUSER (universal)

DRG Weight Tables:

CLDRGWT.CDATE_TIME+CORG+CUSER (facility-specific)

GLDRGWT.CDATE_TIME+CORG+CUSER (universal)

Modifier Tables:

CLMOD.CDATE_TIME+CORG+CUSER (facility-specific)

Effective Date

Date when the lookup table is effective

Source:

Procedure Lookup Tables:

CLTABLE1.EFF_DATE (facility-specific)

GLTABLE1.EFF_DATE (universal)

DRG Weight Tables:

CLDRGWT.EFF_DATE (facility-specific)

GLDRGWT.EFF_DATE (universal)

Modifier Tables:

CLMOD.EFF_DATE (facility-specific)

Facility Name

Source facility name

Source:

Procedure Lookup Tables:

CLTABLE1.PFACID (facility-specific)

GLTABLE1.PFACID (universal)

DRG Weight Tables:

CLDRGWT.PFACID (facility-specific)

GLDRGWT.PFACID (universal)

Modifier Tables:

CLMOD.PFACID (facility-specific)

Import Instructions

Instructions on how the system should import a data-set.

Import Type

Type of data to import

Location

Destination facility name

Name

Name of the lookup table version to select

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)

Source Location

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

Source 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)

Stage

Current implementation stage of the table

Source:

Procedure Lookup Tables:

CLTABLE1.STAGE (facility-specific)

GLTABLE1.STAGE (universal)

DRG Weight Tables:

CLDRGWT.STAGE (facility-specific)

GLDRGWT.STAGE (universal)

Modifier Tables:

CLMOD.STAGE (facility-specific)

Status

Current implementation status of the table; progression within the current implementation stage

Source:

Procedure Lookup Tables:

CLTABLE1.STATUS (facility-specific)

GLTABLE1.STATUS (universal)

DRG Weight Tables:

CLDRGWT.STATUS (facility-specific)

GLDRGWT.STATUS (universal)

Modifier Tables:

CLMOD.STATUS (facility-specific)

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)

Termination Date

Date when the lookup table is terminated, or no longer effective

Source:

Procedure Lookup Tables:

CLTABLE1.TRM_DATE (facility-specific)

GLTABLE1.TRM_DATE (universal)

DRG Weight Tables:

CLDRGWT.TRM_DATE (facility-specific)

GLDRGWT.TRM_DATE (universal)

Modifier Tables:

CLMOD.TRM_DATE (facility-specific)

  • 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.