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
-|| '''[[Patient_ID]]/[[D_ID]]''' || text || link to [[L_Log table]]
+|default=No pages for labs that meet the semantic mediawiki criteria
-|-
+|headers=show
-|| '''CCI_ID''' || Long Integer || link to [[s_CCI table]], defaults to [[No diagnosis entered]] Record
+|class=sortable wikitable smwtable
-|-
+}}
-|| '''[[Dx_Date]]''' || Date/Time || [[Dx Date]]
-|-
-|| '''[[Dx_Type]]''' || text(8) || Acquired, Admit, Comorbid
-|-
-|| '''[[Dx_Priority]]''' || number/single || groups records and assigns importance
-|}
 == Related Articles ==
 {{Related Articles}}
-[[Category: Data structure]]
+[[Category:Data structure]]
-[[Category: ICD10/CCI Conversion]]
+[[Category:ICD10/CCI Conversion]]
-[[Category: L Table]]
+[[Category:L Table]]
-[[Category: ICD10]]
+[[Category:ICD10]]
-[[Category: L_ICD10 table|*]]
+[[Category:L_ICD10 table| *]]