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.
File locations
- \\Hsc1msfp0001\med_ccmed\CCMDB\centralized_front_end
- ie x:\\CCMDB\centralized_front_end
Queries
ADL_scores
- chosen ADL options
- associated component scores
- ADL standard TOTAL
- MOST Score-version of ADL Total
Charlson_Comorbid_Score
see Charlson Comorbid Score query
Created_Variables
L_Log_PHI
Standard starting query that combines L_Log and L_ PHI
L_Tasks
Pulls only the tasks out of L_Dxs
Multiple_Encounter
start of implementing Multiple Encounter work left!
Primary_admit
- Primary Admit Dx
NDC_* queries
see Centralized data Vetting Process
s_gcs_eye, s_gcs_motor, s_gcs_verbal
Limits s_gcs to only the options for one of the components.
TISS_Connect
Combines the TISS elements in linked tables work left! connect automations
TISS_DailyScore
Daily TISS score per patient work left! connect automations
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