S CCI Picklist table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
(11 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
The '''{{PAGENAME}}''' in [[CCMDB. | {{DISPLAYTITLE:s_CCI_Picklist table}}The '''{{PAGENAME}}''' in [[CCMDB.accdb]] contains the possible picklist entries to use with [[CCI Collection]]. | ||
== Data Structure == | == Data Structure == | ||
Line 8: | Line 8: | ||
!| description | !| description | ||
|- | |- | ||
|| ''' | || '''CCI_Picklist_ID''' || number|| order on picklist | ||
|- | |- | ||
|| ''' | || '''CCI_Picklist_category''' || text || [[:Category:CCI Category]] | ||
|- | |- | ||
|| ''' | || '''CCI_Picklist_code''' || number || [[L_CCI_Picklist table|L_CCI_Picklist]].CCI_1_ID | ||
|- | |- | ||
|| ''' | || '''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 | |||
|} | |} | ||
Line 23: | Line 27: | ||
[[Category: Data structure]] | [[Category: Data structure]] | ||
[[Category: CCI Data Structure]] | |||
[[Category: ICD10/CCI Conversion]] | [[Category: ICD10/CCI Conversion]] | ||
[[Category: CCI]] | [[Category: CCI]] | ||
[[Category: L_CCI_Picklist table]] | |||
[[Category: CCI Picklist Coding]] |
Latest revision as of 14:20, 2023 May 17
The S CCI Picklist table in CCMDB.accdb contains the possible picklist entries to use with CCI Collection.
Data Structure
field | type | description |
---|---|---|
CCI_Picklist_ID | number | order on picklist |
CCI_Picklist_category | text | Category:CCI Category |
CCI_Picklist_code | number | L_CCI_Picklist.CCI_1_ID |
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 |