CT Count of sent query: Difference between revisions

Revision as of 11:31, 2021 January 20

P_Count_SENTdata is a query in CFE.

Purpose : Summarizes when and how many records are sent by each site per week.

The query lists the last 30 days of SentDtTm for each laptop.

This query will primarily be useful for staffing monitoring (when and how often a staff sends)

@@ Line 2: / Line 2: @@
 *'''Purpose''' : Summarizes when and how many records are sent by each site per week.
-*coming from Complete & Incomplete in recordstatus field
-**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)
+The query lists the last 30 days of [[SentDtTm]] for each laptop.
+This query will primarily be useful for staffing monitoring (when and how often a staff sends)
+== Related articles ==
+{{Related Articles}}
 [[Category:CFE Data Integrity Checks]]
 [[Category:Centralized data front end.accdb]]