CCI Procedure: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Line 6: Line 6:
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
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]]:
We encode these components in three fields as a single record in [[L_CCI_Component table]]:
* [[CCI_1_ID]] - first component, <number between 1-3>.<2 letters>
* [[CCI_1_ID]] - first component, <number between 1-3>.<2 letters>
* [[CCI_2_ID]] - second component, <2 numbers><optionally more letters>
* [[CCI_2_ID]] - second component, <2 numbers><optionally more letters>

Revision as of 17:00, 2018 February 5

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

Related articles

Related articles: