Centralized data front end.accdb: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
Line 16: Line 16:


=== Created_Variables ===
=== Created_Variables ===
*Age in years - see details in [[Date of Birth]]
see [[Created Variables]]
*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 ===
=== 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

see 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