CCI Procedure: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 8: | Line 8: | ||
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 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> | * [[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 3 table]], [[s_CCI 2 | 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 3 table]], [[s_CCI 2 table]]. | ||
[[Query L CCI Resolver]] can be used to see the actual CCI code. | [[Query L CCI Resolver]] can be used to see the actual CCI code. | ||
Revision as of 14:32, 5 February 2018
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 3 table, s_CCI 2 table.
Query L CCI Resolver can be used to see the actual CCI code.