ion Education Help Site / User's Manual / SIS Connections

Skyward SMS 2.0 SQL Queries

Updated on Mar 30, 2023

ion's preferred method of connecting to Skyward's SMS platform is through an ODBC connection. If your district is hosted by ISCorp, please visit the instructions. To set up an ODBC connection on an instance of Skyward hosted either by your district or another third party, visit the Skyward Self-Hosted instructions.

Prerequisites

Agent Setup
File Transfer Utility

SQL Statement Templates

Users

select 
	a."ALTERNATE-ID" as 'user_id'
	, a."LAST-NAME" as 'last_name'
	, a."FIRST-NAME" as 'first_name'
	, replace(a."INTERNET-ADDRESS",'school.com','school.org') as 'email'
	, '' as 'ldap_dn'
	, 'FALSE' as 'isDistrictAdmin'
	, c."ENTITY-ID" as 'school_id'
	, '' as 'school_id_2'
	, '' as 'school_id_3'
	, '' as 'school_id_4'
	, '' as 'school_id_5'
	, '' as 'school_id_6'
from 
	SKYWARD.PUB."NAME" a 
	INNER JOIN SKYWARD.PUB."STAFF" b on a."NAME-ID" = b."NAME-ID"
	INNER JOIN SKYWARD.PUB."STAFF-ENTITY" c on a."NAME-ID" = c."NAME-ID" 
where 
	a."INTERNET-ADDRESS" like '%school.org'
	and c."STATUS-CUR-YR" = 'A'
order by a."NAME-ID" asc

Click to copy

Students

select 
	d."ENTITY-ID" as 'school_id',
	a."OTHER-ID" as 'student_id',
	a."MN-EDE-NBR" as 'state_id',
	f."LAST-NAME" as 'last_name',
	f."FIRST-NAME" as 'first_name',
	f."MIDDLE-NAME" as 'middle_name',
	f."GENDER" as 'gender',
	case when g."GRADE" = '00' then 'KG' 
		when g."GRADE" = 'P3' then 'PK'
		when g."GRADE" = 'P2' then 'PK'
		when left(g."GRADE", 1) = '0' then right(g.GRADE,1)
	else g."GRADE" end as 'grade',
	f.BIRTHDATE as 'date_of_birth',
	a."INTERNET-ADDRESS" as 'email', 
	a."GRAD-YR" as 'class_of',
	case when gtc."STUDENT-ID" is null then 'FALSE' else 'TRUE' end as 'is_gt',
	case when ell."SC-CHAR-3" >= 6 then 'FALSE' 
		when ell."SC-CHAR-3" <= 6 then 'TRUE'
		when ell."SC-CHAR-3" is null then 'FALSE' end as 'is_ell',
	case when ell."SC-CHAR-3" <> 7 then 'TRUE' else 'FALSE' end as 'ever_ell',
	h."LANGUAGE-LDESC" as 'language_1',
	b."HOMEROOM-NUMBER" as 'home_room',
	b."STUDENT-PERCENT-ENROLLED" / 100 as 'fte',
	rc."race-code" as 'race_ethnicity',
	a."NAME-ID" as 'student_id_2',
	case when sec."student-id" is null then 'FALSE' else 'TRUE' end as 'is_sped',
	case when sec."Student-id" is null then '' else ses."STATE-REPORTING-CODE" end as 'disability_1',
	case when s504."STUDENT-ID" is null then 'FALSE' else 'TRUE' end as 'is_504'
	
from 
	PUB."STUDENT" a 
	INNER JOIN PUB."STUDENT-ENTITY" b on a."STUDENT-ID" = b."STUDENT-ID"
	INNER JOIN PUB."CALENDAR-MASTER" c on b."CALENDAR-ID" = c."CALENDAR-ID" and b."ENTITY-ID" = c."ENTITY-ID" and CURDATE() between c."CAL-STR-DTE" and c."CAL-STP-DTE"
	INNER JOIN PUB."STUDENT-EW" d on a."STUDENT-ID" = d."STUDENT-ID" and b."ENTITY-ID" = d."ENTITY-ID" and c."CALENDAR-ID" = d."CALENDAR-ID"
	left JOIN PUB."ENR-STUDENT" e on a."NAME-ID" = e."NAME-ID"
	left join PUB."NAME" f on a."NAME-ID" = f."NAME-ID"
	left join PUB."ENT-GRD-GY-XREF" g on a."GRAD-YR" = g."GRAD-YR" and c."SCHOOL-YEAR" = g."SCHOOL-YEAR"
	left join PUB."LANGUAGE" h on f."LANGUAGE-CODE" = h."LANGUAGE-CODE" 
	left join (
    select
      aa."NAME-ID",
      'mr' as 'race-code'
    from
      (
        SELECT
          "NAME"."NAME-ID",
          "NAME"."ETHNICITY-HISP-X",
          CASE
            WHEN "NAME"."ETHNICITY-HISP-X" != "NAME"."ETHNICITY-HISP-X" THEN "NAME"."ETHNICITY-HISP-X"
            ELSE CASE
              WHEN RIGHT(
                LEFT(
                  (
                    CASE
                      WHEN "NAME"."FED-RACE-FLAGS" IS NULL
                      OR LTRIM("NAME"."FED-RACE-FLAGS") = '' THEN "QGT97_GENERIC_TABLE"."QGT97-CHR" [1]
                      ELSE "NAME"."FED-RACE-FLAGS"
                    END
                  ),
                  "SYS_CTD"."CODE-ID"
                ),
                1
              ) IS NULL
              OR RIGHT(
                LEFT(
                  (
                    CASE
                      WHEN "NAME"."FED-RACE-FLAGS" IS NULL
                      OR LTRIM("NAME"."FED-RACE-FLAGS") = '' THEN "QGT97_GENERIC_TABLE"."QGT97-CHR" [1]
                      ELSE "NAME"."FED-RACE-FLAGS"
                    END
                  ),
                  "SYS_CTD"."CODE-ID"
                ),
                1
              ) != '1' THEN 0
              ELSE 1
            END
          END AS "FED-RACE-FLAGS",
          "SYS_CTD"."CODE-ID",
          "SYS_CTD"."CODE-LDESC",
          "SYS_CTD"."CODE-SDESC"
        FROM
          "SKYWARD"."PUB"."NAME" "NAME"
          INNER JOIN "SKYWARD"."PUB"."SYS-CTD" "SYS_CTD" ON "SYS_CTD"."TABLE-ID" = 'FED-RACE'
          AND "SYS_CTD"."START-YEAR" <= (
            SELECT
              CASE
                WHEN "FFAACT_CONTROL_FILE"."FFAACT-CUR-FIS" IS NULL
                OR "FFAACT_CONTROL_FILE"."FFAACT-CUR-FIS" + 1 < "ENTITY"."SCHOOL-YEAR" THEN "ENTITY"."SCHOOL-YEAR"
                ELSE "FFAACT_CONTROL_FILE"."FFAACT-CUR-FIS" + 1
              END AS "CUR-YEAR"
            FROM
              "PUB"."ENTITY" "ENTITY",
              "PUB"."FFAACT-CONTROL-FILE" "FFAACT_CONTROL_FILE"
            WHERE
              "ENTITY"."ENTITY-ID" = '000'
          )
          AND "SYS_CTD"."END-YEAR" >= (
            SELECT
              CASE
                WHEN "FFAACT_CONTROL_FILE"."FFAACT-CUR-FIS" IS NULL
                OR "FFAACT_CONTROL_FILE"."FFAACT-CUR-FIS" + 1 < "ENTITY"."SCHOOL-YEAR" THEN "ENTITY"."SCHOOL-YEAR"
                ELSE "FFAACT_CONTROL_FILE"."FFAACT-CUR-FIS" + 1
              END AS "CUR-YEAR"
            FROM
              "PUB"."ENTITY" "ENTITY",
              "PUB"."FFAACT-CONTROL-FILE" "FFAACT_CONTROL_FILE"
            WHERE
              "ENTITY"."ENTITY-ID" = '000'
          )
          LEFT OUTER JOIN "SKYWARD"."PUB"."QGT97-GENERIC-TABLE" "QGT97_GENERIC_TABLE" ON "QGT97_GENERIC_TABLE"."QGT97-TABLE-NAME" = 'NAME.FED-RACE-CODE'
          AND "NAME"."NAME-ID" = "QGT97_GENERIC_TABLE"."QGT97-SRC-ID"
      ) aa
    where
      aa."FED-RACE-FLAGS" = 1
      and aa."ETHNICITY-HISP-X" = 0
    group by
      aa."NAME-ID"
    having
      count(aa."NAME-ID") > 1
    union all
    select
      distinct "NAME-ID",
      'hs' as 'race-code'
    from
      (
        SELECT
          "NAME"."NAME-ID",
          "NAME"."ETHNICITY-HISP-X",
          CASE
            WHEN "NAME"."ETHNICITY-HISP-X" != "NAME"."ETHNICITY-HISP-X" THEN "NAME"."ETHNICITY-HISP-X"
            ELSE CASE
              WHEN RIGHT(
                LEFT(
                  (
                    CASE
                      WHEN "NAME"."FED-RACE-FLAGS" IS NULL
                      OR LTRIM("NAME"."FED-RACE-FLAGS") = '' THEN "QGT97_GENERIC_TABLE"."QGT97-CHR" [1]
                      ELSE "NAME"."FED-RACE-FLAGS"
                    END
                  ),
                  "SYS_CTD"."CODE-ID"
                ),
                1
              ) IS NULL
              OR RIGHT(
                LEFT(
                  (
                    CASE
                      WHEN "NAME"."FED-RACE-FLAGS" IS NULL
                      OR LTRIM("NAME"."FED-RACE-FLAGS") = '' THEN "QGT97_GENERIC_TABLE"."QGT97-CHR" [1]
                      ELSE "NAME"."FED-RACE-FLAGS"
                    END
                  ),
                  "SYS_CTD"."CODE-ID"
                ),
                1
              ) != '1' THEN 0
              ELSE 1
            END
          END AS "FED-RACE-FLAGS",
          "SYS_CTD"."CODE-ID",
          "SYS_CTD"."CODE-LDESC",
          "SYS_CTD"."CODE-SDESC"
        FROM
          "SKYWARD"."PUB"."NAME" "NAME"
          INNER JOIN "SKYWARD"."PUB"."SYS-CTD" "SYS_CTD" ON "SYS_CTD"."TABLE-ID" = 'FED-RACE'
          AND "SYS_CTD"."START-YEAR" <= (
            SELECT
              CASE
                WHEN "FFAACT_CONTROL_FILE"."FFAACT-CUR-FIS" IS NULL
                OR "FFAACT_CONTROL_FILE"."FFAACT-CUR-FIS" + 1 < "ENTITY"."SCHOOL-YEAR" THEN "ENTITY"."SCHOOL-YEAR"
                ELSE "FFAACT_CONTROL_FILE"."FFAACT-CUR-FIS" + 1
              END AS "CUR-YEAR"
            FROM
              "PUB"."ENTITY" "ENTITY",
              "PUB"."FFAACT-CONTROL-FILE" "FFAACT_CONTROL_FILE"
            WHERE
              "ENTITY"."ENTITY-ID" = '000'
          )
          AND "SYS_CTD"."END-YEAR" >= (
            SELECT
              CASE
                WHEN "FFAACT_CONTROL_FILE"."FFAACT-CUR-FIS" IS NULL
                OR "FFAACT_CONTROL_FILE"."FFAACT-CUR-FIS" + 1 < "ENTITY"."SCHOOL-YEAR" THEN "ENTITY"."SCHOOL-YEAR"
                ELSE "FFAACT_CONTROL_FILE"."FFAACT-CUR-FIS" + 1
              END AS "CUR-YEAR"
            FROM
              "PUB"."ENTITY" "ENTITY",
              "PUB"."FFAACT-CONTROL-FILE" "FFAACT_CONTROL_FILE"
            WHERE
              "ENTITY"."ENTITY-ID" = '000'
          )
          LEFT OUTER JOIN "SKYWARD"."PUB"."QGT97-GENERIC-TABLE" "QGT97_GENERIC_TABLE" ON "QGT97_GENERIC_TABLE"."QGT97-TABLE-NAME" = 'NAME.FED-RACE-CODE'
          AND "NAME"."NAME-ID" = "QGT97_GENERIC_TABLE"."QGT97-SRC-ID"
      ) aa
    where
      aa."FED-RACE-FLAGS" = 1
      and aa."ETHNICITY-HISP-X" = 1
    union all
    select
      sub_a."NAME-ID",
      case
        when sub_b."CODE-SDESC" = 'White' then 'wh'
        when sub_b."CODE-SDESC" = 'Asian' then 'as'
        when sub_b."CODE-SDESC" = 'American Indian' then 'ai'
        when sub_b."CODE-SDESC" = 'Black' then 'bl'
        when sub_b."CODE-SDESC" = 'Native Hawaiian' then 'hi'
      end as 'race-code'
    from
      (
        select
          "NAME-ID",
          count("NAME-ID")
        from
          (
            SELECT
              "NAME"."NAME-ID",
              "NAME"."ETHNICITY-HISP-X",
              CASE
                WHEN "NAME"."ETHNICITY-HISP-X" != "NAME"."ETHNICITY-HISP-X" THEN "NAME"."ETHNICITY-HISP-X"
                ELSE CASE
                  WHEN RIGHT(
                    LEFT(
                      (
                        CASE
                          WHEN "NAME"."FED-RACE-FLAGS" IS NULL
                          OR LTRIM("NAME"."FED-RACE-FLAGS") = '' THEN "QGT97_GENERIC_TABLE"."QGT97-CHR" [1]
                          ELSE "NAME"."FED-RACE-FLAGS"
                        END
                      ),
                      "SYS_CTD"."CODE-ID"
                    ),
                    1
                  ) IS NULL
                  OR RIGHT(
                    LEFT(
                      (
                        CASE
                          WHEN "NAME"."FED-RACE-FLAGS" IS NULL
                          OR LTRIM("NAME"."FED-RACE-FLAGS") = '' THEN "QGT97_GENERIC_TABLE"."QGT97-CHR" [1]
                          ELSE "NAME"."FED-RACE-FLAGS"
                        END
                      ),
                      "SYS_CTD"."CODE-ID"
                    ),
                    1
                  ) != '1' THEN 0
                  ELSE 1
                END
              END AS "FED-RACE-FLAGS",
              "SYS_CTD"."CODE-ID",
              "SYS_CTD"."CODE-LDESC",
              "SYS_CTD"."CODE-SDESC"
            FROM
              "SKYWARD"."PUB"."NAME" "NAME"
              INNER JOIN "SKYWARD"."PUB"."SYS-CTD" "SYS_CTD" ON "SYS_CTD"."TABLE-ID" = 'FED-RACE'
              AND "SYS_CTD"."START-YEAR" <= (
                SELECT
                  CASE
                    WHEN "FFAACT_CONTROL_FILE"."FFAACT-CUR-FIS" IS NULL
                    OR "FFAACT_CONTROL_FILE"."FFAACT-CUR-FIS" + 1 < "ENTITY"."SCHOOL-YEAR" THEN "ENTITY"."SCHOOL-YEAR"
                    ELSE "FFAACT_CONTROL_FILE"."FFAACT-CUR-FIS" + 1
                  END AS "CUR-YEAR"
                FROM
                  "PUB"."ENTITY" "ENTITY",
                  "PUB"."FFAACT-CONTROL-FILE" "FFAACT_CONTROL_FILE"
                WHERE
                  "ENTITY"."ENTITY-ID" = '000'
              )
              AND "SYS_CTD"."END-YEAR" >= (
                SELECT
                  CASE
                    WHEN "FFAACT_CONTROL_FILE"."FFAACT-CUR-FIS" IS NULL
                    OR "FFAACT_CONTROL_FILE"."FFAACT-CUR-FIS" + 1 < "ENTITY"."SCHOOL-YEAR" THEN "ENTITY"."SCHOOL-YEAR"
                    ELSE "FFAACT_CONTROL_FILE"."FFAACT-CUR-FIS" + 1
                  END AS "CUR-YEAR"
                FROM
                  "PUB"."ENTITY" "ENTITY",
                  "PUB"."FFAACT-CONTROL-FILE" "FFAACT_CONTROL_FILE"
                WHERE
                  "ENTITY"."ENTITY-ID" = '000'
              )
              LEFT OUTER JOIN "SKYWARD"."PUB"."QGT97-GENERIC-TABLE" "QGT97_GENERIC_TABLE" ON "QGT97_GENERIC_TABLE"."QGT97-TABLE-NAME" = 'NAME.FED-RACE-CODE'
              AND "NAME"."NAME-ID" = "QGT97_GENERIC_TABLE"."QGT97-SRC-ID"
          ) aa
        where
          aa."FED-RACE-FLAGS" = 1
          and aa."ETHNICITY-HISP-X" = 0
        group by
          "NAME-ID"
        having
          count("NAME-ID") = 1
      ) sub_a
      inner join (
        SELECT
          "NAME"."NAME-ID",
          "NAME"."ETHNICITY-HISP-X",
          CASE
            WHEN "NAME"."ETHNICITY-HISP-X" != "NAME"."ETHNICITY-HISP-X" THEN "NAME"."ETHNICITY-HISP-X"
            ELSE CASE
              WHEN RIGHT(
                LEFT(
                  (
                    CASE
                      WHEN "NAME"."FED-RACE-FLAGS" IS NULL
                      OR LTRIM("NAME"."FED-RACE-FLAGS") = '' THEN "QGT97_GENERIC_TABLE"."QGT97-CHR" [1]
                      ELSE "NAME"."FED-RACE-FLAGS"
                    END
                  ),
                  "SYS_CTD"."CODE-ID"
                ),
                1
              ) IS NULL
              OR RIGHT(
                LEFT(
                  (
                    CASE
                      WHEN "NAME"."FED-RACE-FLAGS" IS NULL
                      OR LTRIM("NAME"."FED-RACE-FLAGS") = '' THEN "QGT97_GENERIC_TABLE"."QGT97-CHR" [1]
                      ELSE "NAME"."FED-RACE-FLAGS"
                    END
                  ),
                  "SYS_CTD"."CODE-ID"
                ),
                1
              ) != '1' THEN 0
              ELSE 1
            END
          END AS "FED-RACE-FLAGS",
          "SYS_CTD"."CODE-ID",
          "SYS_CTD"."CODE-LDESC",
          "SYS_CTD"."CODE-SDESC"
        FROM
          "SKYWARD"."PUB"."NAME" "NAME"
          INNER JOIN "SKYWARD"."PUB"."SYS-CTD" "SYS_CTD" ON "SYS_CTD"."TABLE-ID" = 'FED-RACE'
          AND "SYS_CTD"."START-YEAR" <= (
            SELECT
              CASE
                WHEN "FFAACT_CONTROL_FILE"."FFAACT-CUR-FIS" IS NULL
                OR "FFAACT_CONTROL_FILE"."FFAACT-CUR-FIS" + 1 < "ENTITY"."SCHOOL-YEAR" THEN "ENTITY"."SCHOOL-YEAR"
                ELSE "FFAACT_CONTROL_FILE"."FFAACT-CUR-FIS" + 1
              END AS "CUR-YEAR"
            FROM
              "PUB"."ENTITY" "ENTITY",
              "PUB"."FFAACT-CONTROL-FILE" "FFAACT_CONTROL_FILE"
            WHERE
              "ENTITY"."ENTITY-ID" = '000'
          )
          AND "SYS_CTD"."END-YEAR" >= (
            SELECT
              CASE
                WHEN "FFAACT_CONTROL_FILE"."FFAACT-CUR-FIS" IS NULL
                OR "FFAACT_CONTROL_FILE"."FFAACT-CUR-FIS" + 1 < "ENTITY"."SCHOOL-YEAR" THEN "ENTITY"."SCHOOL-YEAR"
                ELSE "FFAACT_CONTROL_FILE"."FFAACT-CUR-FIS" + 1
              END AS "CUR-YEAR"
            FROM
              "PUB"."ENTITY" "ENTITY",
              "PUB"."FFAACT-CONTROL-FILE" "FFAACT_CONTROL_FILE"
            WHERE
              "ENTITY"."ENTITY-ID" = '000'
          )
          LEFT OUTER JOIN "SKYWARD"."PUB"."QGT97-GENERIC-TABLE" "QGT97_GENERIC_TABLE" ON "QGT97_GENERIC_TABLE"."QGT97-TABLE-NAME" = 'NAME.FED-RACE-CODE'
          AND "NAME"."NAME-ID" = "QGT97_GENERIC_TABLE"."QGT97-SRC-ID"
      ) sub_b on sub_a."NAME-ID" = sub_b."NAME-ID"
      and sub_b."FED-RACE-FLAGS" = 1
      and sub_b."ETHNICITY-HISP-X" = 0
  ) rc on a."NAME-ID" = rc."NAME-ID"
	left join PUB."STUDENT-CLASSIFICATIONS" sec on a."student-id" = sec."student-id" and sec."sc-record-type" = 'SE' and sec."SC-CHAR-6" <> '' and sec."SC-CHAR-6" <> 'GI'
	left join PUB."SPECIAL-SERVICE" ses on sec."SC-CHAR-6" = ses."SPECIAL-SERVICE-ID" 
	left join PUB."STUDENT-SECTION-504" s504 on a."STUDENT-ID" = s504."STUDENT-ID" and s504."S504-STATUS" = 'A'
	left join PUB."STUDENT-CLASSIFICATIONS" gtc on a."student-id" = gtc."student-id" and gtc."sc-record-type" = 'SE' and gtc."SC-CHAR-6" = 'GI'
	left join PUB."STUDENT-CLASSIFICATIONS" ell on a."student-id" = ell."student-id" and ell."sc-record-type" = 'KSLEP' and CURDate() between ell."SC-STR-DATE" and ell."SC-END-DATE"
WHERE
	b."STUDENT-STATUS" = 'A'
	and (d."WITHDRAWAL-DATE" is null or d."WITHDRAWAL-DATE" >= CURDATE())
	and d."ENTITY-ID" in ('100','200','300','400','500')
	and g."GRADE" is not null
group by 
		d."ENTITY-ID",
	a."OTHER-ID",
	a."NAME-ID",
	a."MN-EDE-NBR",
	f."LAST-NAME",
	f."FIRST-NAME",
	f."MIDDLE-NAME",
	f."GENDER",
	case when g."GRADE" = '00' then 'KG' 
		when g."GRADE" = 'P3' then 'PK'
		when g."GRADE" = 'P2' then 'PK'
		when left(g."GRADE", 1) = '0' then right(g.GRADE,1)
	else g."GRADE" end,
	f.BIRTHDATE,
	a."INTERNET-ADDRESS", 
	a."GRAD-YR",
	case when a."X-GIFTED-TALENTED" = 1 then 'TRUE' else 'FALSE' end,
	case when ell."SC-CHAR-3" >= 6 then 'FALSE' 
		when ell."SC-CHAR-3" <= 6 then 'TRUE'
		when ell."SC-CHAR-3" is null then 'FALSE' end,
	case when ell."SC-CHAR-3" <> 7 then 'TRUE' else 'FALSE' end,
	h."LANGUAGE-LDESC",
	b."HOMEROOM-NUMBER",
	b."STUDENT-PERCENT-ENROLLED" / 100,
	rc."NAME-ID",
	rc."race-code",
	case when sec."student-id" is null then 'FALSE' else 'TRUE' end,
	case when sec."Student-id" is null then '' else ses."STATE-REPORTING-CODE" end,
	case when s504."STUDENT-ID" is null then 'FALSE' else 'TRUE' end
	
with (nolock)

Click to copy

Enrollment Days

SELECT DISTINCT
	st."OTHER-ID" as "student_id",
	cm."ENTITY-ID" as "school_id",
	cm."SCHOOL-YEAR" as "school_year",
	CASE WHEN LEFT(gl."GRADE",1) = '0' THEN right(gl."GRADE",1) ELSE gl."GRADE" end as "grade",
	ucase(td."TERM-DESC") as "term",
	cd."CAL-DATE" as "date"
FROM 
	PUB."STUDENT" st
	INNER JOIN
	PUB."STUDENT-EW" se
		on st."STUDENT-ID" = se."STUDENT-ID"
	INNER JOIN PUB."STUDENT-ENTITY" b ON st."STUDENT-ID" = b."STUDENT-ID"
	INNER JOIN
	PUB."CALENDAR-MASTER" cm
		on se."ENTITY-ID" = cm."ENTITY-ID" and
		CURDATE() between cm."CAL-STR-DTE" and cm."CAL-STP-DTE"
	INNER JOIN PUB."STUDENT-EW" d on st."STUDENT-ID" = d."STUDENT-ID" and b."ENTITY-ID" = d."ENTITY-ID" and cm."CALENDAR-ID" = d."CALENDAR-ID"
	INNER JOIN
	PUB."CALENDAR-DAY" cd
		on se."ENTITY-ID" = cd."ENTITY-ID" and 
		cm."CALENDAR-ID" = cd."CALENDAR-ID" and 
		cd."CAL-DATE" between cm."CAL-STR-DTE" and cm."CAL-STP-DTE"
	inner join PUB."CALENDAR-TERMS" ct 
		on cm."ENTITY-ID" = ct."ENTITY-ID" and cm."SCHOOL-YEAR" = ct."SCHOOL-YEAR"
	inner join PUB."TERM-DEFINITION" td 
		on ct."SCH-TERM" = td."TERM-NBR" and cm."ENTITY-ID" = td."ENTITY-ID" and cm."SCHOOL-YEAR" = td."SCHOOL-YEAR"
			and cd."CAL-DATE" between td."SEM-TRM-STR-DATE" and td."SEM-TRM-STP-DATE"
	INNER JOIN
	PUB."ENT-GRD-GY-XREF" gl
		on st."GRAD-YR" = gl."GRAD-YR" and cm."SCHOOL-YEAR" = gl."SCHOOL-YEAR"
WHERE
	se."ENTRYC-CODE" in ('NEW','PR','RE','PRO') and
	cd."CAL-DATE" between cm."CAL-STR-DTE" and CURDATE() and
	cd."CAL-DATE" BETWEEN se."EW-DATE" and case when se."WITHDRAWAL-DATE" is null then cm."CAL-STP-DTE" else se."WITHDRAWAL-DATE" end 
    and cd."CAL-DATE" BETWEEN ##START## AND ##END## --CURDATE() - 20 AND CURDATE()'
	AND b."STUDENT-STATUS" = 'A'
	and (d."WITHDRAWAL-DATE" is null or d."WITHDRAWAL-DATE" >= ##START##)
	and st."other-id" is not null
	and cm."entity-id" is not null
	and cm."school-year" is not null
	and CASE WHEN LEFT(gl."GRADE",1) = '0' THEN right(gl."GRADE",1) ELSE gl."GRADE" end is not null
	and ucase(td."TERM-DESC") is not null
	and cd."CAL-DATE" is not null

with (nolock)

Click to copy

Attendance Detail

select 
	st."other-id" as 'student_id',
	sad."school-year" as 'school_year',
	sad."entity-id" as 'school_id',
	case when grd."GRADE" = '00' then 'KG' 
		when grd."GRADE" = 'P3' then 'PK'
		when grd."GRADE" = 'P2' then 'PK'
		when left(grd."GRADE", 1) = '0' then right(grd.GRADE,1)
	else grd."GRADE" end as 'grade',
	ucase(td."term-desc") as 'term',
	sad."atnd-date" as 'date',
	round(length(replace(replace(replace(sad."aat-id",';',''),'T',''),'Y','')) / cal."cal-prds-in-day",2) as 'absent_days',
	pd.period as 'period_name',
	cm."CLAS-SECTION" as 'section_id',
	cm."CLAS-SECTION" as 'section_name',
	crs."COR-sdesc" as 'course_name',
	crs."cor-alphakey" as 'course_number',
	crs."cor-alphakey" as 'course_id',
	ucase(substring(case when left(replace(replace(sad."aat-id",';;','; ;'),';;', '; ;'),1) = ';' then concat(' ',replace(replace(sad."aat-id",';;','; ;'),';;', '; ;')) else replace(replace(sad."aat-id",';;','; ;'),';;', '; ;') end,pd."column",1)) as 'excuse',
	replace(ucase(substring(case when left(replace(replace(sad."aar-id",';;',';  ;'),';;', ';  ;'),1) = ';' then concat('  ',replace(replace(sad."aar-id",';;',';  ;'),';;', ';  ;')) else replace(replace(sad."aar-id",';;',';  ;'),';;', ';  ;') end,pd."rcolumn",2)),';','') as 'code',
	at."aat-ldesc" as 'description',
	case when ucase(substring(case when left(replace(replace(sad."aat-id",';;','; ;'),';;', '; ;'),1) = ';' then concat(' ',replace(replace(sad."aat-id",';;','; ;'),';;', '; ;')) else replace(replace(sad."aat-id",';;','; ;'),';;', '; ;') end,pd."column",1)) in ('T','Y') then 'TRUE' else 'FALSE' end as 'tardy'
from 
	pub."student-atnd-detail" sad
		inner join pub."calendar-day" cal on sad."entity-id" = cal."entity-id" and sad."atnd-date" = cal."cal-date"
		cross join (
			(select 1 as period, 1 as 'column',1 as 'rcolumn' from sysprogress."SYSCALCTABLE"
	 			union all
				 select 2,3,4 from sysprogress."SYSCALCTABLE"
				 union all
				 select 3,5,7 from sysprogress."SYSCALCTABLE"
				 union all
				 select 4,7,10 from sysprogress."SYSCALCTABLE"
				 union all
				 select 5,9,13 from sysprogress."SYSCALCTABLE"
				 union all
				 select 6,11,16 from sysprogress."SYSCALCTABLE"
				 union all
				 select 7,13,19 from sysprogress."SYSCALCTABLE"
				 union all
				 select 8,15,22 from sysprogress."SYSCALCTABLE"
				 union all
				 select 9,17,25 from sysprogress."SYSCALCTABLE"
				 union all
				 select 10,19,28 from sysprogress."SYSCALCTABLE"
				 union all
				 select 11,21,31 from sysprogress."SYSCALCTABLE"
			)
		) pd
	inner join pub."ATND-ABSENCE-TYPE" at on sad."Entity-Id"=at."Entity-Id" 
			and sad."school-Year" = at."school-year" 
			and ucase(substring(case when left(replace(replace(sad."aat-id",';;','; ;'),';;', '; ;'),1) = ';' then concat(' ',replace(replace(sad."aat-id",';;','; ;'),';;', '; ;')) else replace(replace(sad."aat-id",';;','; ;'),';;', '; ;') end,pd."column",1)) = at."AAt-ID"
	inner join "PUB"."STUDENT-CLASS" stc on sad."student-id" = stc."student-id" 
		and sad."entity-id" = stc."entity-Id" 
		and sad."school-year" = stc."school-year"
		and stc."schd-status" = 'A'
	inner join "PUB"."CLASS-MEET" cm 
		on stc."cor-num-id" = cm."cor-num-id" 
		and stc."track" = cm."track" 
		and stc."clas-section" = cm."clas-section" 
		and pd."period" = cm."atn-period" 
		and sad."entity-id" = cm."entity-id" 
		and sad."school-year" = cm."school-year" 
		and cal."cal-day-nbr" = case when cm."atn-day-nbr" = 992 then 0 else (cm."atn-day-nbr"/256) end
	inner join "PUB"."COURSE" crs on cm."cor-num-id" = crs."cor-num-id"
	inner join "PUB"."STUDENT" st on sad."student-id" = st."student-id"
	inner join PUB."ENT-GRD-GY-XREF" grd on st."GRAD-YR" = grd."GRAD-YR" and sad."SCHOOL-YEAR" = grd."SCHOOL-YEAR"
	inner join PUB."CALENDAR-TERMS" ct on
			sad."ENTITY-ID" = ct."ENTITY-ID" and
			sad."SCHOOL-YEAR" = ct."SCHOOL-YEAR" and
			sad."ATND-DATE" between ct."CAL-TRM-STR-DTE" and ct."CAL-TRM-STP-DTE" and
			ct."sch-term" between cm."sch-str-trm" and cm."sch-stp-trm"
	inner join PUB."TERM-DEFINITION" td 
		on ct."SCH-TERM" = td."TERM-NBR" and sad."ENTITY-ID" = td."ENTITY-ID" and sad."SCHOOL-YEAR" = td."SCHOOL-YEAR"
			and cal."CAL-DATE" between td."SEM-TRM-STR-DATE" and td."SEM-TRM-STP-DATE"
where
	sad."school-year" = 2023
	and sad."atnd-date" between ##START## AND ##END##
with (NOLOCK)

Click to copy

Behavior

select 
	a."SCHOOL-YEAR" as 'school_year',
	a."ENTITY-ID" as 'school_id',
	td."TERM-DESC" as 'term_name',
	b."OTHER-ID" as 'student_id',
	case when d."GRADE" = '00' then 'KG' 
		when d."GRADE" = 'P3' then 'PK'
		when d."GRADE" = 'P2' then 'PK'
		when left(d."GRADE", 1) = '0' then right(d.GRADE,1)
	else d."GRADE" end as 'grade',
	a."OFFENSE-REF-NO" as 'event_id',
	e."DIS-OFFENSE-LDESC" as 'event_name',
	a."OFF-DATE" as 'event_date',
	f."LOCATION-LDESC" as 'event_location',
	case when h."DIS-ACTION-SDESC" is null then '' else h."DIS-ACTION-SDESC" end as 'resolution',
	case when h."DIS-ACTION-ID" is null then '' 
		when h."DIS-ACTION-ID" = 180 then 1 else h."DIS-ACTION-TIME" end as 'resolution_days',
	c."LAST-NAME" + ', ' + c."FIRST-NAME" as 'submitted_by',
	'' as 'motivation',
	'' as 'event_description',
	case when e."DIS-OFFENSE-SEVERITy" = 1 then 'Major' else '' end as 'severity',
	'SIS' as 'source'
from PUB."STUDENT-DIS-OFFENSE" a
inner join PUB."STUDENT" b on a."STUDENT-ID" = b."STUDENT-ID"
inner join PUB."NAME" c on a."OFF-REF-BY-NAME-ID" = c."NAME-ID"
inner join PUB."ENT-GRD-GY-XREF" d on b."GRAD-YR" = d."GRAD-YR" and a."SCHOOL-YEAR" = d."SCHOOL-YEAR"
inner join PUB."DIS-OFFENSE" e on a."DIS-OFFENSE-ID" = e."DIS-OFFENSE-ID"
inner join PUB."LOCATION" f on a."LOCATION-ID" = f."LOCATION-ID"
inner join PUB."CALENDAR-MASTER" cm
		on a."ENTITY-ID" = cm."ENTITY-ID" and
		a."OFF-DATE" between cm."CAL-STR-DTE" and cm."CAL-STP-DTE"
inner join PUB."CALENDAR-TERMS" ct 
		on cm."ENTITY-ID" = ct."ENTITY-ID" and cm."SCHOOL-YEAR" = ct."SCHOOL-YEAR"
inner join PUB."TERM-DEFINITION" td 
		on ct."SCH-TERM" = td."TERM-NBR" and cm."ENTITY-ID" = td."ENTITY-ID" and cm."SCHOOL-YEAR" = td."SCHOOL-YEAR"
			and a."OFF-DATE" between td."SEM-TRM-STR-DATE" and td."SEM-TRM-STP-DATE"
left join PUB."STUDENT-DIS-ACTION" g on a."OFFENSE-REF-NO" = g."OFFENSE-REF-NO"
left join PUB."DIS-ACTION" h on g."DIS-ACTION-ID" = h."DIS-ACTION-ID"
where a."SCHOOL-YEAR" = 2023
with (nolock)

Click to copy

Courses

select 
	distinct
  v."STU-ENTITY-ENTITY-ID" as 'school_id',
  v."COURSE-COR-ALPHAKEY" as 'course_id',
  v."COURSE-LDESC" as 'name',
  v."COURSE-COR-ALPHAKEY" as 'number',
  v."STU-CLASS-SCHOOL-YEAR" as 'school_year',
  v."COURSE-SUBJECT-ID" as 'department',
  case when v."COURSE-REQ-ELEC" = 'R' then '1' else '0' end as 'is_core'
from (
SELECT "student" . "student-id"                       AS "STUDENT-ID",
       "student" . "other-id"                         AS "STUDENT-OTHER-ID",
       "student" . "alphakey"                         AS "STUDENT-ALPHAKEY",
       "student" . "other-name"                       AS "STUDENT-OTHER-NAME",
       "student" . "internet-address"                 AS "STUDENT-EMAIL-ADDRESS",
       "student" . "library-card-no"                  AS
       "STUDENT-LIBRARY-CARD-NO",
       "student" . "grad-yr"                          AS "STUDENT-GRAD-YR",
       "student" . "nxt-grad-yr"                      AS "STUDENT-NXT-GRAD-YR",
       "student" . "student-ecp"                      AS "STUDENT-ECP",
       "student" . "graduated"                        AS "STUDENT-GRADUATED",
       "student" . "retained"                         AS "STUDENT-RETAINED",
       "student" . "advance"                          AS "STUDENT-ADVANCE",
       "student" . "resident"                         AS "STUDENT-RESIDENT",
       "student" . "district-code"                    AS "STUDENT-DISTRICT-CODE",
       "student" . "attendance-area"                  AS
       "STUDENT-ATTENDANCE-AREA",
       "student" . "feeder-school-id"                 AS
       "STUDENT-FEEDER-SCHOOL-ID",
       "student" . "mn-ede-nbr"                       AS "STUDENT-MN-EDE-NBR",
       "student" . "path-id"                          AS "STUDENT-PATH-ID",
       "student" . "nxt-yr-sch-flag"                  AS
       "STUDENT-NXT-YR-SCH-FLAG",
       "student" . "graduation-date"                  AS
       "STUDENT-GRADUATION-DATE",
       "student" . "full-name-lfm"                    AS "STUDENT-FULL-NAME-LFM",
       "STUDENT_ENTITY" . "entity-id"                 AS "STU-ENTITY-ENTITY-ID",
       "STUDENT_ENTITY" . "school-id"                 AS "STU-ENTITY-SCHOOL-ID",
       "STUDENT_ENTITY" . "homeroom-number"           AS
       "STU-ENTITY-HMROOM-NUMBER",
       "STUDENT_ENTITY" . "x-default-entity"          AS
       "STU-ENTITY-X-DEFLT-ENTITY",
       "STUDENT_ENTITY" . "student-status"            AS
       "STU-ENTITY-STUDENT-STATUS",
       "STUDENT_ENTITY" . "student-ny-status"         AS "STU-ENTITY-NY-STATUS",
       "STUDENT_ENTITY" . "student-full-part"         AS "STU-ENTITY-FULL-PART",
       "STUDENT_ENTITY" . "student-percent-enrolled"  AS
       "STU-ENTITY-PRCNT-ENROLLED",
       "STUDENT_ENTITY" . "student-incl-honor-roll"   AS
       "STU-ENTITY-INCL-HNR-ROLL",
       "STUDENT_ENTITY" . "student-cy-member"         AS "STU-ENTITY-CY-MEMBER",
       "STUDENT_ENTITY" . "student-entity-id"         AS
       "STU-ENTITY-UDF-STU-ENT-ID",
       "STUDENT_ENTITY" . "stu-promoted-retained"     AS
       "STU-ENTITY-PRMTD-RETAINED",
       "STUDENT_ENTITY" . "promote-status"            AS
       "STU-ENTITY-PROMOTE-STATUS",
       "homeroom" . "room-number"                     AS "HOMEROOM-ROOM-NUMBER",
       "NAME_HR" . "first-name"                       AS "HR-TEACH-FIRST-NAME",
       "NAME_HR" . "middle-name"                      AS "HR-TEACH-MIDDLE-NAME",
       "NAME_HR" . "last-name"                        AS "HR-TEACH-LAST-NAME",
       "NAME_HR" . "nalphakey"                        AS "HR-TEACH-ALPHAKEY",
       "NAME_HR" . "internet-address"                 AS "HR-TEACH-EMAIL-ADDRESS"
       ,
       "NAME_HR" . "birthdate"                        AS
       "HR-TEACH-BIRTHDATE",
       "NAME_HR" . "gender"                           AS "HR-TEACH-GENDER",
       "NAME_HR" . "salutation-id"                    AS "HR-TEACH-SALUTATION",
       "NAME_HR" . "name-suffix-id"                   AS "HR-TEACH-SUFFIX",
       "NAME_ADV" . "first-name"                      AS "ADVISOR-FIRST-NAME",
       "NAME_ADV" . "middle-name"                     AS "ADVISOR-MIDDLE-NAME",
       "NAME_ADV" . "last-name"                       AS "ADVISOR-LAST-NAME",
       "NAME_ADV" . "nalphakey"                       AS "ADVISOR-ALPHAKEY",
       "NAME_ADV" . "internet-address"                AS "ADVISOR-EMAIL-ADDRESS",
       "NAME_ADV" . "birthdate"                       AS "ADVISOR-BIRTHDATE",
       "NAME_ADV" . "gender"                          AS "ADVISOR-GENDER",
       "NAME_ADV" . "salutation-id"                   AS "ADVISOR-SALUTATION",
       "NAME_ADV" . "name-suffix-id"                  AS "ADVISOR-SUFFIX",
       "NAME_SE_TCHR_OF_REC" . "first-name"           AS "TCHR-OF-REC-FIRST-NAME"
       ,
       "NAME_SE_TCHR_OF_REC" . "middle-name"          AS
       "TCHR-OF-REC-MIDDLE-NAME",
       "NAME_SE_TCHR_OF_REC" . "last-name"            AS "TCHR-OF-REC-LAST-NAME",
       "NAME_SE_TCHR_OF_REC" . "nalphakey"            AS "TCHR-OF-REC-ALPHAKEY",
       "NAME_SE_TCHR_OF_REC" . "internet-address"     AS
       "TCHR-OF-REC-EMAIL-ADDRESS",
       "NAME_SE_TCHR_OF_REC" . "birthdate"            AS "TCHR-OF-REC-BIRTHDATE",
       "NAME_SE_TCHR_OF_REC" . "gender"               AS "TCHR-OF-REC-GENDER",
       "NAME_SE_TCHR_OF_REC" . "salutation-id"        AS "TCHR-OF-REC-SALUTATION"
       ,
       "NAME_SE_TCHR_OF_REC" . "name-suffix-id"       AS
       "TCHR-OF-REC-SUFFIX",
       "NAME_DISC" . "first-name"                     AS "DISC-OFCR-FIRST-NAME",
       "NAME_DISC" . "middle-name"                    AS "DISC-OFCR-MIDDLE-NAME",
       "NAME_DISC" . "last-name"                      AS "DISC-OFCR-LAST-NAME",
       "NAME_DISC" . "nalphakey"                      AS "DISC-OFCR-ALPHAKEY",
       "NAME_DISC" . "internet-address"               AS
       "DISC-OFCR-EMAIL-ADDRESS",
       "NAME_DISC" . "birthdate"                      AS "DISC-OFCR-BIRTHDATE",
       "NAME_DISC" . "gender"                         AS "DISC-OFCR-GENDER",
       "NAME_DISC" . "salutation-id"                  AS "DISC-OFCR-SALUTATION",
       "NAME_DISC" . "name-suffix-id"                 AS "DISC-OFCR-SUFFIX",
       "entity" . "entity-name"                       AS "ENTITY-NAME",
       "entity" . "school-year"                       AS "ENTITY-SCHOOL-YEAR",
       "STUDENT_CLASS" . "cor-num-id"                 AS "STU-CLASS-COR-NUM-ID",
       "STUDENT_CLASS" . "track"                      AS "STU-CLASS-TRACK",
       "STUDENT_CLASS" . "clas-section"               AS "STU-CLASS-CLAS-SECTION"
       ,
       "STUDENT_CLASS" . "alphakey"                   AS
       "STU-CLASS-ALPHAKEY",
       "STUDENT_CLASS" . "school-year"                AS "STU-CLASS-SCHOOL-YEAR",
       "STUDENT_CLASS" . "schd-str-trm"               AS "STU-CLASS-SCHD-STR-TRM"
       ,
       "STUDENT_CLASS" . "schd-stp-trm"               AS
       "STU-CLASS-SCHD-STP-TRM",
       "STUDENT_CLASS" . "schd-record-type"           AS
       "STU-CLASS-SCHD-RECORD-TYPE",
       "STUDENT_CLASS" . "schd-status"                AS "STU-CLASS-SCHD-STATUS",
       "STUDENT_CLASS" . "schd-hst-grad-year"         AS
       "STU-CLASS-SCHD-HST-GRAD-YEAR",
       "STUDENT_CLASS" . "schd-hst-ecp"               AS "STU-CLASS-SCHD-HST-ECP"
       ,
       "STUDENT_CLASS" . "schd-ytd-earn-crds"         AS
       "STU-CLASS-SCHD-YTD-EARN-CRDS",
       "STUDENT_CLASS" . "schd-ytd-fail-crds"         AS
       "STU-CLASS-SCHD-YTD-FAIL-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-CRDS" [ 1 ]    AS
       "STU-CLASS-SCHD-YTD-GPA1-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-CRDS" [ 2 ]    AS
       "STU-CLASS-SCHD-YTD-GPA2-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-CRDS" [ 3 ]    AS
       "STU-CLASS-SCHD-YTD-GPA3-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-CRDS" [ 4 ]    AS
       "STU-CLASS-SCHD-YTD-GPA4-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-CRDS" [ 5 ]    AS
       "STU-CLASS-SCHD-YTD-GPA5-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-CRDS" [ 6 ]    AS
       "STU-CLASS-SCHD-YTD-GPA6-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-CRDS" [ 7 ]    AS
       "STU-CLASS-SCHD-YTD-GPA7-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-CRDS" [ 8 ]    AS
       "STU-CLASS-SCHD-YTD-GPA8-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-CRDS" [ 9 ]    AS
       "STU-CLASS-SCHD-YTD-GPA9-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-PNTS" [ 1 ]    AS
       "STU-CLASS-SCHD-YTD-GPA1-PNTS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-PNTS" [ 2 ]    AS
       "STU-CLASS-SCHD-YTD-GPA2-PNTS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-PNTS" [ 3 ]    AS
       "STU-CLASS-SCHD-YTD-GPA3-PNTS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-PNTS" [ 4 ]    AS
       "STU-CLASS-SCHD-YTD-GPA4-PNTS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-PNTS" [ 5 ]    AS
       "STU-CLASS-SCHD-YTD-GPA5-PNTS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-PNTS" [ 6 ]    AS
       "STU-CLASS-SCHD-YTD-GPA6-PNTS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-PNTS" [ 7 ]    AS
       "STU-CLASS-SCHD-YTD-GPA7-PNTS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-PNTS" [ 8 ]    AS
       "STU-CLASS-SCHD-YTD-GPA8-PNTS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-PNTS" [ 9 ]    AS
       "STU-CLASS-SCHD-YTD-GPA9-PNTS",
       "STUDENT_CLASS" . "GRD-SEM-EXM-MRK" [ 1 ]      AS
       "STU-CLASS-GRD-SEM-EXM-MRK1",
       "STUDENT_CLASS" . "GRD-SEM-EXM-MRK" [ 2 ]      AS
       "STU-CLASS-GRD-SEM-EXM-MRK2",
       "STUDENT_CLASS" . "GRD-SEM-EXM-MRK" [ 3 ]      AS
       "STU-CLASS-GRD-SEM-EXM-MRK3",
       "STUDENT_CLASS" . "GRD-SEM-EXM-MRK" [ 4 ]      AS
       "STU-CLASS-GRD-SEM-EXM-MRK4",
       "STUDENT_CLASS" . "GRD-SEM-MRK" [ 1 ]          AS "STU-CLASS-GRD-SEM-MRK1"
       ,
       "STUDENT_CLASS" . "GRD-SEM-MRK" [ 2 ]          AS
       "STU-CLASS-GRD-SEM-MRK2",
       "STUDENT_CLASS" . "GRD-SEM-MRK" [ 3 ]          AS "STU-CLASS-GRD-SEM-MRK3"
       ,
       "STUDENT_CLASS" . "GRD-SEM-MRK" [ 4 ]          AS
       "STU-CLASS-GRD-SEM-MRK4",
       "STUDENT_CLASS" . "grd-fnl-exm-mrk"            AS
       "STU-CLASS-GRD-FNL-EXM-MRK",
       "STUDENT_CLASS" . "grd-fnl-mrk"                AS "STU-CLASS-GRD-FNL-MRK",
       "STUDENT_CLASS" . "grd-ath-mrk"                AS "STU-CLASS-GRD-ATH-MRK",
       "STUDENT_CLASS" . "grd-ath-eff-date"           AS
       "STU-CLASS-GRD-ATH-EFF-DATE",
       "STUDENT_CLASS" . "duser-id"                   AS "STU-CLASS-DUSER-ID",
       "STUDENT_CLASS" . "grd-ath-trn-date"           AS
       "STU-CLASS-GRD-ATH-TRN-DATE",
       "STUDENT_CLASS" . "grd-oth-mrk"                AS "STU-CLASS-GRD-OTH-MRK",
       "STUDENT_CLASS" . "grd-oth-eff-date"           AS
       "STU-CLASS-GRD-OTH-EFF-DATE",
       "STUDENT_CLASS" . "grd-oth-duser-id"           AS
       "STU-CLASS-GRD-OTH-DUSER-ID",
       "STUDENT_CLASS" . "grd-oth-trn-date"           AS
       "STU-CLASS-GRD-OTH-TRN-DATE",
       "STUDENT_CLASS" . "seat"                       AS "STU-CLASS-SEAT",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 1 ]         AS
       "STU-CLASS-SCHD-TRM-ABS1",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 2 ]         AS
       "STU-CLASS-SCHD-TRM-ABS2",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 3 ]         AS
       "STU-CLASS-SCHD-TRM-ABS3",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 4 ]         AS
       "STU-CLASS-SCHD-TRM-ABS4",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 5 ]         AS
       "STU-CLASS-SCHD-TRM-ABS5",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 6 ]         AS
       "STU-CLASS-SCHD-TRM-ABS6",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 7 ]         AS
       "STU-CLASS-SCHD-TRM-ABS7",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 8 ]         AS
       "STU-CLASS-SCHD-TRM-ABS8",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 9 ]         AS
       "STU-CLASS-SCHD-TRM-ABS9",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 10 ]        AS
       "STU-CLASS-SCHD-TRM-ABS10",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 11 ]        AS
       "STU-CLASS-SCHD-TRM-ABS11",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 12 ]        AS
       "STU-CLASS-SCHD-TRM-ABS12",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 1 ]         AS
       "STU-CLASS-SCHD-TRM-TDY1",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 2 ]         AS
       "STU-CLASS-SCHD-TRM-TDY2",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 3 ]         AS
       "STU-CLASS-SCHD-TRM-TDY3",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 4 ]         AS
       "STU-CLASS-SCHD-TRM-TDY4",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 5 ]         AS
       "STU-CLASS-SCHD-TRM-TDY5",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 6 ]         AS
       "STU-CLASS-SCHD-TRM-TDY6",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 7 ]         AS
       "STU-CLASS-SCHD-TRM-TDY7",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 8 ]         AS
       "STU-CLASS-SCHD-TRM-TDY8",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 9 ]         AS
       "STU-CLASS-SCHD-TRM-TDY9",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 10 ]        AS
       "STU-CLASS-SCHD-TRM-TDY10",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 11 ]        AS
       "STU-CLASS-SCHD-TRM-TDY11",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 12 ]        AS
       "STU-CLASS-SCHD-TRM-TDY12",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 1 ]      AS
       "STU-CLASS-GRD-CITZ-MRK1",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 2 ]      AS
       "STU-CLASS-GRD-CITZ-MRK2",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 3 ]      AS
       "STU-CLASS-GRD-CITZ-MRK3",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 4 ]      AS
       "STU-CLASS-GRD-CITZ-MRK4",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 5 ]      AS
       "STU-CLASS-GRD-CITZ-MRK5",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 6 ]      AS
       "STU-CLASS-GRD-CITZ-MRK6",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 7 ]      AS
       "STU-CLASS-GRD-CITZ-MRK7",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 8 ]      AS
       "STU-CLASS-GRD-CITZ-MRK8",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 9 ]      AS
       "STU-CLASS-GRD-CITZ-MRK9",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 10 ]     AS
       "STU-CLASS-GRD-CITZ-MRK10",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 11 ]     AS
       "STU-CLASS-GRD-CITZ-MRK11",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 12 ]     AS
       "STU-CLASS-GRD-CITZ-MRK12",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 13 ]     AS
       "STU-CLASS-GRD-CITZ-MRK13",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 14 ]     AS
       "STU-CLASS-GRD-CITZ-MRK14",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 15 ]     AS
       "STU-CLASS-GRD-CITZ-MRK15",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 16 ]     AS
       "STU-CLASS-GRD-CITZ-MRK16",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 17 ]     AS
       "STU-CLASS-GRD-CITZ-MRK17",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 18 ]     AS
       "STU-CLASS-GRD-CITZ-MRK18",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 19 ]     AS
       "STU-CLASS-GRD-CITZ-MRK19",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 20 ]     AS
       "STU-CLASS-GRD-CITZ-MRK20",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 21 ]     AS
       "STU-CLASS-GRD-CITZ-MRK21",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 22 ]     AS
       "STU-CLASS-GRD-CITZ-MRK22",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 23 ]     AS
       "STU-CLASS-GRD-CITZ-MRK23",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 24 ]     AS
       "STU-CLASS-GRD-CITZ-MRK24",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 1 ]      AS
       "STU-CLASS-GRD-MDTRM-MRK1",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 2 ]      AS
       "STU-CLASS-GRD-MDTRM-MRK2",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 3 ]      AS
       "STU-CLASS-GRD-MDTRM-MRK3",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 4 ]      AS
       "STU-CLASS-GRD-MDTRM-MRK4",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 5 ]      AS
       "STU-CLASS-GRD-MDTRM-MRK5",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 6 ]      AS
       "STU-CLASS-GRD-MDTRM-MRK6",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 7 ]      AS
       "STU-CLASS-GRD-MDTRM-MRK7",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 8 ]      AS
       "STU-CLASS-GRD-MDTRM-MRK8",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 9 ]      AS
       "STU-CLASS-GRD-MDTRM-MRK9",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 10 ]     AS
       "STU-CLASS-GRD-MDTRM-MRK10",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 11 ]     AS
       "STU-CLASS-GRD-MDTRM-MRK11",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 12 ]     AS
       "STU-CLASS-GRD-MDTRM-MRK12",
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 1 ]          AS "STU-CLASS-GRD-TRM-MRK1"
       ,
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 2 ]          AS
       "STU-CLASS-GRD-TRM-MRK2",
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 3 ]          AS "STU-CLASS-GRD-TRM-MRK3"
       ,
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 4 ]          AS
       "STU-CLASS-GRD-TRM-MRK4",
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 5 ]          AS "STU-CLASS-GRD-TRM-MRK5"
       ,
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 6 ]          AS
       "STU-CLASS-GRD-TRM-MRK6",
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 7 ]          AS "STU-CLASS-GRD-TRM-MRK7"
       ,
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 8 ]          AS
       "STU-CLASS-GRD-TRM-MRK8",
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 9 ]          AS "STU-CLASS-GRD-TRM-MRK9"
       ,
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 10 ]         AS
       "STU-CLASS-GRD-TRM-MRK10",
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 11 ]         AS
       "STU-CLASS-GRD-TRM-MRK11",
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 12 ]         AS
       "STU-CLASS-GRD-TRM-MRK12",
       "STUDENT_CLASS" . "wgt-schd-add-on"            AS
       "STU-CLASS-WGT-SCHD-ADD-ON",
       "STUDENT_CLASS" . "unused-char-1"              AS "STU-CLASS-SCHOOL-NAME",
       "STUDENT_CLASS" . "schd-ytd-remain-crds"       AS
       "STU-CLASS-YTD-REMAIN-CRDS",
       "STUDENT_CLASS" . "trn-grd-lvl-ovr"            AS
       "STU-CLASS-TRN-GRD-LVL-OVR",
       "STUDENT_CLASS" . "substituted-course"         AS
       "STU-CLASS-SUBSTITUTED-CRS",
       "STUDENT_CLASS" . "course-flag"                AS "STU-CLASS-COURSE-FLAG",
       "STUDENT_CLASS" . "x-do-not-incl-rc-tran"      AS
       "STU-CLASS-NO-INCL-RC-TRAN",
       "class" . "team-schd-id"                       AS "CLASS-TEAM-SCHD-ID",
       "class" . "clas-status"                        AS "CLASS-STATUS",
       "class" . "clas-nbr-stds-opt"                  AS "CLASS-NBR-STDS-OPT",
       "class" . "clas-nbr-stds-max"                  AS "CLASS-NBR-STDS-MAX",
       "class" . "clas-nbr-stds-min"                  AS "CLASS-NBR-STDS-MIN",
       "class" . "control-set-id"                     AS "CLASS-CONTROL-SET-ID",
       "class" . "calendar-id"                        AS "CLASS-CALENDAR-ID",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 1 ]            AS "CLASS-NBR-STDS-ENR1",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 2 ]            AS "CLASS-NBR-STDS-ENR2",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 3 ]            AS "CLASS-NBR-STDS-ENR3",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 4 ]            AS "CLASS-NBR-STDS-ENR4",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 5 ]            AS "CLASS-NBR-STDS-ENR5",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 6 ]            AS "CLASS-NBR-STDS-ENR6",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 7 ]            AS "CLASS-NBR-STDS-ENR7",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 8 ]            AS "CLASS-NBR-STDS-ENR8",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 9 ]            AS "CLASS-NBR-STDS-ENR9",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 10 ]           AS "CLASS-NBR-STDS-ENR10",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 11 ]           AS "CLASS-NBR-STDS-ENR11",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 12 ]           AS "CLASS-NBR-STDS-ENR12",
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 1 ]         AS "CLASS-WGT-SCHD-ADD-ON1"
       ,
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 2 ]         AS
       "CLASS-WGT-SCHD-ADD-ON2",
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 3 ]         AS "CLASS-WGT-SCHD-ADD-ON3"
       ,
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 4 ]         AS
       "CLASS-WGT-SCHD-ADD-ON4",
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 5 ]         AS "CLASS-WGT-SCHD-ADD-ON5"
       ,
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 6 ]         AS
       "CLASS-WGT-SCHD-ADD-ON6",
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 7 ]         AS "CLASS-WGT-SCHD-ADD-ON7"
       ,
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 8 ]         AS
       "CLASS-WGT-SCHD-ADD-ON8",
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 9 ]         AS "CLASS-WGT-SCHD-ADD-ON9"
       ,
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 10 ]        AS
       "CLASS-WGT-SCHD-ADD-ON10",
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 11 ]        AS
       "CLASS-WGT-SCHD-ADD-ON11",
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 12 ]        AS
       "CLASS-WGT-SCHD-ADD-ON12",
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 1 ]         AS "CLASS-WRK-FEMALE-CNTS1"
       ,
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 2 ]         AS
       "CLASS-WRK-FEMALE-CNTS2",
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 3 ]         AS "CLASS-WRK-FEMALE-CNTS3"
       ,
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 4 ]         AS
       "CLASS-WRK-FEMALE-CNTS4",
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 5 ]         AS "CLASS-WRK-FEMALE-CNTS5"
       ,
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 6 ]         AS
       "CLASS-WRK-FEMALE-CNTS6",
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 7 ]         AS "CLASS-WRK-FEMALE-CNTS7"
       ,
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 8 ]         AS
       "CLASS-WRK-FEMALE-CNTS8",
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 9 ]         AS "CLASS-WRK-FEMALE-CNTS9"
       ,
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 10 ]        AS
       "CLASS-WRK-FEMALE-CNTS10",
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 11 ]        AS
       "CLASS-WRK-FEMALE-CNTS11",
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 12 ]        AS
       "CLASS-WRK-FEMALE-CNTS12",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 1 ]           AS "CLASS-WRK-MALE-CNTS1",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 2 ]           AS "CLASS-WRK-MALE-CNTS2",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 3 ]           AS "CLASS-WRK-MALE-CNTS3",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 4 ]           AS "CLASS-WRK-MALE-CNTS4",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 5 ]           AS "CLASS-WRK-MALE-CNTS5",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 6 ]           AS "CLASS-WRK-MALE-CNTS6",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 7 ]           AS "CLASS-WRK-MALE-CNTS7",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 8 ]           AS "CLASS-WRK-MALE-CNTS8",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 9 ]           AS "CLASS-WRK-MALE-CNTS9",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 10 ]          AS "CLASS-WRK-MALE-CNTS10",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 11 ]          AS "CLASS-WRK-MALE-CNTS11",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 12 ]          AS "CLASS-WRK-MALE-CNTS12",
       "class" . "x-bilingual"                        AS "CLASS-X-BILINGUAL",
       "class" . "ss-class"                           AS
       "CLASS-SUMMERSCHOOL-CLASS",
       "class" . "x-consecutive-prds"                 AS
       "CLASS-X-CONSECUTIVE-PRDS",
       "class" . "clas-nbr-est-stds"                  AS "CLASS-NBR-EST-STDS",
       "class" . "spec-ed-limit"                      AS "CLASS-SPEC-ED-LIMIT",
       "class" . "clas-minutes-per-week"              AS "CLASS-MINUTES-PER-WEEK"
       ,
       "class" . "course-flag"                        AS
       "CLASS-COURSE-FLAG",
       "class" . "bell-schedule-id"                   AS "CLASS-BELL-SCHEDULE-ID"
       ,
       "CLASS_MEET" . "dsp-str-trm"                   AS
       "CLASS-MEET-DSP-STR-TRM",
       "CLASS_MEET" . "dsp-stp-trm"                   AS "CLASS-MEET-DSP-STP-TRM"
       ,
       "CLASS_MEET" . "dsp-period"                    AS
       "CLASS-MEET-DSP-PERIOD",
       "CLASS_MEET" . "clas-lun-code"                 AS
       "CLASS-MEET-CLAS-LUN-CODE",
       "CLASS_MEET" . "dsp-day-nbr"                   AS "CLASS-MEET-DSP-DAY-NBR"
       ,
       "CLASS_MEET" . "dsp-days-meet"                 AS
       "CLASS-MEET-DSP-DAYS-MEET",
       "CLASS_MEET" . "sch-str-trm"                   AS "CLASS-MEET-SCH-STR-TRM"
       ,
       "CLASS_MEET" . "sch-stp-trm"                   AS
       "CLASS-MEET-SCH-STP-TRM",
       "CLASS_MEET" . "sch-period"                    AS "CLASS-MEET-SCH-PERIOD",
       "CLASS_MEET" . "sch-day-nbr"                   AS "CLASS-MEET-SCH-DAY-NBR"
       ,
       "CLASS_MEET" . "sch-days-meet"                 AS
       "CLASS-MEET-SCH-DAYS-MEET",
       "CLASS_MEET" . "atn-period"                    AS "CLASS-MEET-ATN-PERIOD",
       "CLASS_MEET" . "atn-day-nbr"                   AS "CLASS-MEET-ATN-DAY-NBR"
       ,
       "CLASS_MEET" . "atn-days-meet"                 AS
       "CLASS-MEET-ATN-DAYS-MEET",
       "CLASS_MEET" . "room-number"                   AS "CLASS-MEET-ROOM-NUMBER"
       ,
       "CLASS_MEET" . "tchr-prime-flag"               AS
       "CLASS-MEET-TCHR-PRIMARY",
       "CLASS_MEET" . "clas-str-time"                 AS
       "CLASS-MEET-CLAS-STR-TIME",
       "CLASS_MEET" . "clas-stp-time"                 AS
       "CLASS-MEET-CLAS-STP-TIME",
       "CLASS_MEET" . "time-type"                     AS "CLASS-MEET-TIME-TYPE",
       "CLASS_MEET" . "x-print-meet"                  AS
       "CLASS-MEET-X-PRINT-MEET",
       "CLASS_MEET" . "cert-status"                   AS "CLASS-MEET-CERT-STATUS"
       ,
       "CLASS_MEET" . "highly-qualified"              AS
       "CLASS-MEET-HIGHLY-QUALIFD",
       "CLASS_MEET" . "team-teacher-training"         AS
       "CLASS-MEET-TEAMTCHR-TRAIN",
       "building" . "building-id"                     AS "BUILDING-ID",
       "building" . "building-sdesc"                  AS "BUILDING-SDESC",
       "building" . "building-ldesc"                  AS "BUILDING-LDESC",
       "course" . "cor-alphakey"                      AS "COURSE-COR-ALPHAKEY",
       "course" . "cor-status"                        AS "COURSE-STATUS",
       "course" . "cor-sdesc"                         AS "COURSE-SDESC",
       "course" . "cor-ldesc"                         AS "COURSE-LDESC",
       "course" . "cor-length-set-id"                 AS "COURSE-LENGTH-SET-ID",
       "course" . "subject-id"                        AS "COURSE-SUBJECT-ID",
       "course" . "department-id"                     AS "COURSE-DEPARTMENT-ID",
       "course" . "course-type-id"                    AS "COURSE-TYPE-ID",
       "course" . "cor-reg-lun-stdy-tran"             AS
       "COURSE-REG-LUN-STDY-TRAN",
       "course" . "cor-has-attendance"                AS "COURSE-HAS-ATTENDANCE",
       "course" . "cor-has-grades"                    AS "COURSE-HAS-GRADES",
       "course" . "cor-req-elec"                      AS "COURSE-REQ-ELEC",
       "course" . "cor-schd-type"                     AS "COURSE-SCHD-TYPE",
       "course" . "cor-grd-rng-low"                   AS "COURSE-GRD-RNG-LOW",
       "course" . "cor-grd-rng-high"                  AS "COURSE-GRD-RNG-HIGH",
       "course" . "cor-credits-good"                  AS "COURSE-CREDITS-GOOD",
       "course" . "cor-fee"                           AS "COURSE-FEE",
       "course" . "cor-academic-hours"                AS "COURSE-ACADEMIC-HOURS",
       "course" . "report-card-grp-id"                AS
       "COURSE-REPORT-CARD-GRP-ID",
       "course" . "cor-cat-num-id"                    AS "COURSE-CAT-NUM-ID",
       "course" . "trn-grd-lvl-ovr"                   AS "COURSE-TRN-GRD-LVL-OVR"
       ,
       "course" . "cor-repeatable"                    AS
       "COURSE-REPEATABLE",
       "course" . "certification-req"                 AS
       "COURSE-CERTIFICATION-REQ",
       "course" . "cor-core"                          AS "COURSE-CORE",
       "course" . "x-allow-gpa-set-override"          AS
       "COURSE-X-GPA-SET-OVRRDE",
       "course" . "cor-grade-system"                  AS "COURSE-GRADE-SYSTEM",
       "course" . "cor-grade-type"                    AS "COURSE-GRADE-TYPE",
       "course" . "cor-academic-minutes"              AS
       "COURSE-ACADEMIC-MINUTES",
       "course" . "reading-intervention"              AS
       "COURSE-RDING-INTERVENTION",
       "COURSE_TYPE" . "course-type-sdesc"            AS "COURSE-TYPE-SDESC",
       "COURSE_TYPE" . "course-type-ldesc"            AS "COURSE-TYPE-LDESC",
       "NAME_TCHR" . "first-name"                     AS "TCHR-FIRST-NAME",
       "NAME_TCHR" . "middle-name"                    AS "TCHR-MIDDLE-NAME",
       "NAME_TCHR" . "last-name"                      AS "TCHR-LAST-NAME",
       "NAME_TCHR" . "nalphakey"                      AS "TCHR-ALPHAKEY",
       "NAME_TCHR" . "internet-address"               AS "TCHR-EMAIL-ADDRESS",
       "NAME_TCHR" . "birthdate"                      AS "TCHR-BIRTHDATE",
       "NAME_TCHR" . "gender"                         AS "TCHR-GENDER",
       "NAME_TCHR" . "salutation-id"                  AS "TCHR-SALUTATION",
       "NAME_TCHR" . "name-suffix-id"                 AS "TCHR-NAME-SUFFIX",
       "NAME_STU" . "first-name"                      AS "STUNAME-FIRST-NAME",
       "NAME_STU" . "middle-name"                     AS "STUNAME-MIDDLE-NAME",
       "NAME_STU" . "last-name"                       AS "STUNAME-LAST-NAME",
       "NAME_STU" . "nalphakey"                       AS "STUNAME-ALPHAKEY",
       "NAME_STU" . "federal-id-no"                   AS "STUNAME-FEDERAL-ID-NO",
       "NAME_STU" . "internet-address"                AS "STUNAME-EMAIL-ADDRESS",
       "NAME_STU" . "birthdate"                       AS "STUNAME-BIRTHDATE",
       "NAME_STU" . "gender"                          AS "STUNAME-GENDER",
       "NAME_STU" . "language-code"                   AS "STUNAME-LANGUAGE-CODE",
       "NAME_STU" . "salutation-id"                   AS "STUNAME-SALUTATION",
       "NAME_STU" . "name-suffix-id"                  AS "STUNAME-SUFFIX",
       "NAME_STU" . "birth-place"                     AS "STUNAME-BIRTH-PLACE",
       "language" . "language-sdesc"                  AS "LANGUAGE-SDESC",
       "language" . "language-ldesc"                  AS "LANGUAGE-LDESC",
       "subject" . "subject-sdesc"                    AS "SUBJECT-SDESC",
       "subject" . "subject-ldesc"                    AS "SUBJECT-LDESC",
       "department" . "department-sdesc"              AS "DEPARTMENT-SDESC",
       "department" . "department-ldesc"              AS "DEPARTMENT-LDESC",
       "COR_LENGTH_SET" . "cor-length-sdesc"          AS "COR-LENGTH-SET-SDESC",
       "COR_LENGTH_SET" . "cor-length-ldesc"          AS "COR-LENGTH-SET-LDESC",
       "CLAS_CONTROL_SET" . "control-set-ref"         AS "CCS-CONTROL-SET-REF",
       "CLAS_CONTROL_SET" . "ccs-desc"                AS "CCS-DESC",
       "CLAS_CONTROL_SET" . "ccs-atnd-str-dte"        AS "CCS-ATND-STR-DTE",
       "CLAS_CONTROL_SET" . "ccs-atnd-stp-dte"        AS "CCS-ATND-STP-DTE",
       "CLAS_CONTROL_SET" . "ccs-dsp-trm-lit"         AS "CCS-DSP-TRM-LIT",
       "CLAS_CONTROL_SET" . "ccs-dsp-nbr-trms"        AS "CCS-DSP-NBR-TRMS",
       "CLAS_CONTROL_SET" . "ccs-dsp-str-trm"         AS "CCS-DSP-STR-TRM",
       "CLAS_CONTROL_SET" . "ccs-dsp-stp-trm"         AS "CCS-DSP-STP-TRM",
       "CLAS_CONTROL_SET" . "ccs-sch-nbr-trms"        AS "CCS-SCH-NBR-TRMS",
       "CLAS_CONTROL_SET" . "ccs-sch-str-trm"         AS "CCS-SCH-STR-TRM",
       "CLAS_CONTROL_SET" . "ccs-sch-stp-trm"         AS "CCS-SCH-STP-TRM",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 1 ]  AS "CCS-SEM-USE-TRMS1",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 2 ]  AS "CCS-SEM-USE-TRMS2",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 3 ]  AS "CCS-SEM-USE-TRMS3",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 4 ]  AS "CCS-SEM-USE-TRMS4",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 5 ]  AS "CCS-SEM-USE-TRMS5",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 6 ]  AS "CCS-SEM-USE-TRMS6",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 7 ]  AS "CCS-SEM-USE-TRMS7",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 8 ]  AS "CCS-SEM-USE-TRMS8",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 9 ]  AS "CCS-SEM-USE-TRMS9",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 10 ] AS "CCS-SEM-USE-TRMS10",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 11 ] AS "CCS-SEM-USE-TRMS11",
"CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 12 ] AS "CCS-SEM-USE-TRMS12"
FROM   "SKYWARD" . "PUB" . "entity"
       inner join "SKYWARD" . "PUB" . "student-entity" "STUDENT_ENTITY"
               ON "entity" . "entity-id" = "STUDENT_ENTITY" . "entity-id"
       inner join "SKYWARD" . "PUB" . "student"
               ON "STUDENT_ENTITY" . "student-id" = "student" . "student-id"
       inner join "SKYWARD" . "PUB" . "student-class" "STUDENT_CLASS"
               ON "STUDENT_ENTITY" . "student-id" = "STUDENT_CLASS" . "student-id"
                  AND "STUDENT_CLASS" . "school-year" IN (
                          ( "student" . "grad-yr" - 20 ), (
                          "student" . "grad-yr" - 19 ),
                          (
                          "student" . "grad-yr" - 18 ), (
                          "student" . "grad-yr" - 17 ),
                           ( "student" . "grad-yr" - 16
                          ), (
                          "student" . "grad-yr" - 15 ), (
                          "student" . "grad-yr" - 14
                          ), (
                          "student" . "grad-yr" - 13 ),
                                                           (
                          "student" . "grad-yr" - 12
                          ), (
                          "student" . "grad-yr" - 11 ), (
                          "student" . "grad-yr" - 10
                          ), (
                          "student" . "grad-yr" - 9 ),
                                                           (
                          "student" . "grad-yr" - 8 )
                          , (
                          "student" . "grad-yr" - 7 ), (
                          "student" . "grad-yr" - 6 )
                          , (
                          "student" . "grad-yr" - 5 ),
                                                           (
                          "student" . "grad-yr" - 4 )
                          , (
                          "student" . "grad-yr" - 3 ), (
                          "student" . "grad-yr" - 2 )
                          , (
                          "student" . "grad-yr" - 1 ),
                                                           (
                          "student" . "grad-yr" ), (
                          "student" . "grad-yr" + 1 ), (
                          "student" . "grad-yr" + 2 )
                          , (
                          "student" . "grad-yr" + 3 ),
                                                           (
                          "student" . "grad-yr" + 4 )
                          , (
                          "student" . "grad-yr" + 5 ), (
                          "student" . "grad-yr" + 6 )
                          , (
                          "student" . "grad-yr" + 7 ),
                                                           (
                          "student" . "grad-yr" + 8 )
                          , (
                          "student" . "grad-yr" + 9 ), (
                          "student" . "grad-yr" + 10
                          ), (
                          "student" . "grad-yr" + 11 ),
                                                           (
                          "student" . "grad-yr" + 12
                          ), (
                          "student" . "grad-yr" + 13 ), (
                          "student" . "grad-yr" + 14
                          ), (
                          "student" . "grad-yr" + 15 ),
                                                           (
                          "student" . "grad-yr" + 16
                          ), (
                          "student" . "grad-yr" + 17 ), (
                          "student" . "grad-yr" + 18
                          ), (
                          "student" . "grad-yr" + 19 ), (
                          "student" . "grad-yr" + 20
                                                        ) )
                  AND "STUDENT_ENTITY" . "entity-id" =
                      "STUDENT_CLASS" . "entity-id"
       left outer join "SKYWARD" . "PUB" . "class" "CLASS"
                    ON "STUDENT_CLASS" . "cor-num-id" = "class" . "cor-num-id"
                       AND "STUDENT_CLASS" . "track" = "class" . "track"
                       AND "STUDENT_CLASS" . "clas-section" =
                           "class" . "clas-section"
       left outer join "SKYWARD" . "PUB" . "class-meet" "CLASS_MEET"
                    ON "class" . "cor-num-id" = "CLASS_MEET" . "cor-num-id"
                       AND "class" . "track" = "CLASS_MEET" . "track"
                       AND "class" . "clas-section" =
                           "CLASS_MEET" . "clas-section"
       left outer join "SKYWARD" . "PUB" . "building" "BUILDING"
                    ON "CLASS_MEET" . "building-id" = "building" . "building-id"
       inner join "SKYWARD" . "PUB" . "course" "COURSE"
               ON "STUDENT_CLASS" . "cor-num-id" = "course" . "cor-num-id"
       left outer join "SKYWARD" . "PUB" . "course-type" "COURSE_TYPE"
                    ON "course" . "entity-id" = "COURSE_TYPE" . "entity-id"
                       AND "course" . "course-type-id" =
                           "COURSE_TYPE" . "course-type-id"
       left outer join "SKYWARD" . "PUB" . "name" "NAME_TCHR"
                    ON "CLASS_MEET" . "name-id" = "NAME_TCHR" . "name-id"
       left outer join "SKYWARD" . "PUB" . "homeroom" "HOMEROOM"
                    ON "STUDENT_ENTITY" . "entity-id" = "homeroom" . "entity-id"
                       AND "STUDENT_CLASS" . "school-year" =
                           "homeroom" . "school-year"
                       AND "STUDENT_ENTITY" . "homeroom-number" =
                           "homeroom" . "homeroom-number"
       left outer join "SKYWARD" . "PUB" . "name" "NAME_HR"
                    ON "homeroom" . "homeroom-teacher" = "NAME_HR" . "name-id"
       left outer join "SKYWARD" . "PUB" . "name" "NAME_ADV"
                    ON "STUDENT_ENTITY" . "advisor" = "NAME_ADV" . "name-id"
       left outer join "SKYWARD" . "PUB" . "name" "NAME_SE_TCHR_OF_REC"
                    ON "STUDENT_ENTITY" . "se-tchr-of-record" =
                       "NAME_SE_TCHR_OF_REC" . "name-id"
       left outer join "SKYWARD" . "PUB" . "name" "NAME_DISC"
                    ON "STUDENT_ENTITY" . "dis-officer" = "NAME_DISC" . "name-id"
       inner join "SKYWARD" . "PUB" . "name" "NAME_STU"
               ON "student" . "name-id" = "NAME_STU" . "name-id"
       inner join "SKYWARD" . "PUB" . "language" "LANGUAGE"
               ON "NAME_STU" . "language-code" = "language" . "language-code"
       left outer join "SKYWARD" . "PUB" . "subject" "SUBJECT"
                    ON "course" . "entity-id" = "subject" . "entity-id"
                       AND "course" . "school-year" = "subject" . "school-year"
                       AND "course" . "subject-id" = "subject" . "subject-id"
       left outer join "SKYWARD" . "PUB" . "department" "DEPARTMENT"
                    ON "course" . "entity-id" = "department" . "entity-id"
                       AND "course" . "school-year" = "department" . "school-year"
                       AND "course" . "department-id" =
                           "department" . "department-id"
       left outer join "SKYWARD" . "PUB" . "cor-length-set" "COR_LENGTH_SET"
                    ON "course" . "entity-id" = "COR_LENGTH_SET" . "entity-id"
                       AND "course" . "school-year" =
                           "COR_LENGTH_SET" . "school-year"
                       AND "course" . "cor-length-set-id" =
                           "COR_LENGTH_SET" . "cor-length-set-id"
       left outer join "SKYWARD" . "PUB" . "clas-control-set" "CLAS_CONTROL_SET"
                    ON "STUDENT_CLASS" . "entity-id" =
                       "CLAS_CONTROL_SET" . "entity-id"
                       AND "STUDENT_CLASS" . "school-year" =
                           "CLAS_CONTROL_SET" . "school-year"
                       AND "course" . "cor-length-set-id" =
                           "CLAS_CONTROL_SET" . "cor-length-set-id"
                       AND "STUDENT_CLASS" . "track" =
                           "CLAS_CONTROL_SET" . "track"
                       AND "class" . "control-set-id" =
                           "CLAS_CONTROL_SET" . "control-set-id"
                       AND "CLAS_CONTROL_SET" . "control-set-ref" = 0 
) v
WHERE v."StU-CLASS-SCHOOL-YEAR" = 2023
and v."STU-ENTITY-ENTITY-ID" is not null
with (nolock)

Click to copy

Sections

select 
	distinct
  v."COURSE-COR-ALPHAKEY" as 'course_id',
  rtrim(cast(v."STU-CLASS-COR-NUM-ID" as char(10))) + '.' +  rtrim(cast(v."STU-CLASS-CLAS-SECTION" as char(10))) as 'section_id',
  v."STU-CLASS-CLAS-SECTION" as 'number',
  v."STU-CLASS-CLAS-SECTION" + ', ' + case when v."TCHR-LAST-NAME" is null then '' else v."TCHR-LAST-NAME" end as 'name',
  v."CCS-ATND-STR-DTE" as 'start_date',
  v."CCS-ATND-STP-DTE" as 'end_date'
from (
SELECT "student" . "student-id"                       AS "STUDENT-ID",
       "student" . "other-id"                         AS "STUDENT-OTHER-ID",
       "student" . "alphakey"                         AS "STUDENT-ALPHAKEY",
       "student" . "other-name"                       AS "STUDENT-OTHER-NAME",
       "student" . "internet-address"                 AS "STUDENT-EMAIL-ADDRESS",
       "student" . "library-card-no"                  AS
       "STUDENT-LIBRARY-CARD-NO",
       "student" . "grad-yr"                          AS "STUDENT-GRAD-YR",
       "student" . "nxt-grad-yr"                      AS "STUDENT-NXT-GRAD-YR",
       "student" . "student-ecp"                      AS "STUDENT-ECP",
       "student" . "graduated"                        AS "STUDENT-GRADUATED",
       "student" . "retained"                         AS "STUDENT-RETAINED",
       "student" . "advance"                          AS "STUDENT-ADVANCE",
       "student" . "resident"                         AS "STUDENT-RESIDENT",
       "student" . "district-code"                    AS "STUDENT-DISTRICT-CODE",
       "student" . "attendance-area"                  AS
       "STUDENT-ATTENDANCE-AREA",
       "student" . "feeder-school-id"                 AS
       "STUDENT-FEEDER-SCHOOL-ID",
       "student" . "mn-ede-nbr"                       AS "STUDENT-MN-EDE-NBR",
       "student" . "path-id"                          AS "STUDENT-PATH-ID",
       "student" . "nxt-yr-sch-flag"                  AS
       "STUDENT-NXT-YR-SCH-FLAG",
       "student" . "graduation-date"                  AS
       "STUDENT-GRADUATION-DATE",
       "student" . "full-name-lfm"                    AS "STUDENT-FULL-NAME-LFM",
       "STUDENT_ENTITY" . "entity-id"                 AS "STU-ENTITY-ENTITY-ID",
       "STUDENT_ENTITY" . "school-id"                 AS "STU-ENTITY-SCHOOL-ID",
       "STUDENT_ENTITY" . "homeroom-number"           AS
       "STU-ENTITY-HMROOM-NUMBER",
       "STUDENT_ENTITY" . "x-default-entity"          AS
       "STU-ENTITY-X-DEFLT-ENTITY",
       "STUDENT_ENTITY" . "student-status"            AS
       "STU-ENTITY-STUDENT-STATUS",
       "STUDENT_ENTITY" . "student-ny-status"         AS "STU-ENTITY-NY-STATUS",
       "STUDENT_ENTITY" . "student-full-part"         AS "STU-ENTITY-FULL-PART",
       "STUDENT_ENTITY" . "student-percent-enrolled"  AS
       "STU-ENTITY-PRCNT-ENROLLED",
       "STUDENT_ENTITY" . "student-incl-honor-roll"   AS
       "STU-ENTITY-INCL-HNR-ROLL",
       "STUDENT_ENTITY" . "student-cy-member"         AS "STU-ENTITY-CY-MEMBER",
       "STUDENT_ENTITY" . "student-entity-id"         AS
       "STU-ENTITY-UDF-STU-ENT-ID",
       "STUDENT_ENTITY" . "stu-promoted-retained"     AS
       "STU-ENTITY-PRMTD-RETAINED",
       "STUDENT_ENTITY" . "promote-status"            AS
       "STU-ENTITY-PROMOTE-STATUS",
       "homeroom" . "room-number"                     AS "HOMEROOM-ROOM-NUMBER",
       "NAME_HR" . "first-name"                       AS "HR-TEACH-FIRST-NAME",
       "NAME_HR" . "middle-name"                      AS "HR-TEACH-MIDDLE-NAME",
       "NAME_HR" . "last-name"                        AS "HR-TEACH-LAST-NAME",
       "NAME_HR" . "nalphakey"                        AS "HR-TEACH-ALPHAKEY",
       "NAME_HR" . "internet-address"                 AS "HR-TEACH-EMAIL-ADDRESS"
       ,
       "NAME_HR" . "birthdate"                        AS
       "HR-TEACH-BIRTHDATE",
       "NAME_HR" . "gender"                           AS "HR-TEACH-GENDER",
       "NAME_HR" . "salutation-id"                    AS "HR-TEACH-SALUTATION",
       "NAME_HR" . "name-suffix-id"                   AS "HR-TEACH-SUFFIX",
       "NAME_ADV" . "first-name"                      AS "ADVISOR-FIRST-NAME",
       "NAME_ADV" . "middle-name"                     AS "ADVISOR-MIDDLE-NAME",
       "NAME_ADV" . "last-name"                       AS "ADVISOR-LAST-NAME",
       "NAME_ADV" . "nalphakey"                       AS "ADVISOR-ALPHAKEY",
       "NAME_ADV" . "internet-address"                AS "ADVISOR-EMAIL-ADDRESS",
       "NAME_ADV" . "birthdate"                       AS "ADVISOR-BIRTHDATE",
       "NAME_ADV" . "gender"                          AS "ADVISOR-GENDER",
       "NAME_ADV" . "salutation-id"                   AS "ADVISOR-SALUTATION",
       "NAME_ADV" . "name-suffix-id"                  AS "ADVISOR-SUFFIX",
       "NAME_SE_TCHR_OF_REC" . "first-name"           AS "TCHR-OF-REC-FIRST-NAME"
       ,
       "NAME_SE_TCHR_OF_REC" . "middle-name"          AS
       "TCHR-OF-REC-MIDDLE-NAME",
       "NAME_SE_TCHR_OF_REC" . "last-name"            AS "TCHR-OF-REC-LAST-NAME",
       "NAME_SE_TCHR_OF_REC" . "nalphakey"            AS "TCHR-OF-REC-ALPHAKEY",
       "NAME_SE_TCHR_OF_REC" . "internet-address"     AS
       "TCHR-OF-REC-EMAIL-ADDRESS",
       "NAME_SE_TCHR_OF_REC" . "birthdate"            AS "TCHR-OF-REC-BIRTHDATE",
       "NAME_SE_TCHR_OF_REC" . "gender"               AS "TCHR-OF-REC-GENDER",
       "NAME_SE_TCHR_OF_REC" . "salutation-id"        AS "TCHR-OF-REC-SALUTATION"
       ,
       "NAME_SE_TCHR_OF_REC" . "name-suffix-id"       AS
       "TCHR-OF-REC-SUFFIX",
       "NAME_DISC" . "first-name"                     AS "DISC-OFCR-FIRST-NAME",
       "NAME_DISC" . "middle-name"                    AS "DISC-OFCR-MIDDLE-NAME",
       "NAME_DISC" . "last-name"                      AS "DISC-OFCR-LAST-NAME",
       "NAME_DISC" . "nalphakey"                      AS "DISC-OFCR-ALPHAKEY",
       "NAME_DISC" . "internet-address"               AS
       "DISC-OFCR-EMAIL-ADDRESS",
       "NAME_DISC" . "birthdate"                      AS "DISC-OFCR-BIRTHDATE",
       "NAME_DISC" . "gender"                         AS "DISC-OFCR-GENDER",
       "NAME_DISC" . "salutation-id"                  AS "DISC-OFCR-SALUTATION",
       "NAME_DISC" . "name-suffix-id"                 AS "DISC-OFCR-SUFFIX",
       "entity" . "entity-name"                       AS "ENTITY-NAME",
       "entity" . "school-year"                       AS "ENTITY-SCHOOL-YEAR",
       "STUDENT_CLASS" . "cor-num-id"                 AS "STU-CLASS-COR-NUM-ID",
       "STUDENT_CLASS" . "track"                      AS "STU-CLASS-TRACK",
       "STUDENT_CLASS" . "clas-section"               AS "STU-CLASS-CLAS-SECTION"
       ,
       "STUDENT_CLASS" . "alphakey"                   AS
       "STU-CLASS-ALPHAKEY",
       "STUDENT_CLASS" . "school-year"                AS "STU-CLASS-SCHOOL-YEAR",
       "STUDENT_CLASS" . "schd-str-trm"               AS "STU-CLASS-SCHD-STR-TRM"
       ,
       "STUDENT_CLASS" . "schd-stp-trm"               AS
       "STU-CLASS-SCHD-STP-TRM",
       "STUDENT_CLASS" . "schd-record-type"           AS
       "STU-CLASS-SCHD-RECORD-TYPE",
       "STUDENT_CLASS" . "schd-status"                AS "STU-CLASS-SCHD-STATUS",
       "STUDENT_CLASS" . "schd-hst-grad-year"         AS
       "STU-CLASS-SCHD-HST-GRAD-YEAR",
       "STUDENT_CLASS" . "schd-hst-ecp"               AS "STU-CLASS-SCHD-HST-ECP"
       ,
       "STUDENT_CLASS" . "schd-ytd-earn-crds"         AS
       "STU-CLASS-SCHD-YTD-EARN-CRDS",
       "STUDENT_CLASS" . "schd-ytd-fail-crds"         AS
       "STU-CLASS-SCHD-YTD-FAIL-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-CRDS" [ 1 ]    AS
       "STU-CLASS-SCHD-YTD-GPA1-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-CRDS" [ 2 ]    AS
       "STU-CLASS-SCHD-YTD-GPA2-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-CRDS" [ 3 ]    AS
       "STU-CLASS-SCHD-YTD-GPA3-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-CRDS" [ 4 ]    AS
       "STU-CLASS-SCHD-YTD-GPA4-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-CRDS" [ 5 ]    AS
       "STU-CLASS-SCHD-YTD-GPA5-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-CRDS" [ 6 ]    AS
       "STU-CLASS-SCHD-YTD-GPA6-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-CRDS" [ 7 ]    AS
       "STU-CLASS-SCHD-YTD-GPA7-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-CRDS" [ 8 ]    AS
       "STU-CLASS-SCHD-YTD-GPA8-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-CRDS" [ 9 ]    AS
       "STU-CLASS-SCHD-YTD-GPA9-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-PNTS" [ 1 ]    AS
       "STU-CLASS-SCHD-YTD-GPA1-PNTS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-PNTS" [ 2 ]    AS
       "STU-CLASS-SCHD-YTD-GPA2-PNTS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-PNTS" [ 3 ]    AS
       "STU-CLASS-SCHD-YTD-GPA3-PNTS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-PNTS" [ 4 ]    AS
       "STU-CLASS-SCHD-YTD-GPA4-PNTS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-PNTS" [ 5 ]    AS
       "STU-CLASS-SCHD-YTD-GPA5-PNTS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-PNTS" [ 6 ]    AS
       "STU-CLASS-SCHD-YTD-GPA6-PNTS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-PNTS" [ 7 ]    AS
       "STU-CLASS-SCHD-YTD-GPA7-PNTS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-PNTS" [ 8 ]    AS
       "STU-CLASS-SCHD-YTD-GPA8-PNTS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-PNTS" [ 9 ]    AS
       "STU-CLASS-SCHD-YTD-GPA9-PNTS",
       "STUDENT_CLASS" . "GRD-SEM-EXM-MRK" [ 1 ]      AS
       "STU-CLASS-GRD-SEM-EXM-MRK1",
       "STUDENT_CLASS" . "GRD-SEM-EXM-MRK" [ 2 ]      AS
       "STU-CLASS-GRD-SEM-EXM-MRK2",
       "STUDENT_CLASS" . "GRD-SEM-EXM-MRK" [ 3 ]      AS
       "STU-CLASS-GRD-SEM-EXM-MRK3",
       "STUDENT_CLASS" . "GRD-SEM-EXM-MRK" [ 4 ]      AS
       "STU-CLASS-GRD-SEM-EXM-MRK4",
       "STUDENT_CLASS" . "GRD-SEM-MRK" [ 1 ]          AS "STU-CLASS-GRD-SEM-MRK1"
       ,
       "STUDENT_CLASS" . "GRD-SEM-MRK" [ 2 ]          AS
       "STU-CLASS-GRD-SEM-MRK2",
       "STUDENT_CLASS" . "GRD-SEM-MRK" [ 3 ]          AS "STU-CLASS-GRD-SEM-MRK3"
       ,
       "STUDENT_CLASS" . "GRD-SEM-MRK" [ 4 ]          AS
       "STU-CLASS-GRD-SEM-MRK4",
       "STUDENT_CLASS" . "grd-fnl-exm-mrk"            AS
       "STU-CLASS-GRD-FNL-EXM-MRK",
       "STUDENT_CLASS" . "grd-fnl-mrk"                AS "STU-CLASS-GRD-FNL-MRK",
       "STUDENT_CLASS" . "grd-ath-mrk"                AS "STU-CLASS-GRD-ATH-MRK",
       "STUDENT_CLASS" . "grd-ath-eff-date"           AS
       "STU-CLASS-GRD-ATH-EFF-DATE",
       "STUDENT_CLASS" . "duser-id"                   AS "STU-CLASS-DUSER-ID",
       "STUDENT_CLASS" . "grd-ath-trn-date"           AS
       "STU-CLASS-GRD-ATH-TRN-DATE",
       "STUDENT_CLASS" . "grd-oth-mrk"                AS "STU-CLASS-GRD-OTH-MRK",
       "STUDENT_CLASS" . "grd-oth-eff-date"           AS
       "STU-CLASS-GRD-OTH-EFF-DATE",
       "STUDENT_CLASS" . "grd-oth-duser-id"           AS
       "STU-CLASS-GRD-OTH-DUSER-ID",
       "STUDENT_CLASS" . "grd-oth-trn-date"           AS
       "STU-CLASS-GRD-OTH-TRN-DATE",
       "STUDENT_CLASS" . "seat"                       AS "STU-CLASS-SEAT",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 1 ]         AS
       "STU-CLASS-SCHD-TRM-ABS1",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 2 ]         AS
       "STU-CLASS-SCHD-TRM-ABS2",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 3 ]         AS
       "STU-CLASS-SCHD-TRM-ABS3",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 4 ]         AS
       "STU-CLASS-SCHD-TRM-ABS4",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 5 ]         AS
       "STU-CLASS-SCHD-TRM-ABS5",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 6 ]         AS
       "STU-CLASS-SCHD-TRM-ABS6",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 7 ]         AS
       "STU-CLASS-SCHD-TRM-ABS7",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 8 ]         AS
       "STU-CLASS-SCHD-TRM-ABS8",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 9 ]         AS
       "STU-CLASS-SCHD-TRM-ABS9",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 10 ]        AS
       "STU-CLASS-SCHD-TRM-ABS10",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 11 ]        AS
       "STU-CLASS-SCHD-TRM-ABS11",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 12 ]        AS
       "STU-CLASS-SCHD-TRM-ABS12",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 1 ]         AS
       "STU-CLASS-SCHD-TRM-TDY1",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 2 ]         AS
       "STU-CLASS-SCHD-TRM-TDY2",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 3 ]         AS
       "STU-CLASS-SCHD-TRM-TDY3",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 4 ]         AS
       "STU-CLASS-SCHD-TRM-TDY4",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 5 ]         AS
       "STU-CLASS-SCHD-TRM-TDY5",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 6 ]         AS
       "STU-CLASS-SCHD-TRM-TDY6",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 7 ]         AS
       "STU-CLASS-SCHD-TRM-TDY7",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 8 ]         AS
       "STU-CLASS-SCHD-TRM-TDY8",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 9 ]         AS
       "STU-CLASS-SCHD-TRM-TDY9",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 10 ]        AS
       "STU-CLASS-SCHD-TRM-TDY10",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 11 ]        AS
       "STU-CLASS-SCHD-TRM-TDY11",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 12 ]        AS
       "STU-CLASS-SCHD-TRM-TDY12",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 1 ]      AS
       "STU-CLASS-GRD-CITZ-MRK1",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 2 ]      AS
       "STU-CLASS-GRD-CITZ-MRK2",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 3 ]      AS
       "STU-CLASS-GRD-CITZ-MRK3",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 4 ]      AS
       "STU-CLASS-GRD-CITZ-MRK4",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 5 ]      AS
       "STU-CLASS-GRD-CITZ-MRK5",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 6 ]      AS
       "STU-CLASS-GRD-CITZ-MRK6",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 7 ]      AS
       "STU-CLASS-GRD-CITZ-MRK7",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 8 ]      AS
       "STU-CLASS-GRD-CITZ-MRK8",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 9 ]      AS
       "STU-CLASS-GRD-CITZ-MRK9",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 10 ]     AS
       "STU-CLASS-GRD-CITZ-MRK10",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 11 ]     AS
       "STU-CLASS-GRD-CITZ-MRK11",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 12 ]     AS
       "STU-CLASS-GRD-CITZ-MRK12",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 13 ]     AS
       "STU-CLASS-GRD-CITZ-MRK13",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 14 ]     AS
       "STU-CLASS-GRD-CITZ-MRK14",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 15 ]     AS
       "STU-CLASS-GRD-CITZ-MRK15",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 16 ]     AS
       "STU-CLASS-GRD-CITZ-MRK16",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 17 ]     AS
       "STU-CLASS-GRD-CITZ-MRK17",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 18 ]     AS
       "STU-CLASS-GRD-CITZ-MRK18",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 19 ]     AS
       "STU-CLASS-GRD-CITZ-MRK19",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 20 ]     AS
       "STU-CLASS-GRD-CITZ-MRK20",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 21 ]     AS
       "STU-CLASS-GRD-CITZ-MRK21",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 22 ]     AS
       "STU-CLASS-GRD-CITZ-MRK22",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 23 ]     AS
       "STU-CLASS-GRD-CITZ-MRK23",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 24 ]     AS
       "STU-CLASS-GRD-CITZ-MRK24",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 1 ]      AS
       "STU-CLASS-GRD-MDTRM-MRK1",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 2 ]      AS
       "STU-CLASS-GRD-MDTRM-MRK2",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 3 ]      AS
       "STU-CLASS-GRD-MDTRM-MRK3",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 4 ]      AS
       "STU-CLASS-GRD-MDTRM-MRK4",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 5 ]      AS
       "STU-CLASS-GRD-MDTRM-MRK5",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 6 ]      AS
       "STU-CLASS-GRD-MDTRM-MRK6",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 7 ]      AS
       "STU-CLASS-GRD-MDTRM-MRK7",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 8 ]      AS
       "STU-CLASS-GRD-MDTRM-MRK8",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 9 ]      AS
       "STU-CLASS-GRD-MDTRM-MRK9",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 10 ]     AS
       "STU-CLASS-GRD-MDTRM-MRK10",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 11 ]     AS
       "STU-CLASS-GRD-MDTRM-MRK11",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 12 ]     AS
       "STU-CLASS-GRD-MDTRM-MRK12",
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 1 ]          AS "STU-CLASS-GRD-TRM-MRK1"
       ,
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 2 ]          AS
       "STU-CLASS-GRD-TRM-MRK2",
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 3 ]          AS "STU-CLASS-GRD-TRM-MRK3"
       ,
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 4 ]          AS
       "STU-CLASS-GRD-TRM-MRK4",
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 5 ]          AS "STU-CLASS-GRD-TRM-MRK5"
       ,
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 6 ]          AS
       "STU-CLASS-GRD-TRM-MRK6",
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 7 ]          AS "STU-CLASS-GRD-TRM-MRK7"
       ,
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 8 ]          AS
       "STU-CLASS-GRD-TRM-MRK8",
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 9 ]          AS "STU-CLASS-GRD-TRM-MRK9"
       ,
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 10 ]         AS
       "STU-CLASS-GRD-TRM-MRK10",
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 11 ]         AS
       "STU-CLASS-GRD-TRM-MRK11",
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 12 ]         AS
       "STU-CLASS-GRD-TRM-MRK12",
       "STUDENT_CLASS" . "wgt-schd-add-on"            AS
       "STU-CLASS-WGT-SCHD-ADD-ON",
       "STUDENT_CLASS" . "unused-char-1"              AS "STU-CLASS-SCHOOL-NAME",
       "STUDENT_CLASS" . "schd-ytd-remain-crds"       AS
       "STU-CLASS-YTD-REMAIN-CRDS",
       "STUDENT_CLASS" . "trn-grd-lvl-ovr"            AS
       "STU-CLASS-TRN-GRD-LVL-OVR",
       "STUDENT_CLASS" . "substituted-course"         AS
       "STU-CLASS-SUBSTITUTED-CRS",
       "STUDENT_CLASS" . "course-flag"                AS "STU-CLASS-COURSE-FLAG",
       "STUDENT_CLASS" . "x-do-not-incl-rc-tran"      AS
       "STU-CLASS-NO-INCL-RC-TRAN",
       "class" . "team-schd-id"                       AS "CLASS-TEAM-SCHD-ID",
       "class" . "clas-status"                        AS "CLASS-STATUS",
       "class" . "clas-nbr-stds-opt"                  AS "CLASS-NBR-STDS-OPT",
       "class" . "clas-nbr-stds-max"                  AS "CLASS-NBR-STDS-MAX",
       "class" . "clas-nbr-stds-min"                  AS "CLASS-NBR-STDS-MIN",
       "class" . "control-set-id"                     AS "CLASS-CONTROL-SET-ID",
       "class" . "calendar-id"                        AS "CLASS-CALENDAR-ID",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 1 ]            AS "CLASS-NBR-STDS-ENR1",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 2 ]            AS "CLASS-NBR-STDS-ENR2",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 3 ]            AS "CLASS-NBR-STDS-ENR3",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 4 ]            AS "CLASS-NBR-STDS-ENR4",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 5 ]            AS "CLASS-NBR-STDS-ENR5",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 6 ]            AS "CLASS-NBR-STDS-ENR6",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 7 ]            AS "CLASS-NBR-STDS-ENR7",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 8 ]            AS "CLASS-NBR-STDS-ENR8",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 9 ]            AS "CLASS-NBR-STDS-ENR9",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 10 ]           AS "CLASS-NBR-STDS-ENR10",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 11 ]           AS "CLASS-NBR-STDS-ENR11",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 12 ]           AS "CLASS-NBR-STDS-ENR12",
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 1 ]         AS "CLASS-WGT-SCHD-ADD-ON1"
       ,
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 2 ]         AS
       "CLASS-WGT-SCHD-ADD-ON2",
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 3 ]         AS "CLASS-WGT-SCHD-ADD-ON3"
       ,
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 4 ]         AS
       "CLASS-WGT-SCHD-ADD-ON4",
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 5 ]         AS "CLASS-WGT-SCHD-ADD-ON5"
       ,
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 6 ]         AS
       "CLASS-WGT-SCHD-ADD-ON6",
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 7 ]         AS "CLASS-WGT-SCHD-ADD-ON7"
       ,
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 8 ]         AS
       "CLASS-WGT-SCHD-ADD-ON8",
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 9 ]         AS "CLASS-WGT-SCHD-ADD-ON9"
       ,
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 10 ]        AS
       "CLASS-WGT-SCHD-ADD-ON10",
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 11 ]        AS
       "CLASS-WGT-SCHD-ADD-ON11",
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 12 ]        AS
       "CLASS-WGT-SCHD-ADD-ON12",
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 1 ]         AS "CLASS-WRK-FEMALE-CNTS1"
       ,
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 2 ]         AS
       "CLASS-WRK-FEMALE-CNTS2",
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 3 ]         AS "CLASS-WRK-FEMALE-CNTS3"
       ,
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 4 ]         AS
       "CLASS-WRK-FEMALE-CNTS4",
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 5 ]         AS "CLASS-WRK-FEMALE-CNTS5"
       ,
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 6 ]         AS
       "CLASS-WRK-FEMALE-CNTS6",
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 7 ]         AS "CLASS-WRK-FEMALE-CNTS7"
       ,
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 8 ]         AS
       "CLASS-WRK-FEMALE-CNTS8",
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 9 ]         AS "CLASS-WRK-FEMALE-CNTS9"
       ,
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 10 ]        AS
       "CLASS-WRK-FEMALE-CNTS10",
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 11 ]        AS
       "CLASS-WRK-FEMALE-CNTS11",
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 12 ]        AS
       "CLASS-WRK-FEMALE-CNTS12",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 1 ]           AS "CLASS-WRK-MALE-CNTS1",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 2 ]           AS "CLASS-WRK-MALE-CNTS2",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 3 ]           AS "CLASS-WRK-MALE-CNTS3",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 4 ]           AS "CLASS-WRK-MALE-CNTS4",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 5 ]           AS "CLASS-WRK-MALE-CNTS5",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 6 ]           AS "CLASS-WRK-MALE-CNTS6",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 7 ]           AS "CLASS-WRK-MALE-CNTS7",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 8 ]           AS "CLASS-WRK-MALE-CNTS8",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 9 ]           AS "CLASS-WRK-MALE-CNTS9",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 10 ]          AS "CLASS-WRK-MALE-CNTS10",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 11 ]          AS "CLASS-WRK-MALE-CNTS11",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 12 ]          AS "CLASS-WRK-MALE-CNTS12",
       "class" . "x-bilingual"                        AS "CLASS-X-BILINGUAL",
       "class" . "ss-class"                           AS
       "CLASS-SUMMERSCHOOL-CLASS",
       "class" . "x-consecutive-prds"                 AS
       "CLASS-X-CONSECUTIVE-PRDS",
       "class" . "clas-nbr-est-stds"                  AS "CLASS-NBR-EST-STDS",
       "class" . "spec-ed-limit"                      AS "CLASS-SPEC-ED-LIMIT",
       "class" . "clas-minutes-per-week"              AS "CLASS-MINUTES-PER-WEEK"
       ,
       "class" . "course-flag"                        AS
       "CLASS-COURSE-FLAG",
       "class" . "bell-schedule-id"                   AS "CLASS-BELL-SCHEDULE-ID"
       ,
       "CLASS_MEET" . "dsp-str-trm"                   AS
       "CLASS-MEET-DSP-STR-TRM",
       "CLASS_MEET" . "dsp-stp-trm"                   AS "CLASS-MEET-DSP-STP-TRM"
       ,
       "CLASS_MEET" . "dsp-period"                    AS
       "CLASS-MEET-DSP-PERIOD",
       "CLASS_MEET" . "clas-lun-code"                 AS
       "CLASS-MEET-CLAS-LUN-CODE",
       "CLASS_MEET" . "dsp-day-nbr"                   AS "CLASS-MEET-DSP-DAY-NBR"
       ,
       "CLASS_MEET" . "dsp-days-meet"                 AS
       "CLASS-MEET-DSP-DAYS-MEET",
       "CLASS_MEET" . "sch-str-trm"                   AS "CLASS-MEET-SCH-STR-TRM"
       ,
       "CLASS_MEET" . "sch-stp-trm"                   AS
       "CLASS-MEET-SCH-STP-TRM",
       "CLASS_MEET" . "sch-period"                    AS "CLASS-MEET-SCH-PERIOD",
       "CLASS_MEET" . "sch-day-nbr"                   AS "CLASS-MEET-SCH-DAY-NBR"
       ,
       "CLASS_MEET" . "sch-days-meet"                 AS
       "CLASS-MEET-SCH-DAYS-MEET",
       "CLASS_MEET" . "atn-period"                    AS "CLASS-MEET-ATN-PERIOD",
       "CLASS_MEET" . "atn-day-nbr"                   AS "CLASS-MEET-ATN-DAY-NBR"
       ,
       "CLASS_MEET" . "atn-days-meet"                 AS
       "CLASS-MEET-ATN-DAYS-MEET",
       "CLASS_MEET" . "room-number"                   AS "CLASS-MEET-ROOM-NUMBER"
       ,
       "CLASS_MEET" . "tchr-prime-flag"               AS
       "CLASS-MEET-TCHR-PRIMARY",
       "CLASS_MEET" . "clas-str-time"                 AS
       "CLASS-MEET-CLAS-STR-TIME",
       "CLASS_MEET" . "clas-stp-time"                 AS
       "CLASS-MEET-CLAS-STP-TIME",
       "CLASS_MEET" . "time-type"                     AS "CLASS-MEET-TIME-TYPE",
       "CLASS_MEET" . "x-print-meet"                  AS
       "CLASS-MEET-X-PRINT-MEET",
       "CLASS_MEET" . "cert-status"                   AS "CLASS-MEET-CERT-STATUS"
       ,
       "CLASS_MEET" . "highly-qualified"              AS
       "CLASS-MEET-HIGHLY-QUALIFD",
       "CLASS_MEET" . "team-teacher-training"         AS
       "CLASS-MEET-TEAMTCHR-TRAIN",
       "building" . "building-id"                     AS "BUILDING-ID",
       "building" . "building-sdesc"                  AS "BUILDING-SDESC",
       "building" . "building-ldesc"                  AS "BUILDING-LDESC",
       "course" . "cor-alphakey"                      AS "COURSE-COR-ALPHAKEY",
       "course" . "cor-status"                        AS "COURSE-STATUS",
       "course" . "cor-sdesc"                         AS "COURSE-SDESC",
       "course" . "cor-ldesc"                         AS "COURSE-LDESC",
       "course" . "cor-length-set-id"                 AS "COURSE-LENGTH-SET-ID",
       "course" . "subject-id"                        AS "COURSE-SUBJECT-ID",
       "course" . "department-id"                     AS "COURSE-DEPARTMENT-ID",
       "course" . "course-type-id"                    AS "COURSE-TYPE-ID",
       "course" . "cor-reg-lun-stdy-tran"             AS
       "COURSE-REG-LUN-STDY-TRAN",
       "course" . "cor-has-attendance"                AS "COURSE-HAS-ATTENDANCE",
       "course" . "cor-has-grades"                    AS "COURSE-HAS-GRADES",
       "course" . "cor-req-elec"                      AS "COURSE-REQ-ELEC",
       "course" . "cor-schd-type"                     AS "COURSE-SCHD-TYPE",
       "course" . "cor-grd-rng-low"                   AS "COURSE-GRD-RNG-LOW",
       "course" . "cor-grd-rng-high"                  AS "COURSE-GRD-RNG-HIGH",
       "course" . "cor-credits-good"                  AS "COURSE-CREDITS-GOOD",
       "course" . "cor-fee"                           AS "COURSE-FEE",
       "course" . "cor-academic-hours"                AS "COURSE-ACADEMIC-HOURS",
       "course" . "report-card-grp-id"                AS
       "COURSE-REPORT-CARD-GRP-ID",
       "course" . "cor-cat-num-id"                    AS "COURSE-CAT-NUM-ID",
       "course" . "trn-grd-lvl-ovr"                   AS "COURSE-TRN-GRD-LVL-OVR"
       ,
       "course" . "cor-repeatable"                    AS
       "COURSE-REPEATABLE",
       "course" . "certification-req"                 AS
       "COURSE-CERTIFICATION-REQ",
       "course" . "cor-core"                          AS "COURSE-CORE",
       "course" . "x-allow-gpa-set-override"          AS
       "COURSE-X-GPA-SET-OVRRDE",
       "course" . "cor-grade-system"                  AS "COURSE-GRADE-SYSTEM",
       "course" . "cor-grade-type"                    AS "COURSE-GRADE-TYPE",
       "course" . "cor-academic-minutes"              AS
       "COURSE-ACADEMIC-MINUTES",
       "course" . "reading-intervention"              AS
       "COURSE-RDING-INTERVENTION",
       "COURSE_TYPE" . "course-type-sdesc"            AS "COURSE-TYPE-SDESC",
       "COURSE_TYPE" . "course-type-ldesc"            AS "COURSE-TYPE-LDESC",
       "NAME_TCHR" . "first-name"                     AS "TCHR-FIRST-NAME",
       "NAME_TCHR" . "middle-name"                    AS "TCHR-MIDDLE-NAME",
       "NAME_TCHR" . "last-name"                      AS "TCHR-LAST-NAME",
       "NAME_TCHR" . "nalphakey"                      AS "TCHR-ALPHAKEY",
       "NAME_TCHR" . "internet-address"               AS "TCHR-EMAIL-ADDRESS",
       "NAME_TCHR" . "birthdate"                      AS "TCHR-BIRTHDATE",
       "NAME_TCHR" . "gender"                         AS "TCHR-GENDER",
       "NAME_TCHR" . "salutation-id"                  AS "TCHR-SALUTATION",
       "NAME_TCHR" . "name-suffix-id"                 AS "TCHR-NAME-SUFFIX",
       "NAME_STU" . "first-name"                      AS "STUNAME-FIRST-NAME",
       "NAME_STU" . "middle-name"                     AS "STUNAME-MIDDLE-NAME",
       "NAME_STU" . "last-name"                       AS "STUNAME-LAST-NAME",
       "NAME_STU" . "nalphakey"                       AS "STUNAME-ALPHAKEY",
       "NAME_STU" . "federal-id-no"                   AS "STUNAME-FEDERAL-ID-NO",
       "NAME_STU" . "internet-address"                AS "STUNAME-EMAIL-ADDRESS",
       "NAME_STU" . "birthdate"                       AS "STUNAME-BIRTHDATE",
       "NAME_STU" . "gender"                          AS "STUNAME-GENDER",
       "NAME_STU" . "language-code"                   AS "STUNAME-LANGUAGE-CODE",
       "NAME_STU" . "salutation-id"                   AS "STUNAME-SALUTATION",
       "NAME_STU" . "name-suffix-id"                  AS "STUNAME-SUFFIX",
       "NAME_STU" . "birth-place"                     AS "STUNAME-BIRTH-PLACE",
       "language" . "language-sdesc"                  AS "LANGUAGE-SDESC",
       "language" . "language-ldesc"                  AS "LANGUAGE-LDESC",
       "subject" . "subject-sdesc"                    AS "SUBJECT-SDESC",
       "subject" . "subject-ldesc"                    AS "SUBJECT-LDESC",
       "department" . "department-sdesc"              AS "DEPARTMENT-SDESC",
       "department" . "department-ldesc"              AS "DEPARTMENT-LDESC",
       "COR_LENGTH_SET" . "cor-length-sdesc"          AS "COR-LENGTH-SET-SDESC",
       "COR_LENGTH_SET" . "cor-length-ldesc"          AS "COR-LENGTH-SET-LDESC",
       "CLAS_CONTROL_SET" . "control-set-ref"         AS "CCS-CONTROL-SET-REF",
       "CLAS_CONTROL_SET" . "ccs-desc"                AS "CCS-DESC",
       "CLAS_CONTROL_SET" . "ccs-atnd-str-dte"        AS "CCS-ATND-STR-DTE",
       "CLAS_CONTROL_SET" . "ccs-atnd-stp-dte"        AS "CCS-ATND-STP-DTE",
       "CLAS_CONTROL_SET" . "ccs-dsp-trm-lit"         AS "CCS-DSP-TRM-LIT",
       "CLAS_CONTROL_SET" . "ccs-dsp-nbr-trms"        AS "CCS-DSP-NBR-TRMS",
       "CLAS_CONTROL_SET" . "ccs-dsp-str-trm"         AS "CCS-DSP-STR-TRM",
       "CLAS_CONTROL_SET" . "ccs-dsp-stp-trm"         AS "CCS-DSP-STP-TRM",
       "CLAS_CONTROL_SET" . "ccs-sch-nbr-trms"        AS "CCS-SCH-NBR-TRMS",
       "CLAS_CONTROL_SET" . "ccs-sch-str-trm"         AS "CCS-SCH-STR-TRM",
       "CLAS_CONTROL_SET" . "ccs-sch-stp-trm"         AS "CCS-SCH-STP-TRM",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 1 ]  AS "CCS-SEM-USE-TRMS1",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 2 ]  AS "CCS-SEM-USE-TRMS2",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 3 ]  AS "CCS-SEM-USE-TRMS3",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 4 ]  AS "CCS-SEM-USE-TRMS4",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 5 ]  AS "CCS-SEM-USE-TRMS5",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 6 ]  AS "CCS-SEM-USE-TRMS6",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 7 ]  AS "CCS-SEM-USE-TRMS7",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 8 ]  AS "CCS-SEM-USE-TRMS8",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 9 ]  AS "CCS-SEM-USE-TRMS9",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 10 ] AS "CCS-SEM-USE-TRMS10",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 11 ] AS "CCS-SEM-USE-TRMS11",
"CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 12 ] AS "CCS-SEM-USE-TRMS12"
FROM   "SKYWARD" . "PUB" . "entity"
       inner join "SKYWARD" . "PUB" . "student-entity" "STUDENT_ENTITY"
               ON "entity" . "entity-id" = "STUDENT_ENTITY" . "entity-id"
       inner join "SKYWARD" . "PUB" . "student"
               ON "STUDENT_ENTITY" . "student-id" = "student" . "student-id"
       inner join "SKYWARD" . "PUB" . "student-class" "STUDENT_CLASS"
               ON "STUDENT_ENTITY" . "student-id" = "STUDENT_CLASS" . "student-id"
                  AND "STUDENT_CLASS" . "school-year" IN (
                          ( "student" . "grad-yr" - 20 ), (
                          "student" . "grad-yr" - 19 ),
                          (
                          "student" . "grad-yr" - 18 ), (
                          "student" . "grad-yr" - 17 ),
                           ( "student" . "grad-yr" - 16
                          ), (
                          "student" . "grad-yr" - 15 ), (
                          "student" . "grad-yr" - 14
                          ), (
                          "student" . "grad-yr" - 13 ),
                                                           (
                          "student" . "grad-yr" - 12
                          ), (
                          "student" . "grad-yr" - 11 ), (
                          "student" . "grad-yr" - 10
                          ), (
                          "student" . "grad-yr" - 9 ),
                                                           (
                          "student" . "grad-yr" - 8 )
                          , (
                          "student" . "grad-yr" - 7 ), (
                          "student" . "grad-yr" - 6 )
                          , (
                          "student" . "grad-yr" - 5 ),
                                                           (
                          "student" . "grad-yr" - 4 )
                          , (
                          "student" . "grad-yr" - 3 ), (
                          "student" . "grad-yr" - 2 )
                          , (
                          "student" . "grad-yr" - 1 ),
                                                           (
                          "student" . "grad-yr" ), (
                          "student" . "grad-yr" + 1 ), (
                          "student" . "grad-yr" + 2 )
                          , (
                          "student" . "grad-yr" + 3 ),
                                                           (
                          "student" . "grad-yr" + 4 )
                          , (
                          "student" . "grad-yr" + 5 ), (
                          "student" . "grad-yr" + 6 )
                          , (
                          "student" . "grad-yr" + 7 ),
                                                           (
                          "student" . "grad-yr" + 8 )
                          , (
                          "student" . "grad-yr" + 9 ), (
                          "student" . "grad-yr" + 10
                          ), (
                          "student" . "grad-yr" + 11 ),
                                                           (
                          "student" . "grad-yr" + 12
                          ), (
                          "student" . "grad-yr" + 13 ), (
                          "student" . "grad-yr" + 14
                          ), (
                          "student" . "grad-yr" + 15 ),
                                                           (
                          "student" . "grad-yr" + 16
                          ), (
                          "student" . "grad-yr" + 17 ), (
                          "student" . "grad-yr" + 18
                          ), (
                          "student" . "grad-yr" + 19 ), (
                          "student" . "grad-yr" + 20
                                                        ) )
                  AND "STUDENT_ENTITY" . "entity-id" =
                      "STUDENT_CLASS" . "entity-id"
       left outer join "SKYWARD" . "PUB" . "class" "CLASS"
                    ON "STUDENT_CLASS" . "cor-num-id" = "class" . "cor-num-id"
                       AND "STUDENT_CLASS" . "track" = "class" . "track"
                       AND "STUDENT_CLASS" . "clas-section" =
                           "class" . "clas-section"
       left outer join "SKYWARD" . "PUB" . "class-meet" "CLASS_MEET"
                    ON "class" . "cor-num-id" = "CLASS_MEET" . "cor-num-id"
                       AND "class" . "track" = "CLASS_MEET" . "track"
                       AND "class" . "clas-section" =
                           "CLASS_MEET" . "clas-section"
       left outer join "SKYWARD" . "PUB" . "building" "BUILDING"
                    ON "CLASS_MEET" . "building-id" = "building" . "building-id"
       inner join "SKYWARD" . "PUB" . "course" "COURSE"
               ON "STUDENT_CLASS" . "cor-num-id" = "course" . "cor-num-id"
       left outer join "SKYWARD" . "PUB" . "course-type" "COURSE_TYPE"
                    ON "course" . "entity-id" = "COURSE_TYPE" . "entity-id"
                       AND "course" . "course-type-id" =
                           "COURSE_TYPE" . "course-type-id"
       left outer join "SKYWARD" . "PUB" . "name" "NAME_TCHR"
                    ON "CLASS_MEET" . "name-id" = "NAME_TCHR" . "name-id"
       left outer join "SKYWARD" . "PUB" . "homeroom" "HOMEROOM"
                    ON "STUDENT_ENTITY" . "entity-id" = "homeroom" . "entity-id"
                       AND "STUDENT_CLASS" . "school-year" =
                           "homeroom" . "school-year"
                       AND "STUDENT_ENTITY" . "homeroom-number" =
                           "homeroom" . "homeroom-number"
       left outer join "SKYWARD" . "PUB" . "name" "NAME_HR"
                    ON "homeroom" . "homeroom-teacher" = "NAME_HR" . "name-id"
       left outer join "SKYWARD" . "PUB" . "name" "NAME_ADV"
                    ON "STUDENT_ENTITY" . "advisor" = "NAME_ADV" . "name-id"
       left outer join "SKYWARD" . "PUB" . "name" "NAME_SE_TCHR_OF_REC"
                    ON "STUDENT_ENTITY" . "se-tchr-of-record" =
                       "NAME_SE_TCHR_OF_REC" . "name-id"
       left outer join "SKYWARD" . "PUB" . "name" "NAME_DISC"
                    ON "STUDENT_ENTITY" . "dis-officer" = "NAME_DISC" . "name-id"
       inner join "SKYWARD" . "PUB" . "name" "NAME_STU"
               ON "student" . "name-id" = "NAME_STU" . "name-id"
       inner join "SKYWARD" . "PUB" . "language" "LANGUAGE"
               ON "NAME_STU" . "language-code" = "language" . "language-code"
       left outer join "SKYWARD" . "PUB" . "subject" "SUBJECT"
                    ON "course" . "entity-id" = "subject" . "entity-id"
                       AND "course" . "school-year" = "subject" . "school-year"
                       AND "course" . "subject-id" = "subject" . "subject-id"
       left outer join "SKYWARD" . "PUB" . "department" "DEPARTMENT"
                    ON "course" . "entity-id" = "department" . "entity-id"
                       AND "course" . "school-year" = "department" . "school-year"
                       AND "course" . "department-id" =
                           "department" . "department-id"
       left outer join "SKYWARD" . "PUB" . "cor-length-set" "COR_LENGTH_SET"
                    ON "course" . "entity-id" = "COR_LENGTH_SET" . "entity-id"
                       AND "course" . "school-year" =
                           "COR_LENGTH_SET" . "school-year"
                       AND "course" . "cor-length-set-id" =
                           "COR_LENGTH_SET" . "cor-length-set-id"
       left outer join "SKYWARD" . "PUB" . "clas-control-set" "CLAS_CONTROL_SET"
                    ON "STUDENT_CLASS" . "entity-id" =
                       "CLAS_CONTROL_SET" . "entity-id"
                       AND "STUDENT_CLASS" . "school-year" =
                           "CLAS_CONTROL_SET" . "school-year"
                       AND "course" . "cor-length-set-id" =
                           "CLAS_CONTROL_SET" . "cor-length-set-id"
                       AND "STUDENT_CLASS" . "track" =
                           "CLAS_CONTROL_SET" . "track"
                       AND "class" . "control-set-id" =
                           "CLAS_CONTROL_SET" . "control-set-id"
                       AND "CLAS_CONTROL_SET" . "control-set-ref" = 0 
) v
WHERE v."StU-CLASS-SCHOOL-YEAR" = 2023
and v."STU-ENTITY-ENTITY-ID" is not null
and v."CCS-ATND-STR-DTE" is not null
and v."CCS-ATND-STP-DTE" is not null
with (nolock)

Click to copy

Teachers

select 
	distinct
		  a."COURSE-COR-ALPHAKEY" as 'course_id',
		  rtrim(cast(a."STU-CLASS-COR-NUM-ID" as char(10))) + '.' +  rtrim(cast(a."STU-CLASS-CLAS-SECTION" as char(10))) as 'section_id',
		  b."ALTERNATE-ID" as 'user_id'
from (
SELECT "student" . "student-id"                       AS "STUDENT-ID",
       "student" . "other-id"                         AS "STUDENT-OTHER-ID",
       "student" . "alphakey"                         AS "STUDENT-ALPHAKEY",
       "student" . "other-name"                       AS "STUDENT-OTHER-NAME",
       "student" . "internet-address"                 AS "STUDENT-EMAIL-ADDRESS",
       "student" . "library-card-no"                  AS
       "STUDENT-LIBRARY-CARD-NO",
       "student" . "grad-yr"                          AS "STUDENT-GRAD-YR",
       "student" . "nxt-grad-yr"                      AS "STUDENT-NXT-GRAD-YR",
       "student" . "student-ecp"                      AS "STUDENT-ECP",
       "student" . "graduated"                        AS "STUDENT-GRADUATED",
       "student" . "retained"                         AS "STUDENT-RETAINED",
       "student" . "advance"                          AS "STUDENT-ADVANCE",
       "student" . "resident"                         AS "STUDENT-RESIDENT",
       "student" . "district-code"                    AS "STUDENT-DISTRICT-CODE",
       "student" . "attendance-area"                  AS
       "STUDENT-ATTENDANCE-AREA",
       "student" . "feeder-school-id"                 AS
       "STUDENT-FEEDER-SCHOOL-ID",
       "student" . "mn-ede-nbr"                       AS "STUDENT-MN-EDE-NBR",
       "student" . "path-id"                          AS "STUDENT-PATH-ID",
       "student" . "nxt-yr-sch-flag"                  AS
       "STUDENT-NXT-YR-SCH-FLAG",
       "student" . "graduation-date"                  AS
       "STUDENT-GRADUATION-DATE",
       "student" . "full-name-lfm"                    AS "STUDENT-FULL-NAME-LFM",
       "STUDENT_ENTITY" . "entity-id"                 AS "STU-ENTITY-ENTITY-ID",
       "STUDENT_ENTITY" . "school-id"                 AS "STU-ENTITY-SCHOOL-ID",
       "STUDENT_ENTITY" . "homeroom-number"           AS
       "STU-ENTITY-HMROOM-NUMBER",
       "STUDENT_ENTITY" . "x-default-entity"          AS
       "STU-ENTITY-X-DEFLT-ENTITY",
       "STUDENT_ENTITY" . "student-status"            AS
       "STU-ENTITY-STUDENT-STATUS",
       "STUDENT_ENTITY" . "student-ny-status"         AS "STU-ENTITY-NY-STATUS",
       "STUDENT_ENTITY" . "student-full-part"         AS "STU-ENTITY-FULL-PART",
       "STUDENT_ENTITY" . "student-percent-enrolled"  AS
       "STU-ENTITY-PRCNT-ENROLLED",
       "STUDENT_ENTITY" . "student-incl-honor-roll"   AS
       "STU-ENTITY-INCL-HNR-ROLL",
       "STUDENT_ENTITY" . "student-cy-member"         AS "STU-ENTITY-CY-MEMBER",
       "STUDENT_ENTITY" . "student-entity-id"         AS
       "STU-ENTITY-UDF-STU-ENT-ID",
       "STUDENT_ENTITY" . "stu-promoted-retained"     AS
       "STU-ENTITY-PRMTD-RETAINED",
       "STUDENT_ENTITY" . "promote-status"            AS
       "STU-ENTITY-PROMOTE-STATUS",
       "homeroom" . "room-number"                     AS "HOMEROOM-ROOM-NUMBER",
       "NAME_HR" . "first-name"                       AS "HR-TEACH-FIRST-NAME",
       "NAME_HR" . "middle-name"                      AS "HR-TEACH-MIDDLE-NAME",
       "NAME_HR" . "last-name"                        AS "HR-TEACH-LAST-NAME",
       "NAME_HR" . "nalphakey"                        AS "HR-TEACH-ALPHAKEY",
       "NAME_HR" . "internet-address"                 AS "HR-TEACH-EMAIL-ADDRESS"
       ,
       "NAME_HR" . "birthdate"                        AS
       "HR-TEACH-BIRTHDATE",
       "NAME_HR" . "gender"                           AS "HR-TEACH-GENDER",
       "NAME_HR" . "salutation-id"                    AS "HR-TEACH-SALUTATION",
       "NAME_HR" . "name-suffix-id"                   AS "HR-TEACH-SUFFIX",
       "NAME_ADV" . "first-name"                      AS "ADVISOR-FIRST-NAME",
       "NAME_ADV" . "middle-name"                     AS "ADVISOR-MIDDLE-NAME",
       "NAME_ADV" . "last-name"                       AS "ADVISOR-LAST-NAME",
       "NAME_ADV" . "nalphakey"                       AS "ADVISOR-ALPHAKEY",
       "NAME_ADV" . "internet-address"                AS "ADVISOR-EMAIL-ADDRESS",
       "NAME_ADV" . "birthdate"                       AS "ADVISOR-BIRTHDATE",
       "NAME_ADV" . "gender"                          AS "ADVISOR-GENDER",
       "NAME_ADV" . "salutation-id"                   AS "ADVISOR-SALUTATION",
       "NAME_ADV" . "name-suffix-id"                  AS "ADVISOR-SUFFIX",
       "NAME_SE_TCHR_OF_REC" . "first-name"           AS "TCHR-OF-REC-FIRST-NAME"
       ,
       "NAME_SE_TCHR_OF_REC" . "middle-name"          AS
       "TCHR-OF-REC-MIDDLE-NAME",
       "NAME_SE_TCHR_OF_REC" . "last-name"            AS "TCHR-OF-REC-LAST-NAME",
       "NAME_SE_TCHR_OF_REC" . "nalphakey"            AS "TCHR-OF-REC-ALPHAKEY",
       "NAME_SE_TCHR_OF_REC" . "internet-address"     AS
       "TCHR-OF-REC-EMAIL-ADDRESS",
       "NAME_SE_TCHR_OF_REC" . "birthdate"            AS "TCHR-OF-REC-BIRTHDATE",
       "NAME_SE_TCHR_OF_REC" . "gender"               AS "TCHR-OF-REC-GENDER",
       "NAME_SE_TCHR_OF_REC" . "salutation-id"        AS "TCHR-OF-REC-SALUTATION"
       ,
       "NAME_SE_TCHR_OF_REC" . "name-suffix-id"       AS
       "TCHR-OF-REC-SUFFIX",
       "NAME_DISC" . "first-name"                     AS "DISC-OFCR-FIRST-NAME",
       "NAME_DISC" . "middle-name"                    AS "DISC-OFCR-MIDDLE-NAME",
       "NAME_DISC" . "last-name"                      AS "DISC-OFCR-LAST-NAME",
       "NAME_DISC" . "nalphakey"                      AS "DISC-OFCR-ALPHAKEY",
       "NAME_DISC" . "internet-address"               AS
       "DISC-OFCR-EMAIL-ADDRESS",
       "NAME_DISC" . "birthdate"                      AS "DISC-OFCR-BIRTHDATE",
       "NAME_DISC" . "gender"                         AS "DISC-OFCR-GENDER",
       "NAME_DISC" . "salutation-id"                  AS "DISC-OFCR-SALUTATION",
       "NAME_DISC" . "name-suffix-id"                 AS "DISC-OFCR-SUFFIX",
       "entity" . "entity-name"                       AS "ENTITY-NAME",
       "entity" . "school-year"                       AS "ENTITY-SCHOOL-YEAR",
       "STUDENT_CLASS" . "cor-num-id"                 AS "STU-CLASS-COR-NUM-ID",
       "STUDENT_CLASS" . "track"                      AS "STU-CLASS-TRACK",
       "STUDENT_CLASS" . "clas-section"               AS "STU-CLASS-CLAS-SECTION"
       ,
       "STUDENT_CLASS" . "alphakey"                   AS
       "STU-CLASS-ALPHAKEY",
       "STUDENT_CLASS" . "school-year"                AS "STU-CLASS-SCHOOL-YEAR",
       "STUDENT_CLASS" . "schd-str-trm"               AS "STU-CLASS-SCHD-STR-TRM"
       ,
       "STUDENT_CLASS" . "schd-stp-trm"               AS
       "STU-CLASS-SCHD-STP-TRM",
       "STUDENT_CLASS" . "schd-record-type"           AS
       "STU-CLASS-SCHD-RECORD-TYPE",
       "STUDENT_CLASS" . "schd-status"                AS "STU-CLASS-SCHD-STATUS",
       "STUDENT_CLASS" . "schd-hst-grad-year"         AS
       "STU-CLASS-SCHD-HST-GRAD-YEAR",
       "STUDENT_CLASS" . "schd-hst-ecp"               AS "STU-CLASS-SCHD-HST-ECP"
       ,
       "STUDENT_CLASS" . "schd-ytd-earn-crds"         AS
       "STU-CLASS-SCHD-YTD-EARN-CRDS",
       "STUDENT_CLASS" . "schd-ytd-fail-crds"         AS
       "STU-CLASS-SCHD-YTD-FAIL-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-CRDS" [ 1 ]    AS
       "STU-CLASS-SCHD-YTD-GPA1-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-CRDS" [ 2 ]    AS
       "STU-CLASS-SCHD-YTD-GPA2-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-CRDS" [ 3 ]    AS
       "STU-CLASS-SCHD-YTD-GPA3-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-CRDS" [ 4 ]    AS
       "STU-CLASS-SCHD-YTD-GPA4-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-CRDS" [ 5 ]    AS
       "STU-CLASS-SCHD-YTD-GPA5-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-CRDS" [ 6 ]    AS
       "STU-CLASS-SCHD-YTD-GPA6-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-CRDS" [ 7 ]    AS
       "STU-CLASS-SCHD-YTD-GPA7-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-CRDS" [ 8 ]    AS
       "STU-CLASS-SCHD-YTD-GPA8-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-CRDS" [ 9 ]    AS
       "STU-CLASS-SCHD-YTD-GPA9-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-PNTS" [ 1 ]    AS
       "STU-CLASS-SCHD-YTD-GPA1-PNTS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-PNTS" [ 2 ]    AS
       "STU-CLASS-SCHD-YTD-GPA2-PNTS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-PNTS" [ 3 ]    AS
       "STU-CLASS-SCHD-YTD-GPA3-PNTS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-PNTS" [ 4 ]    AS
       "STU-CLASS-SCHD-YTD-GPA4-PNTS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-PNTS" [ 5 ]    AS
       "STU-CLASS-SCHD-YTD-GPA5-PNTS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-PNTS" [ 6 ]    AS
       "STU-CLASS-SCHD-YTD-GPA6-PNTS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-PNTS" [ 7 ]    AS
       "STU-CLASS-SCHD-YTD-GPA7-PNTS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-PNTS" [ 8 ]    AS
       "STU-CLASS-SCHD-YTD-GPA8-PNTS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-PNTS" [ 9 ]    AS
       "STU-CLASS-SCHD-YTD-GPA9-PNTS",
       "STUDENT_CLASS" . "GRD-SEM-EXM-MRK" [ 1 ]      AS
       "STU-CLASS-GRD-SEM-EXM-MRK1",
       "STUDENT_CLASS" . "GRD-SEM-EXM-MRK" [ 2 ]      AS
       "STU-CLASS-GRD-SEM-EXM-MRK2",
       "STUDENT_CLASS" . "GRD-SEM-EXM-MRK" [ 3 ]      AS
       "STU-CLASS-GRD-SEM-EXM-MRK3",
       "STUDENT_CLASS" . "GRD-SEM-EXM-MRK" [ 4 ]      AS
       "STU-CLASS-GRD-SEM-EXM-MRK4",
       "STUDENT_CLASS" . "GRD-SEM-MRK" [ 1 ]          AS "STU-CLASS-GRD-SEM-MRK1"
       ,
       "STUDENT_CLASS" . "GRD-SEM-MRK" [ 2 ]          AS
       "STU-CLASS-GRD-SEM-MRK2",
       "STUDENT_CLASS" . "GRD-SEM-MRK" [ 3 ]          AS "STU-CLASS-GRD-SEM-MRK3"
       ,
       "STUDENT_CLASS" . "GRD-SEM-MRK" [ 4 ]          AS
       "STU-CLASS-GRD-SEM-MRK4",
       "STUDENT_CLASS" . "grd-fnl-exm-mrk"            AS
       "STU-CLASS-GRD-FNL-EXM-MRK",
       "STUDENT_CLASS" . "grd-fnl-mrk"                AS "STU-CLASS-GRD-FNL-MRK",
       "STUDENT_CLASS" . "grd-ath-mrk"                AS "STU-CLASS-GRD-ATH-MRK",
       "STUDENT_CLASS" . "grd-ath-eff-date"           AS
       "STU-CLASS-GRD-ATH-EFF-DATE",
       "STUDENT_CLASS" . "duser-id"                   AS "STU-CLASS-DUSER-ID",
       "STUDENT_CLASS" . "grd-ath-trn-date"           AS
       "STU-CLASS-GRD-ATH-TRN-DATE",
       "STUDENT_CLASS" . "grd-oth-mrk"                AS "STU-CLASS-GRD-OTH-MRK",
       "STUDENT_CLASS" . "grd-oth-eff-date"           AS
       "STU-CLASS-GRD-OTH-EFF-DATE",
       "STUDENT_CLASS" . "grd-oth-duser-id"           AS
       "STU-CLASS-GRD-OTH-DUSER-ID",
       "STUDENT_CLASS" . "grd-oth-trn-date"           AS
       "STU-CLASS-GRD-OTH-TRN-DATE",
       "STUDENT_CLASS" . "seat"                       AS "STU-CLASS-SEAT",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 1 ]         AS
       "STU-CLASS-SCHD-TRM-ABS1",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 2 ]         AS
       "STU-CLASS-SCHD-TRM-ABS2",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 3 ]         AS
       "STU-CLASS-SCHD-TRM-ABS3",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 4 ]         AS
       "STU-CLASS-SCHD-TRM-ABS4",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 5 ]         AS
       "STU-CLASS-SCHD-TRM-ABS5",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 6 ]         AS
       "STU-CLASS-SCHD-TRM-ABS6",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 7 ]         AS
       "STU-CLASS-SCHD-TRM-ABS7",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 8 ]         AS
       "STU-CLASS-SCHD-TRM-ABS8",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 9 ]         AS
       "STU-CLASS-SCHD-TRM-ABS9",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 10 ]        AS
       "STU-CLASS-SCHD-TRM-ABS10",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 11 ]        AS
       "STU-CLASS-SCHD-TRM-ABS11",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 12 ]        AS
       "STU-CLASS-SCHD-TRM-ABS12",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 1 ]         AS
       "STU-CLASS-SCHD-TRM-TDY1",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 2 ]         AS
       "STU-CLASS-SCHD-TRM-TDY2",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 3 ]         AS
       "STU-CLASS-SCHD-TRM-TDY3",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 4 ]         AS
       "STU-CLASS-SCHD-TRM-TDY4",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 5 ]         AS
       "STU-CLASS-SCHD-TRM-TDY5",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 6 ]         AS
       "STU-CLASS-SCHD-TRM-TDY6",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 7 ]         AS
       "STU-CLASS-SCHD-TRM-TDY7",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 8 ]         AS
       "STU-CLASS-SCHD-TRM-TDY8",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 9 ]         AS
       "STU-CLASS-SCHD-TRM-TDY9",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 10 ]        AS
       "STU-CLASS-SCHD-TRM-TDY10",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 11 ]        AS
       "STU-CLASS-SCHD-TRM-TDY11",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 12 ]        AS
       "STU-CLASS-SCHD-TRM-TDY12",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 1 ]      AS
       "STU-CLASS-GRD-CITZ-MRK1",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 2 ]      AS
       "STU-CLASS-GRD-CITZ-MRK2",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 3 ]      AS
       "STU-CLASS-GRD-CITZ-MRK3",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 4 ]      AS
       "STU-CLASS-GRD-CITZ-MRK4",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 5 ]      AS
       "STU-CLASS-GRD-CITZ-MRK5",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 6 ]      AS
       "STU-CLASS-GRD-CITZ-MRK6",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 7 ]      AS
       "STU-CLASS-GRD-CITZ-MRK7",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 8 ]      AS
       "STU-CLASS-GRD-CITZ-MRK8",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 9 ]      AS
       "STU-CLASS-GRD-CITZ-MRK9",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 10 ]     AS
       "STU-CLASS-GRD-CITZ-MRK10",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 11 ]     AS
       "STU-CLASS-GRD-CITZ-MRK11",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 12 ]     AS
       "STU-CLASS-GRD-CITZ-MRK12",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 13 ]     AS
       "STU-CLASS-GRD-CITZ-MRK13",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 14 ]     AS
       "STU-CLASS-GRD-CITZ-MRK14",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 15 ]     AS
       "STU-CLASS-GRD-CITZ-MRK15",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 16 ]     AS
       "STU-CLASS-GRD-CITZ-MRK16",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 17 ]     AS
       "STU-CLASS-GRD-CITZ-MRK17",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 18 ]     AS
       "STU-CLASS-GRD-CITZ-MRK18",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 19 ]     AS
       "STU-CLASS-GRD-CITZ-MRK19",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 20 ]     AS
       "STU-CLASS-GRD-CITZ-MRK20",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 21 ]     AS
       "STU-CLASS-GRD-CITZ-MRK21",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 22 ]     AS
       "STU-CLASS-GRD-CITZ-MRK22",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 23 ]     AS
       "STU-CLASS-GRD-CITZ-MRK23",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 24 ]     AS
       "STU-CLASS-GRD-CITZ-MRK24",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 1 ]      AS
       "STU-CLASS-GRD-MDTRM-MRK1",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 2 ]      AS
       "STU-CLASS-GRD-MDTRM-MRK2",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 3 ]      AS
       "STU-CLASS-GRD-MDTRM-MRK3",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 4 ]      AS
       "STU-CLASS-GRD-MDTRM-MRK4",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 5 ]      AS
       "STU-CLASS-GRD-MDTRM-MRK5",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 6 ]      AS
       "STU-CLASS-GRD-MDTRM-MRK6",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 7 ]      AS
       "STU-CLASS-GRD-MDTRM-MRK7",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 8 ]      AS
       "STU-CLASS-GRD-MDTRM-MRK8",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 9 ]      AS
       "STU-CLASS-GRD-MDTRM-MRK9",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 10 ]     AS
       "STU-CLASS-GRD-MDTRM-MRK10",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 11 ]     AS
       "STU-CLASS-GRD-MDTRM-MRK11",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 12 ]     AS
       "STU-CLASS-GRD-MDTRM-MRK12",
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 1 ]          AS "STU-CLASS-GRD-TRM-MRK1"
       ,
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 2 ]          AS
       "STU-CLASS-GRD-TRM-MRK2",
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 3 ]          AS "STU-CLASS-GRD-TRM-MRK3"
       ,
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 4 ]          AS
       "STU-CLASS-GRD-TRM-MRK4",
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 5 ]          AS "STU-CLASS-GRD-TRM-MRK5"
       ,
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 6 ]          AS
       "STU-CLASS-GRD-TRM-MRK6",
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 7 ]          AS "STU-CLASS-GRD-TRM-MRK7"
       ,
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 8 ]          AS
       "STU-CLASS-GRD-TRM-MRK8",
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 9 ]          AS "STU-CLASS-GRD-TRM-MRK9"
       ,
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 10 ]         AS
       "STU-CLASS-GRD-TRM-MRK10",
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 11 ]         AS
       "STU-CLASS-GRD-TRM-MRK11",
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 12 ]         AS
       "STU-CLASS-GRD-TRM-MRK12",
       "STUDENT_CLASS" . "wgt-schd-add-on"            AS
       "STU-CLASS-WGT-SCHD-ADD-ON",
       "STUDENT_CLASS" . "unused-char-1"              AS "STU-CLASS-SCHOOL-NAME",
       "STUDENT_CLASS" . "schd-ytd-remain-crds"       AS
       "STU-CLASS-YTD-REMAIN-CRDS",
       "STUDENT_CLASS" . "trn-grd-lvl-ovr"            AS
       "STU-CLASS-TRN-GRD-LVL-OVR",
       "STUDENT_CLASS" . "substituted-course"         AS
       "STU-CLASS-SUBSTITUTED-CRS",
       "STUDENT_CLASS" . "course-flag"                AS "STU-CLASS-COURSE-FLAG",
       "STUDENT_CLASS" . "x-do-not-incl-rc-tran"      AS
       "STU-CLASS-NO-INCL-RC-TRAN",
       "class" . "team-schd-id"                       AS "CLASS-TEAM-SCHD-ID",
       "class" . "clas-status"                        AS "CLASS-STATUS",
       "class" . "clas-nbr-stds-opt"                  AS "CLASS-NBR-STDS-OPT",
       "class" . "clas-nbr-stds-max"                  AS "CLASS-NBR-STDS-MAX",
       "class" . "clas-nbr-stds-min"                  AS "CLASS-NBR-STDS-MIN",
       "class" . "control-set-id"                     AS "CLASS-CONTROL-SET-ID",
       "class" . "calendar-id"                        AS "CLASS-CALENDAR-ID",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 1 ]            AS "CLASS-NBR-STDS-ENR1",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 2 ]            AS "CLASS-NBR-STDS-ENR2",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 3 ]            AS "CLASS-NBR-STDS-ENR3",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 4 ]            AS "CLASS-NBR-STDS-ENR4",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 5 ]            AS "CLASS-NBR-STDS-ENR5",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 6 ]            AS "CLASS-NBR-STDS-ENR6",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 7 ]            AS "CLASS-NBR-STDS-ENR7",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 8 ]            AS "CLASS-NBR-STDS-ENR8",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 9 ]            AS "CLASS-NBR-STDS-ENR9",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 10 ]           AS "CLASS-NBR-STDS-ENR10",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 11 ]           AS "CLASS-NBR-STDS-ENR11",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 12 ]           AS "CLASS-NBR-STDS-ENR12",
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 1 ]         AS "CLASS-WGT-SCHD-ADD-ON1"
       ,
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 2 ]         AS
       "CLASS-WGT-SCHD-ADD-ON2",
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 3 ]         AS "CLASS-WGT-SCHD-ADD-ON3"
       ,
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 4 ]         AS
       "CLASS-WGT-SCHD-ADD-ON4",
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 5 ]         AS "CLASS-WGT-SCHD-ADD-ON5"
       ,
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 6 ]         AS
       "CLASS-WGT-SCHD-ADD-ON6",
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 7 ]         AS "CLASS-WGT-SCHD-ADD-ON7"
       ,
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 8 ]         AS
       "CLASS-WGT-SCHD-ADD-ON8",
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 9 ]         AS "CLASS-WGT-SCHD-ADD-ON9"
       ,
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 10 ]        AS
       "CLASS-WGT-SCHD-ADD-ON10",
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 11 ]        AS
       "CLASS-WGT-SCHD-ADD-ON11",
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 12 ]        AS
       "CLASS-WGT-SCHD-ADD-ON12",
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 1 ]         AS "CLASS-WRK-FEMALE-CNTS1"
       ,
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 2 ]         AS
       "CLASS-WRK-FEMALE-CNTS2",
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 3 ]         AS "CLASS-WRK-FEMALE-CNTS3"
       ,
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 4 ]         AS
       "CLASS-WRK-FEMALE-CNTS4",
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 5 ]         AS "CLASS-WRK-FEMALE-CNTS5"
       ,
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 6 ]         AS
       "CLASS-WRK-FEMALE-CNTS6",
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 7 ]         AS "CLASS-WRK-FEMALE-CNTS7"
       ,
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 8 ]         AS
       "CLASS-WRK-FEMALE-CNTS8",
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 9 ]         AS "CLASS-WRK-FEMALE-CNTS9"
       ,
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 10 ]        AS
       "CLASS-WRK-FEMALE-CNTS10",
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 11 ]        AS
       "CLASS-WRK-FEMALE-CNTS11",
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 12 ]        AS
       "CLASS-WRK-FEMALE-CNTS12",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 1 ]           AS "CLASS-WRK-MALE-CNTS1",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 2 ]           AS "CLASS-WRK-MALE-CNTS2",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 3 ]           AS "CLASS-WRK-MALE-CNTS3",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 4 ]           AS "CLASS-WRK-MALE-CNTS4",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 5 ]           AS "CLASS-WRK-MALE-CNTS5",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 6 ]           AS "CLASS-WRK-MALE-CNTS6",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 7 ]           AS "CLASS-WRK-MALE-CNTS7",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 8 ]           AS "CLASS-WRK-MALE-CNTS8",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 9 ]           AS "CLASS-WRK-MALE-CNTS9",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 10 ]          AS "CLASS-WRK-MALE-CNTS10",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 11 ]          AS "CLASS-WRK-MALE-CNTS11",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 12 ]          AS "CLASS-WRK-MALE-CNTS12",
       "class" . "x-bilingual"                        AS "CLASS-X-BILINGUAL",
       "class" . "ss-class"                           AS
       "CLASS-SUMMERSCHOOL-CLASS",
       "class" . "x-consecutive-prds"                 AS
       "CLASS-X-CONSECUTIVE-PRDS",
       "class" . "clas-nbr-est-stds"                  AS "CLASS-NBR-EST-STDS",
       "class" . "spec-ed-limit"                      AS "CLASS-SPEC-ED-LIMIT",
       "class" . "clas-minutes-per-week"              AS "CLASS-MINUTES-PER-WEEK"
       ,
       "class" . "course-flag"                        AS
       "CLASS-COURSE-FLAG",
       "class" . "bell-schedule-id"                   AS "CLASS-BELL-SCHEDULE-ID"
       ,
       "CLASS_MEET" . "dsp-str-trm"                   AS
       "CLASS-MEET-DSP-STR-TRM",
       "CLASS_MEET" . "dsp-stp-trm"                   AS "CLASS-MEET-DSP-STP-TRM"
       ,
       "CLASS_MEET" . "dsp-period"                    AS
       "CLASS-MEET-DSP-PERIOD",
       "CLASS_MEET" . "clas-lun-code"                 AS
       "CLASS-MEET-CLAS-LUN-CODE",
       "CLASS_MEET" . "dsp-day-nbr"                   AS "CLASS-MEET-DSP-DAY-NBR"
       ,
       "CLASS_MEET" . "dsp-days-meet"                 AS
       "CLASS-MEET-DSP-DAYS-MEET",
       "CLASS_MEET" . "sch-str-trm"                   AS "CLASS-MEET-SCH-STR-TRM"
       ,
       "CLASS_MEET" . "sch-stp-trm"                   AS
       "CLASS-MEET-SCH-STP-TRM",
       "CLASS_MEET" . "sch-period"                    AS "CLASS-MEET-SCH-PERIOD",
       "CLASS_MEET" . "sch-day-nbr"                   AS "CLASS-MEET-SCH-DAY-NBR"
       ,
       "CLASS_MEET" . "sch-days-meet"                 AS
       "CLASS-MEET-SCH-DAYS-MEET",
       "CLASS_MEET" . "atn-period"                    AS "CLASS-MEET-ATN-PERIOD",
       "CLASS_MEET" . "atn-day-nbr"                   AS "CLASS-MEET-ATN-DAY-NBR"
       ,
       "CLASS_MEET" . "atn-days-meet"                 AS
       "CLASS-MEET-ATN-DAYS-MEET",
       "CLASS_MEET" . "room-number"                   AS "CLASS-MEET-ROOM-NUMBER"
       ,
       "CLASS_MEET" . "tchr-prime-flag"               AS
       "CLASS-MEET-TCHR-PRIMARY",
       "CLASS_MEET" . "clas-str-time"                 AS
       "CLASS-MEET-CLAS-STR-TIME",
       "CLASS_MEET" . "clas-stp-time"                 AS
       "CLASS-MEET-CLAS-STP-TIME",
       "CLASS_MEET" . "time-type"                     AS "CLASS-MEET-TIME-TYPE",
       "CLASS_MEET" . "x-print-meet"                  AS
       "CLASS-MEET-X-PRINT-MEET",
       "CLASS_MEET" . "cert-status"                   AS "CLASS-MEET-CERT-STATUS"
       ,
       "CLASS_MEET" . "highly-qualified"              AS
       "CLASS-MEET-HIGHLY-QUALIFD",
       "CLASS_MEET" . "team-teacher-training"         AS
       "CLASS-MEET-TEAMTCHR-TRAIN",
       "building" . "building-id"                     AS "BUILDING-ID",
       "building" . "building-sdesc"                  AS "BUILDING-SDESC",
       "building" . "building-ldesc"                  AS "BUILDING-LDESC",
       "course" . "cor-alphakey"                      AS "COURSE-COR-ALPHAKEY",
       "course" . "cor-status"                        AS "COURSE-STATUS",
       "course" . "cor-sdesc"                         AS "COURSE-SDESC",
       "course" . "cor-ldesc"                         AS "COURSE-LDESC",
       "course" . "cor-length-set-id"                 AS "COURSE-LENGTH-SET-ID",
       "course" . "subject-id"                        AS "COURSE-SUBJECT-ID",
       "course" . "department-id"                     AS "COURSE-DEPARTMENT-ID",
       "course" . "course-type-id"                    AS "COURSE-TYPE-ID",
       "course" . "cor-reg-lun-stdy-tran"             AS
       "COURSE-REG-LUN-STDY-TRAN",
       "course" . "cor-has-attendance"                AS "COURSE-HAS-ATTENDANCE",
       "course" . "cor-has-grades"                    AS "COURSE-HAS-GRADES",
       "course" . "cor-req-elec"                      AS "COURSE-REQ-ELEC",
       "course" . "cor-schd-type"                     AS "COURSE-SCHD-TYPE",
       "course" . "cor-grd-rng-low"                   AS "COURSE-GRD-RNG-LOW",
       "course" . "cor-grd-rng-high"                  AS "COURSE-GRD-RNG-HIGH",
       "course" . "cor-credits-good"                  AS "COURSE-CREDITS-GOOD",
       "course" . "cor-fee"                           AS "COURSE-FEE",
       "course" . "cor-academic-hours"                AS "COURSE-ACADEMIC-HOURS",
       "course" . "report-card-grp-id"                AS
       "COURSE-REPORT-CARD-GRP-ID",
       "course" . "cor-cat-num-id"                    AS "COURSE-CAT-NUM-ID",
       "course" . "trn-grd-lvl-ovr"                   AS "COURSE-TRN-GRD-LVL-OVR"
       ,
       "course" . "cor-repeatable"                    AS
       "COURSE-REPEATABLE",
       "course" . "certification-req"                 AS
       "COURSE-CERTIFICATION-REQ",
       "course" . "cor-core"                          AS "COURSE-CORE",
       "course" . "x-allow-gpa-set-override"          AS
       "COURSE-X-GPA-SET-OVRRDE",
       "course" . "cor-grade-system"                  AS "COURSE-GRADE-SYSTEM",
       "course" . "cor-grade-type"                    AS "COURSE-GRADE-TYPE",
       "course" . "cor-academic-minutes"              AS
       "COURSE-ACADEMIC-MINUTES",
       "course" . "reading-intervention"              AS
       "COURSE-RDING-INTERVENTION",
       "COURSE_TYPE" . "course-type-sdesc"            AS "COURSE-TYPE-SDESC",
       "COURSE_TYPE" . "course-type-ldesc"            AS "COURSE-TYPE-LDESC",
       "NAME_TCHR" . "first-name"                     AS "TCHR-FIRST-NAME",
       "NAME_TCHR" . "middle-name"                    AS "TCHR-MIDDLE-NAME",
       "NAME_TCHR" . "last-name"                      AS "TCHR-LAST-NAME",
       "NAME_TCHR" . "nalphakey"                      AS "TCHR-ALPHAKEY",
       "NAME_TCHR" . "internet-address"               AS "TCHR-EMAIL-ADDRESS",
       "NAME_TCHR" . "birthdate"                      AS "TCHR-BIRTHDATE",
       "NAME_TCHR" . "gender"                         AS "TCHR-GENDER",
       "NAME_TCHR" . "salutation-id"                  AS "TCHR-SALUTATION",
       "NAME_TCHR" . "name-suffix-id"                 AS "TCHR-NAME-SUFFIX",
       "NAME_STU" . "first-name"                      AS "STUNAME-FIRST-NAME",
       "NAME_STU" . "middle-name"                     AS "STUNAME-MIDDLE-NAME",
       "NAME_STU" . "last-name"                       AS "STUNAME-LAST-NAME",
       "NAME_STU" . "nalphakey"                       AS "STUNAME-ALPHAKEY",
       "NAME_STU" . "federal-id-no"                   AS "STUNAME-FEDERAL-ID-NO",
       "NAME_STU" . "internet-address"                AS "STUNAME-EMAIL-ADDRESS",
       "NAME_STU" . "birthdate"                       AS "STUNAME-BIRTHDATE",
       "NAME_STU" . "gender"                          AS "STUNAME-GENDER",
       "NAME_STU" . "language-code"                   AS "STUNAME-LANGUAGE-CODE",
       "NAME_STU" . "salutation-id"                   AS "STUNAME-SALUTATION",
       "NAME_STU" . "name-suffix-id"                  AS "STUNAME-SUFFIX",
       "NAME_STU" . "birth-place"                     AS "STUNAME-BIRTH-PLACE",
       "language" . "language-sdesc"                  AS "LANGUAGE-SDESC",
       "language" . "language-ldesc"                  AS "LANGUAGE-LDESC",
       "subject" . "subject-sdesc"                    AS "SUBJECT-SDESC",
       "subject" . "subject-ldesc"                    AS "SUBJECT-LDESC",
       "department" . "department-sdesc"              AS "DEPARTMENT-SDESC",
       "department" . "department-ldesc"              AS "DEPARTMENT-LDESC",
       "COR_LENGTH_SET" . "cor-length-sdesc"          AS "COR-LENGTH-SET-SDESC",
       "COR_LENGTH_SET" . "cor-length-ldesc"          AS "COR-LENGTH-SET-LDESC",
       "CLAS_CONTROL_SET" . "control-set-ref"         AS "CCS-CONTROL-SET-REF",
       "CLAS_CONTROL_SET" . "ccs-desc"                AS "CCS-DESC",
       "CLAS_CONTROL_SET" . "ccs-atnd-str-dte"        AS "CCS-ATND-STR-DTE",
       "CLAS_CONTROL_SET" . "ccs-atnd-stp-dte"        AS "CCS-ATND-STP-DTE",
       "CLAS_CONTROL_SET" . "ccs-dsp-trm-lit"         AS "CCS-DSP-TRM-LIT",
       "CLAS_CONTROL_SET" . "ccs-dsp-nbr-trms"        AS "CCS-DSP-NBR-TRMS",
       "CLAS_CONTROL_SET" . "ccs-dsp-str-trm"         AS "CCS-DSP-STR-TRM",
       "CLAS_CONTROL_SET" . "ccs-dsp-stp-trm"         AS "CCS-DSP-STP-TRM",
       "CLAS_CONTROL_SET" . "ccs-sch-nbr-trms"        AS "CCS-SCH-NBR-TRMS",
       "CLAS_CONTROL_SET" . "ccs-sch-str-trm"         AS "CCS-SCH-STR-TRM",
       "CLAS_CONTROL_SET" . "ccs-sch-stp-trm"         AS "CCS-SCH-STP-TRM",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 1 ]  AS "CCS-SEM-USE-TRMS1",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 2 ]  AS "CCS-SEM-USE-TRMS2",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 3 ]  AS "CCS-SEM-USE-TRMS3",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 4 ]  AS "CCS-SEM-USE-TRMS4",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 5 ]  AS "CCS-SEM-USE-TRMS5",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 6 ]  AS "CCS-SEM-USE-TRMS6",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 7 ]  AS "CCS-SEM-USE-TRMS7",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 8 ]  AS "CCS-SEM-USE-TRMS8",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 9 ]  AS "CCS-SEM-USE-TRMS9",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 10 ] AS "CCS-SEM-USE-TRMS10",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 11 ] AS "CCS-SEM-USE-TRMS11",
"CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 12 ] AS "CCS-SEM-USE-TRMS12"
FROM   "SKYWARD" . "PUB" . "entity"
       inner join "SKYWARD" . "PUB" . "student-entity" "STUDENT_ENTITY"
               ON "entity" . "entity-id" = "STUDENT_ENTITY" . "entity-id"
       inner join "SKYWARD" . "PUB" . "student"
               ON "STUDENT_ENTITY" . "student-id" = "student" . "student-id"
       inner join "SKYWARD" . "PUB" . "student-class" "STUDENT_CLASS"
               ON "STUDENT_ENTITY" . "student-id" = "STUDENT_CLASS" . "student-id"
                  AND "STUDENT_CLASS" . "school-year" IN (
                          ( "student" . "grad-yr" - 20 ), (
                          "student" . "grad-yr" - 19 ),
                          (
                          "student" . "grad-yr" - 18 ), (
                          "student" . "grad-yr" - 17 ),
                           ( "student" . "grad-yr" - 16
                          ), (
                          "student" . "grad-yr" - 15 ), (
                          "student" . "grad-yr" - 14
                          ), (
                          "student" . "grad-yr" - 13 ),
                                                           (
                          "student" . "grad-yr" - 12
                          ), (
                          "student" . "grad-yr" - 11 ), (
                          "student" . "grad-yr" - 10
                          ), (
                          "student" . "grad-yr" - 9 ),
                                                           (
                          "student" . "grad-yr" - 8 )
                          , (
                          "student" . "grad-yr" - 7 ), (
                          "student" . "grad-yr" - 6 )
                          , (
                          "student" . "grad-yr" - 5 ),
                                                           (
                          "student" . "grad-yr" - 4 )
                          , (
                          "student" . "grad-yr" - 3 ), (
                          "student" . "grad-yr" - 2 )
                          , (
                          "student" . "grad-yr" - 1 ),
                                                           (
                          "student" . "grad-yr" ), (
                          "student" . "grad-yr" + 1 ), (
                          "student" . "grad-yr" + 2 )
                          , (
                          "student" . "grad-yr" + 3 ),
                                                           (
                          "student" . "grad-yr" + 4 )
                          , (
                          "student" . "grad-yr" + 5 ), (
                          "student" . "grad-yr" + 6 )
                          , (
                          "student" . "grad-yr" + 7 ),
                                                           (
                          "student" . "grad-yr" + 8 )
                          , (
                          "student" . "grad-yr" + 9 ), (
                          "student" . "grad-yr" + 10
                          ), (
                          "student" . "grad-yr" + 11 ),
                                                           (
                          "student" . "grad-yr" + 12
                          ), (
                          "student" . "grad-yr" + 13 ), (
                          "student" . "grad-yr" + 14
                          ), (
                          "student" . "grad-yr" + 15 ),
                                                           (
                          "student" . "grad-yr" + 16
                          ), (
                          "student" . "grad-yr" + 17 ), (
                          "student" . "grad-yr" + 18
                          ), (
                          "student" . "grad-yr" + 19 ), (
                          "student" . "grad-yr" + 20
                                                        ) )
                  AND "STUDENT_ENTITY" . "entity-id" =
                      "STUDENT_CLASS" . "entity-id"
       left outer join "SKYWARD" . "PUB" . "class" "CLASS"
                    ON "STUDENT_CLASS" . "cor-num-id" = "class" . "cor-num-id"
                       AND "STUDENT_CLASS" . "track" = "class" . "track"
                       AND "STUDENT_CLASS" . "clas-section" =
                           "class" . "clas-section"
       left outer join "SKYWARD" . "PUB" . "class-meet" "CLASS_MEET"
                    ON "class" . "cor-num-id" = "CLASS_MEET" . "cor-num-id"
                       AND "class" . "track" = "CLASS_MEET" . "track"
                       AND "class" . "clas-section" =
                           "CLASS_MEET" . "clas-section"
       left outer join "SKYWARD" . "PUB" . "building" "BUILDING"
                    ON "CLASS_MEET" . "building-id" = "building" . "building-id"
       inner join "SKYWARD" . "PUB" . "course" "COURSE"
               ON "STUDENT_CLASS" . "cor-num-id" = "course" . "cor-num-id"
       left outer join "SKYWARD" . "PUB" . "course-type" "COURSE_TYPE"
                    ON "course" . "entity-id" = "COURSE_TYPE" . "entity-id"
                       AND "course" . "course-type-id" =
                           "COURSE_TYPE" . "course-type-id"
       left outer join "SKYWARD" . "PUB" . "name" "NAME_TCHR"
                    ON "CLASS_MEET" . "name-id" = "NAME_TCHR" . "name-id"
       left outer join "SKYWARD" . "PUB" . "homeroom" "HOMEROOM"
                    ON "STUDENT_ENTITY" . "entity-id" = "homeroom" . "entity-id"
                       AND "STUDENT_CLASS" . "school-year" =
                           "homeroom" . "school-year"
                       AND "STUDENT_ENTITY" . "homeroom-number" =
                           "homeroom" . "homeroom-number"
       left outer join "SKYWARD" . "PUB" . "name" "NAME_HR"
                    ON "homeroom" . "homeroom-teacher" = "NAME_HR" . "name-id"
       left outer join "SKYWARD" . "PUB" . "name" "NAME_ADV"
                    ON "STUDENT_ENTITY" . "advisor" = "NAME_ADV" . "name-id"
       left outer join "SKYWARD" . "PUB" . "name" "NAME_SE_TCHR_OF_REC"
                    ON "STUDENT_ENTITY" . "se-tchr-of-record" =
                       "NAME_SE_TCHR_OF_REC" . "name-id"
       left outer join "SKYWARD" . "PUB" . "name" "NAME_DISC"
                    ON "STUDENT_ENTITY" . "dis-officer" = "NAME_DISC" . "name-id"
       inner join "SKYWARD" . "PUB" . "name" "NAME_STU"
               ON "student" . "name-id" = "NAME_STU" . "name-id"
       inner join "SKYWARD" . "PUB" . "language" "LANGUAGE"
               ON "NAME_STU" . "language-code" = "language" . "language-code"
       left outer join "SKYWARD" . "PUB" . "subject" "SUBJECT"
                    ON "course" . "entity-id" = "subject" . "entity-id"
                       AND "course" . "school-year" = "subject" . "school-year"
                       AND "course" . "subject-id" = "subject" . "subject-id"
       left outer join "SKYWARD" . "PUB" . "department" "DEPARTMENT"
                    ON "course" . "entity-id" = "department" . "entity-id"
                       AND "course" . "school-year" = "department" . "school-year"
                       AND "course" . "department-id" =
                           "department" . "department-id"
       left outer join "SKYWARD" . "PUB" . "cor-length-set" "COR_LENGTH_SET"
                    ON "course" . "entity-id" = "COR_LENGTH_SET" . "entity-id"
                       AND "course" . "school-year" =
                           "COR_LENGTH_SET" . "school-year"
                       AND "course" . "cor-length-set-id" =
                           "COR_LENGTH_SET" . "cor-length-set-id"
       left outer join "SKYWARD" . "PUB" . "clas-control-set" "CLAS_CONTROL_SET"
                    ON "STUDENT_CLASS" . "entity-id" =
                       "CLAS_CONTROL_SET" . "entity-id"
                       AND "STUDENT_CLASS" . "school-year" =
                           "CLAS_CONTROL_SET" . "school-year"
                       AND "course" . "cor-length-set-id" =
                           "CLAS_CONTROL_SET" . "cor-length-set-id"
                       AND "STUDENT_CLASS" . "track" =
                           "CLAS_CONTROL_SET" . "track"
                       AND "class" . "control-set-id" =
                           "CLAS_CONTROL_SET" . "control-set-id"
                       AND "CLAS_CONTROL_SET" . "control-set-ref" = 0 
) a inner join PUB."NAME" b on a."TCHR-ALPHAKEY" = b."NALPHAKEY"
WHERE a."StU-CLASS-SCHOOL-YEAR" = 2023
and a."STU-ENTITY-ENTITY-ID" is not null
with (nolock)

Click to copy

Roster

select 
	distinct
		  a."COURSE-COR-ALPHAKEY" as 'course_id',
  rtrim(cast(a."STU-CLASS-COR-NUM-ID" as char(10))) + '.' +  rtrim(cast(a."STU-CLASS-CLAS-SECTION" as char(10))) as 'section_id',
  a."STUDENT-OTHER-ID" as 'student_id'
from (
SELECT "student" . "student-id"                       AS "STUDENT-ID",
       "student" . "other-id"                         AS "STUDENT-OTHER-ID",
       "student" . "alphakey"                         AS "STUDENT-ALPHAKEY",
       "student" . "other-name"                       AS "STUDENT-OTHER-NAME",
       "student" . "internet-address"                 AS "STUDENT-EMAIL-ADDRESS",
       "student" . "library-card-no"                  AS
       "STUDENT-LIBRARY-CARD-NO",
       "student" . "grad-yr"                          AS "STUDENT-GRAD-YR",
       "student" . "nxt-grad-yr"                      AS "STUDENT-NXT-GRAD-YR",
       "student" . "student-ecp"                      AS "STUDENT-ECP",
       "student" . "graduated"                        AS "STUDENT-GRADUATED",
       "student" . "retained"                         AS "STUDENT-RETAINED",
       "student" . "advance"                          AS "STUDENT-ADVANCE",
       "student" . "resident"                         AS "STUDENT-RESIDENT",
       "student" . "district-code"                    AS "STUDENT-DISTRICT-CODE",
       "student" . "attendance-area"                  AS
       "STUDENT-ATTENDANCE-AREA",
       "student" . "feeder-school-id"                 AS
       "STUDENT-FEEDER-SCHOOL-ID",
       "student" . "mn-ede-nbr"                       AS "STUDENT-MN-EDE-NBR",
       "student" . "path-id"                          AS "STUDENT-PATH-ID",
       "student" . "nxt-yr-sch-flag"                  AS
       "STUDENT-NXT-YR-SCH-FLAG",
       "student" . "graduation-date"                  AS
       "STUDENT-GRADUATION-DATE",
       "student" . "full-name-lfm"                    AS "STUDENT-FULL-NAME-LFM",
       "STUDENT_ENTITY" . "entity-id"                 AS "STU-ENTITY-ENTITY-ID",
       "STUDENT_ENTITY" . "school-id"                 AS "STU-ENTITY-SCHOOL-ID",
       "STUDENT_ENTITY" . "homeroom-number"           AS
       "STU-ENTITY-HMROOM-NUMBER",
       "STUDENT_ENTITY" . "x-default-entity"          AS
       "STU-ENTITY-X-DEFLT-ENTITY",
       "STUDENT_ENTITY" . "student-status"            AS
       "STU-ENTITY-STUDENT-STATUS",
       "STUDENT_ENTITY" . "student-ny-status"         AS "STU-ENTITY-NY-STATUS",
       "STUDENT_ENTITY" . "student-full-part"         AS "STU-ENTITY-FULL-PART",
       "STUDENT_ENTITY" . "student-percent-enrolled"  AS
       "STU-ENTITY-PRCNT-ENROLLED",
       "STUDENT_ENTITY" . "student-incl-honor-roll"   AS
       "STU-ENTITY-INCL-HNR-ROLL",
       "STUDENT_ENTITY" . "student-cy-member"         AS "STU-ENTITY-CY-MEMBER",
       "STUDENT_ENTITY" . "student-entity-id"         AS
       "STU-ENTITY-UDF-STU-ENT-ID",
       "STUDENT_ENTITY" . "stu-promoted-retained"     AS
       "STU-ENTITY-PRMTD-RETAINED",
       "STUDENT_ENTITY" . "promote-status"            AS
       "STU-ENTITY-PROMOTE-STATUS",
       "homeroom" . "room-number"                     AS "HOMEROOM-ROOM-NUMBER",
       "NAME_HR" . "first-name"                       AS "HR-TEACH-FIRST-NAME",
       "NAME_HR" . "middle-name"                      AS "HR-TEACH-MIDDLE-NAME",
       "NAME_HR" . "last-name"                        AS "HR-TEACH-LAST-NAME",
       "NAME_HR" . "nalphakey"                        AS "HR-TEACH-ALPHAKEY",
       "NAME_HR" . "internet-address"                 AS "HR-TEACH-EMAIL-ADDRESS"
       ,
       "NAME_HR" . "birthdate"                        AS
       "HR-TEACH-BIRTHDATE",
       "NAME_HR" . "gender"                           AS "HR-TEACH-GENDER",
       "NAME_HR" . "salutation-id"                    AS "HR-TEACH-SALUTATION",
       "NAME_HR" . "name-suffix-id"                   AS "HR-TEACH-SUFFIX",
       "NAME_ADV" . "first-name"                      AS "ADVISOR-FIRST-NAME",
       "NAME_ADV" . "middle-name"                     AS "ADVISOR-MIDDLE-NAME",
       "NAME_ADV" . "last-name"                       AS "ADVISOR-LAST-NAME",
       "NAME_ADV" . "nalphakey"                       AS "ADVISOR-ALPHAKEY",
       "NAME_ADV" . "internet-address"                AS "ADVISOR-EMAIL-ADDRESS",
       "NAME_ADV" . "birthdate"                       AS "ADVISOR-BIRTHDATE",
       "NAME_ADV" . "gender"                          AS "ADVISOR-GENDER",
       "NAME_ADV" . "salutation-id"                   AS "ADVISOR-SALUTATION",
       "NAME_ADV" . "name-suffix-id"                  AS "ADVISOR-SUFFIX",
       "NAME_SE_TCHR_OF_REC" . "first-name"           AS "TCHR-OF-REC-FIRST-NAME"
       ,
       "NAME_SE_TCHR_OF_REC" . "middle-name"          AS
       "TCHR-OF-REC-MIDDLE-NAME",
       "NAME_SE_TCHR_OF_REC" . "last-name"            AS "TCHR-OF-REC-LAST-NAME",
       "NAME_SE_TCHR_OF_REC" . "nalphakey"            AS "TCHR-OF-REC-ALPHAKEY",
       "NAME_SE_TCHR_OF_REC" . "internet-address"     AS
       "TCHR-OF-REC-EMAIL-ADDRESS",
       "NAME_SE_TCHR_OF_REC" . "birthdate"            AS "TCHR-OF-REC-BIRTHDATE",
       "NAME_SE_TCHR_OF_REC" . "gender"               AS "TCHR-OF-REC-GENDER",
       "NAME_SE_TCHR_OF_REC" . "salutation-id"        AS "TCHR-OF-REC-SALUTATION"
       ,
       "NAME_SE_TCHR_OF_REC" . "name-suffix-id"       AS
       "TCHR-OF-REC-SUFFIX",
       "NAME_DISC" . "first-name"                     AS "DISC-OFCR-FIRST-NAME",
       "NAME_DISC" . "middle-name"                    AS "DISC-OFCR-MIDDLE-NAME",
       "NAME_DISC" . "last-name"                      AS "DISC-OFCR-LAST-NAME",
       "NAME_DISC" . "nalphakey"                      AS "DISC-OFCR-ALPHAKEY",
       "NAME_DISC" . "internet-address"               AS
       "DISC-OFCR-EMAIL-ADDRESS",
       "NAME_DISC" . "birthdate"                      AS "DISC-OFCR-BIRTHDATE",
       "NAME_DISC" . "gender"                         AS "DISC-OFCR-GENDER",
       "NAME_DISC" . "salutation-id"                  AS "DISC-OFCR-SALUTATION",
       "NAME_DISC" . "name-suffix-id"                 AS "DISC-OFCR-SUFFIX",
       "entity" . "entity-name"                       AS "ENTITY-NAME",
       "entity" . "school-year"                       AS "ENTITY-SCHOOL-YEAR",
       "STUDENT_CLASS" . "cor-num-id"                 AS "STU-CLASS-COR-NUM-ID",
       "STUDENT_CLASS" . "track"                      AS "STU-CLASS-TRACK",
       "STUDENT_CLASS" . "clas-section"               AS "STU-CLASS-CLAS-SECTION"
       ,
       "STUDENT_CLASS" . "alphakey"                   AS
       "STU-CLASS-ALPHAKEY",
       "STUDENT_CLASS" . "school-year"                AS "STU-CLASS-SCHOOL-YEAR",
       "STUDENT_CLASS" . "schd-str-trm"               AS "STU-CLASS-SCHD-STR-TRM"
       ,
       "STUDENT_CLASS" . "schd-stp-trm"               AS
       "STU-CLASS-SCHD-STP-TRM",
       "STUDENT_CLASS" . "schd-record-type"           AS
       "STU-CLASS-SCHD-RECORD-TYPE",
       "STUDENT_CLASS" . "schd-status"                AS "STU-CLASS-SCHD-STATUS",
       "STUDENT_CLASS" . "schd-hst-grad-year"         AS
       "STU-CLASS-SCHD-HST-GRAD-YEAR",
       "STUDENT_CLASS" . "schd-hst-ecp"               AS "STU-CLASS-SCHD-HST-ECP"
       ,
       "STUDENT_CLASS" . "schd-ytd-earn-crds"         AS
       "STU-CLASS-SCHD-YTD-EARN-CRDS",
       "STUDENT_CLASS" . "schd-ytd-fail-crds"         AS
       "STU-CLASS-SCHD-YTD-FAIL-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-CRDS" [ 1 ]    AS
       "STU-CLASS-SCHD-YTD-GPA1-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-CRDS" [ 2 ]    AS
       "STU-CLASS-SCHD-YTD-GPA2-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-CRDS" [ 3 ]    AS
       "STU-CLASS-SCHD-YTD-GPA3-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-CRDS" [ 4 ]    AS
       "STU-CLASS-SCHD-YTD-GPA4-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-CRDS" [ 5 ]    AS
       "STU-CLASS-SCHD-YTD-GPA5-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-CRDS" [ 6 ]    AS
       "STU-CLASS-SCHD-YTD-GPA6-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-CRDS" [ 7 ]    AS
       "STU-CLASS-SCHD-YTD-GPA7-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-CRDS" [ 8 ]    AS
       "STU-CLASS-SCHD-YTD-GPA8-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-CRDS" [ 9 ]    AS
       "STU-CLASS-SCHD-YTD-GPA9-CRDS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-PNTS" [ 1 ]    AS
       "STU-CLASS-SCHD-YTD-GPA1-PNTS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-PNTS" [ 2 ]    AS
       "STU-CLASS-SCHD-YTD-GPA2-PNTS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-PNTS" [ 3 ]    AS
       "STU-CLASS-SCHD-YTD-GPA3-PNTS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-PNTS" [ 4 ]    AS
       "STU-CLASS-SCHD-YTD-GPA4-PNTS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-PNTS" [ 5 ]    AS
       "STU-CLASS-SCHD-YTD-GPA5-PNTS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-PNTS" [ 6 ]    AS
       "STU-CLASS-SCHD-YTD-GPA6-PNTS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-PNTS" [ 7 ]    AS
       "STU-CLASS-SCHD-YTD-GPA7-PNTS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-PNTS" [ 8 ]    AS
       "STU-CLASS-SCHD-YTD-GPA8-PNTS",
       "STUDENT_CLASS" . "SCHD-YTD-GPA-PNTS" [ 9 ]    AS
       "STU-CLASS-SCHD-YTD-GPA9-PNTS",
       "STUDENT_CLASS" . "GRD-SEM-EXM-MRK" [ 1 ]      AS
       "STU-CLASS-GRD-SEM-EXM-MRK1",
       "STUDENT_CLASS" . "GRD-SEM-EXM-MRK" [ 2 ]      AS
       "STU-CLASS-GRD-SEM-EXM-MRK2",
       "STUDENT_CLASS" . "GRD-SEM-EXM-MRK" [ 3 ]      AS
       "STU-CLASS-GRD-SEM-EXM-MRK3",
       "STUDENT_CLASS" . "GRD-SEM-EXM-MRK" [ 4 ]      AS
       "STU-CLASS-GRD-SEM-EXM-MRK4",
       "STUDENT_CLASS" . "GRD-SEM-MRK" [ 1 ]          AS "STU-CLASS-GRD-SEM-MRK1"
       ,
       "STUDENT_CLASS" . "GRD-SEM-MRK" [ 2 ]          AS
       "STU-CLASS-GRD-SEM-MRK2",
       "STUDENT_CLASS" . "GRD-SEM-MRK" [ 3 ]          AS "STU-CLASS-GRD-SEM-MRK3"
       ,
       "STUDENT_CLASS" . "GRD-SEM-MRK" [ 4 ]          AS
       "STU-CLASS-GRD-SEM-MRK4",
       "STUDENT_CLASS" . "grd-fnl-exm-mrk"            AS
       "STU-CLASS-GRD-FNL-EXM-MRK",
       "STUDENT_CLASS" . "grd-fnl-mrk"                AS "STU-CLASS-GRD-FNL-MRK",
       "STUDENT_CLASS" . "grd-ath-mrk"                AS "STU-CLASS-GRD-ATH-MRK",
       "STUDENT_CLASS" . "grd-ath-eff-date"           AS
       "STU-CLASS-GRD-ATH-EFF-DATE",
       "STUDENT_CLASS" . "duser-id"                   AS "STU-CLASS-DUSER-ID",
       "STUDENT_CLASS" . "grd-ath-trn-date"           AS
       "STU-CLASS-GRD-ATH-TRN-DATE",
       "STUDENT_CLASS" . "grd-oth-mrk"                AS "STU-CLASS-GRD-OTH-MRK",
       "STUDENT_CLASS" . "grd-oth-eff-date"           AS
       "STU-CLASS-GRD-OTH-EFF-DATE",
       "STUDENT_CLASS" . "grd-oth-duser-id"           AS
       "STU-CLASS-GRD-OTH-DUSER-ID",
       "STUDENT_CLASS" . "grd-oth-trn-date"           AS
       "STU-CLASS-GRD-OTH-TRN-DATE",
       "STUDENT_CLASS" . "seat"                       AS "STU-CLASS-SEAT",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 1 ]         AS
       "STU-CLASS-SCHD-TRM-ABS1",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 2 ]         AS
       "STU-CLASS-SCHD-TRM-ABS2",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 3 ]         AS
       "STU-CLASS-SCHD-TRM-ABS3",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 4 ]         AS
       "STU-CLASS-SCHD-TRM-ABS4",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 5 ]         AS
       "STU-CLASS-SCHD-TRM-ABS5",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 6 ]         AS
       "STU-CLASS-SCHD-TRM-ABS6",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 7 ]         AS
       "STU-CLASS-SCHD-TRM-ABS7",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 8 ]         AS
       "STU-CLASS-SCHD-TRM-ABS8",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 9 ]         AS
       "STU-CLASS-SCHD-TRM-ABS9",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 10 ]        AS
       "STU-CLASS-SCHD-TRM-ABS10",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 11 ]        AS
       "STU-CLASS-SCHD-TRM-ABS11",
       "STUDENT_CLASS" . "SCHD-TRM-ABS" [ 12 ]        AS
       "STU-CLASS-SCHD-TRM-ABS12",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 1 ]         AS
       "STU-CLASS-SCHD-TRM-TDY1",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 2 ]         AS
       "STU-CLASS-SCHD-TRM-TDY2",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 3 ]         AS
       "STU-CLASS-SCHD-TRM-TDY3",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 4 ]         AS
       "STU-CLASS-SCHD-TRM-TDY4",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 5 ]         AS
       "STU-CLASS-SCHD-TRM-TDY5",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 6 ]         AS
       "STU-CLASS-SCHD-TRM-TDY6",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 7 ]         AS
       "STU-CLASS-SCHD-TRM-TDY7",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 8 ]         AS
       "STU-CLASS-SCHD-TRM-TDY8",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 9 ]         AS
       "STU-CLASS-SCHD-TRM-TDY9",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 10 ]        AS
       "STU-CLASS-SCHD-TRM-TDY10",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 11 ]        AS
       "STU-CLASS-SCHD-TRM-TDY11",
       "STUDENT_CLASS" . "SCHD-TRM-TDY" [ 12 ]        AS
       "STU-CLASS-SCHD-TRM-TDY12",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 1 ]      AS
       "STU-CLASS-GRD-CITZ-MRK1",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 2 ]      AS
       "STU-CLASS-GRD-CITZ-MRK2",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 3 ]      AS
       "STU-CLASS-GRD-CITZ-MRK3",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 4 ]      AS
       "STU-CLASS-GRD-CITZ-MRK4",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 5 ]      AS
       "STU-CLASS-GRD-CITZ-MRK5",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 6 ]      AS
       "STU-CLASS-GRD-CITZ-MRK6",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 7 ]      AS
       "STU-CLASS-GRD-CITZ-MRK7",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 8 ]      AS
       "STU-CLASS-GRD-CITZ-MRK8",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 9 ]      AS
       "STU-CLASS-GRD-CITZ-MRK9",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 10 ]     AS
       "STU-CLASS-GRD-CITZ-MRK10",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 11 ]     AS
       "STU-CLASS-GRD-CITZ-MRK11",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 12 ]     AS
       "STU-CLASS-GRD-CITZ-MRK12",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 13 ]     AS
       "STU-CLASS-GRD-CITZ-MRK13",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 14 ]     AS
       "STU-CLASS-GRD-CITZ-MRK14",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 15 ]     AS
       "STU-CLASS-GRD-CITZ-MRK15",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 16 ]     AS
       "STU-CLASS-GRD-CITZ-MRK16",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 17 ]     AS
       "STU-CLASS-GRD-CITZ-MRK17",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 18 ]     AS
       "STU-CLASS-GRD-CITZ-MRK18",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 19 ]     AS
       "STU-CLASS-GRD-CITZ-MRK19",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 20 ]     AS
       "STU-CLASS-GRD-CITZ-MRK20",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 21 ]     AS
       "STU-CLASS-GRD-CITZ-MRK21",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 22 ]     AS
       "STU-CLASS-GRD-CITZ-MRK22",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 23 ]     AS
       "STU-CLASS-GRD-CITZ-MRK23",
       "STUDENT_CLASS" . "GRD-CITIZEN-MRK" [ 24 ]     AS
       "STU-CLASS-GRD-CITZ-MRK24",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 1 ]      AS
       "STU-CLASS-GRD-MDTRM-MRK1",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 2 ]      AS
       "STU-CLASS-GRD-MDTRM-MRK2",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 3 ]      AS
       "STU-CLASS-GRD-MDTRM-MRK3",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 4 ]      AS
       "STU-CLASS-GRD-MDTRM-MRK4",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 5 ]      AS
       "STU-CLASS-GRD-MDTRM-MRK5",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 6 ]      AS
       "STU-CLASS-GRD-MDTRM-MRK6",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 7 ]      AS
       "STU-CLASS-GRD-MDTRM-MRK7",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 8 ]      AS
       "STU-CLASS-GRD-MDTRM-MRK8",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 9 ]      AS
       "STU-CLASS-GRD-MDTRM-MRK9",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 10 ]     AS
       "STU-CLASS-GRD-MDTRM-MRK10",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 11 ]     AS
       "STU-CLASS-GRD-MDTRM-MRK11",
       "STUDENT_CLASS" . "GRD-MID-TRM-MRK" [ 12 ]     AS
       "STU-CLASS-GRD-MDTRM-MRK12",
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 1 ]          AS "STU-CLASS-GRD-TRM-MRK1"
       ,
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 2 ]          AS
       "STU-CLASS-GRD-TRM-MRK2",
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 3 ]          AS "STU-CLASS-GRD-TRM-MRK3"
       ,
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 4 ]          AS
       "STU-CLASS-GRD-TRM-MRK4",
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 5 ]          AS "STU-CLASS-GRD-TRM-MRK5"
       ,
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 6 ]          AS
       "STU-CLASS-GRD-TRM-MRK6",
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 7 ]          AS "STU-CLASS-GRD-TRM-MRK7"
       ,
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 8 ]          AS
       "STU-CLASS-GRD-TRM-MRK8",
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 9 ]          AS "STU-CLASS-GRD-TRM-MRK9"
       ,
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 10 ]         AS
       "STU-CLASS-GRD-TRM-MRK10",
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 11 ]         AS
       "STU-CLASS-GRD-TRM-MRK11",
       "STUDENT_CLASS" . "GRD-TRM-MRK" [ 12 ]         AS
       "STU-CLASS-GRD-TRM-MRK12",
       "STUDENT_CLASS" . "wgt-schd-add-on"            AS
       "STU-CLASS-WGT-SCHD-ADD-ON",
       "STUDENT_CLASS" . "unused-char-1"              AS "STU-CLASS-SCHOOL-NAME",
       "STUDENT_CLASS" . "schd-ytd-remain-crds"       AS
       "STU-CLASS-YTD-REMAIN-CRDS",
       "STUDENT_CLASS" . "trn-grd-lvl-ovr"            AS
       "STU-CLASS-TRN-GRD-LVL-OVR",
       "STUDENT_CLASS" . "substituted-course"         AS
       "STU-CLASS-SUBSTITUTED-CRS",
       "STUDENT_CLASS" . "course-flag"                AS "STU-CLASS-COURSE-FLAG",
       "STUDENT_CLASS" . "x-do-not-incl-rc-tran"      AS
       "STU-CLASS-NO-INCL-RC-TRAN",
       "class" . "team-schd-id"                       AS "CLASS-TEAM-SCHD-ID",
       "class" . "clas-status"                        AS "CLASS-STATUS",
       "class" . "clas-nbr-stds-opt"                  AS "CLASS-NBR-STDS-OPT",
       "class" . "clas-nbr-stds-max"                  AS "CLASS-NBR-STDS-MAX",
       "class" . "clas-nbr-stds-min"                  AS "CLASS-NBR-STDS-MIN",
       "class" . "control-set-id"                     AS "CLASS-CONTROL-SET-ID",
       "class" . "calendar-id"                        AS "CLASS-CALENDAR-ID",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 1 ]            AS "CLASS-NBR-STDS-ENR1",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 2 ]            AS "CLASS-NBR-STDS-ENR2",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 3 ]            AS "CLASS-NBR-STDS-ENR3",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 4 ]            AS "CLASS-NBR-STDS-ENR4",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 5 ]            AS "CLASS-NBR-STDS-ENR5",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 6 ]            AS "CLASS-NBR-STDS-ENR6",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 7 ]            AS "CLASS-NBR-STDS-ENR7",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 8 ]            AS "CLASS-NBR-STDS-ENR8",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 9 ]            AS "CLASS-NBR-STDS-ENR9",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 10 ]           AS "CLASS-NBR-STDS-ENR10",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 11 ]           AS "CLASS-NBR-STDS-ENR11",
       "CLASS" . "CLAS-NBR-STDS-ENR" [ 12 ]           AS "CLASS-NBR-STDS-ENR12",
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 1 ]         AS "CLASS-WGT-SCHD-ADD-ON1"
       ,
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 2 ]         AS
       "CLASS-WGT-SCHD-ADD-ON2",
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 3 ]         AS "CLASS-WGT-SCHD-ADD-ON3"
       ,
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 4 ]         AS
       "CLASS-WGT-SCHD-ADD-ON4",
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 5 ]         AS "CLASS-WGT-SCHD-ADD-ON5"
       ,
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 6 ]         AS
       "CLASS-WGT-SCHD-ADD-ON6",
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 7 ]         AS "CLASS-WGT-SCHD-ADD-ON7"
       ,
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 8 ]         AS
       "CLASS-WGT-SCHD-ADD-ON8",
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 9 ]         AS "CLASS-WGT-SCHD-ADD-ON9"
       ,
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 10 ]        AS
       "CLASS-WGT-SCHD-ADD-ON10",
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 11 ]        AS
       "CLASS-WGT-SCHD-ADD-ON11",
       "CLASS" . "CLAS-WGT-SCHD-ADD-ON" [ 12 ]        AS
       "CLASS-WGT-SCHD-ADD-ON12",
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 1 ]         AS "CLASS-WRK-FEMALE-CNTS1"
       ,
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 2 ]         AS
       "CLASS-WRK-FEMALE-CNTS2",
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 3 ]         AS "CLASS-WRK-FEMALE-CNTS3"
       ,
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 4 ]         AS
       "CLASS-WRK-FEMALE-CNTS4",
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 5 ]         AS "CLASS-WRK-FEMALE-CNTS5"
       ,
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 6 ]         AS
       "CLASS-WRK-FEMALE-CNTS6",
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 7 ]         AS "CLASS-WRK-FEMALE-CNTS7"
       ,
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 8 ]         AS
       "CLASS-WRK-FEMALE-CNTS8",
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 9 ]         AS "CLASS-WRK-FEMALE-CNTS9"
       ,
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 10 ]        AS
       "CLASS-WRK-FEMALE-CNTS10",
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 11 ]        AS
       "CLASS-WRK-FEMALE-CNTS11",
       "CLASS" . "CLAS-WRK-FEMALE-CNTS" [ 12 ]        AS
       "CLASS-WRK-FEMALE-CNTS12",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 1 ]           AS "CLASS-WRK-MALE-CNTS1",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 2 ]           AS "CLASS-WRK-MALE-CNTS2",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 3 ]           AS "CLASS-WRK-MALE-CNTS3",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 4 ]           AS "CLASS-WRK-MALE-CNTS4",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 5 ]           AS "CLASS-WRK-MALE-CNTS5",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 6 ]           AS "CLASS-WRK-MALE-CNTS6",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 7 ]           AS "CLASS-WRK-MALE-CNTS7",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 8 ]           AS "CLASS-WRK-MALE-CNTS8",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 9 ]           AS "CLASS-WRK-MALE-CNTS9",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 10 ]          AS "CLASS-WRK-MALE-CNTS10",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 11 ]          AS "CLASS-WRK-MALE-CNTS11",
       "CLASS" . "CLAS-WRK-MALE-CNTS" [ 12 ]          AS "CLASS-WRK-MALE-CNTS12",
       "class" . "x-bilingual"                        AS "CLASS-X-BILINGUAL",
       "class" . "ss-class"                           AS
       "CLASS-SUMMERSCHOOL-CLASS",
       "class" . "x-consecutive-prds"                 AS
       "CLASS-X-CONSECUTIVE-PRDS",
       "class" . "clas-nbr-est-stds"                  AS "CLASS-NBR-EST-STDS",
       "class" . "spec-ed-limit"                      AS "CLASS-SPEC-ED-LIMIT",
       "class" . "clas-minutes-per-week"              AS "CLASS-MINUTES-PER-WEEK"
       ,
       "class" . "course-flag"                        AS
       "CLASS-COURSE-FLAG",
       "class" . "bell-schedule-id"                   AS "CLASS-BELL-SCHEDULE-ID"
       ,
       "CLASS_MEET" . "dsp-str-trm"                   AS
       "CLASS-MEET-DSP-STR-TRM",
       "CLASS_MEET" . "dsp-stp-trm"                   AS "CLASS-MEET-DSP-STP-TRM"
       ,
       "CLASS_MEET" . "dsp-period"                    AS
       "CLASS-MEET-DSP-PERIOD",
       "CLASS_MEET" . "clas-lun-code"                 AS
       "CLASS-MEET-CLAS-LUN-CODE",
       "CLASS_MEET" . "dsp-day-nbr"                   AS "CLASS-MEET-DSP-DAY-NBR"
       ,
       "CLASS_MEET" . "dsp-days-meet"                 AS
       "CLASS-MEET-DSP-DAYS-MEET",
       "CLASS_MEET" . "sch-str-trm"                   AS "CLASS-MEET-SCH-STR-TRM"
       ,
       "CLASS_MEET" . "sch-stp-trm"                   AS
       "CLASS-MEET-SCH-STP-TRM",
       "CLASS_MEET" . "sch-period"                    AS "CLASS-MEET-SCH-PERIOD",
       "CLASS_MEET" . "sch-day-nbr"                   AS "CLASS-MEET-SCH-DAY-NBR"
       ,
       "CLASS_MEET" . "sch-days-meet"                 AS
       "CLASS-MEET-SCH-DAYS-MEET",
       "CLASS_MEET" . "atn-period"                    AS "CLASS-MEET-ATN-PERIOD",
       "CLASS_MEET" . "atn-day-nbr"                   AS "CLASS-MEET-ATN-DAY-NBR"
       ,
       "CLASS_MEET" . "atn-days-meet"                 AS
       "CLASS-MEET-ATN-DAYS-MEET",
       "CLASS_MEET" . "room-number"                   AS "CLASS-MEET-ROOM-NUMBER"
       ,
       "CLASS_MEET" . "tchr-prime-flag"               AS
       "CLASS-MEET-TCHR-PRIMARY",
       "CLASS_MEET" . "clas-str-time"                 AS
       "CLASS-MEET-CLAS-STR-TIME",
       "CLASS_MEET" . "clas-stp-time"                 AS
       "CLASS-MEET-CLAS-STP-TIME",
       "CLASS_MEET" . "time-type"                     AS "CLASS-MEET-TIME-TYPE",
       "CLASS_MEET" . "x-print-meet"                  AS
       "CLASS-MEET-X-PRINT-MEET",
       "CLASS_MEET" . "cert-status"                   AS "CLASS-MEET-CERT-STATUS"
       ,
       "CLASS_MEET" . "highly-qualified"              AS
       "CLASS-MEET-HIGHLY-QUALIFD",
       "CLASS_MEET" . "team-teacher-training"         AS
       "CLASS-MEET-TEAMTCHR-TRAIN",
       "building" . "building-id"                     AS "BUILDING-ID",
       "building" . "building-sdesc"                  AS "BUILDING-SDESC",
       "building" . "building-ldesc"                  AS "BUILDING-LDESC",
       "course" . "cor-alphakey"                      AS "COURSE-COR-ALPHAKEY",
       "course" . "cor-status"                        AS "COURSE-STATUS",
       "course" . "cor-sdesc"                         AS "COURSE-SDESC",
       "course" . "cor-ldesc"                         AS "COURSE-LDESC",
       "course" . "cor-length-set-id"                 AS "COURSE-LENGTH-SET-ID",
       "course" . "subject-id"                        AS "COURSE-SUBJECT-ID",
       "course" . "department-id"                     AS "COURSE-DEPARTMENT-ID",
       "course" . "course-type-id"                    AS "COURSE-TYPE-ID",
       "course" . "cor-reg-lun-stdy-tran"             AS
       "COURSE-REG-LUN-STDY-TRAN",
       "course" . "cor-has-attendance"                AS "COURSE-HAS-ATTENDANCE",
       "course" . "cor-has-grades"                    AS "COURSE-HAS-GRADES",
       "course" . "cor-req-elec"                      AS "COURSE-REQ-ELEC",
       "course" . "cor-schd-type"                     AS "COURSE-SCHD-TYPE",
       "course" . "cor-grd-rng-low"                   AS "COURSE-GRD-RNG-LOW",
       "course" . "cor-grd-rng-high"                  AS "COURSE-GRD-RNG-HIGH",
       "course" . "cor-credits-good"                  AS "COURSE-CREDITS-GOOD",
       "course" . "cor-fee"                           AS "COURSE-FEE",
       "course" . "cor-academic-hours"                AS "COURSE-ACADEMIC-HOURS",
       "course" . "report-card-grp-id"                AS
       "COURSE-REPORT-CARD-GRP-ID",
       "course" . "cor-cat-num-id"                    AS "COURSE-CAT-NUM-ID",
       "course" . "trn-grd-lvl-ovr"                   AS "COURSE-TRN-GRD-LVL-OVR"
       ,
       "course" . "cor-repeatable"                    AS
       "COURSE-REPEATABLE",
       "course" . "certification-req"                 AS
       "COURSE-CERTIFICATION-REQ",
       "course" . "cor-core"                          AS "COURSE-CORE",
       "course" . "x-allow-gpa-set-override"          AS
       "COURSE-X-GPA-SET-OVRRDE",
       "course" . "cor-grade-system"                  AS "COURSE-GRADE-SYSTEM",
       "course" . "cor-grade-type"                    AS "COURSE-GRADE-TYPE",
       "course" . "cor-academic-minutes"              AS
       "COURSE-ACADEMIC-MINUTES",
       "course" . "reading-intervention"              AS
       "COURSE-RDING-INTERVENTION",
       "COURSE_TYPE" . "course-type-sdesc"            AS "COURSE-TYPE-SDESC",
       "COURSE_TYPE" . "course-type-ldesc"            AS "COURSE-TYPE-LDESC",
       "NAME_TCHR" . "first-name"                     AS "TCHR-FIRST-NAME",
       "NAME_TCHR" . "middle-name"                    AS "TCHR-MIDDLE-NAME",
       "NAME_TCHR" . "last-name"                      AS "TCHR-LAST-NAME",
       "NAME_TCHR" . "nalphakey"                      AS "TCHR-ALPHAKEY",
       "NAME_TCHR" . "internet-address"               AS "TCHR-EMAIL-ADDRESS",
       "NAME_TCHR" . "birthdate"                      AS "TCHR-BIRTHDATE",
       "NAME_TCHR" . "gender"                         AS "TCHR-GENDER",
       "NAME_TCHR" . "salutation-id"                  AS "TCHR-SALUTATION",
       "NAME_TCHR" . "name-suffix-id"                 AS "TCHR-NAME-SUFFIX",
       "NAME_STU" . "first-name"                      AS "STUNAME-FIRST-NAME",
       "NAME_STU" . "middle-name"                     AS "STUNAME-MIDDLE-NAME",
       "NAME_STU" . "last-name"                       AS "STUNAME-LAST-NAME",
       "NAME_STU" . "nalphakey"                       AS "STUNAME-ALPHAKEY",
       "NAME_STU" . "federal-id-no"                   AS "STUNAME-FEDERAL-ID-NO",
       "NAME_STU" . "internet-address"                AS "STUNAME-EMAIL-ADDRESS",
       "NAME_STU" . "birthdate"                       AS "STUNAME-BIRTHDATE",
       "NAME_STU" . "gender"                          AS "STUNAME-GENDER",
       "NAME_STU" . "language-code"                   AS "STUNAME-LANGUAGE-CODE",
       "NAME_STU" . "salutation-id"                   AS "STUNAME-SALUTATION",
       "NAME_STU" . "name-suffix-id"                  AS "STUNAME-SUFFIX",
       "NAME_STU" . "birth-place"                     AS "STUNAME-BIRTH-PLACE",
       "language" . "language-sdesc"                  AS "LANGUAGE-SDESC",
       "language" . "language-ldesc"                  AS "LANGUAGE-LDESC",
       "subject" . "subject-sdesc"                    AS "SUBJECT-SDESC",
       "subject" . "subject-ldesc"                    AS "SUBJECT-LDESC",
       "department" . "department-sdesc"              AS "DEPARTMENT-SDESC",
       "department" . "department-ldesc"              AS "DEPARTMENT-LDESC",
       "COR_LENGTH_SET" . "cor-length-sdesc"          AS "COR-LENGTH-SET-SDESC",
       "COR_LENGTH_SET" . "cor-length-ldesc"          AS "COR-LENGTH-SET-LDESC",
       "CLAS_CONTROL_SET" . "control-set-ref"         AS "CCS-CONTROL-SET-REF",
       "CLAS_CONTROL_SET" . "ccs-desc"                AS "CCS-DESC",
       "CLAS_CONTROL_SET" . "ccs-atnd-str-dte"        AS "CCS-ATND-STR-DTE",
       "CLAS_CONTROL_SET" . "ccs-atnd-stp-dte"        AS "CCS-ATND-STP-DTE",
       "CLAS_CONTROL_SET" . "ccs-dsp-trm-lit"         AS "CCS-DSP-TRM-LIT",
       "CLAS_CONTROL_SET" . "ccs-dsp-nbr-trms"        AS "CCS-DSP-NBR-TRMS",
       "CLAS_CONTROL_SET" . "ccs-dsp-str-trm"         AS "CCS-DSP-STR-TRM",
       "CLAS_CONTROL_SET" . "ccs-dsp-stp-trm"         AS "CCS-DSP-STP-TRM",
       "CLAS_CONTROL_SET" . "ccs-sch-nbr-trms"        AS "CCS-SCH-NBR-TRMS",
       "CLAS_CONTROL_SET" . "ccs-sch-str-trm"         AS "CCS-SCH-STR-TRM",
       "CLAS_CONTROL_SET" . "ccs-sch-stp-trm"         AS "CCS-SCH-STP-TRM",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 1 ]  AS "CCS-SEM-USE-TRMS1",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 2 ]  AS "CCS-SEM-USE-TRMS2",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 3 ]  AS "CCS-SEM-USE-TRMS3",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 4 ]  AS "CCS-SEM-USE-TRMS4",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 5 ]  AS "CCS-SEM-USE-TRMS5",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 6 ]  AS "CCS-SEM-USE-TRMS6",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 7 ]  AS "CCS-SEM-USE-TRMS7",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 8 ]  AS "CCS-SEM-USE-TRMS8",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 9 ]  AS "CCS-SEM-USE-TRMS9",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 10 ] AS "CCS-SEM-USE-TRMS10",
       "CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 11 ] AS "CCS-SEM-USE-TRMS11",
"CLAS_CONTROL_SET" . "CCS-SEM-USE-TRMS" [ 12 ] AS "CCS-SEM-USE-TRMS12"
FROM   "SKYWARD" . "PUB" . "entity"
       inner join "SKYWARD" . "PUB" . "student-entity" "STUDENT_ENTITY"
               ON "entity" . "entity-id" = "STUDENT_ENTITY" . "entity-id"
       inner join "SKYWARD" . "PUB" . "student"
               ON "STUDENT_ENTITY" . "student-id" = "student" . "student-id"
       inner join "SKYWARD" . "PUB" . "student-class" "STUDENT_CLASS"
               ON "STUDENT_ENTITY" . "student-id" = "STUDENT_CLASS" . "student-id"
                  AND "STUDENT_CLASS" . "school-year" IN (
                          ( "student" . "grad-yr" - 20 ), (
                          "student" . "grad-yr" - 19 ),
                          (
                          "student" . "grad-yr" - 18 ), (
                          "student" . "grad-yr" - 17 ),
                           ( "student" . "grad-yr" - 16
                          ), (
                          "student" . "grad-yr" - 15 ), (
                          "student" . "grad-yr" - 14
                          ), (
                          "student" . "grad-yr" - 13 ),
                                                           (
                          "student" . "grad-yr" - 12
                          ), (
                          "student" . "grad-yr" - 11 ), (
                          "student" . "grad-yr" - 10
                          ), (
                          "student" . "grad-yr" - 9 ),
                                                           (
                          "student" . "grad-yr" - 8 )
                          , (
                          "student" . "grad-yr" - 7 ), (
                          "student" . "grad-yr" - 6 )
                          , (
                          "student" . "grad-yr" - 5 ),
                                                           (
                          "student" . "grad-yr" - 4 )
                          , (
                          "student" . "grad-yr" - 3 ), (
                          "student" . "grad-yr" - 2 )
                          , (
                          "student" . "grad-yr" - 1 ),
                                                           (
                          "student" . "grad-yr" ), (
                          "student" . "grad-yr" + 1 ), (
                          "student" . "grad-yr" + 2 )
                          , (
                          "student" . "grad-yr" + 3 ),
                                                           (
                          "student" . "grad-yr" + 4 )
                          , (
                          "student" . "grad-yr" + 5 ), (
                          "student" . "grad-yr" + 6 )
                          , (
                          "student" . "grad-yr" + 7 ),
                                                           (
                          "student" . "grad-yr" + 8 )
                          , (
                          "student" . "grad-yr" + 9 ), (
                          "student" . "grad-yr" + 10
                          ), (
                          "student" . "grad-yr" + 11 ),
                                                           (
                          "student" . "grad-yr" + 12
                          ), (
                          "student" . "grad-yr" + 13 ), (
                          "student" . "grad-yr" + 14
                          ), (
                          "student" . "grad-yr" + 15 ),
                                                           (
                          "student" . "grad-yr" + 16
                          ), (
                          "student" . "grad-yr" + 17 ), (
                          "student" . "grad-yr" + 18
                          ), (
                          "student" . "grad-yr" + 19 ), (
                          "student" . "grad-yr" + 20
                                                        ) )
                  AND "STUDENT_ENTITY" . "entity-id" =
                      "STUDENT_CLASS" . "entity-id"
       left outer join "SKYWARD" . "PUB" . "class" "CLASS"
                    ON "STUDENT_CLASS" . "cor-num-id" = "class" . "cor-num-id"
                       AND "STUDENT_CLASS" . "track" = "class" . "track"
                       AND "STUDENT_CLASS" . "clas-section" =
                           "class" . "clas-section"
       left outer join "SKYWARD" . "PUB" . "class-meet" "CLASS_MEET"
                    ON "class" . "cor-num-id" = "CLASS_MEET" . "cor-num-id"
                       AND "class" . "track" = "CLASS_MEET" . "track"
                       AND "class" . "clas-section" =
                           "CLASS_MEET" . "clas-section"
       left outer join "SKYWARD" . "PUB" . "building" "BUILDING"
                    ON "CLASS_MEET" . "building-id" = "building" . "building-id"
       inner join "SKYWARD" . "PUB" . "course" "COURSE"
               ON "STUDENT_CLASS" . "cor-num-id" = "course" . "cor-num-id"
       left outer join "SKYWARD" . "PUB" . "course-type" "COURSE_TYPE"
                    ON "course" . "entity-id" = "COURSE_TYPE" . "entity-id"
                       AND "course" . "course-type-id" =
                           "COURSE_TYPE" . "course-type-id"
       left outer join "SKYWARD" . "PUB" . "name" "NAME_TCHR"
                    ON "CLASS_MEET" . "name-id" = "NAME_TCHR" . "name-id"
       left outer join "SKYWARD" . "PUB" . "homeroom" "HOMEROOM"
                    ON "STUDENT_ENTITY" . "entity-id" = "homeroom" . "entity-id"
                       AND "STUDENT_CLASS" . "school-year" =
                           "homeroom" . "school-year"
                       AND "STUDENT_ENTITY" . "homeroom-number" =
                           "homeroom" . "homeroom-number"
       left outer join "SKYWARD" . "PUB" . "name" "NAME_HR"
                    ON "homeroom" . "homeroom-teacher" = "NAME_HR" . "name-id"
       left outer join "SKYWARD" . "PUB" . "name" "NAME_ADV"
                    ON "STUDENT_ENTITY" . "advisor" = "NAME_ADV" . "name-id"
       left outer join "SKYWARD" . "PUB" . "name" "NAME_SE_TCHR_OF_REC"
                    ON "STUDENT_ENTITY" . "se-tchr-of-record" =
                       "NAME_SE_TCHR_OF_REC" . "name-id"
       left outer join "SKYWARD" . "PUB" . "name" "NAME_DISC"
                    ON "STUDENT_ENTITY" . "dis-officer" = "NAME_DISC" . "name-id"
       inner join "SKYWARD" . "PUB" . "name" "NAME_STU"
               ON "student" . "name-id" = "NAME_STU" . "name-id"
       inner join "SKYWARD" . "PUB" . "language" "LANGUAGE"
               ON "NAME_STU" . "language-code" = "language" . "language-code"
       left outer join "SKYWARD" . "PUB" . "subject" "SUBJECT"
                    ON "course" . "entity-id" = "subject" . "entity-id"
                       AND "course" . "school-year" = "subject" . "school-year"
                       AND "course" . "subject-id" = "subject" . "subject-id"
       left outer join "SKYWARD" . "PUB" . "department" "DEPARTMENT"
                    ON "course" . "entity-id" = "department" . "entity-id"
                       AND "course" . "school-year" = "department" . "school-year"
                       AND "course" . "department-id" =
                           "department" . "department-id"
       left outer join "SKYWARD" . "PUB" . "cor-length-set" "COR_LENGTH_SET"
                    ON "course" . "entity-id" = "COR_LENGTH_SET" . "entity-id"
                       AND "course" . "school-year" =
                           "COR_LENGTH_SET" . "school-year"
                       AND "course" . "cor-length-set-id" =
                           "COR_LENGTH_SET" . "cor-length-set-id"
       left outer join "SKYWARD" . "PUB" . "clas-control-set" "CLAS_CONTROL_SET"
                    ON "STUDENT_CLASS" . "entity-id" =
                       "CLAS_CONTROL_SET" . "entity-id"
                       AND "STUDENT_CLASS" . "school-year" =
                           "CLAS_CONTROL_SET" . "school-year"
                       AND "course" . "cor-length-set-id" =
                           "CLAS_CONTROL_SET" . "cor-length-set-id"
                       AND "STUDENT_CLASS" . "track" =
                           "CLAS_CONTROL_SET" . "track"
                       AND "class" . "control-set-id" =
                           "CLAS_CONTROL_SET" . "control-set-id"
                       AND "CLAS_CONTROL_SET" . "control-set-ref" = 0 
) a inner join PUB."NAME" b on a."TCHR-ALPHAKEY" = b."NALPHAKEY"
WHERE a."StU-CLASS-SCHOOL-YEAR" = 2023
and a."STU-ENTITY-ENTITY-ID" is not null
with (nolock)

Click to copy

Previous Article ACT Aspire

Next Article Skyward - Self Hosted