Centralized data front end.accdb: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 29: | Line 29: | ||
=== Charlson_Comorbid_Score === | === Charlson_Comorbid_Score === | ||
* [[Charlson Comorbid coding| Charlson Comorbid Score]] | * [[Charlson Comorbid coding| Charlson Comorbid Score]] | ||
== Modules and Functions == | |||
=== Function Fiscal_Year === | |||
Fiscal_Year(date) will return the fiscal year that date is in. | |||
=== Module MOST_Score_Module === | |||
[[Category:MOST]] | |||
==== Function MOST_Score==== | |||
'''Work in progress, waiting for content in [[MOST Score Calculation]]''' | |||
[[category:2013 data upgrades]] | [[category:2013 data upgrades]] | ||
Revision as of 23:38, 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
Charlson_Comorbid_Score
Modules and Functions
Function Fiscal_Year
Fiscal_Year(date) will return the fiscal year that date is in.
Module MOST_Score_Module
Function MOST_Score
Work in progress, waiting for content in MOST Score Calculation