PER IPEDS Report - Non Degree Granting Institutes

Description
Categories: BI Publisher, Human Resources
Application: Human Resources
Source: IPEDS Report - Non Degree Granting Institutes
Short Name: PEUSNDGIPED
DB package: PER_US_IPEDS_PKG
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
Business Group
 
With Race/Ethnicity
 
LOV Oracle
Report Type
 
LOV Oracle
Reporting Date
 
Date