CCMDB Wiki

Centralized data front end.accdb: Difference between revisions

← Older edit
m Text replacement - "Centralized data.accdb" to "Centralized_data.accdb"
 
(25 intermediate revisions by 3 users not shown)
Line 1: Line 1:
'' see [[Centralized data front end.mdb Change Log| change log]] and [[Centralized data front end.mdb Change Request|requested changes]] for this article separately.  
'' 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.  
Access front end to connect [[PHI.mdb]] to [[Centralized_data.accdb]] to help with data processing tasks.  


See [[Centralized data front end.mdb Change Log]] and [[Centralized data front end.mdb Change Request]] for development info.
== 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 ==
== Queries ==
Line 10: Line 13:
* associated component scores
* associated component scores
* ADL standard TOTAL
* ADL standard TOTAL
* [[:Category:MOST|MOST Score]]-version of ADL Total
* [[ALERT Scale]]-version of ADL Total


=== Charlson_Comorbid_Score ===
=== Charlson_Comorbid_Score ===
D_ID and [[Charlson Comorbid Score]] - ''' there are outstanding questions!'''
see [[query Charlson_Score_pre_and_ICD10]]


=== Created_Variables ===
=== Created_Variables ===
*Age in years - see details in [[Date of Birth]]
see [[Created Variables]]
*Length of Stay in days - see details in [[LOS]]
 
*[[Transfer Delay]] in days
=== L_Log_PHI ===
*APACHE - see details in [[APACHE Scoring table]]
Standard starting query that combines L_Log and L_[[:Category: PHI | PHI]]
**Total APACHE SCORE
 
**Mean Blood Pressure
=== L_Tasks ===
**Glasgow Coma Scale - ([[Glasgow Coma Scale]])
Pulls only the tasks out of L_Dxs
**Acute Physiological points
 
**Age points
=== Multiple_Encounter ===
**Chronic Health points
start of implementing [[Multiple Encounter]] '''work left!'''


=== Primary_admit ===
=== Primary_admit ===
Line 32: Line 35:
=== NDC_* queries ===
=== NDC_* queries ===
see [[Centralized data Vetting Process]]
see [[Centralized data Vetting Process]]
=== Count_of_admissions===
 
see [[Basic Analysis Capabilities]]
=== s_gcs_eye, s_gcs_motor, s_gcs_verbal ===
=== Summary_Discharges===
Limits s_gcs to only the options for one of the components.
see [[Basic Analysis Capabilities]]


== Modules and Functions ==
== Modules and Functions ==
Line 42: Line 44:


=== Module MOST_Score_Module ===
=== Module MOST_Score_Module ===
[[Category:MOST]]
[[Category:ALERT Scale]]
==== Function MOST_Score====
==== Function MOST_Score====
'''Work in progress, waiting for content in [[MOST Score Calculation]]'''
see [[ALERT Scale Calculation]]
 


== Related articles ==
{{Related Articles}}


[[category:2013 data upgrades]]
[[category:2013 data upgrades]]
[[Category:Centralized_data_front_end.accdb| *]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_data_front_end.accdb"