DSM Labs data.accdb: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m →Log: moved here from readme.txt |
Ttenbergen (talk | contribs) m Text replacement - "S:\MED\CCMED" to "S:\MED\MED_CCMED" |
||
| (9 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
The file | The file | ||
:: '''DSM Labs data.accdb''' in ''' | :: '''DSM Labs data.accdb''' in '''{{S:\MED\MED_CCMED}}CCMDB\DSM Labs Imports\''' | ||
contains the s_ and L_ tables for DSM Data [[L_Labs_DSM table]]. | contains the s_ and L_ tables for DSM Data [[L_Labs_DSM table]]. | ||
| Line 8: | Line 8: | ||
== Log == | == Log == | ||
=== 2024-05-03 === | |||
* discussion to change the split to Jan 1, 2019 - but is that according to admit, lab dttm, or discharge? | |||
{{DJ | Emailed Julie: | |||
* found overlap in old file, what does it mean | |||
* proposed using labDtTm for split threshold | |||
[[User:Ttenbergen|Ttenbergen]] 16:51, 2024 May 2 (CDT) }} | |||
=== version 2023-08-27 === | |||
* Split of the file into ''DSM_Labs_data_pre_2023-08-27.accdb'' and DSM_Labs_data.accdb because the old one was generating error for further imports, likely too large [[User:Ttenbergen|Ttenbergen]] 21:52, 2023 August 27 (CDT) | |||
Oct 29,2020 - Julie went back to the batch files from 2019 to Oct2020 dumped data from Alun, replaced updated the D_IDs which had changes, compiled and imported the new DSM Data into the DSM_Labs_data.accdb | ===Nov 18, 2020=== | ||
- in the [[DSM_Labs_data.accdb]], Julie rename the current [[L_Labs_DSM table]] with L_Labs_DSM_old and also relabel the new_Labs_DSM with L_Labs_DSM. in this way, all the queries set up by Tina will still work. | |||
===Nov 18, 2020=== | |||
- Julie saved a copy of the pre Oct 1, 2020 of access containing the old DSM data and the Oct 29,2020 copy of new dsm lab data in the subfolder versions | |||
===Oct 29,2020=== | |||
- Julie went back to the batch files from 2019 to Oct2020 dumped data from Alun, replaced updated the D_IDs which had changes, compiled and imported the new DSM Data into the [[DSM_Labs_data.accdb]] | |||
and relabel it 2020-10-29_DSM_Labs_data.accdb | and relabel it 2020-10-29_DSM_Labs_data.accdb | ||
Oct 2020 - Julie found some duplicates and/or missing lab tests in the L_Labs_DSM due to changes in D_ID when sent to Alun and when | Oct 2020 - Julie found some duplicates and/or missing lab tests in the [[L_Labs_DSM table]] due to changes in D_ID when sent to Alun and when imported to ACCESS. | ||
=== version 2020-09-30 === | === version 2020-09-30 === | ||
| Line 32: | Line 45: | ||
* initial spinning out of data from [[DSM Labs Consistency check.accdb]]. | * initial spinning out of data from [[DSM Labs Consistency check.accdb]]. | ||
== Related articles == | |||
{{Related Articles}} | |||
[[Category:DSM Labs Extract]] | [[Category:DSM Labs Extract]] | ||
[[Category:Data_Repository]] | |||
Latest revision as of 00:12, 30 June 2025
The file
- DSM Labs data.accdb in S:\MED\Med_CCMED\S:\MED\Med_CCMED\CCMDB\DSM Labs Imports\
contains the s_ and L_ tables for DSM Data L_Labs_DSM table.
It uses DSM Labs Consistency check.accdb as a front end to request and to import data.
The statistician accesses it through SAS to analyze the data.
Log
2024-05-03
- discussion to change the split to Jan 1, 2019 - but is that according to admit, lab dttm, or discharge?
|
Emailed Julie:
Ttenbergen 16:51, 2024 May 2 (CDT) |
version 2023-08-27
- Split of the file into DSM_Labs_data_pre_2023-08-27.accdb and DSM_Labs_data.accdb because the old one was generating error for further imports, likely too large Ttenbergen 21:52, 2023 August 27 (CDT)
Nov 18, 2020
- in the DSM_Labs_data.accdb, Julie rename the current L_Labs_DSM table with L_Labs_DSM_old and also relabel the new_Labs_DSM with L_Labs_DSM. in this way, all the queries set up by Tina will still work.
Nov 18, 2020
- Julie saved a copy of the pre Oct 1, 2020 of access containing the old DSM data and the Oct 29,2020 copy of new dsm lab data in the subfolder versions
Oct 29,2020
- Julie went back to the batch files from 2019 to Oct2020 dumped data from Alun, replaced updated the D_IDs which had changes, compiled and imported the new DSM Data into the DSM_Labs_data.accdb and relabel it 2020-10-29_DSM_Labs_data.accdb
Oct 2020 - Julie found some duplicates and/or missing lab tests in the L_Labs_DSM table due to changes in D_ID when sent to Alun and when imported to ACCESS.
version 2020-09-30
- added RecordStatus field to 0_D_RawData table in to accommodate data added to requestor in last change. Ttenbergen 14:20, 2020 September 30 (CDT)
version 2020-08-13
- Added Record Status column to the requestor file. --PTorres 15:46, 2020 August 13 (CDT)
version 2018-04-09
- 2018-01-25 and 2017-10-26 data imported and uploaded to X Ttenbergen 17:17, 2018 April 9 (CDT)
version 2018-04-03
- updated table s_mapping_lab to see new fields as PTT as per email from Allan Garland to Tina Tenbergen 2018-02-28
version 2017-11-24
- initial spinning out of data from DSM Labs Consistency check.accdb.