CT Outstandings query - Revision history

Ttenbergen: /* See also = */

2021-08-25T17:03:26Z

Ttenbergen at 17:03, 25 August 2021

2021-08-25T17:03:06Z

← Older revision		Revision as of 12:03, 25 August 2021
Line 1:		Line 1:
	~~P_Outstandings~~ is a query in [[CFE]].		{{PAGENAME}} is a query in [[CFE]].

	*'''Purpose~~''' : Summarizes the pending patients who still in the unit or ward for each site by their [[Arrive DtTm]] month~~ and ~~provides the counts of long stayed patients.~~		===Purpose===
			workload and backlog analysis

	*~~Data: will be counts of Incompletes in~~ [[~~RecordStatus field~~]] ~~WITH and WITHOUT a [[Dispo DtTm]].~~		===Description===
			Counts profiles currently on all laptops

			== See also ===
			* [[CT_Outstandings_Dispo query]] - profiles where pt has been discharged

	== Related articles ==		== Related articles ==
Line 9:		Line 14:

	[[Category:Data Processing]]		[[Category:Data Processing]]
	[[Category:~~CFE Data Integrity Checks~~]]		[[Category:Database Manager]]
	[[Category:Centralized data front end.accdb]]		[[Category:Centralized data front end.accdb]]
	[[Category:P Query]]		[[Category:CT Query]]

Ttenbergen: Ttenbergen moved page Query P Outstandings to CT Outstandings query without leaving a redirect: Text replacement - "Query P Outstandings" to "CT_Outstandings query"

2021-08-25T17:00:02Z

Ttenbergen moved page Query P Outstandings to CT Outstandings query without leaving a redirect: Text replacement - "Query P Outstandings" to "CT_Outstandings query"

← Older revision	Revision as of 12:00, 25 August 2021
(No difference)

Ttenbergen at 15:04, 27 July 2021

2021-07-27T15:04:26Z

← Older revision		Revision as of 10:04, 27 July 2021
Line 11:		Line 11:
	[[Category:CFE Data Integrity Checks]]		[[Category:CFE Data Integrity Checks]]
	[[Category:Centralized data front end.accdb]]		[[Category:Centralized data front end.accdb]]
			[[Category:P Query]]

Ttenbergen: Ttenbergen moved page P Outstandings query to Query P Outstandings without leaving a redirect: Text replacement - "P Outstandings query" to "query P_Outstandings "

2021-01-27T22:37:09Z

Ttenbergen moved page P Outstandings query to Query P Outstandings without leaving a redirect: Text replacement - "P Outstandings query" to "query P_Outstandings "

← Older revision	Revision as of 17:37, 27 January 2021
(No difference)

Ttenbergen at 22:30, 27 January 2021

2021-01-27T22:30:39Z

← Older revision		Revision as of 17:30, 27 January 2021
Line 1:		Line 1:
	P_Outstandings is a query in [[CFE]].		P_Outstandings is a query in [[CFE]].

	*'''Purpose''' : Summarizes the pending patients who still in the unit or ward for each site by their ~~admit~~ month and provides the counts of long stayed patients.		*'''Purpose''' : Summarizes the pending patients who still in the unit or ward for each site by their [[Arrive DtTm]] month and provides the counts of long stayed patients.
	*Column: yyyy/mmm of ADMIT DATE
	*Row: Dbase (CC/Med) x Hosp_Loc
	*Data: will be counts of Incompletes in RecordStatus field WITH and WITHOUT a discharge date.

			*Data: will be counts of Incompletes in [[RecordStatus field]] WITH and WITHOUT a [[Dispo DtTm]].

			== Related articles ==
			{{Related Articles}}

			[[Category:Data Processing]]
	[[Category:CFE Data Integrity Checks]]		[[Category:CFE Data Integrity Checks]]
	[[Category:Centralized data front end.accdb]]		[[Category:Centralized data front end.accdb]]

Ttenbergen: link fix

2018-05-16T17:59:53Z

link fix

← Older revision		Revision as of 12:59, 16 May 2018
Line 2:		Line 2:

	*'''Purpose''' : Summarizes the pending patients who still in the unit or ward for each site by their admit month and provides the counts of long stayed patients.		*'''Purpose''' : Summarizes the pending patients who still in the unit or ward for each site by their admit month and provides the counts of long stayed patients.
	** {{discussion}} how is that different from [[P_Outstandings]]?
	*Column: yyyy/mmm of ADMIT DATE		*Column: yyyy/mmm of ADMIT DATE
	*Row: Dbase (CC/Med) x Hosp_Loc		*Row: Dbase (CC/Med) x Hosp_Loc

Ttenbergen: Ttenbergen moved page P Outstandings to P Outstandings query without leaving a redirect

2018-02-07T22:41:17Z

Ttenbergen moved page P Outstandings to P Outstandings query without leaving a redirect

← Older revision	Revision as of 17:41, 7 February 2018
(No difference)

Ttenbergen at 20:08, 7 February 2018

2018-02-07T20:08:51Z

← Older revision		Revision as of 15:08, 7 February 2018
Line 1:		Line 1:
	P_Outstandings is a query in [[CFE]].		P_Outstandings is a query in [[CFE]].

	*'''Purpose''' : {{discussion}}		*'''Purpose''' : Summarizes the pending patients who still in the unit or ward for each site by their admit month and provides the counts of long stayed patients.
	*Column: ~~{{discussion}}~~		** {{discussion}} how is that different from [[P_Outstandings]]?
	*Row: ~~{{discussion}}~~		*Column: yyyy/mmm of ADMIT DATE
	*Data: ~~{{discussion}}~~		*Row: Dbase (CC/Med) x Hosp_Loc
			*Data: will be counts of Incompletes in RecordStatus field WITH and WITHOUT a discharge date.

	[[Category:CFE Data Integrity Checks]]		[[Category:CFE Data Integrity Checks]]
	[[Category:Centralized data front end.accdb]]		[[Category:Centralized data front end.accdb]]

Ttenbergen at 20:05, 7 February 2018

2018-02-07T20:05:41Z

← Older revision		Revision as of 15:05, 7 February 2018
Line 1:		Line 1:
	P_Outstandings is a query in [[CFE]].		P_Outstandings is a query in [[CFE]].

			*'''Purpose''' : {{discussion}}
			*Column: {{discussion}}
			*Row: {{discussion}}
			*Data: {{discussion}}


	[[Category:CFE Data Integrity Checks]]		[[Category:CFE Data Integrity Checks]]
	[[Category:Centralized data front end.accdb]]		[[Category:Centralized data front end.accdb]]

← Older revision		Revision as of 12:03, 25 August 2021
Line 7:		Line 7:
	Counts profiles currently on all laptops		Counts profiles currently on all laptops

	== See also ===		=== See also ===
	* [[CT_Outstandings_Dispo query]] - profiles where pt has been discharged		* [[CT_Outstandings_Dispo query]] - profiles where pt has been discharged