L ICD10 table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m m
m cat
Line 30: Line 30:
[[Category: Data structure]]
[[Category: Data structure]]
[[Category: ICD10/CCI Conversion]]
[[Category: ICD10/CCI Conversion]]
[[Category:L Table]]
[[Category: L Table]]
[[Category: ICD10]]

Revision as of 17:32, 18 September 2017

The L ICD10 table in CCMDB.mdb contains the ICD10 data collected as per ICD10 collection.

Data Structure

field type description
L_ICD10_ID Long Integer(AutoNumber) unique ID
D_ID text link to L_Log table
ICD10_ID link to s_ICD10 table
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

Related Articles

Related articles: