CCMDB.accdb Change Log 2022: Difference between revisions
Ttenbergen (talk | contribs) m Text replacement - "S Tmp" to "s_tmp table" |
Ttenbergen (talk | contribs) |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 97: | Line 97: | ||
Changes collectors probably don't care about (incl. bug fixes that should just make things work now): | Changes collectors probably don't care about (incl. bug fixes that should just make things work now): | ||
* changed trigger for [[query s_tmp_check_Boarding_Loc_and_TransferReadyDtTm_pairs]] from pre-sent checker to tmp box since it's not part of minimal data set | * changed trigger for [[query s_tmp_check_Boarding_Loc_and_TransferReadyDtTm_pairs]] from pre-sent checker to tmp box since it's not part of minimal data set | ||
* did a [[Recreate CCMDB.accdb]] to fix | * did a [[Recreate CCMDB.accdb]] to fix [[CCMDB.accdb requires password when closing]] on previous version | ||
=== 2022-10-06 === | === 2022-10-06 === | ||
| Line 193: | Line 193: | ||
** added tb_ClientGUID hidden element to [[Cognos2 Service Starter]] to contain field | ** added tb_ClientGUID hidden element to [[Cognos2 Service Starter]] to contain field | ||
** updated [[Cognos2_matcher query]] to include field | ** updated [[Cognos2_matcher query]] to include field | ||
* made [[HSC ALC Medicine Service]] entries available in [[S tmp table]] | * made [[HSC and GRA ALC Medicine Service]] entries available in [[S tmp table]] | ||
=== 2022-08-09 === | === 2022-08-09 === | ||
| Line 306: | Line 306: | ||
** SBGH Cardiac / Cardiology C Service | ** SBGH Cardiac / Cardiology C Service | ||
* changed [[query s_tmp_Boarding_Loc_date_item]] and [[query check_tmp_Boarding_Loc_Service_first_same]] to be checked when record is complete, not for incomplete records | * changed [[query s_tmp_Boarding_Loc_date_item]] and [[query check_tmp_Boarding_Loc_Service_first_same]] to be checked when record is complete, not for incomplete records | ||
* updated tmp cross | * updated tmp [[cross check]]s to change the [[Record field]] to "Problem" when they trigger; they previously would set the recordstatus to incomplete but leave record as whatever it was, possibly "C". | ||
=== 2022-05-19-1 === | === 2022-05-19-1 === | ||
| Line 427: | Line 427: | ||
'''<mark>Changes collectors need to know about:</mark>''' | '''<mark>Changes collectors need to know about:</mark>''' | ||
* added [[Selkirk Mental Health Centre]] to [[s_dispo table]] as dropdown similar to St Amant | * added [[Selkirk Mental Health Centre]] to [[s_dispo table]] as dropdown similar to [[St.Amant]] | ||
* removed the Accept and Arrive DtTm from the [[Patient Viewer Tab APACHE]] - the time is listed above, no to show it repeatedly. | * removed the Accept and Arrive DtTm from the [[Patient Viewer Tab APACHE]] - the time is listed above, no to show it repeatedly. | ||
| Line 588: | Line 588: | ||
Changes collectors probably don't care about (incl. bug fixes that should just make things work now): | Changes collectors probably don't care about (incl. bug fixes that should just make things work now): | ||
* updated all entries containing ALC ([[HSC ALC Medicine Service]]) in [[s_Cognos_Services table]] to only show on medicine laptops | * updated all entries containing ALC ([[HSC and GRA ALC Medicine Service]]) in [[s_Cognos_Services table]] to only show on medicine laptops | ||
* updated "SBGH Womens Health / General" in [[s_Cognos_Services table]] to be automatically excluded | * updated "SBGH Womens Health / General" in [[s_Cognos_Services table]] to be automatically excluded | ||
* updating [[Query check minimal data set incomplete]] to detect missing times | * updating [[Query check minimal data set incomplete]] to detect missing times | ||