S CCI Picklist table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| Line 26: | Line 26: | ||
{{Related Articles}} | {{Related Articles}} | ||
[[Category: Data structure]] | [[Category:Data structure]] | ||
[[Category: CCI Data Structure]] | [[Category:CCI Data Structure]] | ||
[[Category: ICD10/CCI Conversion]] | [[Category:ICD10/CCI Conversion]] | ||
[[Category: CCI]] | [[Category:CCI]] | ||
[[Category: L_CCI_Picklist table]] | [[Category:L_CCI_Picklist table]] | ||
[[Category: CCI Picklist Coding]] | [[Category:CCI Picklist Coding]] | ||
Latest revision as of 12:01, 30 July 2025
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 |