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
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
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
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
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
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
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
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
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
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