SELECT  DISTINCT
        s.ID
,       s.person_uid

FROM    odsmgr.academic_study t

        INNER JOIN odsmgr.student_course s
            ON t.id = s.id

        INNER JOIN
        (
            SELECT  *
            FROM
            (
                SELECT  person_uid
                ,       student_status
                ,       academic_period
                ,       MAX(academic_period) OVER (PARTITION BY person_uid) last_academic_period

                FROM    mst_general_student
            )

            WHERE   academic_period = last_academic_period
                    AND student_status    ='AS'
        ) statuses
            ON s.person_uid = statuses.person_uid

WHERE   s.academic_period IN ('201550', '201590', '201610', '201650')
        AND s.registration_status IN ('RE', 'RW')
        AND t.college NOT IN ('24', '96')
        AND t.program NOT LIKE 'E26%'
        AND s.campus IN('M', 'B', 'DE', 'OC', 'WNC', 'WKT')