1. Examinee scheduling instructions are sent by AutomatedScheduling hosted service based on passing of date on examination (scheduling instructions AKA legacy Admission Slip).
2. When scheduling instructions get emailed, a column on examinee/otherboardexaminee updates from 0 to 1.
3. If the email was already sent to an examinee, and Exam Admin requests for email to be resent and the exam scheduling instructions date has passed, the value needs to be updated from 1 to 0.
4. Then, the next time the hosted service runs, the scheduling instructions email will send again.
Update ABPN examinee:
investigate -
select * from applicant a
join testtaker tt on tt.TestTaker_Key = a.Applicant_Key
where a.person_key = 123456 and a.Examination_Key = 1234
update -
update testtaker
set Admission_Slip_Sent = 1
where TestTaker_Key in
(select tt.TestTaker_Key from applicant a
join testtaker tt on tt.TestTaker_Key = a.Applicant_Key
where a.person_key = 123456 and a.Examination_Key = 1234)
Update Other Board Examinee
investigate -
select * from otherboardphysician obp
join OtherBoardExaminee obe on obe.OtherBoardPhysicianId = obp.OtherBoardPhysicianId
join examinee e on e.OtherBoardExamineeId = obe.OtherBoardExamineeId
where obp.OtherBoardPhysicianCode = 'ABIM-12345' and obe.examination_key = 1234
update -
update OtherBoardExaminee
set Admission_Slip_Sent = 1
where OtherBoardExamineeId in
(select obe.OtherBoardExamineeId from otherboardphysician obp
join OtherBoardExaminee obe on obe.OtherBoardPhysicianId = obp.OtherBoardPhysicianId
join examinee e on e.OtherBoardExamineeId = obe.OtherBoardExamineeId
where obp.OtherBoardPhysicianCode = 'ABIM-12345' and obe.Examination_Key = 1234)