Catalog Lookup directive

The CATALOG-LOOKUP directive provides lookups into catalogs that are pre-loaded (static). Currently, the directive supports looking up health care ICD-9 and ICD-10-{2016,2017} codes.

Syntax

The 'catalog' argument specifies the dictionary to use for looking up the value in the :column.

These catalogs are currently supported:

• ICD-9

• ICD-10-2016

• ICD-10-2017

Usage Notes

Using this record as an example: A record containing a single field (code) that requires looking up:

Applying the CATALOG-LOOKUP directive with the ICD-10-2016 Catalog:

results in the record having an additional column code_catalog_description containing the result of the lookup. In cases where there is no matching code, a null is stored instead. For this example, in code_icd_10_2016_description:

In cases where the lookup is null or empty for a record, a null value is added to the :column field.