Centralized data front end.mdb Change Log 2014: Difference between revisions

Revision as of 12:36, 31 January 2014

see the Development Documentation Category for other development logs

Modified form: Patient List
- added drop-down to include all queries with the "NDC" prefix. When a query is selected, the [Patient List] form is filtered down to the results of the selected query using the [D_ID] field.
- added a button beside the drop-down to remove any filters in place.
- queries added with the "NDC" prefix must return the [D_ID] field. This is tested for prior to attempting to filter the data. If a selected/created query does not contain the [D_ID] field the user is prompted and given the opportunity to edit the query or return to the unfiltered form.

temporarily added 2 queries 1check_* to test with minimum moving parts whether SAS can not access built-in and/or user defined functions Ttenbergen 22:24, 2014 January 19 (CST)
temporarily made table created_variables_table to allow Julie to continue testing content while we work out why SAS can't see the created_variables query. Ttenbergen 22:24, 2014 January 19 (CST)

imported Trish's queries and pivots
- NDC* queries, see Centralized data Vetting Process for more info
- Count_of_admissions
- Summary_Discharges
TISS queries

adding query Created_Variables to implement Created Variables in TMSX or Med TMS Ttenbergen 15:42, 2014 January 2 (CST)
added function fiscal_year(date) Ttenbergen 20:40, 2014 January 15 (CST)
re-imported s_tables and apache scoring from newest version of ccmdb_program Ttenbergen 20:40, 2014 January 15 (CST)
added reconnect button to main form; clicking will ask for directory that contains centralized and phi and reconnect them Ttenbergen 20:40, 2014 January 15 (CST)
added "pseudo" button to patient viewer, above PHIN field; clicking will put next new PseudoPHIN into PHIN field. Ttenbergen 20:54, 2014 January 15 (CST)
added query ADL_scores
fixed query Primary_admit
added query Charlson_Comorbid_Score
- preliminary for now, have questions on that one, see Charlson Comorbid coding Ttenbergen 22:21, 2014 January 15 (CST)
added Module for MOST score, work in progress
- see MOST Score Calculation
- see Created Variables in TMSX or Med TMS

rolled out to X:\ on 2013-12-30

imported Viewer form and sub-forms from CCMDB.mdbTtenbergen 15:59, 2013 November 7 (CST)
commenting out checkers
changing the expected data structure
converted to 2002 format at least
did a compile on all the VB code
set PatientList to be the form that opens at startup Ttenbergen 22:26, 2013 November 18 (CST)
cleaned up viewer form, removed a few references that were not needed, recompiled Ttenbergen 11:39, 2013 November 19 (CST)
made SAS front end query for Labs Ttenbergen 12:45, 2013 November 19 (CST)
disabled all fields on the patient list, edits should happen in actual form - Ttenbergen 15:05, 2013 December 30 (CST)
removed input masks from dates in form view. Ttenbergen 15:11, 2013 December 30 (CST)
consolidated date formats in form view Ttenbergen 15:14, 2013 December 30 (CST)
added query SAS_L_Log:
- contains all fields from L_Log
- GCS
  - adds GCS plain-score fields AP_(eye/motor/verbal)_pts
  - adds GCS_sum field
- ADL
  - adds ADL plain-score fields ADL_(bathing/dressing/etc)_score
  - adds MOST-score fields ADL_(bathing/dressing/etc)_MOST Ttenbergen 16:17, 2013 December 30 (CST)
  - adds sums ADLs as ADL_Score_sum and ADL_MOST_sum Ttenbergen 16:17, 2013 December 30 (CST)
added query SAS_L_Dxs:
- contains L_Dxs where adm_acqu <> "Task"
- added fields DxCode for numerical code instead of resolved dx name, and DxCodeMainOnly for main-dx part of code Ttenbergen 16:38, 2013 December 30 (CST)
added query SAS_L_Tasks:
- contains L_Dxs where adm_acqu = "Task"

@@ Line 17: / Line 17: @@
 *Modified form:  Patient List
-** added drop-down to include all queries with the "NDC" prefix.  When a query is selected, the Patient List form is filtered down to the results of the selected query using the D_ID field.
+** added drop-down to include all queries with the "NDC" prefix.  When a query is selected, the [Patient List] form is filtered down to the results of the selected query using the [D_ID] field.
 ** added a button beside the drop-down to remove any filters in place.
-** queries added with the "NDC" prefix must return the D_ID field.  This is tested for prior to attempting to filter the data.  If a selected/created query does not contain the [D_ID] field the user is prompted and given the opportunity to edit the query or return to the unfiltered form.
+** queries added with the "NDC" prefix must return the [D_ID] field.  This is tested for prior to attempting to filter the data.  If a selected/created query does not contain the [D_ID] field the user is prompted and given the opportunity to edit the query or return to the unfiltered form.
 === 2014-01-19 ===