CT Count of sent query: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) Created page with "P_Count_SENTdata is a query in CFE. Category:CFE Data Integrity Checks Category:Centralized data front end.accdb" |
Ttenbergen (talk | contribs) |
||
| (8 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{PAGENAME}} is a query in [[CFE]]. | |||
=== Purpose === | |||
* workload assessment: this query will primarily be useful for staffing monitoring (when and how often a staff sends) | |||
=== Definition === | |||
* The query lists counts for the last 28 days of [[SentDtTm]] for each laptop | |||
* Counts when and how many records are sent on each day | |||
* First 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:Centralized data front end.accdb]] | [[Category:Centralized data front end.accdb]] | ||
[[Category:Database Manager]] | |||
[[Category:CT Query]] | |||
Latest revision as of 11:27, 26 August 2021
CT Count of sent query is a query in CFE.
Purpose
- workload assessment: this query will primarily be useful for staffing monitoring (when and how often a staff sends)
Definition
- The query lists counts for the last 28 days of SentDtTm for each laptop
- Counts when and how many records are sent on each day
- First 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: |