S CCI 1 table: Difference between revisions

← Older edit

@@ Line 1: / Line 1: @@
-The '''{{PAGENAME}}''' in [[CCMDB.mdb]] contains the possible codes to use with [[CCI collection]].
+{{DISPLAYTITLE:s_CCI_1 table}}The '''s_CCI_1 table''' in [[CCMDB.accdb]] contains the possible codes to use with [[CCI Collection]].
 == Data Structure ==
@@ Line 8: / Line 8: @@
 !| description
 |-
-|| '''sortorder''' || number|| order on picklist
+|| '''CCI_1_ID''' || AutoNumber ||  unique identifier, links to [[L_CCI_Component table|L_ICD10]].CCI_1_ID
 |-
-|| '''description''' || text || description of picklist item
+|| '''CCI_1_Code''' || text ||  first component of CCI code
 |-
-|| '''CCI_1''' || number || [[L_CCI table|L_CCI]].CCI_1_ID
+|| '''CCI_1_category''' || text ||  [[:Category:CCI Category]]
 |-
-|| '''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 25: / Line 29: @@
 [[Category: ICD10/CCI Conversion]]
 [[Category: CCI]]
+[[Category: S_CCI_1 table]]
+[[Category: L CCI Component table]]
+[[Category: CCI Data Structure]]
+[[Category:CCI Component Coding]]