Issue 

Used Scheduling Setup to convert SMS to Flex Scheduling and now all teachers show as Unassigned on the Flex SMS Board 


Environment

Newly converted to Flex Scheduling


Cause

Del tagged/Hidden FTF and/or SMS records can cause teachers to convert as (0) Unassigned


Resolution

SELECT * INTO FTF_BACKUPxxxxxxxx
FROM FTF

DELETE FROM FTF 
WHERE DEL = 1 


SELECT * INTO SMS_BACKUPxxxxxxxx
FROM SMS

DELETE FROM SMS 
WHERE DEL = 1
SQL