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

m Text replacement - "[[Category: " to "[[Category:"
 
(29 intermediate revisions by 2 users not shown)
Line 10: Line 10:
* created table ''Created_Variables_CC'' combining the Apache elements and other CC only fields Ttenbergen 14:35, 2014 December 18 (CST)
* created table ''Created_Variables_CC'' combining the Apache elements and other CC only fields Ttenbergen 14:35, 2014 December 18 (CST)
** created query ''Created_Variables_CC_maker'' to populate above
** created query ''Created_Variables_CC_maker'' to populate above
* updated "calc creted variables" button to use those two new tables Ttenbergen 14:36, 2014 December 18 (CST)
* updated [[Calc created variables button]] to use those two new tables Ttenbergen 14:36, 2014 December 18 (CST)
* updated query ''link_suspect_negative_transit_time'' to always ignore old known errors: Not "GRA_N5-4786" And Not "GRA_N3-7555" And Not "CON_MICU-2008" And Not "CON_MICU-2185" And Not "HSC_CCU-29239" And Not "GRA_MICU-3291" And Not "GRA_MICU-3418" Ttenbergen 15:07, 2014 December 18 (CST)
* updated query ''link_suspect_negative_transit_time'' to always ignore old known errors: Not "GRA_N5-4786" And Not "GRA_N3-7555" And Not "CON_MICU-2008" And Not "CON_MICU-2185" And Not "HSC_CCU-29239" And Not "GRA_MICU-3291" And Not "GRA_MICU-3418" Ttenbergen 15:07, 2014 December 18 (CST)
* made query link_suspect_from_partner_no_match to replace ls_med_from... Ttenbergen 16:52, 2014 December 18 (CST)
* made query link_suspect_from_partner_no_match to replace ls_med_from... Ttenbergen 16:52, 2014 December 18 (CST)
Line 27: Line 27:
* fixed double-click for notes field so it will now open the notes form Ttenbergen 14:58, 2014 December 10 (CST)
* fixed double-click for notes field so it will now open the notes form Ttenbergen 14:58, 2014 December 10 (CST)
* changed the copy-to-clipboard and start-email buttons to only set to questioned if the patient is not incomplete. Ttenbergen 15:12, 2014 December 10 (CST)
* changed the copy-to-clipboard and start-email buttons to only set to questioned if the patient is not incomplete. Ttenbergen 15:12, 2014 December 10 (CST)
* commented out "References.AddFromFile ("C:\Centralized_CCMDB\CCMDB.mdb")" which wasn't doing what it was supposed to anyway. Ttenbergen 15:35, 2014 December 10 (CST)
* commented out "References.AddFromFile ("C:\Centralized_CCMDB\CCMDB.accdb")" which wasn't doing what it was supposed to anyway. Ttenbergen 15:35, 2014 December 10 (CST)
* troubleshooting DB password that suddenly started to come up:  
* troubleshooting DB password that suddenly started to come up:  
** made sure all set =s had corresponding set = nothing
** made sure all set =s had corresponding set = nothing
Line 38: Line 38:
* removed query ''NDC_Highest_PseudoPHIN'' Ttenbergen 12:07, 2014 December 8 (CST)
* removed query ''NDC_Highest_PseudoPHIN'' Ttenbergen 12:07, 2014 December 8 (CST)
* renamed some NDC_ queries to PL_
* renamed some NDC_ queries to PL_
** NDC_orphans --> [[PL_1orphans]]
** NDC_orphans --> [[Reconnect_check_orphans query ]]
** NDC_Phin Fake or Blank --> PL_2Phin Fake or Blank
** NDC_Phin Fake or Blank --> PL_2Phin Fake or Blank
** NDC_Diff_Phin_SameLN_FN_DOB --> PL_Diff_Phin_SameLN_FN_DOB
** NDC_Diff_Phin_SameLN_FN_DOB --> PL_DiffPhin_SameLN_FN_DOB
** NDC_SameChart_Site_Diff_Phin --> PL_SameChart_Site_Diff_Phin
** NDC_SameChart_Site_Diff_Phin --> PL_SameChart_Site_Diff_Phin
** NDC_SamePhin_Diff_LN_FN_DOB_Sex --> PL_SamePhin_Diff_LN_FN_DOB_Sex
** NDC_SamePhin_Diff_LN_FN_DOB_Sex --> PL_SamePhin_Diff_DOB_Sex
** NDC_SamePHIN_Site_Diff_chart --> PL_SamePHIN_Site_Diff_chart
** NDC_SamePHIN_Site_Diff_chart --> PL_SamePHIN_Site_Diff_chart
** NDC_Chart_9_Digit --> PL_Chart_9_Digit
** NDC_Chart_9_Digit --> PL_Chart_9_Digit
Line 71: Line 71:


=== 2014-11-17 ===
=== 2014-11-17 ===
copied to X:\ Ttenbergen 18:03, 2014 November 17 (CST)
copied to {{S:\MED\MED_CCMED}} Ttenbergen 18:03, 2014 November 17 (CST)
* updated query ''created_apache_details'' to draw GCS points from table rather than from function to speed it up. After adding medicine, it became way slower than the other created query. Ttenbergen 14:32, 2014 November 17 (CST)
* updated query ''created_apache_details'' to draw GCS points from table rather than from function to speed it up. After adding medicine, it became way slower than the other created query. Ttenbergen 14:32, 2014 November 17 (CST)


Line 95: Line 95:
** somehow this got messed up again Ttenbergen 13:23, 2014 October 22 (CDT)
** somehow this got messed up again Ttenbergen 13:23, 2014 October 22 (CDT)
* updated query ''NDC_PHIN _Fake_or_blank'' to include incompletes as per Pagasa's request Ttenbergen 15:21, 2014 October 22 (CDT)
* updated query ''NDC_PHIN _Fake_or_blank'' to include incompletes as per Pagasa's request Ttenbergen 15:21, 2014 October 22 (CDT)
* changed table s_provinces in ccmdb.mdb to change province abbreviation for Newfoundland and Labrador should to NL not NF
* changed table s_provinces in [[CCMDB.accdb]] to change province abbreviation for Newfoundland and Labrador should to NL not NF
* updated updating of linking pairs so it will give error and stop if there are any PHINs missing. Ttenbergen 16:57, 2014 October 22 (CDT)
* updated updating of linking pairs so it will give error and stop if there are any PHINs missing. Ttenbergen 16:57, 2014 October 22 (CDT)
* updated query 'NDC_Missing_TransferDate_wPivot'' as per email from Pagasa Ttenbergen 16:59, 2014 October 22 (CDT)
* updated query 'NDC_Missing_TransferDate_wPivot'' as per email from Pagasa Ttenbergen 16:59, 2014 October 22 (CDT)
Line 102: Line 102:
=== 2014-10-09 - 2 ===
=== 2014-10-09 - 2 ===
rolled out Ttenbergen 18:27, 2014 October 9 (CDT)
rolled out Ttenbergen 18:27, 2014 October 9 (CDT)
* moved S_Standard_emails into [[Centralized_data.mdb]] Ttenbergen 18:27, 2014 October 9 (CDT)
* moved S_Standard_emails into [[Centralized_data.accdb]] Ttenbergen 18:27, 2014 October 9 (CDT)
* updated function ''confirm_files_and_links'' to run against [[ccmdb.mdb]] for s_ tables Ttenbergen 18:27, 2014 October 9 (CDT)
* updated function ''confirm_files_and_links'' to run against [[CCMDB.accdb]] for s_ tables Ttenbergen 18:27, 2014 October 9 (CDT)
* updated reconnect button so it only gives the count if the L_Log, L_PHI and L_LogPHI are not the same. No sense having a gopher otherwise. Ttenbergen 18:27, 2014 October 9 (CDT)
* updated reconnect button so it only gives the count if the L_Log, L_PHI and L_LogPHI are not the same. No sense having a gopher otherwise. Ttenbergen 18:27, 2014 October 9 (CDT)


Line 142: Line 142:
* deleted ''1_use_only*'' queries, done with - Ttenbergen 14:44, 2014 August 14 (CDT)
* deleted ''1_use_only*'' queries, done with - Ttenbergen 14:44, 2014 August 14 (CDT)
* deleted query ''000_ARF-fix'' Ttenbergen 14:44, 2014 August 14 (CDT)
* deleted query ''000_ARF-fix'' Ttenbergen 14:44, 2014 August 14 (CDT)
* added query ''J_in-process_records'' for Julie; contains list of complete records that are not yet fully processed by Pagasa Ttenbergen 12:26, 2014 August 21 (CDT)
* added query [[Query J in-process records]] for Julie; contains list of complete records that are not yet fully processed by Pagasa Ttenbergen 12:26, 2014 August 21 (CDT)
* added query ''[[NDC_Discharged_incomplete]]'' at Pagasa/Julie's request Ttenbergen 20:01, 2014 August 25 (CDT)
* added query ''query NDC_discharged_incomplete'' at Pagasa/Julie's request Ttenbergen 20:01, 2014 August 25 (CDT)
* update for the mail helper:
* update for the mail helper:
** added table s_standard_emails to contain the pre-set wordings. Ttenbergen 20:37, 2014 August 25 (CDT)
** added table s_standard_emails to contain the pre-set wordings. Ttenbergen 20:37, 2014 August 25 (CDT)
** split out function pt_demo_getter() to use same for all emailing Ttenbergen 20:37, 2014 August 25 (CDT)
** split out function pt_demo_getter() to use same for all emailing Ttenbergen 20:37, 2014 August 25 (CDT)
** generated form ''standard_email_chooser Ttenbergen 20:37, 2014 August 25 (CDT)
** generated form ''standard_email_chooser Ttenbergen 20:37, 2014 August 25 (CDT)
* generated interface for Linking in Centralized data front end.accdb, queries and code had been there for some time; more to do.
* generated interface for Linking in [[Centralized data front end.accdb]], queries and code had been there for some time; more to do.


=== 2014-08-13 ===
=== 2014-08-13 ===
Line 178: Line 178:
* updated s_como to make left_join to charlsons; s_como is subset of s_alldxs that are comos, not just that are charlsons. Ttenbergen 16:13, 2014 July 21 (CDT)
* updated s_como to make left_join to charlsons; s_como is subset of s_alldxs that are comos, not just that are charlsons. Ttenbergen 16:13, 2014 July 21 (CDT)
* set up queries 1_use_only_fix_dx_casing, 1_use_only_med_apache_null_after_SAPS, 1_use_only_update_3000_transfer_dates_to_null; emailed Pagasa/Julie/Trish with use instructions Ttenbergen 17:26, 2014 July 21 (CDT)
* set up queries 1_use_only_fix_dx_casing, 1_use_only_med_apache_null_after_SAPS, 1_use_only_update_3000_transfer_dates_to_null; emailed Pagasa/Julie/Trish with use instructions Ttenbergen 17:26, 2014 July 21 (CDT)
* replaced s_charlson_dxs with version from ccmdb.mdb that includes which are allowed as admit/complications Ttenbergen 11:18, 2014 July 24 (CDT)
* replaced [[s_charlson_dxs table]] with version from [[CCMDB.accdb]] that includes which are allowed as admit/complications Ttenbergen 11:18, 2014 July 24 (CDT)
* Charlson comorbid scoring; added/updated queries Ttenbergen 12:18, 2014 July 24 (CDT)
* Charlson comorbid scoring; added/updated queries Ttenbergen 12:18, 2014 July 24 (CDT)
** Charlson_Comorbid_Score
** Charlson_Comorbid_Score
Line 197: Line 197:
* made viewer form's fields trans and discharge date formats consistent with other fields, ie dd-mmm-yyyy Ttenbergen 16:04, 2014 July 17 (CDT)
* made viewer form's fields trans and discharge date formats consistent with other fields, ie dd-mmm-yyyy Ttenbergen 16:04, 2014 July 17 (CDT)
* updated query s_como to include charlson score Ttenbergen 16:14, 2014 July 17 (CDT)
* updated query s_como to include charlson score Ttenbergen 16:14, 2014 July 17 (CDT)
* updated query s_charlson_dxs to loose allow_admit and allow_como columns, those are addressed in s_alldiagnoses Ttenbergen 16:14, 2014 July 17 (CDT)
* updated query [[s_charlson_dxs table]] to loose allow_admit and allow_como columns, those are addressed in s_alldiagnoses Ttenbergen 16:14, 2014 July 17 (CDT)
* updated query charlson_comorbid_score_detail to use s_como Ttenbergen 16:14, 2014 July 17 (CDT)
* updated query charlson_comorbid_score_detail to use s_como Ttenbergen 16:14, 2014 July 17 (CDT)
* updated query charlson_comorbid_score to use charlson_comorbid_score_detail Ttenbergen 16:14, 2014 July 17 (CDT)
* updated query charlson_comorbid_score to use charlson_comorbid_score_detail Ttenbergen 16:14, 2014 July 17 (CDT)
Line 228: Line 228:
copied to x: Ttenbergen 14:46, 2014 June 27 (CDT)
copied to x: Ttenbergen 14:46, 2014 June 27 (CDT)
* removed explicit edit restrictions from patient list because they were breaking the NDC dropdown Ttenbergen 14:05, 2014 June 27 (CDT)
* removed explicit edit restrictions from patient list because they were breaking the NDC dropdown Ttenbergen 14:05, 2014 June 27 (CDT)
* integrated "changed table ''s_charlson_dxs'' to not duplicate values that should come from s_alldiagnoses. " as in CCMDB [[CCMDB.mdb_Change_Log_2014#2014-Jun-23]] Ttenbergen 14:08, 2014 June 27 (CDT)
* integrated "changed table ''[[s_charlson_dxs table]]'' to not duplicate values that should come from s_alldiagnoses. " as in CCMDB [[CCMDB.mdb_Change_Log_2014#2014-Jun-23]] Ttenbergen 14:08, 2014 June 27 (CDT)


=== 2014-06-26-2 ===
=== 2014-06-26-2 ===
Line 282: Line 282:


=== (same version as before because I forgot to update) ===
=== (same version as before because I forgot to update) ===
copied to X:\ - Ttenbergen 15:49, 2014 June 9 (CDT)
copied to {{S:\MED\MED_CCMED}} - Ttenbergen 15:49, 2014 June 9 (CDT)
* fixed Function ApTotal_Physiological() to be able to output Nulls (changed data type) Ttenbergen 15:49, 2014 June 9 (CDT)
* fixed Function ApTotal_Physiological() to be able to output Nulls (changed data type) Ttenbergen 15:49, 2014 June 9 (CDT)


Line 289: Line 289:
* added ph to new variables details query
* added ph to new variables details query
* realized and messed with problem in 1run only saps clean up queryTtenbergen 16:30, 2014 May 29 (CDT)
* realized and messed with problem in 1run only saps clean up queryTtenbergen 16:30, 2014 May 29 (CDT)
* fixed query ''NDC_VAP_AcqDX_but_NoVAP_DateinTMPV2''; it had two D_ID columns which was confusing the form that opens it. Ttenbergen 10:43, 2014 June 2 (CDT)
* fixed query ''Query query NDC_VAP_AcqDX_but_NoVAP_DateinTMPV2''; it had two D_ID columns which was confusing the form that opens it. Ttenbergen 10:43, 2014 June 2 (CDT)
* updated queries ''NDC_orphans, NDC_CLI_AcqDX_but_NoCLI_DateinTMPV2, NDC_CLI_No_AcqDX_but_CLI_DateinTMPV2, NDC_CLI_unacceptable_date'' - Ttenbergen 16:04, 2014 June 2 (CDT)
* updated queries ''NDC_orphans, query NDC_CLI_AcqDX_but_NoCLI_DateinTMPV2, NDC_CLI_No_AcqDX_but_CLI_DateinTMPV2, NDC_CLI_unacceptable_date'' - Ttenbergen 16:04, 2014 June 2 (CDT)
* changed created_variables and apache scoring module to give null when no input or medicine. Ttenbergen 17:22, 2014 June 2 (CDT)
* changed created_variables and apache scoring module to give null when no input or medicine. Ttenbergen 17:22, 2014 June 2 (CDT)
* updated function ''ApScore_Creat'' to properly double Creat score if ARF. Ttenbergen 09:47, 2014 June 4 (CDT)
* updated function ''ApScore_Creat'' to properly double Creat score if ARF. Ttenbergen 09:47, 2014 June 4 (CDT)
Line 304: Line 304:
=== 2014-05-19 ===
=== 2014-05-19 ===
copied to x: Ttenbergen 19:27, 2014 May 28 (CDT)
copied to x: Ttenbergen 19:27, 2014 May 28 (CDT)
* query ''link_suspect_negative_transit_time'' to implement checks against [[Transfer time rule]]Ttenbergen 23:01, 2014 May 19 (CDT)
* query ''link_suspect_negative_transit_time'' to implement checks against '''Transfer time rule''' Ttenbergen 23:01, 2014 May 19 (CDT)
* query ''link_suspect_medicine_to_med_no_partner''
* query ''link_suspect_medicine_to_med_no_partner''
* query ''link_suspect_medicine_from_med_no_partner''
* query ''link_suspect_medicine_from_med_no_partner''
Line 310: Line 310:
* added to table '''s_admitDischarge''' column "hosp" and "ward", and indexed and populated Ttenbergen 22:39, 2014 May 20 (CDT)
* added to table '''s_admitDischarge''' column "hosp" and "ward", and indexed and populated Ttenbergen 22:39, 2014 May 20 (CDT)
* added indices to table ''s_locations'' - Ttenbergen 10:25, 2014 May 21 (CDT)
* added indices to table ''s_locations'' - Ttenbergen 10:25, 2014 May 21 (CDT)
* updated query NDC_Orphans to reflect [[Orphans_in_Centralized_data.mdb#ward.2Funits_with_more_than_one_collector]] Ttenbergen 22:35, 2014 May 26 (CDT)
* updated query NDC_Orphans to reflect [[Orphans_in_[[Centralized_data.accdb]]#ward.2Funits_with_more_than_one_collector]] Ttenbergen 22:35, 2014 May 26 (CDT)
* fixed function "transfer_time_maker"; it was failing when the transfer date is null. Ttenbergen 18:14, 2014 May 28 (CDT)
* fixed function "transfer_time_maker"; it was failing when the transfer date is null. Ttenbergen 18:14, 2014 May 28 (CDT)
* added fields to create_variables: Ttenbergen 18:14, 2014 May 28 (CDT)
* added fields to create_variables: Ttenbergen 18:14, 2014 May 28 (CDT)
Line 337: Line 337:
* added column "is_ICU" to [[S_AdmitDischarge]] Ttenbergen 13:57, 2014 May 12 (CDT)
* added column "is_ICU" to [[S_AdmitDischarge]] Ttenbergen 13:57, 2014 May 12 (CDT)
* working on NDC queries
* working on NDC queries
** [[VAP Dx vs Tmp checking]]
** VAP Dx vs Tmp checking
*** renamed related queries to start with NDC_VAP
*** renamed related queries to start with NDC_VAP
*** added query to check for tmp date > discharge date or < admit date + 1 (we discussed +2, but because we don't have a time for the VAP a +2 would have false positives)
*** added query to check for tmp date > discharge date or < admit date + 1 (we discussed +2, but because we don't have a time for the VAP a +2 would have false positives)
Line 354: Line 354:
===2014-05-05===
===2014-05-05===
copied to x:\ - Ttenbergen 10:20, 2014 May 5 (CDT)
copied to x:\ - Ttenbergen 10:20, 2014 May 5 (CDT)
* restored ap_physiological score function; had got lost when apache_scoring module was imported from CCMDB.mdb. Ttenbergen 10:14, 2014 May 5 (CDT)
* restored ap_physiological score function; had got lost when apache_scoring module was imported from CCMDB.accdb. Ttenbergen 10:14, 2014 May 5 (CDT)


===2014-05-01===
===2014-05-01===
copied to x: Ttenbergen 20:30, 2014 May 1 (CDT)
copied to x: Ttenbergen 20:30, 2014 May 1 (CDT)
* imported updated module Apache_Scoring from CCMDB.mdb. Ttenbergen 18:05, 2014 May 1 (CDT)
* imported updated module Apache_Scoring from CCMDB.accdb. Ttenbergen 18:05, 2014 May 1 (CDT)
* updated P_Outstanding_Admits to include a "has_discharge_date" field Ttenbergen 20:09, 2014 May 1 (CDT)
* updated P_Outstanding_Admits to include a "has_discharge_date" field Ttenbergen 20:09, 2014 May 1 (CDT)


Line 378: Line 378:
rolled to x: - Ttenbergen 16:13, 2014 March 21 (CDT)
rolled to x: - Ttenbergen 16:13, 2014 March 21 (CDT)
* to get control over the data type of fields in Created_Variables_Table
* to get control over the data type of fields in Created_Variables_Table
** added "calc created variables" button
** added [[Calc created variables button]]
*** empties table
*** empties table
*** runs query
*** runs query
Line 420: Line 420:
* updated Apache scoring module to  
* updated Apache scoring module to  
** re-introduce apache physiological function, chronic and ABG function which got lost somehow.
** re-introduce apache physiological function, chronic and ABG function which got lost somehow.
** update error message to only trigger when called from CCMDB.mdb (only WBC for now)
** update error message to only trigger when called from CCMDB.accdb (only WBC for now)
* added form TISS_Viewer, using query TISS_Connect, added tab to Patient Viewer form to view it
* added form TISS_Viewer, using query TISS_Connect, added tab to Patient Viewer form to view it


Line 464: Line 464:
* fixed location dropdown, it was still checking against settings - Ttenbergen 16:50, 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)
* 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)
* got rid of error listing box in viewer that had been used in [[CCMDB.accdb]] - 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)
* 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)
* in PatientList, combined firstname and lastname in one field so they will sort together - Ttenbergen 17:18, 2014 February 24 (CST)
Line 470: Line 470:
=== 2014-02-13 ===
=== 2014-02-13 ===
not rolled yet ( actually was rolled...)
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)
* imported query ''s_como'' (the como only subset from s_alldiagnoses) from [[CCMDB.accdb]] 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)
* changed form PatientList to Pagasa's specs Ttenbergen 18:09, 2014 February 13 (CST)


Line 521: Line 521:
** ''' preliminary for now, have questions on that one, see [[ Charlson Comorbid coding (pre ICD10)]] Ttenbergen 22:21, 2014 January 15 (CST)
** ''' preliminary for now, have questions on that one, see [[ Charlson Comorbid coding (pre ICD10)]] Ttenbergen 22:21, 2014 January 15 (CST)
* added Module for MOST score, '''work in progress'''
* added Module for MOST score, '''work in progress'''
** see [[MOST Score Calculation]]
** see [[ALERT Scale Calculation]]
** see [[Created Variables in TMSX or Med TMS]]
** see [[Created Variables in TMSX or Med TMS]]


===2013-11-04===
===2013-11-04===
rolled out to X:\ on 2013-12-30
rolled out to {{S:\MED\MED_CCMED}} on 2013-12-30
* imported Viewer form and sub-forms from [[CCMDB.mdb]]Ttenbergen 15:59, 2013 November 7 (CST)
* imported Viewer form and sub-forms from [[CCMDB.accdb]]Ttenbergen 15:59, 2013 November 7 (CST)
* commenting out checkers
* commenting out checkers
* changing the expected data structure
* changing the expected data structure
Line 544: Line 544:
** ADL
** ADL
*** adds ADL plain-score fields ADL_(bathing/dressing/etc)_score
*** 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 [[ALERT Scale]] 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)
*** adds sums ADLs as ADL_Score_sum and ADL_MOST_sum Ttenbergen 16:17, 2013 December 30 (CST)
* added query SAS_L_Dxs:  
* added query SAS_L_Dxs:  
Line 552: Line 552:
** contains L_Dxs where adm_acqu = "Task"
** contains L_Dxs where adm_acqu = "Task"


[[Category: Development Documentation]]
[[Category:Development Documentation]]
[[category:2013 data upgrades]]
[[category:2013 data upgrades]]
[[Category: Centralized data front end.accdb]]
[[Category:Centralized data front end.accdb]]