Centralized data front end.accdb: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (Text replacement - "{{DT" to "{{TT")
Line 50: Line 50:


=== Module MOST_Score_Module ===
=== Module MOST_Score_Module ===
{{DT | Still has old name, need to update. Also, isn't really documented here yet }}
{{TT | Still has old name, need to update. Also, isn't really documented here yet }}
[[Category:ALERT Scale]]
[[Category:ALERT Scale]]
==== Function MOST_Score====
==== Function MOST_Score====

Revision as of 16:53, 2020 May 5

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

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

  • added: no added date
  • action: no action date
  • Cargo


  • Categories

Function MOST_Score

Work in progress, waiting for content in ALERT Scale Calculation

Related articles

Related articles: