Centralized data front end.accdb: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (→Module MOST_Score_Module: No, not renaming this, could cause problem and no value in renaming it.) |
Ttenbergen (talk | contribs) m (→Queries: no more) |
||
Line 38: | Line 38: | ||
=== s_gcs_eye, s_gcs_motor, s_gcs_verbal === | === s_gcs_eye, s_gcs_motor, s_gcs_verbal === | ||
Limits s_gcs to only the options for one of the components. | Limits s_gcs to only the options for one of the components. | ||
== Modules and Functions == | == Modules and Functions == |
Revision as of 15:31, 2021 October 7
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.
Modules and Functions
Function Fiscal_Year
Fiscal_Year(date) will return the fiscal year that date is in.