mgh missmatch

SELECT
    'Student' AS ROLE,
    psc.email AS username,
    u.vmps_tech_student_password AS password,
    s.last_name AS last_name,
    s.first_name AS first_name,
    substr(s.middle_name, 1, 1) AS middlie_initial,
    s.gender AS gender,
    u.VMPS_DEMO_STUDENT_EMAIL AS email,
    to_char(s.grade_level) AS student_grade,
    to_char(s.student_number) AS student_id,
    '' AS school_zipcode,
    CASE s.schoolid
        WHEN 90 THEN 'Virginia Secondary School' ELSE to_char(s.schoolid) END AS school_name,
    u.vmps_mgh_sci_astr_s AS master_code,
    to_char(to_date(u.vmps_mgh_contentexpiredate),'mm/dd/yyyy') AS content_expiry_date,
    to_char(se.id)||' '||tchr.last_name AS class_name,
    s.grade_level AS class_grade,
    'skrage@vmps.org' AS students_teacher_user_name
FROM students s
INNER JOIN sync_studentmap ssm ON ssm.studentsdcid=s.dcid
INNER JOIN psm_studentcontact psc ON psc.studentid=ssm.studentid
INNER JOIN psm_studentcontacttype psct ON psc.studentcontacttypeid=psct.id AND psct.name='Self'
INNER JOIN schools sch ON sch.school_number=s.schoolid
INNER JOIN terms t ON t.schoolid=sch.school_number AND t.yearid=29
INNER JOIN cc ON cc.studentid=s.id
INNER JOIN sections se ON se.id=cc.sectionid AND se.termid=t.id AND se.course_number='1344'
INNER JOIN teachers tchr ON tchr.id=se.teacher
LEFT OUTER JOIN u_def_ext_students u ON u.studentsdcid=s.dcid
WHERE s.enroll_status=0
  AND u.vmps_mgh_sci_astr_s IS NOT NULL
  AND s.grade_level BETWEEN 7 AND 12

UNION

SELECT
    'Teacher' AS ROLE,
    tchr.email_addr AS username,
    LOWER(substr(tchr.first_name,1,1))||LOWER(tchr.last_name) || se.course_number AS password,
    tchr.last_name AS last_name,
    tchr.first_name AS first_name,
    '' AS middle_initial,
    '' AS gender,
    tchr.email_addr AS email,
    '' AS student_grade,
    '' AS student_id,
    sch.schoolzip AS school_zipcode,
    sch.name AS school_name,
    u.vmps_mgh_sci_astr_t AS master_code,
    to_char(to_date(u.vmps_mgh_masterc_math_s_exp),'mm/dd/yyyy') AS content_expiry_date,
    to_char(se.id)||' '||tchr.last_name AS class_name,
    '' AS class_grade,
    '' AS students_teacher_user_name
FROM teachers tchr
INNER JOIN schools sch ON sch.school_number=tchr.schoolid
INNER JOIN terms t ON t.schoolid=sch.school_number AND t.yearid=29
INNER JOIN sections se ON se.teacher=tchr.id AND se.termid=t.id AND se.course_number='1344'
LEFT OUTER JOIN u_def_ext_schoolstaff u ON u.schoolstaffdcid=tchr.dcid