CT Count of sent query: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
m Ttenbergen moved page P Count SENTdata to P Count of sent query without leaving a redirect: actual name of query
 
(5 intermediate revisions by the same user not shown)
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 ===
*coming from Complete & Incomplete in recordstatus field
* workload assessment: this query will primarily be useful for staffing monitoring (when and how often a staff sends)
**replaces weekly sent batch file & PDA sending
*Column:  Dbase (CC /Med) x HOSP_LOC x RecordStatus
*Row: yyyy/mmm x dd of '''SENT Date'''
*Data:  will be counts of complete and incompletes


This query will primarily be useful for staffing monitoring (when and how often a staff sends) as well as providing the overview of how the database is being populated over time. This will be a quick snapshot of history at one glance (from newest to oldest).  In addition, this will be useful in determining cut-off time when program glitches in certain site's sending  happen and determine which other sites after that site are affected by the error. The counts of records appended each time are bonus information instead of just placing binary  YES/NO. Whether combining or separating the complete and incomplete counts will be Pagasa's call. I strongly suggest to have this pivot table.[[User:JMojica|JMojica]] 10:41, 2014 February 11 (CST)
=== 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:CFE Data Integrity Checks]]
[[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:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=CT_Count_of_sent_query&oldid=151713"