PQH IPEDS Report - Staff Survey (S1) - Part G(obsoleted)
Description
- Categories
- 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
Imported from BI Publisher
SQL 26 lines
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 |
Parameters 1
| Parameter | Type | List of values SQL |
|---|---|---|
| Reporting Date | Date |