S CCI Categories table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) Created page with "The '''{{PAGENAME}}''' in CCMDB.mdb contains diagnosis categories that are used to filter CCI procedures in CCMDB.mdb and are also used by some cross checks for CCI..." |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (5 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
The '''{{PAGENAME}}''' in [[CCMDB. | {{DISPLAYTITLE:s_CCI_Categories table}}The '''{{PAGENAME}}''' in [[CCMDB.accdb]] contains procedure categories that are used to filter CCI procedures in [[CCMDB.accdb]] and are also used by some cross checks for [[CCI Collection]]. See [[Re-importing CCI and IDC10 categories from wiki to CCMDB.accdb]] for how this table is populated. | ||
== Data Structure == | == Data Structure == | ||
| Line 8: | Line 8: | ||
!| description | !| description | ||
|- | |- | ||
|| '''CCI_Code''' || text || the CCI_code, could be CCI_1_Code, CCI_2_Code or CCI_Picklist_Code | || '''CCI_Code''' || text(21) || the CCI_code, could be CCI_1_Code, CCI_2_Code or CCI_Picklist_Code | ||
|- | |- | ||
|| '''CCI_category''' || text || category as taken from wiki, see [[CCI Categories for CCMDB. | || '''CCI_category''' || text(25) || category as taken from wiki, see [[CCI Categories for CCMDB.accdb]] | ||
|} | |} | ||
| Line 18: | Line 18: | ||
[[Category:Data structure]] | [[Category:Data structure]] | ||
[[Category:CCI]] | [[Category:CCI]] | ||
[[Category CCI Data Structure]] | [[Category:CCI Data Structure]] | ||
[[Category:CCI Component Coding]] | [[Category:CCI Component Coding]] | ||
Latest revision as of 14:21, 2023 May 17
The S CCI Categories table in CCMDB.accdb contains procedure categories that are used to filter CCI procedures in CCMDB.accdb and are also used by some cross checks for CCI Collection. See Re-importing CCI and IDC10 categories from wiki to CCMDB.accdb for how this table is populated.
Data Structure
| field | type | description |
|---|---|---|
| CCI_Code | text(21) | the CCI_code, could be CCI_1_Code, CCI_2_Code or CCI_Picklist_Code |
| CCI_category | text(25) | category as taken from wiki, see CCI Categories for CCMDB.accdb |