How can I query the Course Attendance (CAR) page for an Alt Ed School? It keeps duplicating and the Sections do not match. Also, the periods are all zero.


Environment

  1. In an Alternative Education School Sections are virtualized unless the actual Course Section is being used
  2. The Section (SEC) table should not be included in the query as the Section in Course Attendance will not match the Alt Ed Placeholder Master Schedule Section
  3. In an Alt Ed School using Flex, the Class Period should come from the Flexible Periods (FTF) table


Solution

Removing the Section (SEC) table from the query will give the correct unduplicated Course Attendance page information as seen in the example query below:


LIST CRS CAR STU MST SSE STF FTF STU.ID STU.NM STU.GR FTF.STI CAR.CN CRS.CO STF.LN STF.FN SSE.PR CAR.DS CAR.DE BY STU.NM FTF.STI IF SSE.PR = 1 



NOTE: The Course Name in the query above will extract the Alt Ed placeholder course and not the actual course if the actual course has not been assigned yet