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

Description
Categories: BI Publisher, Human Resources
Application: Public Sector HR
Source: IPEDS Report - Staff Survey (S1) - Part G (XML) (obsoleted)
Short Name: PQIPED9_XML
DB package: PQH_PQIPED9_XMLP_PKG
SELECT distinct value1 jCode,
               value2 NRMen,
               value3 NRWmen,
               value4 BnHMen,
               value5 BnHWmen,
               value6 Am_AlMen,
               value7 Am_AlWmen,
               value8 AMen,
               value9 AWmen,
               value10 HMen,
               value11 HWmen,
               value12 WnHMen,
               value13 WnHWmen,
               value14 URMen,
               value15 URWmen,
               value16 TotMen,
               value17 TotWmen,
               value18 NHOPMen,
               value19 NHOPWmen,
               value20 TmrMen,
               value21 TmrWmen               
FROM pay_us_rpt_totals
WHERE session_id = userenv('sessionid')
AND attribute1 = 'IPED9'
 and value1=:jobCode
Parameter Name SQL text Validation
Business Group ID
 
Reporting Date
 
Date