S CCI 1 table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
The ''' | {{DISPLAYTITLE:s_CCI_1 table}}The '''s_CCI_1 table''' in [[CCMDB.accdb]] contains the possible codes to use with [[CCI Collection]]. | ||
== Data Structure == | == Data Structure == | ||
Latest revision as of 14:25, 2023 May 17
The s_CCI_1 table in CCMDB.accdb contains the possible codes to use with CCI Collection.
Data Structure
| field | type | description |
|---|---|---|
| CCI_1_ID | AutoNumber | unique identifier, links to L_ICD10.CCI_1_ID |
| CCI_1_Code | text | first component of CCI code |
| CCI_1_category | text | Category:CCI Category |
| 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 |