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

➜ Back to Library
Description
Categories: BI Publisher
Columns: Jobcode, Meaning, Line No, Rownum ...
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 
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
Business Group ID 
 
Download
Related Blitz Reports
CAC Cost Vs. Planning Item Controls AR Profile Option Migration CAC Inventory and Intransit Value (Period-End) CAC ICP PII Inventory and Intransit Value (Period-End) INV Shortage Parameter PA Implementation Options CAC Item Cost Summary CAC Item Target Cost Review PER Full Person Details CAC Accounting Period Status
Blitz Report In Action
Blitz Report™

Blitz Report™ provides multiple benefits: