L CCI Picklist table - Revision history

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

2025-07-30T16:34:42Z

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

← Older revision		Revision as of 11:34, 30 July 2025
Line 29:		Line 29:
	{{Related Articles}}		{{Related Articles}}

	[[Category: Data structure]]		[[Category:Data structure]]
	[[Category: ICD10/CCI Conversion]]		[[Category:ICD10/CCI Conversion]]
	[[Category: CCI]]		[[Category:CCI]]
	[[Category: L Table]]		[[Category:L Table]]
	[[Category: CCI Data Structure]]		[[Category:CCI Data Structure]]
	[[Category: L CCI Picklist table]]		[[Category:L CCI Picklist table]]
	[[Category: CCI Picklist Coding]]		[[Category:CCI Picklist Coding]]

2025-06-20T19:26:29Z

Text replacement - "cross check " to "cross check "

← Older revision		Revision as of 14:26, 20 June 2025
Line 16:		Line 16:
	\|\| '''[[Px_Date]]''' \|\| Date/Time \|\| [[Px_Date]]		\|\| '''[[Px_Date]]''' \|\| Date/Time \|\| [[Px_Date]]
	\|-		\|-
	\|\| '''[[Px_Date]]_missing''' \|\| yes/no \|\| originally intended for cross check if no [[Px_Date]] and [[Px_Type]] = acquired; not currently used or accessible in CCMDB.accdb front end		\|\| '''[[Px_Date]]_missing''' \|\| yes/no \|\| originally intended for [[cross check]] if no [[Px_Date]] and [[Px_Type]] = acquired; not currently used or accessible in CCMDB.accdb front end
	\|-		\|-
	\|\| '''[[Px_Type]]''' \|\| text(8) \|\| Acquired, Admit, Comorbid		\|\| '''[[Px_Type]]''' \|\| text(8) \|\| Acquired, Admit, Comorbid

2023-05-17T20:07:30Z

← Older revision		Revision as of 15:07, 17 May 2023
Line 1:		Line 1:
	{{DISPLAYTITLE:L_CCI_Picklist table}} The '''L_CCI_Picklist ''' table in [[CCMDB.accdb]] contains the [[CCI Picklist]] data collected as per [[CCI Collection]]. It's the counterpart of the [[L CCI Component table]].		{{DISPLAYTITLE:L_CCI_Picklist table}} The '''L_CCI_Picklist ''' table in [[CCMDB.accdb]] contains the [[CCI Picklist]] data collected as per [[CCI Collection]]. It's the counterpart of the [[L CCI Component table]].

	~~test: {{PAGENAME}}~~
	== Data Structure ==		== Data Structure ==
	{\| class="wikitable sortable"		{\| class="wikitable sortable"

2023-05-17T20:07:17Z

← Older revision		Revision as of 15:07, 17 May 2023
Line 1:		Line 1:
	{{DISPLAYTITLE:~~L_CCI_Component~~ table}} The '''~~L_CCI_Component~~''' table in [[CCMDB.accdb]] contains the [[CCI Picklist]] data collected as per [[CCI Collection]]. It's the counterpart of the [[L CCI Component table]].		{{DISPLAYTITLE:L_CCI_Picklist table}} The '''L_CCI_Picklist ''' table in [[CCMDB.accdb]] contains the [[CCI Picklist]] data collected as per [[CCI Collection]]. It's the counterpart of the [[L CCI Component table]].

	test ~~pagename~~: {{PAGENAME}}		test: {{PAGENAME}}
	== Data Structure ==		== Data Structure ==
	{\| class="wikitable sortable"		{\| class="wikitable sortable"

2023-05-17T20:06:23Z

← Older revision		Revision as of 15:06, 17 May 2023
Line 1:		Line 1:
	The '''L_CCI_Component''' table in [[CCMDB.accdb]] contains the [[CCI Picklist]] data collected as per [[CCI Collection]]. It's the counterpart of the [[L CCI Component table]].		{{DISPLAYTITLE:L_CCI_Component table}} The '''L_CCI_Component''' table in [[CCMDB.accdb]] contains the [[CCI Picklist]] data collected as per [[CCI Collection]]. It's the counterpart of the [[L CCI Component table]].


			test pagename: {{PAGENAME}}
	== Data Structure ==		== Data Structure ==
	{\| class="wikitable sortable"		{\| class="wikitable sortable"

2019-09-22T16:45:33Z

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

← Older revision		Revision as of 11:45, 22 September 2019
Line 1:		Line 1:
	The '''L_CCI_Component''' table in [[CCMDB.~~mdb~~]] contains the [[CCI Picklist]] data collected as per [[CCI Collection]]. It's the counterpart of the [[L CCI Component table]].		The '''L_CCI_Component''' table in [[CCMDB.accdb]] contains the [[CCI Picklist]] data collected as per [[CCI Collection]]. It's the counterpart of the [[L CCI Component table]].


Line 17:		Line 17:
	\|\| '''[[Px_Date]]''' \|\| Date/Time \|\| [[Px_Date]]		\|\| '''[[Px_Date]]''' \|\| Date/Time \|\| [[Px_Date]]
	\|-		\|-
	\|\| '''[[Px_Date]]_missing''' \|\| yes/no \|\| originally intended for cross check if no [[Px_Date]] and [[Px_Type]] = acquired; not currently used or accessible in CCMDB.~~mdb~~ front end		\|\| '''[[Px_Date]]_missing''' \|\| yes/no \|\| originally intended for cross check if no [[Px_Date]] and [[Px_Type]] = acquired; not currently used or accessible in CCMDB.accdb front end
	\|-		\|-
	\|\| '''[[Px_Type]]''' \|\| text(8) \|\| Acquired, Admit, Comorbid		\|\| '''[[Px_Type]]''' \|\| text(8) \|\| Acquired, Admit, Comorbid

2019-01-17T02:52:18Z

← Older revision		Revision as of 21:52, 16 January 2019
Line 25:		Line 25:

	== How it works ==		== How it works ==
	To understand all [[CCI Procedure]]s for a patient, consider [[L_CCI_Component table]] and [[L_CCI_Picklist table]] together, eg. by using the [[~~Query L CCI Resolver~~]].		To understand all [[CCI Procedure]]s for a patient, consider [[L_CCI_Component table]] and [[L_CCI_Picklist table]] together, eg. by using the [[query L_CCI_Combined]].

	== Related Articles ==		== Related Articles ==

2019-01-17T02:47:50Z

← Older revision		Revision as of 21:47, 16 January 2019
Line 25:		Line 25:

	== How it works ==		== How it works ==
	To understand all [[CCI Procedure]]s for a patient, consider [[~~L CCI Picklist~~ table]] and [[~~L CCI Component~~ table]] together, eg. by using the [[Query L CCI Resolver]].		To understand all [[CCI Procedure]]s for a patient, consider [[L_CCI_Component table]] and [[L_CCI_Picklist table]] together, eg. by using the [[Query L CCI Resolver]].

	== Related Articles ==		== Related Articles ==

2018-10-14T21:31:19Z

← Older revision		Revision as of 16:31, 14 October 2018
Line 17:		Line 17:
	\|\| '''[[Px_Date]]''' \|\| Date/Time \|\| [[Px_Date]]		\|\| '''[[Px_Date]]''' \|\| Date/Time \|\| [[Px_Date]]
	\|-		\|-
	\|\| '''[[Px_Date]]_missing''' \|\| yes/no \|\| ~~must be set to true~~ if no [[Px_Date]] and [[Px_Type]] = acquired		\|\| '''[[Px_Date]]_missing''' \|\| yes/no \|\| originally intended for cross check if no [[Px_Date]] and [[Px_Type]] = acquired; not currently used or accessible in CCMDB.mdb front end
	\|-		\|-
	\|\| '''[[Px_Type]]''' \|\| text(8) \|\| Acquired, Admit, Comorbid		\|\| '''[[Px_Type]]''' \|\| text(8) \|\| Acquired, Admit, Comorbid

2018-10-14T21:25:35Z

← Older revision		Revision as of 16:25, 14 October 2018
Line 17:		Line 17:
	\|\| '''[[Px_Date]]''' \|\| Date/Time \|\| [[Px_Date]]		\|\| '''[[Px_Date]]''' \|\| Date/Time \|\| [[Px_Date]]
	\|-		\|-
	\|\| '''[[Px_Date]]_missing''' \|\| yes/no \|\| ~~mus~~ be set to true if no [[Px_Date]]		\|\| '''[[Px_Date]]_missing''' \|\| yes/no \|\| must be set to true if no [[Px_Date]] and [[Px_Type]] = acquired
	\|-		\|-
	\|\| '''[[Px_Type]]''' \|\| text(8) \|\| Acquired, Admit, Comorbid		\|\| '''[[Px_Type]]''' \|\| text(8) \|\| Acquired, Admit, Comorbid