S CCI 2 table: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
Line 30: | Line 30: | ||
[[Category: CCI]] | [[Category: CCI]] | ||
[[Category: S_CCI_2 table]] | [[Category: S_CCI_2 table]] | ||
[[Category: L CCI Component table]] |
Revision as of 15:29, 2018 February 5
The S CCI 2 table in CCMDB.mdb contains the possible codes to use with CCI collection.
Data Structure
field | type | description |
---|---|---|
CCI_2_ID | AutoNumber | unique identifier, links to L_ICD10.CCI_1_ID |
CCI_2_Code | text | second component of CCI code |
CCI_2_TID | text | T, D, I (therapy, diagnostic, imaging) |
description | text | description of component code |
active_start | Date/time | date/time the component code became active on laptops |
active_end | Date/time | if filled, date/time the component code became inactive on laptops |
wiki_url | Hyperlink | link to corresponding wiki article |