S CCI 2 table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
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

Related Articles

Related articles: