Manitoba Centre for Health Policy export: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m →checklist: m |
Ttenbergen (talk | contribs) m →Dxs: m |
||
| Line 28: | Line 28: | ||
=== Dxs === | === Dxs === | ||
* contents of L_Dxs (except tasks) | * contents of L_Dxs (except tasks) | ||
* use [[Query L_Dxs_w_primary]]? | |||
=== L_TISS === | === L_TISS === | ||
Revision as of 16:44, 16 April 2015
Which DB, stored where...
Draws from Legacy TMS Data.mdb.
checklist
- The Created Variable (APACHE, APS Score,GCS, LOS, AGE, Delays, etc.) should be given and added to L_LOG.
- I have a note "old Apache medicine" - does this address that?
- Need to add the Comorbidity score
- 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?
structure
Table <what would be a good name for the main table>
- 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