L ICD10 table: Difference between revisions

← Older edit

@@ Line 1: / Line 1: @@
-The '''L ICD10''' table in [[CCMDB.mdb]] contains the [[ICD10]] data collected as per [[ICD10 collection]].
+{{DISPLAYTITLE:L_ICD10 table}}The '''L_ICD10''' table in [[CCMDB.accdb]] contains the [[ICD10]] data collected as per [[ICD10 collection]].
 == Data Structure ==
-{| class="wikitable sortable"
+{{#ask: [[Category:L ICD10 table]]
-|-
+| ?FieldName
-!| field
+| ?FieldDataType
-!| type
+| ?FieldLength
-!| description
+| ?DataElementDescription
-|-
+|sort=DataElementSortIndex
-|| '''L_ICD10_ID''' || Long Integer(AutoNumber)|| unique ID
+|order=ascending
-|-
+|format=broadtable
-|| '''[[D_ID]]''' || text || link to [[L_Log table]]
+|default=No pages for labs that meet the semantic mediawiki criteria
-|-
+|headers=show
-|| '''ICD10_ID''' || || link to [[s_ICD10 table]]
+|class=sortable wikitable smwtable
-|-
+}}
-|| '''Dx_Date''' || Date/Time || date diagnosis made; mandatory for Acquired Dx
-|-
-|| '''Dx_Type''' || text(8) || Acquired, Admit, Comorbid
-|-
-|| '''Priority''' || number (single) || for sorting and grouping
-|}
-== Dx_Date ==
-* {{discussion}} will this be allowed for other dxs?
-* {{discussion}} will this be Date diagnosed, or date dx happened?==
 == Related Articles ==
 {{Related Articles}}
-[[Category: Data structure]]
+[[Category:Data structure]]
-[[Category: ICD10/CCI Conversion]]
+[[Category:ICD10/CCI Conversion]]
 [[Category:L Table]]
+[[Category:ICD10]]
+[[Category:L_ICD10 table| *]]