Centralized data front end.accdb: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
No edit summary
m Text replacement - "Centralized data.accdb" to "Centralized_data.accdb"
 
(41 intermediate revisions by 3 users not shown)
Line 1: Line 1:
Access front end to connect to [[centralized_data.mdb]] to help with data processing tasks. As of 2013-08-12, this is in early development. Will need to work closely with main office to set this up to give best bang-for-buck to Pagasa.
'' 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.


==2013-11-04==
== File locations ==
* changing default s_ table linkage to newly-setup copy in \Programs\centralized_reference so there will not be any accidental changes to Master. Ttenbergen 13:00, 2013 November 4 (CST)
*\\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_[[:Category: PHI | 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 ===
[[Category:ALERT Scale]]
==== Function MOST_Score====
see [[ALERT Scale Calculation]]
 
== Related articles ==
{{Related Articles}}


[[category:2013 data upgrades]]
[[category:2013 data upgrades]]
[[Category:Centralized_data_front_end.accdb| *]]

Latest revision as of 14:51, 23 July 2025

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

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_data_front_end.accdb&oldid=165368"