"SELECT e.EMPL_ID AS EMPL_ID,e.EMPL_SAP_ID AS SAP_ID,e.EMPL_LAST_NAME || ', ' || e.EMPL_FIRST_NAME || ' ' || e.EMPL_MIDDLE_INIT AS EMPLOYEE,c.CATS_PAYWK AS PAY_PERIOD,c.CATS_SPENDER AS COST_CENTER,c.CATS_PRIM AS LOCATION_CODE, CASE WHEN (c.CATS_BUDCTR='') THEN 'Contract' ELSE 'Overhead' END AS TYPE,CASE WHEN substr(c.CATS_GENORDER,1,3)='000' THEN '' ELSE c.CATS_GENORDER || c.CATS_TASK_ END AS TASK,Sum(c.CATS_RHRS+c.CATS_OHRS) AS HOURS,m.EMPL_LAST_NAME AS SUPERVISOR,s.SECT_DESC AS SECTION " & _
"FROM FSET.TFSETCATS c LEFT JOIN ((FSET.TFSETEMPL e LEFT JOIN FSET.TFSETEMPL m ON e.EMPL_EMPL_ID = m.EMPL_ID) LEFT JOIN FSET.TFSETSECT s ON m.EMPL_SECT = s.SECT_ID) ON c.CATS_EMPL_ID = e.EMPL_ID " & _
"GROUP BY e.EMPL_ID,e.EMPL_SAP_ID,e.EMPL_LAST_NAME || ', ' || e.EMPL_FIRST_NAME || ' ' || e.EMPL_MIDDLE_INIT,c.CATS_PAYWK,c.CATS_SPENDER,c.CATS_PRIM,CASE WHEN c.CATS_BUDCTR='' THEN 'Contract' ELSE 'Overhead' END,CASE WHEN substr(c.CATS_GENORDER,1,3)='000' Then '' ELSE c.CATS_GENORDER || c.CATS_TASK_ END,m.EMPL_LAST_NAME,s.SECT_DESC,CASE WHEN (c.CATS_SPENDER='PA' Or c.CATS_SPENDER='OA') And (c.CATS_PRIM='0' Or c.CATS_PRIM='1') THEN 1 ELSE CASE WHEN (c.CATS_SPENDER='R5205' Or c.CATS_SPENDER='R5206' Or c.CATS_SPENDER='A3570' Or c.CATS_SPENDER='EK2' Or c.CATS_SPENDER='2C' Or c.CATS_SPENDER='H31' Or c.CATS_SPENDER='JZ' Or c.CATS_SPENDER='A37') And (c.CATS_PRIM='2' Or c.CATS_PRIM='3' Or c.CATS_PRIM='4' Or c.CATS_PRIM='5' Or c.CATS_PRIM='6' Or c.CATS_PRIM='7' c.CATS_PRIM='8' Or c.CATS_PRIM='9' Or c.CATS_PRIM='X' Or c.CATS_PRIM='Y' Or c.CATS_PRIM='Z') THEN 1 ELSE 0 END END " & _
"WHERE (c.CATS_PAYWK= 25) AND (c.CATS_SPENDER='A3570' Or c.CATS_SPENDER='R5205' Or c.CATS_SPENDER='R5205' Or c.CATS_SPENDER='2C' Or c.CATS_SPENDER='A37' Or c.CATS_SPENDER='PA' Or c.CATS_SPENDER='OA' Or c.CATS_SPENDER='H31' Or c.CATS_SPENDER='BG' Or c.CATS_SPENDER='JZ' Or c.CATS_SPENDER='EK2' Or c.CATS_SPENDER='SA') AND CASE WHEN (c.CATS_SPENDER='PA' Or c.CATS_SPENDER='OA') And (c.CATS_PRIM='0' Or c.CATS_PRIM='1') THEN 1 ELSE CASE WHEN (c.CATS_SPENDER='R5205' Or c.CATS_SPENDER='R5206' Or c.CATS_SPENDER='A3570' Or c.CATS_SPENDER='EK2' Or c.CATS_SPENDER='2C' Or c.CATS_SPENDER='H31' Or c.CATS_SPENDER='JZ' Or c.CATS_SPENDER='A37') And (c.CATS_PRIM='2' Or c.CATS_PRIM='3' Or c.CATS_PRIM='4' Or c.CATS_PRIM='5' Or c.CATS_PRIM='6' Or c.CATS_PRIM='7' Or c.CATS_PRIM='8' Or c.CATS_PRIM='9' Or c.CATS_PRIM='X' Or c.CATS_PRIM='Y' Or c.CATS_PRIM='Z') THEN 1 ELSE 0 END END=1 " & _
"ORDER BY m.EMPL_LAST_NAME,e.EMPL_LAST_NAME || ', ' || e.EMPL_FIRST_NAME || ' ' || e.EMPL_MIDDLE_INIT,c.CATS_PAYWK,CASE WHEN substr(c.CATS_GENORDER,1,3)='000' THEN '' ELSE c.CATS_GENORDER || c.CATS_TASK_ END"