Centralized data front end.accdb

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

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.

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

see ALERT Scale Calculation