CT Count of sent query

From CCMDB Wiki
Revision as of 15:07, 2018 February 7 by Ttenbergen (talk | contribs)
Jump to navigation Jump to search

P_Count_SENTdata is a query in CFE.

  • 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.JMojica 10:41, 2014 February 11 (CST)

Retrieved from "https://ccmdb.kuality.ca/index.php?title=CT_Count_of_sent_query&oldid=104790"