L ICD10 table - Revision history

Ttenbergen: Text replacement - "[[Category: " to "[[Category:"

2025-07-30T16:34:24Z

Text replacement - "[[Category: " to "[[Category:"

2023-05-17T20:11:51Z

← Older revision		Revision as of 15:11, 17 May 2023
Line 1:		Line 1:
	The '''~~L ICD10~~''' table in [[CCMDB.accdb]] 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 ==		== Data Structure ==

2019-09-22T16:45:14Z

Text replacement - "CCMDB.mdb" to "CCMDB.accdb"

← Older revision		Revision as of 11:45, 22 September 2019
Line 1:		Line 1:
	The '''L ICD10''' table in [[CCMDB.~~mdb~~]] contains the [[ICD10]] data collected as per [[ICD10 collection]].		The '''L ICD10''' table in [[CCMDB.accdb]] contains the [[ICD10]] data collected as per [[ICD10 collection]].

	== Data Structure ==		== Data Structure ==

2018-02-19T18:46:35Z

Text replacement - "|*" to "| *"

2017-12-06T02:47:45Z

changed to automatic listing of elements through semantic data

@@ Line 2: / Line 2: @@
 == Data Structure ==
 {{#ask: [[Category:L ICD10 table]]
 | ?FieldName
 | ?FieldDataType
 | ?FieldLength
-| ?DataElementSortIndex = order in table
+| ?DataElementDescription
 |sort=DataElementSortIndex
 |order=ascending

2017-12-06T02:34:58Z

@@ Line 22: / Line 22: @@
 || '''[[Dx_Priority]]''' || number/single || groups records and assigns importance
 |}
 == Related Articles ==

2017-12-06T02:30:51Z

← Older revision		Revision as of 21:30, 5 December 2017
Line 8:		Line 8:
	!\| description		!\| description
	\|-		\|-
	\|\| '''L_ICD10_ID''' \|\| Long Integer(AutoNumber)\|\| unique ID		\|\| '''[[L_ICD10_ID]]''' \|\| Long Integer(AutoNumber)\|\| unique ID
	\|-		\|-
	\|\| '''[[Patient_ID]]/[[D_ID]]''' \|\| text \|\| link to [[L_Log table]]		\|\| '''[[Patient_ID]]/[[D_ID]]''' \|\| text \|\| link to [[L_Log table]]
	\|-		\|-
	\|\| '''ICD10_ID''' \|\| Long Integer \|\| link to [[s_ICD10 table]], defaults to [[No diagnosis entered]] record		\|\| '''[[ICD10_ID]]''' \|\| Long Integer \|\| link to [[s_ICD10 table]], defaults to [[No diagnosis entered]] record
	\|-		\|-
	\|\| '''[[Dx_Date]]''' \|\| Date/Time \|\| [[Dx Date]]		\|\| '''[[Dx_Date]]''' \|\| Date/Time \|\| [[Dx Date]]

2017-12-06T01:35:16Z

← Older revision		Revision as of 20:35, 5 December 2017
Line 8:		Line 8:
	!\| description		!\| description
	\|-		\|-
	\|\| '''[[L_ICD10_ID]]''' \|\| Long Integer(AutoNumber)\|\| unique ID		\|\| '''L_ICD10_ID''' \|\| Long Integer(AutoNumber)\|\| unique ID
	\|-		\|-
	\|\| '''[[Patient_ID]]/[[D_ID]]''' \|\| text \|\| link to [[L_Log table]]		\|\| '''[[Patient_ID]]/[[D_ID]]''' \|\| text \|\| link to [[L_Log table]]
Line 15:		Line 15:
	\|-		\|-
	\|\| '''[[Dx_Date]]''' \|\| Date/Time \|\| [[Dx Date]]		\|\| '''[[Dx_Date]]''' \|\| Date/Time \|\| [[Dx Date]]
			\|-
			\|\| '''[[Dx_Date_unknown]]''' \|\| Yes/No \|\| check true if date is unavailable for acquired dx
	\|-		\|-
	\|\| '''[[Dx_Type]]''' \|\| text(8) \|\| Acquired, Admit, Comorbid		\|\| '''[[Dx_Type]]''' \|\| text(8) \|\| Acquired, Admit, Comorbid

2017-11-14T02:19:33Z

← Older revision		Revision as of 21:19, 13 November 2017
Line 8:		Line 8:
	!\| description		!\| description
	\|-		\|-
	\|\| '''L_ICD10_ID''' \|\| Long Integer(AutoNumber)\|\| unique ID		\|\| '''[[L_ICD10_ID]]''' \|\| Long Integer(AutoNumber)\|\| unique ID
	\|-		\|-
	\|\| '''[[Patient_ID]]/[[D_ID]]''' \|\| text \|\| link to [[L_Log table]]		\|\| '''[[Patient_ID]]/[[D_ID]]''' \|\| text \|\| link to [[L_Log table]]

2017-09-21T23:33:39Z

links

← Older revision		Revision as of 18:33, 21 September 2017
Line 12:		Line 12:
	\|\| '''[[Patient_ID]]/[[D_ID]]''' \|\| text \|\| link to [[L_Log table]]		\|\| '''[[Patient_ID]]/[[D_ID]]''' \|\| text \|\| link to [[L_Log table]]
	\|-		\|-
	\|\| '''~~CCI_ID~~''' \|\| Long Integer \|\| link to [[~~s_CCI~~ table]], defaults to [[No diagnosis entered]] ~~Record~~		\|\| '''ICD10_ID''' \|\| Long Integer \|\| link to [[s_ICD10 table]], defaults to [[No diagnosis entered]] record
	\|-		\|-
	\|\| '''[[Dx_Date]]''' \|\| Date/Time \|\| [[Dx Date]]		\|\| '''[[Dx_Date]]''' \|\| Date/Time \|\| [[Dx Date]]