PQH IPEDS Report - Non-Degree Granting Institutions (S2) - Part B(obsoleted)
Description
- Categories
- BI Publisher
- Application
- Public Sector HR
- Source
- IPEDS Report - Non-Degree Granting Institutions (S2) - Part B (XML) (obsoleted)
- Short Name
- PQIPED11_XML
- DB package
- PQH_PQIPED11_XMLP_PKG
Imported from BI Publisher
SQL 17 lines
SELECT jobcode, meaning, PQH_PQIPED11_XMLP_PKG.line_noformula() line_no, rownum FROM (SELECT hl.lookup_code jobcode, to_number(hl.lookup_code) jobcode1, hl.meaning meaning FROM hr_lookups hl WHERE hl.lookup_type = 'US_IPEDS_JOB_CATEGORIES' AND lookup_code NOT IN('1', '2', '3', '12') ORDER BY 2) /*select hl.lookup_code jobCode, hl.meaning, PQH_PQIPED11_XMLP_PKG.line_noformula() line_no from hr_lookups hl where hl.lookup_type = 'US_IPEDS_JOB_CATEGORIES' and lookup_code not in ('1','2','3','12') order by to_number(hl.lookup_code) */ |
Parameters 1
| Parameter | Type | List of values SQL |
|---|---|---|
| Reporting Date | Date |