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

Description
Categories: BI Publisher
Imported from BI Publisher
Application: Public Sector HR
Source: IPEDS Report - Non-Degree Granting Institutions (S2) - Part A (XML) (obsoleted)
Short Name: PQIPED10_XML
DB package: PQH_PQIPED10_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 jobCode,meaning,PQH_PQIPED10_XMLP_PKG.line_noformula() line_no,rownum
from (
select hl.lookup_code jobCode,
hl.meaning, 
	PQH_PQIPED10_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))
--select hl.lookup_code jobCode,
--hl.meaning, 
--	PQH_PQIPED10_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
Reporting Date
 
Date