Centralized data front end.accdb: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m →Queries: no more |
Ttenbergen (talk | contribs) m Text replacement - "Centralized data.accdb" to "Centralized_data.accdb" |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
'' see [[Centralized data front end.accdb Change Log]] and [[Centralized data front end.accdb Change Request]] for development info. | '' 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 [[ | Access front end to connect [[PHI.mdb]] to [[Centralized_data.accdb]] to help with data processing tasks. | ||
== File locations == | == File locations == | ||
| Line 16: | Line 16: | ||
=== Charlson_Comorbid_Score === | === Charlson_Comorbid_Score === | ||
see [[ | see [[query Charlson_Score_pre_and_ICD10]] | ||
=== Created_Variables === | === Created_Variables === | ||
Latest revision as of 14:51, 23 July 2025
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.