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

Description
Categories: BI Publisher
Imported from BI Publisher
Application: Public Sector HR
Source: IPEDS Report - Staff Survey (S1) - Part G (XML) (obsoleted)
Short Name: PQIPED9_XML
DB package: PQH_PQIPED9_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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
Reporting Date
 
Date