Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

Code Block
catalog-lookup <catalog> <column>

...

'catalog' :column

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

These catalogs are currently supported:

  • ICD-9

  • ICD-10-2016

  • ICD-10-2017

Usage Notes

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

...

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

Code Block
catalog-lookup 'ICD-10-2016' :code

would result results in the record having an additional column code_<catalog>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.