Some of the queries below pay attention to contact types of Mother (10), Father (11), Step Mother (12), Step Father (13), Foster Mother (14), Foster Father (15). You can easily adjust the CON.RL types to include/exclude other relationship types.
LISTS contacts with missing First or Last Name:
LIST STU CON STU.SC STU.NM CON.RL CON.NM CON.FN CON.LN BY STU.SC CON.NM IF ( CON.RL = 10 OR CON.RL = 11 OR CON.RL = 12 OR CON.RL = 13 OR CON.RL = 14 OR CON.RL = 15 ) AND ( STU.SC # 888 OR STU.SC # 44 OR STU.SC # 45 OR STU.SC # 46 OR STU.SC # 54 OR STU.SC # 57 OR STU.SC # 60 OR STU.SC # 63 ) AND ( CON.LN = " " OR CON.FN = " " )
The SKIP query below leaves students with missing links to Student Demographics:
SKIP STU CON IF ( C1F # " " OR C2F # " " )