S CCI Categories table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (4 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]] | ||
|} | |} | ||
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 |