PER IPEDS Report - Non Degree Granting Institutes

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Human Resources
Source: IPEDS Report - Non Degree Granting Institutes
Short Name: PEUSNDGIPED
DB package: PER_US_IPEDS_PKG
Run PER IPEDS Report - Non Degree Granting Institutes and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT  decode (hl.lookup_code
               ,21
               ,hr_general.decode_lookup('PER_US_IPEDS_RPT_LBL','PST')
               ,27
               ,hr_general.decode_lookup('PER_US_IPEDS_RPT_LBL','LCA')
               ,hl.meaning) Ipeds_Category
       ,value1 NRMen
       ,value2 NRWmen
       ,value3 BnHMen
       ,value4 BnHWmen
       ,value5 Am_AlMen
       ,value6 Am_AlWmen
       ,value7 AMen
       ,value8 AWmen
       ,value9 NH_OPMen
       ,value10 NH_OPWmen
       ,value11 HMen
       ,value12 HWmen
       ,value13 WnHMen
       ,value14 WnHWmen
       ,value15 URMen 
       ,value16 URWMen 
       ,value17 TmrMen
       ,value18 TmrWmen
       ,value19 Totmen
       ,value20 TotWmen
FROM    pay_us_rpt_totals prt
       ,hr_lookups hl
WHERE   prt.tax_unit_id(+) = USERENV('sessionid')
AND     prt.attribute1(+)  = 'NDGIPED'
AND     hl.lookup_type     = 'US_IPEDS_JOB_CATEGORIES'
AND     prt.attribute2(+)  = hl.lookup_code
AND     hl.enabled_flag    = 'Y'
AND     hl.lookup_code NOT IN ('12','22','23','24','25','26','28','29')
ORDER BY hl.lookup_code
Parameter Name SQL text Validation
Reporting Date 
 
 Date
Report Type 
 
 LOV Oracle
With Race/Ethnicity 
 
 LOV Oracle
Download
 
Related Blitz Reports
PER IPEDS Report - Degree Granting Institutes - Part H PER IPEDS Report - Degree Granting Institutes - Part A PER IPEDS Report - Degree Granting Institutes - Part G PER IPEDS Report - Degree Granting Institutes - Part E PER IPEDS Report - Degree Granting Institutes - Part D PER IPEDS Report - Degree Granting Institutes - Part B PQH IPEDS Report - Staff Survey (S1) - Part G(obsoleted) PQH IPEDS Report - Staff Survey (S1) - Part D(obsoleted) PQH IPEDS Report - Staff Survey (S1) - Part A(obsoleted)
Blitz Report™

Blitz Report™ provides multiple benefits: