Centralized data front end.accdb: Difference between revisions
Ttenbergen (talk | contribs) No edit summary |
Ttenbergen (talk | contribs) |
||
Line 16: | Line 16: | ||
=== Created_Variables === | === Created_Variables === | ||
see [[Created Variables]] | |||
=== L_Log_PHI === | === L_Log_PHI === |
Revision as of 22:53, 26 May 2014
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.
Queries
ADL_scores
- chosen ADL options
- associated component scores
- ADL standard TOTAL
- MOST Score-version of ADL Total
Charlson_Comorbid_Score
D_ID and Charlson Comorbid coding score - there are outstanding questions!
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