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.mdb 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