PQH IPEDS Report - Non-Degree Granting Institutions (S2) - Part B(obsoleted)

Description
Categories: BI Publisher, Human Resources
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
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)
*/
Parameter Name SQL text Validation
Business Group ID
 
Reporting Date
 
Date