Tasks 1.mdb: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m u |
TOstryzniuk (talk | contribs) m →Legacy info: mnor |
||
| Line 21: | Line 21: | ||
== Legacy info == | == Legacy info == | ||
=== Name change === | === Name change === | ||
File name changed from Tasks.mdb to tasks_1.mdb | File name changed from Tasks.mdb to tasks_1.mdb September 23, 2009 to fix a bug. [[User:Ttenbergen|Ttenbergen]] 09:33, 24 September 2009 (CDT) | ||
[[Category: Task Elements | *]] | [[Category: Task Elements | *]] | ||
[[Category: Data Repository]] | [[Category: Data Repository]] | ||
Revision as of 18:31, 17 November 2014
TASKS.mdb used to contain the Task items , now stored in Centralized_data.mdb.
legacy only below here
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
- Task.mdb is backed up by a Batch File.
- Outputbackup.bat - to data processor "C" drive.
- DataTwisterMDBtoSANS.bat - to share point on X:\.
Data Processing
The Data Processor cleans up the table tasks_master (not tasks). (as per PTorres 09:46, 2013 November 19 (CST))
Data use
The Statistician includes this in the Quarterly report and the Annual report for individual medicine units in the Region.
Legacy info
Name change
File name changed from Tasks.mdb to tasks_1.mdb September 23, 2009 to fix a bug. Ttenbergen 09:33, 24 September 2009 (CDT)