CT Count of sent query: Difference between revisions

Revision as of 11:20, 2021 August 26

CT Count of sent query is a query in CFE.

workload assessment: this query will primarily be useful for staffing monitoring (when and how often a staff sends)

The query lists counts for the last 28 days of SentDtTm for each laptop
Counts when and how many records are sent on each
Last date line with count per laptop tells how many profiles are currently still on that laptop, previous date lines tell how many profiles were completed (ie sent for the last time) that day

@@ Line 1: / Line 1: @@
-P_Count_SENTdata is a query in [[CFE]].
+{{PAGENAME}} is a query in [[CFE]].
-*'''Purpose''' : Summarizes when and how many records are sent by each site per week.
+=== Purpose ===
+* workload assessment: this query will primarily be useful for staffing monitoring (when and how often a staff sends)
-The query lists the last 30 days of [[SentDtTm]] for each laptop.
+=== Definition ===
+* The query lists counts for the last 28 days of [[SentDtTm]] for each laptop
-This query will primarily be useful for staffing monitoring (when and how often a staff sends)
+* Counts when and how many records are sent on each
+* Last date line with count per laptop tells how many profiles are currently still on that laptop, previous date lines tell how many profiles were completed (ie sent for the last time) that day
 == Related articles ==
 {{Related Articles}}
-[[Category:CFE Data Integrity Checks]]
 [[Category:Centralized data front end.accdb]]
-[[Category:P Query]]
+[[Category:Database Manager]]
+[[Category:CT Query]]