Centralized data front end.accdb
see Centralized data front end.accdb Change Log and Centralized data front end.accdb Change Request for development info.
Access front end to connect PHI.mdb to Centralized_data.accdb to help with data processing tasks.
File locations
- \\Hsc1msfp0001\med_ccmed\CCMDB\centralized_front_end
- ie x:\\CCMDB\centralized_front_end
See also Setting up Centralized data on a new PC
Queries
ADL_scores
- chosen ADL options
- associated component scores
- ADL standard TOTAL
- ALERT Scale-version of ADL Total
Charlson_Comorbid_Score
see query Charlson_Score_pre_and_ICD10
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.
Modules and Functions
Function Fiscal_Year
Fiscal_Year(date) will return the fiscal year that date is in.