PQH IPEDS Report - Staff Survey (S1) - Part D(obsoleted)

SELECT value1 Line1,
       attribute2 jobCode1,
       value2 NRMen1,
       value3 NRWmen1,
       value4 BnHMen1,
       value5 BnHWmen1,
       value6 Am_AlMen1,
       value7 Am_AlWmen1,
       value8 APMen1,
       value9 APWmen1,
       value10 HMen1,
       value11 HWmen1,
       value12 WnHMen1,
       value13 WnHWmen1,
       value14 URMen1,
       value15 URWmen1,
       value16 TotMen1,
       value17 TotWmen1,
	   value18 NH_OPMen1,
	   value19 NH_OPWmen1,
	   value20 TmRMen1,
	   value21 TmRWmen1
FROM pay_us_rpt_totals
where session_id = userenv('sessionid')
AND attribute1 = 'IPED7'
AND value1 = '2'
 and attribute2=:job