|
|
| (18 intermediate revisions by 2 users not shown) |
| Line 1: |
Line 1: |
| The export process for [[MCHP]] uses the file [[MCHP Export.mdb]] to generate a date-named file which is then sent to Manitoba Health, where it is de-identified before they send it on to MCHP.
| | This article functions as a portal for the people at [[MCHP]] who import data into their repositories from our [[Manitoba Centre for Health Policy export]]. We provide them a copy of the [[MCHP Export.accdb]] that has been processed as per [[Instructions for exporting data using MCHP Export.accdb]]. |
|
| |
|
| == checklist == | | == Data == |
| * how about the ALERT score (MOST), this was not given before but we can add now, what do you think?
| | Structure is same as [[CCMDB Data Structure]] except for the following. |
| * itiss?
| |
| * data dictionary
| |
|
| |
|
| == Instructions == | | === Splitting dual use L_Dxs === |
| === Preparations === | | For legacy reasons we store different kinds of data in [[L_Dxs table]]. For ease of use by MCHP we split the data into the following two tables and won't send the actual [[L_Dxs table]]. |
| Copy the following files all to one folder:
| | * [[L_DXs_MCHP table]] |
| * a [[centralized_data_front_end.mdb]] with up-to-date created_variables
| | * [[L_Tasks_MCHP table]] |
| * [[Centralized_data.mdb]]
| |
| * [[PHI.mdb]] | |
| * CCMDB.mdb
| |
| * [[Legacy TMS Data.mdb]] | |
| * TISS28_Data.mdb
| |
|
| |
|
| === generating the export file === | | === Splitting Multi-use L_TmpV2 === |
| * open
| | Our [[L_TmpV2 table]] contains data from a number of temporary [[Projects]] . We will only send a subset of this data, '''defined by which data has the MCHP field in the [[s_tmp table]] set to "true"''' . The filtered data will be in |
| * click the "Generate output" button
| | * [[L_TmpV2_MCHP table]] |
|
| |
|
| === sending ===
| | [[L_TmpV2 table]] itself will not be sent. |
| * copy [[MCHP Export.mdb]] to a memory stick or CD
| |
| * '''delete the modules and forms, they contain [[:Category:Password | Passwords]]'''
| |
| * send the memory stick or CD to Julene Reimer at Manitoba Health (address? {{discussion}}), email her the password; Manitoba Health with de-identify the data and pass it on to MCHP.
| |
|
| |
|
| == structure == | | == Related articles == |
| === Main ===
| | {{Related Articles}} |
| * contents of
| |
| ** L_Log
| |
| ** L_PHI (all of it, MB Health can decide what to strip/obfuscate)
| |
| ** Created_variables_CC and Created_variables_common, those which are not already in L_Log
| |
|
| |
|
| === Como ===
| |
| * contents of L_Como
| |
|
| |
|
| === Dxs ===
| | [[Category:MCHP]] |
| * admit and acquired diagnoses with priorities and primary designation.
| |
| | |
| === Labs ===
| |
| * separate table because only in CC and there is a lot there
| |
| * [[Query L Labs total]] which summarizes L_Labs_Flowsheet into one line per pt
| |
| * Labs from [[Legacy TMS Data.mdb]]
| |
| * some of the above were previously combined in which case we kept the value from L Labs total
| |
| | |
| === Pharmacy_new ===
| |
| * separate table because only in CC and there is a lot there
| |
| * [[Query L_Pharm_total]] which summarizes L_Pharm_Flowsheet into one line per pt
| |
| * pharm_* fields from [[L_Log]]
| |
| * Pharmacy from [[Legacy TMS Data.mdb]]
| |
| | |
| === Pharmacy_old ===
| |
| * separate table because only in CC and there is a lot there
| |
| * Pharmacy from [[Legacy TMS Data.mdb]]
| |
| * separate table because combined there were more than the 256 columns access can handle
| |
| | |
| === Tasks ===
| |
| Tasks (since it's only for Medicine)
| |
| | |
| === Tmp ===
| |
| A subset of [[:Category:All_Projects]]
| |
| * ERWait - Med only and it should be clearly specified as DATE_TIME LEFT ED to go to the WARD.
| |
| * ABO_TEE - STB CICU is using the MCHP and this data has been requested by CICU
| |
| ** ABO TEE blood type
| |
| ** ABO TEE function
| |
| ** ABO TEE LV fraction
| |
| ** A_T blood type
| |
| ** A_T function
| |
| ** A_T LV fraction
| |
| * VAP/CLI DATES - there are cases of more than one VAP Date (multi record)
| |
| ** QAInf
| |
| | |
| === TISS28 ===
| |
| * new TISS, one entry per item per day
| |
| | |
| === TISS76 ===
| |
| * from [[Legacy TMS Data.mdb]], own table since one line for all items per day
| |
| | |
| == Log ==
| |
| === 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]])
| |
| | |
| [[Category: MCHP]] | |
This article functions as a portal for the people at MCHP who import data into their repositories from our Manitoba Centre for Health Policy export. We provide them a copy of the MCHP Export.accdb that has been processed as per Instructions for exporting data using MCHP Export.accdb.
Data
Structure is same as CCMDB Data Structure except for the following.
Splitting dual use L_Dxs
For legacy reasons we store different kinds of data in L_Dxs table. For ease of use by MCHP we split the data into the following two tables and won't send the actual L_Dxs table.
Splitting Multi-use L_TmpV2
Our L_TmpV2 table contains data from a number of temporary Projects . We will only send a subset of this data, defined by which data has the MCHP field in the s_tmp table set to "true" . The filtered data will be in
L_TmpV2 table itself will not be sent.
Related articles