What Field Does the PFT Status Summary Report Extract From? 


The "Print Physical Fitness Status Summary" report extracts the Status Passed/Not Passed information from the Testing Pass Status (TPS) table, the TPS.PFXX Field.



NOTE: The XX on the Field depends on the grade level:

Elementary - TPS.PFO5, Middle School - TPS.PFO7, High School - TPS.PFO9


Sample Query for students with Not Passed (0) in the High School Physical Fitness field (TPS.PF09):


LIST STU PFT TPS STU.ID STU.SC STU.NM STU.GR TPS.PFO9 TPS.PDO9 IF TPS.PFO9 = 0


The above field is different than the Test Status at the top of the PFT Page which is not included on this report.