S CCI 2 table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) Created page with "The '''{{PAGENAME}}''' in CCMDB.mdb contains the possible codes to use with CCI collection. == Data Structure == {| class="wikitable sortable" |- !| field !| type !..." |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (10 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
The ''' | {{DISPLAYTITLE:s_CCI_2 table}}The '''s_CCI_2 table''' in [[CCMDB.accdb]] contains the possible codes to use with [[CCI Collection]]. | ||
== Data Structure == | == Data Structure == | ||
| Line 8: | Line 8: | ||
!| description | !| description | ||
|- | |- | ||
|| '''CCI_2_ID''' || AutoNumber || unique identifier, links to [[ | || '''CCI_2_ID''' || AutoNumber || unique identifier, links to [[L_CCI_Component table|L_ICD10]].CCI_1_ID | ||
|- | |- | ||
|| '''CCI_2_Code''' || text || second component of CCI code | || '''CCI_2_Code''' || text || second component of CCI code | ||
|- | |- | ||
|| ''' | || '''CCI_2_category''' || text || [[:Category:CCI Category]] | ||
|- | |- | ||
|| '''description''' || text || description of component code | || '''description''' || text || description of component code | ||
| Line 25: | Line 25: | ||
== Related Articles == | == Related Articles == | ||
{{Related Articles}} | {{Related Articles}} | ||
[[Category: Data structure]] | |||
[[Category: ICD10/CCI Conversion]] | |||
[[Category: CCI]] | |||
[[Category: S_CCI_2 table]] | |||
[[Category: L CCI Component table]] | |||
[[Category: CCI Data Structure]] | |||
[[Category: CCI Component Coding]] | |||
Latest revision as of 14:24, 2023 May 17
The s_CCI_2 table in CCMDB.accdb 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_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 |