The Queries will mimic the 4.3 Staff Teaching Assignments - Detail CALPADS Report from Fall 2 and can be used to look at teacher credentials to help find potential misassignments

1. Schools with Secondary Scheduling Extracting Teacher Table Information

• LIST CRS MST TCH STF STF.SID STF.ID STF.FN STF.LN STF.TYD CRS.C3 CRS.CO MST.SE MST.CN CRS.CS CRS.U1? CRS.U2? CRS.VLU? CRS.CCG? CRS.SGR CRS.MSC MST.SM MST.ESR MST.LI MST.INS CRS.CL CRS.TY MST.TEP MST.ISI MST.DLI MST.MSC MST.OIT? BY STF.SID IF STF.ID # 0 
• Note: Teacher Table must have the Staff ID linked

2. Schools with Flex Scheduling

• LIST CRS MST SSE STF STF.SID STF.ID STF.FN STF.LN STF.TYD CRS.C3 CRS.CO MST.SE MST.CN CRS.CS CRS.U1? CRS.U2? CRS.VLU? CRS.CCG? CRS.SGR CRS.MSC MST.SM MST.ESR MST.LI MST.INS CRS.CL CRS.TY MST.TEP MST.ISI MST.DLI MST.MSC MST.OIT? BY STF.SID IF STF.ID # 0 AND ( SSE.ID = STF.ID )
  
  Other helpful Fall 2 Queries