Tasks 1.mdb: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
TOstryzniuk (talk | contribs)
Line 12: Line 12:
The [[Data Processor]] cleans up the table tasks (not tasks_master). (as per [[User:PTorres|PTorres]] 09:46, 2013 November 19 (CST))
The [[Data Processor]] cleans up the table tasks (not tasks_master). (as per [[User:PTorres|PTorres]] 09:46, 2013 November 19 (CST))


== Questions ==
== Data use==
{{Discussion}}
The [[Statistician]] includes this in the Annual and Quarterly Report for individual medicine ward
*Is this data used at all?[[User:Ttenbergen|Ttenbergen]] 19:02, 2012 September 6 (CDT) Ttenbergen 12:36, 2013 November 19 (CST)
*Which reports is it included with by the [[Statistician]]? [[User:Ttenbergen|Ttenbergen]] 09:34, 24 September 2009 (CDT) Ttenbergen 12:36, 2013 November 19 (CST)


== Legacy info ==
== Legacy info ==

Revision as of 14:52, 19 November 2013

TASKS.mdb is an Access database in the Output folder on the Regional Server which stores Task items collected by the Medicine Program.

Data Output Generation

The data in this file is generated by two queries in the CCMDB.mdb that take 5 lines of task data from L_Dxs and translate it into one line of data in Tasks.mdb.

Backup

  1. Outputbackup.bat - to data processor "C" drive.
  2. DataTwisterMDBtoSANS.bat - to share point on X drive (SANS).

Data Processing

The Data Processor cleans up the table tasks (not tasks_master). (as per PTorres 09:46, 2013 November 19 (CST))

Data use

The Statistician includes this in the Annual and Quarterly Report for individual medicine ward

Legacy info

Name change

File name changed from Tasks.mdb to tasks_1.mdb Sept 23 09 to fix a bug. Ttenbergen 09:33, 24 September 2009 (CDT)