L ICD10 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:" |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
The ''' | {{DISPLAYTITLE:L_ICD10 table}}The '''L_ICD10''' table in [[CCMDB.accdb]] contains the [[ICD10]] data collected as per [[ICD10 collection]]. | ||
== Data Structure == | == Data Structure == | ||
{{#ask: [[Category:L ICD10 table]] | {{#ask: [[Category:L ICD10 table]] | ||
| ?FieldName | | ?FieldName | ||
| ?FieldDataType | | ?FieldDataType | ||
| ?FieldLength | | ?FieldLength | ||
| ? | | ?DataElementDescription | ||
|sort=DataElementSortIndex | |sort=DataElementSortIndex | ||
|order=ascending | |order=ascending | ||
| Line 40: | Line 18: | ||
{{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| *]] | ||
Latest revision as of 10:34, 30 July 2025
The L_ICD10 table in CCMDB.accdb contains the ICD10 data collected as per ICD10 collection.
Data Structure
| FieldName | FieldDataType | FieldLength | DataElementDescription | |
|---|---|---|---|---|
| Pat ID field | Pat_ID | number | Long Integer | The Pat_ID field contains a unique-per-laptop identifying number for patient ward admissions. See Serial number. |
| D ID field | D_ID | string | 18 | The unique identifier/index of records in the Critical Care and Medicine Database. |
| L ICD10 ID | L ICD10 ID | number | long | Unique identifier of the L_ICD10 table |
| ICD10 code | ICD10 code | string | 10 | The actual ICD10 code collected as part of ICD10 collection. |
| Dx Date | Dx_Date | date | not entered | The date/time of an ICD10 diagnosis. |
| Dx Date unknown | Dx_Date_unknown | boolean | not entered | True for Acquired Diagnosis / Complication when Dx Date legitimately missing. |
| Dx Type | Dx Type | string | 8 | The type of an ICD10 diagnosis (Comorbid Diagnosis, Admit Diagnosis or Acquired Diagnosis / Complication) |
| Dx Priority | Dx Priority | number | single | The priority of an ICD10 diagnosis, used to rank and group. |
| Dx Primary | Dx primary | boolean | not entered | Checkbox that is set to true for a single Admit Diagnosis per ward stay that is the Primary Admit Diagnosis |