Centralized data front end.accdb

From CCMDB Wiki
(Redirected from CFE)
Jump to navigationJump to search

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 Charlson Comorbid Score query

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

Swiss Army Knife.svg Still has old name, need to update. Also, isn't really documented here yet

Function MOST_Score

Work in progress, waiting for content in ALERT Scale Calculation

Related articles

Related articles: