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.mdb 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 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 ALERT Scale Calculation