Centralized data front end.accdb: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) No edit summary |
Ttenbergen (talk | contribs) |
||
| Line 10: | Line 10: | ||
* associated component scores | * associated component scores | ||
* ADL standard TOTAL | * ADL standard TOTAL | ||
* [[MOST Score]]-version of ADL Total | * [[:Category:MOST|MOST Score]]-version of ADL Total | ||
=== Created_Variables === | === Created_Variables === | ||
Revision as of 23:06, 15 January 2014
see change log and requested changes for this article separately.
Access front end to connect PHI.mdb to centralized_data.mdb to help with data processing tasks.
See Centralized data front end.mdb Change Log and Centralized data front end.mdb Change Request for development info.
Queries
ADL_scores
- chosen ADL options
- associated component scores
- ADL standard TOTAL
- MOST Score-version of ADL Total
Created_Variables
- Age in years - see details in Date of Birth
- Length of Stay in days - see details in LOS
- Transfer Delay in days
- APACHE - see details in APACHE Scoring table
- Total APACHE SCORE
- Mean Blood Pressure
- Glasgow Coma Scale - (Glasgow Coma Scale)
- Acute Physiological points
- Age points
- Chronic Health points
= Primary_admit
- Primary Admit Dx