Centralized data front end.accdb Change Request: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) No edit summary |
Ttenbergen (talk | contribs) |
||
| Line 4: | Line 4: | ||
== Requested Changes == | == Requested Changes == | ||
=== SAS front end for labs === | |||
make query for SAS to give names of labs with legacy numbers. See [[S_AllLabsTable]] | |||
=== s_table reconciliation === | === s_table reconciliation === | ||
Front end needs access to most s_table data. I set up a copy process to the regeional server, but Brad rightly pointed out that this would be better off right in the program. Need to import s_tables into front_end, update update-process to include this as part of the deal. | Front end needs access to most s_table data. I set up a copy process to the regeional server, but Brad rightly pointed out that this would be better off right in the program. Need to import s_tables into front_end, update update-process to include this as part of the deal. | ||
Revision as of 15:39, 18 November 2013
see the Development Documentation Category for other development logs
This article contains requested changes for Centralized data front end.mdb. See Centralized data front end.mdb Change Log for it's change log.
Requested Changes
SAS front end for labs
make query for SAS to give names of labs with legacy numbers. See S_AllLabsTable
s_table reconciliation
Front end needs access to most s_table data. I set up a copy process to the regeional server, but Brad rightly pointed out that this would be better off right in the program. Need to import s_tables into front_end, update update-process to include this as part of the deal.
Sending SendDtTm
- Centralized_data.mdb - Fix SendDtTm. Patient that are entered onto laptop AND completed BETWEEN sending dates each week, are missing SendDtTm stamp. Details as per email sent today. Trish Ostryzniuk 17:51, 2013 October 21 (CDT)
- Still not working as per Pagasa to Tina Nov 8.13
- Centralized_data.mdb_Change_Log#time_sent_and_time_completed
Error Checking Queries required
we should probably revisit Category:Cleaner.mdb Data Integrity Checks in this context.
Duplicate entry caused by changed location
- generate request to notify Pagasa if location changed after first send (generates duplicate entries) Ttenbergen 16:23, 2013 September 11 (CDT)
importing csvs
- problem importing csv files is with the date field... need to give it the right import specsTtenbergen 17:34, 2013 November 4 (CST)
- Brad will look into that one, in a different file.