CCI Procedure

A CCI Procedure is a therapy, diagnostic intervention or imaging that follows the CCI coding scheme. We collect these following the CCI collection instructions.

See also: Reasoning around moving to CCI and our subset of it

Data representation

CCI codes are sets of letters and numbers of the format <number between 1-3>.<2 letters>.<2 numbers>.<optionally more letters>, e.g. 1.AB.23.CD

We encode these components in three fields as a single record in L CCI table:

• CCI_1_ID - first component, <number between 1-3>.<2 letters>
• CCI_2_ID - second component, <2 numbers><optionally more letters>

For each of those fields, a user of the data on the front end will see a description of the meaning of the chosen code. If the dropdown field is activated, the CCI Code component is seen as well. The actual data stored is a long integer unique ID that resolves to the corresponding s_CCI_1 table, s_CCI_2 table.

Query L CCI Resolver can be used to see the actual CCI code.