Centralized data front end.mdb Change Log 2014

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-02-28

not rolled yet - Ttenbergen 10:28, 2014 February 28 (CST)

• fixed bug where missing phin would break match finder - Ttenbergen 11:02, 2014 February 28 (CST)
• changed patientlist back to separate firsname lastname fields, the reason they were combined is better accommodated by the filter tool Pagasa now uses. Also, this was causing problems in the match finder - Ttenbergen 11:02, 2014 February 28 (CST)
• fixed problem with edit button in tmp form not opening with the proper labels - Ttenbergen 11:16, 2014 February 28 (CST)
• eliminated re-connect at patient list open. Doesn't need to run by default now we have reconnect button - Ttenbergen 11:19, 2014 February 28 (CST)

2014-02-26

rolled to x: Ttenbergen 13:57, 2014 February 27 (CST)

• made version visible from MainPage - Ttenbergen 10:44, 2014 February 26 (CST)
• updated tmp form project and item dropdowns to allow all available in s_tmp. In CCMDB they were restricted to allowed - Ttenbergen
• deleted query "lmm_lfp" - Ttenbergen 20:29, 2014 February 26 (CST)
• added delete button to delete all related records both from phi and centralized; still need to include deleting from TISS... - Ttenbergen 20:29, 2014 February 26 (CST)
• included linking to external table s_AllDiagnoses in connector - Ttenbergen 13:41, 2014 February 27 (CST)

2014-02-24-2

was rolled on 2014-02-24

• added double-click to PHIN field, when double-clicked will filter list to all pt with that PHIN - Ttenbergen 20:49, 2014 February 24 (CST)
• removed error box in forms form_diags and form_comos - Ttenbergen 20:52, 2014 February 24 (CST)
• forms updated to generate d_diag_id for new recordsTtenbergen 22:17, 2014 February 24 (CST)
  • form_diags
  • form_comos
  • form_l_labs_flowsheet
  • form L_Pharm_flow
  • (currently no unique id field in tmp, so no action needed)

2014-02-24

put to x: - Ttenbergen 17:23, 2014 February 24 (CST)

• fixed location dropdown, it was still checking against settings - Ttenbergen 16:50, 2014 February 24 (CST)
• fixed var1-6 drop downs, were still checking against settings - Ttenbergen 16:59, 2014 February 24 (CST)
• got rid of error listing box in viewer that had been used in ccmdb.mdb - Ttenbergen 17:03, 2014 February 24 (CST)
• moved dx code to left in dx chooser, turns out it was already there but off the right off the screen due to Pagasa's small screen - Ttenbergen 17:08, 2014 February 24 (CST)
• in PatientList, combined firstname and lastname in one field so they will sort together - Ttenbergen 17:18, 2014 February 24 (CST)

2014-02-13

not rolled yet ( actually was rolled...)

• imported query s_como (the como only subset from s_alldiagnoses) from ccmdb.mdb to fix listing for comos. Ttenbergen 14:12, 2014 February 13 (CST)
• changed form PatientList to Pagasa's specs Ttenbergen 18:09, 2014 February 13 (CST)

2014-02-03

• added functionality to automate re-linking of files after copying
• changed .mdb to open to a new form mainpage to give option to relink or to open PatientList. Unlinked tables were making it impossible to open PatientList. Ttenbergen 10:27, 2014 February 3 (CST)
• added likely match finder button, form and code; button on patientlist form will open likely_match form that contains all records matching the current record on at least three of (first name, last name, phin, birth, chart); doesn't include sex or site in comparison so may bring up false-positives, which is OK, though, since it will still give a much shortened list to Pagasa to choose which PHIN to use. Ttenbergen 23:50, 2014 February 3 (CST)
• added test for appropriate number of decimal places to the Apache scoring code; this was instead of making the ranges gapless. Initially I thought that Julie's code had them gapless, but it doesn't, so I give up; testing for the appropriate number of decimal places should prevent errors. If #ofdps is too high, the function will return a -99 and give an error. Ttenbergen 14:28, 2014 February 5 (CST)
• fixed the match maker, didn't work with missing PHIN with is main use case
• changed the PatientList to Pagasa's preferences
  • removed the sort buttons because they did not work with new listings, and right-click does work
  • added/removed fields

2014-01-31

• added/updated the following queries:
  • NDC_Chart_9_Digit
  • NDC_DiffPhin_SameLN_FN_DOB
  • NDC_Highest_PseudoPHIN
  • NDC_PHIN_Fake_or_blank
  • NDC_SamePHIN_Diff_LN_FN_DOB
  • NDC_SamePHIN_Site_Diff_chart
  • Count_Of_Admissions
  • Summary_Discharges

• 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.

2014-01-19

• 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)

2014-01-16

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

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
  • 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

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"