Centralized data front end.accdb: Difference between revisions

← Older edit

@@ 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.
-== Change Log ==
+Access front end to connect [[PHI.mdb]] to [[Centralized_data.accdb]] to help with data processing tasks.
-===2013-11-04===
-just on my desktop for now...Ttenbergen 17:12, 2013 November 4 (CST)
-* 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)
-* imported Viewer form and sub-forms from [[CCMDB.mdb]]Ttenbergen 15:59, 2013 November 7 (CST)
+== File locations ==
-* commenting out checkers
+*\\Hsc1msfp0001\med_ccmed\CCMDB\centralized_front_end
-* changing the expected data structure
+**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
-==== importing csvs ====
+=== Charlson_Comorbid_Score ===
-* '''problem importing csv files is with the date field... need to give it the right import specs'''Ttenbergen 17:34, 2013 November 4 (CST)
+see [[query Charlson_Score_pre_and_ICD10]]
-** brad will look into that one, in a different file.
+=== 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:Centralized_data_front_end.accdb| *]]