Denbigh UPS Queries

            SELECT
                denbighID      AS student_id,
                username       AS network_login,
                ''             AS student_title,
                firstname      AS student_given_name,
                firstname      AS student_preferred,
                surname        AS student_surname,
                ''             AS student_gender,
                ''             AS student_home_email,
                email          AS student_default_email,
                ''             AS student_work_email,
                academicYear   AS student_year_level,
                house          AS student_house,
                boardingStatus AS student_boarder,
                cateringHouse  AS student_boarding_house,
                ''             AS student_campus
            FROM Schoolbox_Students
            ORDER BY denbighID ASC

            SELECT DISTINCT
                par.loginID      AS student_contact_network_login,
                peo.denbighID    AS student_contact_id,
                peo.title        AS student_contact_title,
                peo.given_names  AS student_contact_given_name,
                peo.preferred_name AS student_contact_preferred,
                peo.surname      AS student_contact_surname,
                ''               AS student_contact_home_email,
                peo.email        AS student_contact_default_email,
                ''               AS student_contact_work_email,
                s.denbighID      AS student_id,
                s.academicYear   AS student_year_level,
                ''               AS student_campus,
                s.house          AS student_house,
                ''               AS student_gender,
                s.firstname      AS student_preferred,
                s.surname        AS student_surname
            FROM Addresses adr
            JOIN Parents par ON par.familyDenbighID = adr.familyDenbighID
            JOIN People peo ON peo.denbighID = par.peopleDenbighID
            LEFT JOIN Schoolbox_Students s ON s.familyDenbighID = par.familyDenbighID
            WHERE peo.id IS NOT NULL
            ORDER BY adr.familyDenbighID ASC, peo.denbighID ASC

            SELECT
                p.denbighID      AS staff_id,
                s.username       AS network_login,
                1                AS active_flag,
                p.title          AS staff_title,
                p.given_names    AS staff_given_name,
                p.preferred_name AS staff_preferred_name,
                p.surname        AS staff_surname,
                ''               AS default_email_code,
                ''               AS home_email,
                p.email          AS default_email,
                ''               AS work_email,
                s.campus         AS staff_campus,
                ''               AS staff_category_type,
                ''               AS staff_category,
                ''               AS staff_house,
                ''               AS staff_department,
                ''               AS staff_year_level,
                ''               AS staff_year_level_description

            FROM Staff s
            JOIN People p ON s.peopleDenbighID = p.denbighID