ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D471AE51A9E05362FB09050512Y 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 PER PEUSNDGIPED US PER IPEDS Report - Non Degree Granting Institutes Imported from BI Publisher Application: Human Resources Source: IPEDS Report - Non Degree Granting Institutes Short Name: PEUSNDGIPED DB package: PER_US_IPEDS_PKG BI Publisher :p_business_group_id :p_race_gender :p_report_date :p_report_type :p_tenured 1 -10 :p_business_group_id Char fnd_profile.value('PER_BUSINESS_GROUP_ID') US Business Group Business Group ID 2 10 :p_report_date Date Y US Reporting Date Reporting Date 3 20 :p_report_type LOV Oracle PER_US_INDEG_RPT_TYPE Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='PER_US_INDEG_RPT_TYPE' and enabled_flag='Y' order by value,description Y US Report Type Report Type 4 30 :p_race_gender LOV Oracle HR_US_YES_NO Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='YES_NO' order by value,description Y US With Race/Ethnicity With Break up of Race/Ethnicity and Gender