Centralized data front end.accdb: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
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

= Primary_admit

  • Primary Admit Dx