CCMDB.mdb Change Log 2016: Difference between revisions

Line 9: Line 9:
== Versions ==
== Versions ==
'''Next round needs to confirm that ADLs and similar are entered before color generation for [[Overstay_Predictor_Project_Collection_Instructions]].'''
'''Next round needs to confirm that ADLs and similar are entered before color generation for [[Overstay_Predictor_Project_Collection_Instructions]].'''
==-2016-Nov-04===
Note Rolled out yet [[User:Haubel|Haubel]] 10:28, 2016 November 4 (CDT)
* Issue with check_minimal_data_set_incomplete query resulted from yesterday's change (Cleaning up old date checks project). 
** Locn_bad (column 5) changed from:
*** Locn_bad: IIf([dispo_dttm]<=#7/1/2016# And (IsNull([R_Location]) Or ([R_Location]="")),"Problem: empty","")
*** To: IIf([dispo_dttm]>now() And (IsNull([R_Location]) Or ([R_Location]="")),"Problem: empty","")
** admdate_bad (column 7) changed from:
*** admdate_bad: IIf([dispo_dttm]<=#7/1/2016# And (IsNull([r_admdate]) Or ([r_admdate]>Now())),"Problem: empty","")
*** To: admdate_bad: IIf([dispo_dttm]>now() And (IsNull([r_admdate]) Or ([r_admdate]>Now())),"Problem: empty","")


===2016-Nov-03===
===2016-Nov-03===