Manitoba Centre for Health Policy export: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (Instructions)
 
(31 intermediate revisions by 3 users not shown)
Line 1: Line 1:
Which DB, stored where...  
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]].


Draws from [[Legacy TMS Data.mdb]].
== Data ==
Structure is same as [[CCMDB Data Structure]] except for the following.  


== checklist ==
=== Splitting dual use L_Dxs ===
* The Created Variable (APACHE, APS Score,GCS, LOS, AGE, Delays, etc.)  should be given and added to L_LOG. 
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]].
** I have a note "old Apache medicine" - does this address that?
* [[L_DXs_MCHP table]]
* Need to add  the Comorbidity score
* [[L_Tasks_MCHP table]]
** do we need the combined score if I were to add individual scores in como table? Would be easy to do...
* how about the ALERT score (MOST), this was not given before but we can add now, what do you think?
* itiss?
* add "program" field from s_locations, or rather, use individual columns from there rather than using R_Location which has weird stuff like the H4H sharing...  
* Julie has started a data dictionary in
\\HSC1MSFP0001\MED_CCMED\CCMDB_Special_Projects\MCHP\2015\DataDictionary.xlsx
* X:\CCMDB_Special_Projects\MCHP\2015 is drive for this


=== 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_MCHP table]]


=== Instructions ===
[[L_TmpV2 table]] itself will not be sent.
* import data
** steps? {{discussion}}
* sending
** copy the data to a memory stick or CD
** '''delete the modules and forms, they contain passwords'''
** send the data 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 ==  
=== Table <what would be a good name for the main table> ===
{{Related Articles}}
* contents of
** L_Log
** L_PHI (I have a "Julie to talk to Angela" note in my notes, can't remember what about...)
** [[Query L Labs total‎]] which summarizes L_Labs_Flowsheet into one line per pt
** Labs from [[Legacy TMS Data.mdb]]
** [[Query L_Pharm_total]] which summarizes L_Pharm_Flowsheet into one line per pt
** Pharmacy from [[Legacy TMS Data.mdb]]
** created_variables
** Tasks (since it's really always all for Medicine)


=== Como ===
* contents of L_Como
=== Dxs ===
* contents of L_Dxs (except tasks)
* use [[Query L_Dxs_w_primary]]?
=== L_TISS ===
* from [[Legacy TMS Data.mdb]], own table since one per day
== Log ==
=== 2015-04-23 ===
do:
* make-table queries
=== 2015-04-20 ===
* re-conect for relevant files
* initial file (is a modified clone of [[Legacy_TMS_Data.mdb]])


[[Category: MCHP]]
[[Category: MCHP]]

Latest revision as of 10:28, 2020 April 17

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

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Manitoba_Centre_for_Health_Policy_export&oldid=143486"