;0;Transaction Facility Default
update mwtrn
set MWTRN."Facility" = MWCAS."Facility"
From MWCAS
Where
 mwtrn."Case Number" = mwcas."case number"
 and mwtrn."chart Number" = mwcas."chart number"
 and (mwcas."Facility" is not null and mwcas."Facility" <> '')
 and (MWTRN."Facility" is null or MWTRN."Facility" = '' or MWTRN."Facility" not in (select Code from mwadd where Type = 'Facility'))
;1;Transaction Attending Provider Default
update mwtrn
set "attending provider" = "assigned provider"
From MWCAS
Where
 mwtrn."Case Number" = mwcas."case number"
 and mwtrn."chart Number" = mwcas."chart number"
 and ("assigned provider" is not null and "assigned provider" <> '')
 and ("attending provider" is null or "attending provider" = '' or "attending provider" not in (select Code from mwphy))
;2;Transaction Type Default
update mwtrn
set "transaction type" = "type"
From MWPRO
Where
 mwtrn."Procedure Code" = mwpro."Code 1"
 and ("transaction type" is null or "transaction type" = '')
;3;Fix Appt/Repeat Length by 15
update ohapp set Length = Length - Mod(Length, 15) where  Mod(Length, 15) < 10;
update ohapp set Length = Length - Mod(Length, 15) where Mod(Length, 15) < 10 and Mod(Length, 15) > 0;
;4;Fix OHWAI Date Modified
update ohwai
set 
[Date Created] = CurDate(),
[Date Modified] = Current_TimeStamp()
;