FTE ID Report FTE ID Report paramvalue Report of FTE ID values for the selected school year. Data_Validation WITH CTE AS ( SELECT SCHOOLID, YEARID, ID, NAME, ROW_NUMBER() OVER(PARTITION BY SCHOOLID,YEARID ORDER BY ID) ROWNUMBER FROM FTE ) SELECT DECODE(CTE.ROWNUMBER,1,SCHOOLS.ABBREVIATION,''), CTE.ID, CTE.NAME FROM CTE JOIN SCHOOLS ON CTE.SCHOOLID = SCHOOLS.SCHOOL_NUMBER WHERE CTE.YEARID = %param1% ORDER BY SCHOOLS.SORTORDER, CTE.ROWNUMBER SchoolFTEIDDescription School Year 30 schlyears 0 9, 0 0 0 Opt1