Copy a Lookup Table - Advanced

When you want to create a lookup table based on an existing one, you may copy it. Authorized users may copy a lookup table from any accessible facility to another, using the Copy Lookup Table - Advanced page.

  1. Access the Copy Lookup Table - Advanced page.
    • Select Go To > Contract Loading > Lookup Table Management. The Lookup Table Management page opens.
    • Click the Copy Lookup Table - Advanced link. The Copy Lookup Table - Advanced page opens.
  2. Select the copy source criteria. If you select a table name that applies to more than one table, all the tables with that name are displayed in Select Table.
  3. Specify the details of your service type definition table copy.
  4. Click Copy. The Lookup table was copied successfully. message appears.

The following table describes the fields on the Copy Lookup Table -Advanced 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_copy_xfac.asp.

Field

Description

Destination Facility/Location

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

Destination Table Name

Name of the new lookup table

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)

Select Table

Lookup table(s) with the name you selected

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

Table Type

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

Source:

Procedure Tables: CLTABLE1 (facility-specific)

GLTABLE1 (universal)

For DRG Weight Tables: CLDRGWT (facility-specific)

GLDRGWT (universal)

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 .