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