Centralized data front end.accdb: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 14: | Line 14: | ||
=== Charlson_Comorbid_Score === | === Charlson_Comorbid_Score === | ||
D_ID and [[Charlson Comorbid coding]] score - ''' there are outstanding questions!''' | D_ID and [[Charlson Comorbid coding]] score - ''' there are outstanding questions!''' | ||
=== Count_of_admissions=== | |||
see [[Basic Analysis Capabilities]] | |||
=== Created_Variables === | === Created_Variables === | ||
| Line 26: | Line 29: | ||
**Age points | **Age points | ||
**Chronic Health points | **Chronic Health points | ||
=== 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 === | ||
| Line 32: | Line 44: | ||
=== NDC_* queries === | === NDC_* queries === | ||
see [[Centralized data Vetting Process]] | 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. | |||
=== Summary_Discharges=== | === Summary_Discharges=== | ||
see [[Basic Analysis Capabilities]] | see [[Basic Analysis Capabilities]] | ||
=== 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 == | == Modules and Functions == | ||
Revision as of 15:28, 16 January 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!
Count_of_admissions
see Basic Analysis Capabilities
Created_Variables
- Age in years - see details in Date of Birth
- Length of Stay in days - see details in LOS
- Transfer Delay in days
- APACHE - see details in APACHE Scoring table
- Total APACHE SCORE
- Mean Blood Pressure
- Glasgow Coma Scale - (Glasgow Coma Scale)
- Acute Physiological points
- Age points
- Chronic Health points
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.
Summary_Discharges
see Basic Analysis Capabilities
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