S CCI Picklist table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
 
(11 intermediate revisions by the same user not shown)
Line 1: Line 1:
The '''{{PAGENAME}}''' in [[CCMDB.mdb]] contains the possible codes to use with [[CCI collection]].  
{{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
|-
|-
|| '''sortorder''' || number|| order on picklist
|| '''CCI_Picklist_ID''' || number|| order on picklist
|-
|-
|| '''description''' || text || description of picklist item
|| '''CCI_Picklist_category''' || text || [[:Category:CCI Category]]
|-
|-
|| '''CCI_1''' || number || [[L_CCI table|L_CCI]].CCI_1_ID
|| '''CCI_Picklist_code''' || number || [[L_CCI_Picklist table|L_CCI_Picklist]].CCI_1_ID
|-
|-
|| '''CCI_2''' || number || [[L_CCI table|L_CCI]].CCI_1_ID
|| '''description''' || text || description of component code
|-
|-
|| '''CCI_3''' || number || [[L_CCI table|L_CCI]].CCI_1_ID
|| '''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

Related Articles

Related articles: