MCHP Export.accdb: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| (13 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
The file MCHP Export.accdb contains and is used to generate data for [[Manitoba Centre for Health Policy export]]. See [[Instructions for exporting data using MCHP Export.accdb]] for info on how to use it. | The file MCHP Export.accdb contains and is used to generate data for [[Manitoba Centre for Health Policy export]]. See [[Instructions for exporting data using MCHP Export.accdb]] for info on how to use it. | ||
=== older data === | |||
Some of our data structures have changed over time, and integrating the old versions is complicated. So, the program currently can only accommodate exports of data from 2019-01-01 onward. | |||
== file location == | == file location == | ||
X:\CCMDB_Special_Projects\MCHP\Master | [[X:\]]CCMDB_Special_Projects\MCHP\Master | ||
== Password == | == Password == | ||
| Line 8: | Line 11: | ||
== Change log == | == Change log == | ||
=== 2023-07-26 === | |||
not rolled out yet [[User:Ttenbergen|Ttenbergen]] 14:48, 2023 July 26 (CDT) | |||
re-do: | |||
* remove L_Person and L_Hospitalization from Function CFE_array() | |||
* tweaked the lists of tables that are linked and unlinked. | |||
maybe not? | |||
* updated function CFE_array to include created_transferDelay | |||
* added code to include the tables in CFE in reconnection | |||
* added code to function Process_MCHP to (will spit out the transfer delay when done...) | |||
=== 2022-12-14 === | |||
copied to server; the import is likely ready, be we still have transfer ready and some APACHE scoring to figure out before we can send [[User:Ttenbergen|Ttenbergen]] 16:05, 2022 December 21 (CST) | |||
* updated to use new [[Created_AdmitDtTm query]] and [[Created_FirstService query]] as imported from CFE | |||
* imported runQuery to be able to query without disabling errors | |||
=== 2020-05-07 === | |||
* updating more queries to runSql commands so we can exclude records from the start rather than having to delete them after. | |||
=== 2020-04-29 === | |||
* updated the date ranging which was doing the opposite of what it should Ttenbergen 13:25, 2020 April 29 (CDT) | |||
=== 2020-04-18ish === | === 2020-04-18ish === | ||
* added CCI, ICD10, new Apache Scoring that uses them. Ttenbergen 23:00, 2020 April 19 (CDT) | * added CCI, ICD10, new Apache Scoring that uses them. Ttenbergen 23:00, 2020 April 19 (CDT) | ||
* empty file is now at 243MB, fully imported is 599MB Ttenbergen 23:29, 2020 April 19 (CDT) | |||
=== 2019-09-12 === | === 2019-09-12 === | ||
| Line 47: | Line 73: | ||
* initial file (is a modified clone of [[Legacy_TMS_Data.mdb]]) | * initial file (is a modified clone of [[Legacy_TMS_Data.mdb]]) | ||
</onlyinclude> | </onlyinclude> | ||
== Related articles == | |||
{{Related Articles}} | |||
[[Category: MCHP]] | [[Category: MCHP]] | ||
[[Category: Password]] | [[Category: Password]] | ||
[[Category:Data_Repository]] | |||
Latest revision as of 15:45, 2023 August 2
The file MCHP Export.accdb contains and is used to generate data for Manitoba Centre for Health Policy export. See Instructions for exporting data using MCHP Export.accdb for info on how to use it.
older data
Some of our data structures have changed over time, and integrating the old versions is complicated. So, the program currently can only accommodate exports of data from 2019-01-01 onward.
file location
X:\CCMDB_Special_Projects\MCHP\Master
Password
Located: M:\Passwords_mainoffice\
Change log
2023-07-26
not rolled out yet Ttenbergen 14:48, 2023 July 26 (CDT) re-do:
- remove L_Person and L_Hospitalization from Function CFE_array()
- tweaked the lists of tables that are linked and unlinked.
maybe not?
- updated function CFE_array to include created_transferDelay
- added code to include the tables in CFE in reconnection
- added code to function Process_MCHP to (will spit out the transfer delay when done...)
2022-12-14
copied to server; the import is likely ready, be we still have transfer ready and some APACHE scoring to figure out before we can send Ttenbergen 16:05, 2022 December 21 (CST)
- updated to use new Created_AdmitDtTm query and Created_FirstService query as imported from CFE
- imported runQuery to be able to query without disabling errors
2020-05-07
- updating more queries to runSql commands so we can exclude records from the start rather than having to delete them after.
2020-04-29
- updated the date ranging which was doing the opposite of what it should Ttenbergen 13:25, 2020 April 29 (CDT)
2020-04-18ish
- added CCI, ICD10, new Apache Scoring that uses them. Ttenbergen 23:00, 2020 April 19 (CDT)
- empty file is now at 243MB, fully imported is 599MB Ttenbergen 23:29, 2020 April 19 (CDT)
2019-09-12
Moved to master consolidated all mentions of Centralized data.mdb in function centralized_data in prep for Conversion of Centralized data.mdb to Centralized data.accdb.
2019-08-29
Moved to master
- added s_ tables
- confirmed that tasks table is present and populated
2019-08-26
Moved to master
- added date thresholds to export (ie include only data up to Dispo DtTm 2019-01-01)
- additional bug fixes
2019-08-14
Moved to Master
- had to re-write the export code because we didn't keep a version with it. emailed Julie to request review. Ttenbergen 16:58, 2019 August 14 (CDT)
2017-04-12
Starting review
- updated importer to work with current file structure
- added code to remove columns we are not sending, eg. Notes , *_complete, and others no longer used.
2015-04-27
- added "Comfort Care" to query "Create_Tmp" Ttenbergen 09:54, 2015 April 27 (CDT)
- removed several components from 1Main that don't need to be in there Ttenbergen 14:56, 2015 April 27 (CDT)
2015-04-23
copied to master directory
- code to generate export file when "generate output" is clicked
- make-table queries
2015-04-20
- re-conect for relevant files
- initial file (is a modified clone of Legacy_TMS_Data.mdb)