Query check has transfer ready date or checkbox - Revision history

Ttenbergen: /* Log */

2024-11-15T18:12:47Z

Log

← Older revision		Revision as of 13:12, 15 November 2024
Line 34:		Line 34:

	== Log ==		== Log ==
			{{DT\|
			* This check doesn't seem to catch when a time is entered without a date. It would be good to update that. Don't have time right now, so leaving a note. Email exchange 2024-11-14. [[User:Ttenbergen\|Ttenbergen]] 12:12, 2024 November 15 (CST) }}
	* 2021-04-29 - discussed at task meeting that there need not be comments for Transfer Ready DtTm, and therefore no check required.		* 2021-04-29 - discussed at task meeting that there need not be comments for Transfer Ready DtTm, and therefore no check required.
	* 2021-02-03 - implemented		* 2021-02-03 - implemented

Ttenbergen: Decided at Task meeting that we will not need comments and therefore don't need to check for them.

2021-04-29T18:45:55Z

Decided at Task meeting that we will not need comments and therefore don't need to check for them.

← Older revision		Revision as of 13:45, 29 April 2021
Line 5:		Line 5:
	\|DIC_coding=query check_has_transfer_ready_date_or_checkbox		\|DIC_coding=query check_has_transfer_ready_date_or_checkbox
	\|DIC_implementation_date=2021-02-03		\|DIC_implementation_date=2021-02-03
	\|DIC_status=~~needs review~~		\|DIC_status=implemented
	\|DIC_app=CCMDB.accdb		\|DIC_app=CCMDB.accdb
	\|DIC_backlogged=No		\|DIC_backlogged=No
Line 15:		Line 15:
	** checkbox is checked and yet a date is present		** checkbox is checked and yet a date is present
	** checkbox is not checked, and no date is present		** checkbox is not checked, and no date is present
	** checkbox is checked and comment is not either "not ready" or "not available"
	** checkbox is not checked but there is a comment

	~~{{TT \|~~
	*Currently only implemented without the comment cross checks because almost all collectors are not following the instructions.
	*I had a hunch that at least some collectors aren't entering the comment field as instructed and wanted to know how common a problem this cross check would find, so I tweaked it to run in CFE and checked (SQL at bottom). There were over 1000. People seem to be using the field to indicate which TRDT is for which [[Boarding Loc]]. Which is reasonable, because hard to keep track of otherwise, but it means I can't do that check for now.
	*'''Do we want to change the instructions to match what people are doing? Or change the cross check? '''
	*** No comment needed, update [[User:Ttenbergen\|Ttenbergen]] 11:52, 2021 April 29 (CDT)
	}}

	{{Collapsable		{{Collapsable
Line 40:		Line 32:
	FROM ((SELECT L_TmpV2.Pat_ID, Min([date_var]+[time_var]) AS dttm FROM L_TmpV2 WHERE (((L_TmpV2.Project)="Boarding Loc")) GROUP BY L_TmpV2.Pat_ID) AS First_Boarding_Loc RIGHT JOIN L_Log ON First_Boarding_Loc.Pat_ID = L_Log.Pat_ID) INNER JOIN (SELECT L_TmpV2.Pat_ID, [time_var]+[date_var] AS dttm, L_TmpV2.bool_var AS Legit_No_TRDT, comment_var FROM L_TmpV2 WHERE (((L_TmpV2.Project)="Transfer Ready DtTm"))) AS L_TmpV2_Transfer_Ready_DtTm ON L_Log.Pat_ID = L_TmpV2_Transfer_Ready_DtTm.Pat_ID		FROM ((SELECT L_TmpV2.Pat_ID, Min([date_var]+[time_var]) AS dttm FROM L_TmpV2 WHERE (((L_TmpV2.Project)="Boarding Loc")) GROUP BY L_TmpV2.Pat_ID) AS First_Boarding_Loc RIGHT JOIN L_Log ON First_Boarding_Loc.Pat_ID = L_Log.Pat_ID) INNER JOIN (SELECT L_TmpV2.Pat_ID, [time_var]+[date_var] AS dttm, L_TmpV2.bool_var AS Legit_No_TRDT, comment_var FROM L_TmpV2 WHERE (((L_TmpV2.Project)="Transfer Ready DtTm"))) AS L_TmpV2_Transfer_Ready_DtTm ON L_Log.Pat_ID = L_TmpV2_Transfer_Ready_DtTm.Pat_ID
	WHERE (((Not (Nz([L_TmpV2_Transfer_Ready_DtTm].[dttm],0)>0) And Not [legit_no_trdt])=True) AND ((L_Log.RecordStatus)="Complete") AND ((Nz([L_TmpV2_Transfer_Ready_DtTm].[dttm],Nz([first_boarding_loc].[dttm],#10/15/2020#))>=#10/15/2020#)=True)) OR ((((([L_TmpV2_Transfer_Ready_DtTm].[dttm]>0)) And [legit_no_trdt])=True) AND ((L_Log.RecordStatus)="Complete") AND ((Nz([L_TmpV2_Transfer_Ready_DtTm].[dttm],Nz([first_boarding_loc].[dttm],#10/15/2020#))>=#10/15/2020#)=True)) OR ((([Legit_No_TRDT] And Nz([comment_var])="")=True) AND ((L_Log.RecordStatus)="Complete") AND ((Nz([L_TmpV2_Transfer_Ready_DtTm].[dttm],Nz([first_boarding_loc].[dttm],#10/15/2020#))>=#10/15/2020#)=True)) OR (((Not [Legit_No_TRDT] And Nz([comment_var])>"")=True) AND ((L_Log.RecordStatus)="Complete") AND ((Nz([L_TmpV2_Transfer_Ready_DtTm].[dttm],Nz([first_boarding_loc].[dttm],#10/15/2020#))>=#10/15/2020#)=True));}}		WHERE (((Not (Nz([L_TmpV2_Transfer_Ready_DtTm].[dttm],0)>0) And Not [legit_no_trdt])=True) AND ((L_Log.RecordStatus)="Complete") AND ((Nz([L_TmpV2_Transfer_Ready_DtTm].[dttm],Nz([first_boarding_loc].[dttm],#10/15/2020#))>=#10/15/2020#)=True)) OR ((((([L_TmpV2_Transfer_Ready_DtTm].[dttm]>0)) And [legit_no_trdt])=True) AND ((L_Log.RecordStatus)="Complete") AND ((Nz([L_TmpV2_Transfer_Ready_DtTm].[dttm],Nz([first_boarding_loc].[dttm],#10/15/2020#))>=#10/15/2020#)=True)) OR ((([Legit_No_TRDT] And Nz([comment_var])="")=True) AND ((L_Log.RecordStatus)="Complete") AND ((Nz([L_TmpV2_Transfer_Ready_DtTm].[dttm],Nz([first_boarding_loc].[dttm],#10/15/2020#))>=#10/15/2020#)=True)) OR (((Not [Legit_No_TRDT] And Nz([comment_var])>"")=True) AND ((L_Log.RecordStatus)="Complete") AND ((Nz([L_TmpV2_Transfer_Ready_DtTm].[dttm],Nz([first_boarding_loc].[dttm],#10/15/2020#))>=#10/15/2020#)=True));}}


	== Log ==		== Log ==
			* 2021-04-29 - discussed at task meeting that there need not be comments for Transfer Ready DtTm, and therefore no check required.
	* 2021-02-03 - implemented		* 2021-02-03 - implemented

Ttenbergen at 16:52, 29 April 2021

2021-04-29T16:52:38Z

← Older revision		Revision as of 11:52, 29 April 2021
Line 18:		Line 18:
	** checkbox is not checked but there is a comment		** checkbox is not checked but there is a comment

	{{~~DiscussTask~~ \|		{{TT \|
	*Currently only implemented without the comment cross checks because almost all collectors are not following the instructions.		*Currently only implemented without the comment cross checks because almost all collectors are not following the instructions.
	*I had a hunch that at least some collectors aren't entering the comment field as instructed and wanted to know how common a problem this cross check would find, so I tweaked it to run in CFE and checked (SQL at bottom). There were over 1000. People seem to be using the field to indicate which TRDT is for which [[Boarding Loc]]. Which is reasonable, because hard to keep track of otherwise, but it means I can't do that check for now.		*I had a hunch that at least some collectors aren't entering the comment field as instructed and wanted to know how common a problem this cross check would find, so I tweaked it to run in CFE and checked (SQL at bottom). There were over 1000. People seem to be using the field to indicate which TRDT is for which [[Boarding Loc]]. Which is reasonable, because hard to keep track of otherwise, but it means I can't do that check for now.
	*'''Do we want to change the instructions to match what people are doing? Or change the cross check? '''		*'''Do we want to change the instructions to match what people are doing? Or change the cross check? '''
			*** No comment needed, update [[User:Ttenbergen\|Ttenbergen]] 11:52, 2021 April 29 (CDT)
	}}		}}

Ttenbergen at 15:57, 1 April 2021

2021-04-01T15:57:17Z

← Older revision		Revision as of 10:57, 1 April 2021
Line 5:		Line 5:
	\|DIC_coding=query check_has_transfer_ready_date_or_checkbox		\|DIC_coding=query check_has_transfer_ready_date_or_checkbox
	\|DIC_implementation_date=2021-02-03		\|DIC_implementation_date=2021-02-03
	\|DIC_status=~~ready to implement~~		\|DIC_status=needs review
	\|DIC_app=CCMDB.accdb		\|DIC_app=CCMDB.accdb
	\|DIC_backlogged=No		\|DIC_backlogged=No

Ttenbergen: moving to task

2021-02-11T21:58:39Z

moving to task

← Older revision		Revision as of 16:58, 11 February 2021
Line 18:		Line 18:
	** checkbox is not checked but there is a comment		** checkbox is not checked but there is a comment

	{{~~Discuss~~ \|		{{DiscussTask \|
	*Currently only implemented without the comment cross checks because almost all collectors are not following the instructions.		*Currently only implemented without the comment cross checks because almost all collectors are not following the instructions.
	*I had a hunch that at least some collectors aren't entering the comment field as instructed and wanted to know how common a problem this cross check would find, so I tweaked it to run in CFE and checked (SQL at bottom). There were over 1000. People seem to be using the field to indicate which TRDT is for which [[Boarding Loc]]. Which is reasonable, because hard to keep track of otherwise, but it means I can't do that check for now.		*I had a hunch that at least some collectors aren't entering the comment field as instructed and wanted to know how common a problem this cross check would find, so I tweaked it to run in CFE and checked (SQL at bottom). There were over 1000. People seem to be using the field to indicate which TRDT is for which [[Boarding Loc]]. Which is reasonable, because hard to keep track of otherwise, but it means I can't do that check for now.

Ttenbergen at 22:19, 4 February 2021

2021-02-04T22:19:03Z

@@ Line 17: / Line 17: @@
 ** checkbox is checked and comment is not either "not ready" or "not available"
 ** checkbox is not checked but there is a comment
 == Log ==

Ttenbergen at 22:03, 4 February 2021

2021-02-04T22:03:01Z

← Older revision		Revision as of 17:03, 4 February 2021
Line 10:		Line 10:
	}}		}}

	~~{{TT \|~~		The following will trigger an error:
	~~As per~~ [[Transfer Ready DtTm tmp entry]] ~~we can~~ and ~~should go further~~:		* [[RecordStatus]] Complete and either TransferReady dttm or first [[Boarding Loc]] is after 2020-10-15 (ie. [[Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry]])
	* ~~comment (under 'q'): '''only if TR~~ date not ~~available (ie if~~ checkbox checked~~), enter~~ either "not ready" or "not available" ~~into the~~ comment ~~field.}}~~		* and one of the following:
	.		** checkbox is checked and yet a date is present
			** checkbox is not checked, and no date is present
			** checkbox is checked and comment is not either "not ready" or "not available"
			** checkbox is not checked but there is a comment

	== Log ==		== Log ==
	* 2021-02-03 - implemented		* 2021-02-03 - implemented

Ttenbergen at 19:18, 4 February 2021

2021-02-04T19:18:01Z

← Older revision		Revision as of 14:18, 4 February 2021
Line 11:		Line 11:

	{{TT \|		{{TT \|
	As per [[]] we can and should go further:		As per [[Transfer Ready DtTm tmp entry]] we can and should go further:
	* comment (under 'q'): '''only if TR date not available (ie if checkbox checked), enter either "not ready" or "not available" into the comment field.}}		* comment (under 'q'): '''only if TR date not available (ie if checkbox checked), enter either "not ready" or "not available" into the comment field.}}
	.		.

Ttenbergen at 19:17, 4 February 2021

2021-02-04T19:17:41Z

← Older revision		Revision as of 14:17, 4 February 2021
Line 5:		Line 5:
	\|DIC_coding=query check_has_transfer_ready_date_or_checkbox		\|DIC_coding=query check_has_transfer_ready_date_or_checkbox
	\|DIC_implementation_date=2021-02-03		\|DIC_implementation_date=2021-02-03
	\|DIC_status=~~implemented~~		\|DIC_status=ready to implement
	\|DIC_app=CCMDB.accdb		\|DIC_app=CCMDB.accdb
	\|DIC_backlogged=No		\|DIC_backlogged=No
	}}		}}

			{{TT \|
			As per [[]] we can and should go further:
			* comment (under 'q'): '''only if TR date not available (ie if checkbox checked), enter either "not ready" or "not available" into the comment field.}}
	.		.
	== Log ==		== Log ==

Ttenbergen at 20:58, 3 February 2021

2021-02-03T20:58:32Z

← Older revision		Revision as of 15:58, 3 February 2021
Line 3:		Line 3:
	\|DIC_related_concepts=Transfer Ready DtTm tmp entry		\|DIC_related_concepts=Transfer Ready DtTm tmp entry
	\|DIC_timing=complete		\|DIC_timing=complete
	\|DIC_coding=query ~~check_has_transfer_ready_entry_or_checkbox~~		\|DIC_coding=query check_has_transfer_ready_date_or_checkbox
	\|DIC_implementation_date=2021-02-03		\|DIC_implementation_date=2021-02-03
	\|DIC_status=implemented		\|DIC_status=implemented
Line 10:		Line 10:
	}}		}}

			.
	== Log ==		== Log ==
	* 2021-02-03 - implemented		* 2021-02-03 - implemented