Centralized data front end.accdb
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
NDC_* queries
see Centralized data Vetting Process
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