Centralized data front end.mdb Change Log 2014

From CCMDB Wiki
Jump to navigation Jump to search

see the Development Documentation Category for other development logs

This article is the change log for Centralized data front end.mdb. See Centralized data front end.mdb Change Request for requested changes.

Change Log

2014-01-16

2014-01-02

  • 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
  • added Module for MOST score, work in progress

2013-11-04

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"
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_data_front_end.mdb_Change_Log_2014&oldid=36582"