Centralized data front end.accdb: Difference between revisions

← Older edit

@@ 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 ==
@@ Line 10: / Line 13: @@
 * associated component scores
 * ADL standard TOTAL
-* [[MOST Score]]-version of ADL Total
+* [[ALERT Scale]]-version of ADL Total
+=== Charlson_Comorbid_Score ===
+see [[query Charlson_Score_pre_and_ICD10]]
 === 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 ===
 * 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:Centralized_data_front_end.accdb| *]]