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

• 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