Centralized data front end.accdb: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) No edit summary |
Ttenbergen (talk | contribs) No edit summary |
||
Line 4: | Line 4: | ||
See [[Centralized data front end.mdb Change Log]] and [[Centralized data front end.mdb Change Request]] for development info. | 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 | |||
[[category:2013 data upgrades]] | [[category:2013 data upgrades]] |
Revision as of 22:55, 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