Snapshot Date

List of all students with invalid data.
The query will skip students who are not active. This will leave the students who are active on the day you run the query.

SKIP STU IF STU.TG # ' '

For Flex Scheduling - List of all students with invalid data.

The query will skip students who have a course in both Classes (SEC) and Course Attendance (CAR) for the official attendance period. The resulting list is all students who have a course in Master Schedule (MST) but not in Course Attendance (CAR), or vice versa. Data for these students must be corrected.

SKIP CAR STU SEC MST FTF IF MST.SE = CAR.SE AND FTF.STI = "x" AND CAR.DS <= "mm/dd/yyyy" AND CAR.DE >= "mm/dd/yyyy"

where:

• x = Short Title (official attendance period)
• mm/dd/yyyy (both) = snapshot date

Class Roster/Fall PEIMS 

Staff Basic Information

List of all staff at the campus with the required data elements.

District

LIST STF PSC SID LN FN SX BD EL ETH RC1 TYS IF STF.TG = ‘ ‘

Campus

LIST STF PSC SID LN FN SX BD EL ETH RC1 TYS IF STF.TG = ‘ ‘ and STF.PSC = X

where: x denotes campus #

Staff Teacher Class Assignment

List traditional campuses to list staff with Role ID and Position.

LIST MST CRS TCH MST.TN TCH.TE MST.SE CRS.CO MST.TP1 MST.SR1 BY TCH.TE IF MST.TS > 0

List Flex campuses to list staff with Role ID and Position.

LIST STF SSE MST STF.PSC STF.SID STF.LN STF.FN MST.SE SSE.SR SSE.TP BY STF.LN IF MST.TS > 0

List the required elements for Student Parent.

LIST STU ID NM CID BD GN ETH RC1 IF 

List of staff data needed for Class Roster.

This query is used to change the Staff Role. Once the query runs select the CHANGE button (lock fields do not want changed).Then, set Role to 087 for the teacher role

LIST MST FTF CRS SSE MST.SE MST.FSQ FTF.STI MST.CN CRS.CO MST.NCI MST.PSV SSE.SR SSE.TP BY MST.CN IF MST.TS > 0

Fall PEIMS

List of active student demographics. 

LIST STU ID NM CID BD GN ETH RC1 IF STU.TG = " "

List of student endorsement status.

LIST STU GES ACT STU.ID STU.LN STU.FN STU.GR ACT.CD? ACT.RS? GES.EC GES.ST? IF STU.DG >= 8/1/2023 AND ACT.CD = DLA

List of students with missing Census Block coding.

LIST STU SC CID NM GR IF STU.TG = " " AND ( FRE.CD = "F" OR FRE.CD = "R" OR FRE.CD = "X" ) AND FRE.ESD >= 7/1/2022 AND FRE.EED > 10/27/2023 AND STU.SCB = " " 

KG ECDS

List of student demographics.

LIST STU ID NM CID BD GN ETH RC1 IF STU.GR = 0

SPPI 14

List of the students who were reported as SPED in the prior year's Summer PEIMS Submission and as leavers in the current year's Fall PEIMS Submission. 

• Run the query below in the prior school year
• Check the option “Include Inactive Students”

LIST STU CON CSE STU.TG STU.SC STU.ID STU.NM STU.LVR STU.LD CON.RL CSE.DI CSE.ED CSE.XD IF STU.LD > 7/01/2022 AND ( STU.LVR = "01" OR STU.LVR = "24" OR STU.LVR = "88" OR STU.LVR = "90" OR STU.LVR = "98" ) AND CSE.DI > 0 AND ( CSE.XD >= STU.LD OR CSE.XD = NULL ) AND STU.SC < 41

Summer PEIMS

List of active student demographics. 

LIST STU ID NM CID BD GN ETH RC1 IF STU.TG = " "

List of student endorsement status.

LIST STU GES STU.ID STU.LN STU.FN STU.GR STU.EOO GES.EC GES.ST? IF GES.EC = XX

Where: XX is AH (Arts and Humanities), BI (Business and Industry), MD (Multidisciplinary Studies), PS (Public Services) and/or ST (STEM)

List of students without an ADA Eligibility code.

LIST STU SC ID FN LN SP TG IF SP = " " AND SC ; 999  

List of students without a Home Language code.

LIST STU ENR STU.SC STU.CID STU.ID STU.LN STU.FN STU.MN STU.BD STU.GN STU.ETH STU.RC1 ENR.PR STU.CL STU.HL STU.GR IF STU.SC ; 999 AND STU.CL = " "  

Use the following Queries to assist in cleaning up your Master Schedule.

For campuses NOT using Flex Scheduling

LIST MST CRS MST.SE MST.PD MST.RM MST.CN CRS.CO CRS.CSQ MST.TP1 MST.SR1 MST.NCI MST.PSV IF MST.TS > 0

For campuses using Flex Scheduling

LIST MST FTF CRS SSE MST.SE MST.FSQ FTF.STI MST.CN CRS.CO MST.NCI MST.PSV SSE.SR SSE.TP BY MST.CN IF MST.TS > 0

PK ECDS

List of sections missing the required fields: Service ID 01010000.

LIST MST CN SE PD SM PKT CT HQP SIT CCO IF CRS.SVC = 01010000

List of students missing a Unique ID.

• This submission includes all Pre-K students – active and inactive.
• This submission includes all Pre-K students – tested and not tested

LIST STU IF STU.CID = Null AND STU.GR = -1 AND STU.ED >= 8/1/20XX

Where: XX is the current school year  

(Be sure to check the box to “Include Inactive Students”)

Special Ed Language Acquisition (SELA)

List of the required demographic elements for Student Parent.

LIST STU ID NM CID BD GN ETH RC1 IF STU.TG = " " AND ( STU.CID = " " OR STU.GN = " " OR STU.ETH = " " OR STU.RC1 = " " ) 

Child Find 11 & 12

List of the required demographic elements for Student Parent.

LIST STU ID NM CID BD GN ETH RC1 IF STU.TG = " " AND ( STU.CID = " " OR STU.GN = " " OR STU.ETH = " " OR STU.RC1 = " " ) 

Extended Year PEIMS

List of active student demographics 

LIST STU ID NM CID BD GN ETH RC1 IF STU.TG = " "

Use the following Queries to assist in cleaning up your Master Schedule

For campuses NOT using Flex Scheduling

LIST MST CRS MST.SE MST.PD MST.RM MST.CN CRS.CO CRS.CSQ MST.TP1 MST.SR1 MST.NCI MST.PSV IF MST.TS > 0

For campuses using Flex Scheduling

LIST MST FTF CRS SSE MST.SE MST.FSQ FTF.STI MST.CN CRS.CO MST.NCI MST.PSV SSE.SR SSE.TP BY MST.CN IF MST.TS > 0

Other Queries 

List any school with tracks, up to H, to find Enters or Leaves Dates or Both that were entered on a non-school day for a student(s).

LIST STU ATT DAY STU.ID STU.NM STU.GR ATT.DY ATT.CD ATT.TR ATT.DT DAY.DT DAY.DY DAY.T1 DAY.T2 DAY.T3 DAY.T4 DAY.T6 DAY.T7 DAY.T8 DAY.T9 DAY.T11 DAY.T12 IF ( ATT.CD = E OR ATT.CD = L OR ATT.CD = B ) AND ( ( ATT.TR = A AND DAY.T1 # " " AND DAY.T1 # "%" ) OR ( ATT.TR = B AND DAY.T2 # " " AND DAY.T2 # "%" ) OR ( ATT.TR = C AND DAY.T3 # " " AND DAY.T3 # "%" ) OR ( ATT.TR = D AND DAY.T4 # " " AND DAY.T4 # "%" ) OR ( ATT.TR = E AND DAY.T5 # " " AND DAY.T5 # "%" ) OR ( ATT.TR = F AND DAY.T6 # " " AND DAY.T6 # "%" ) OR ( ATT.TR = G AND DAY.T7 # " " AND DAY.T7 # "%" ) OR ( ATT.TR = H AND DAY.T8 # " " AND DAY.T8 # "%" ) ) 

A = 1

B = 2

C = 3

D = 4

E = 5

F = 6

G = 7

H = 8

List the referrals coded as "Yes" for SSSP. Don't forget to click the "Include Inactive Students"

LIST STU ADS DSP STU.SC STU.GR STU.ID STU.FN STU.LN ADS.IID ADS.DT ADS.INI? ADS.CD? ADS.CO ADS.SSP ADS.SDT BY STU.SC IF ADS.DT >= 8/16/23 AND ADS.SSP = Y AND STU.TG # *