ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D471A851A9E05362FB09050512Y SELECT distinct decode( hl.lookup_code, '01', hr_general.decode_lookup('PER_US_IPEDS_RPT_LBL','NAC'), hl.meaning) academic_rank ,hl.lookup_code ,SUM(value3) NRMen ,SUM(value4) NRWmen ,SUM(value5) BnHMen ,SUM(value6) BnHWmen ,SUM(value7) Am_AlMen ,SUM(value8) Am_AlWmen ,SUM(value9) AMen ,SUM(value10) AWmen ,SUM(value11) NH_OPMen ,SUM(value12) NH_OPWmen ,SUM(value13) HMen ,SUM(value14) HWmen ,SUM(value15) WnHMen ,SUM(value16) WnHWmen ,SUM(value17) TmrMen ,SUM(value18) TmrWmen ,SUM(value19) URMen ,SUM(value20) URWmen ,SUM(value21) TotMen ,SUM(value22) TotWmen FROM pay_us_rpt_totals purt ,hr_lookups hl WHERE hl.lookup_type = 'PQH_ACADEMIC_RANK' AND hl.enabled_flag = 'Y' AND purt.value1(+) = :tenure_code AND hl.lookup_code = purt.value2(+) AND purt.tax_unit_id(+) = userenv('sessionid') AND purt.attribute1(+) = 'DGIPEDA' GROUP BY decode( hl.lookup_code, '01', hr_general.decode_lookup('PER_US_IPEDS_RPT_LBL','NAC'), hl.meaning) ,hl.lookup_code ORDER BY hl.lookup_code DESC PER PEUSDGIPEDA US PER IPEDS Report - Degree Granting Institutes - Part A Imported from BI Publisher Application: Human Resources Source: IPEDS Report - Degree Granting Institutes - Part A Short Name: PEUSDGIPEDA DB package: PER_US_IPEDS_PKG BI Publisher :p_business_group_id :p_race_gender :p_report_date :p_report_type :p_tenured :tenure_code 1 -10 :p_business_group_id Char fnd_profile.value('PER_BUSINESS_GROUP_ID') Y US Business Group Business Group ID 2 10 :p_report_date Date Y US Reporting Date Reporting Date 3 20 :p_tenured 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 Tenured Is Org using Tenure Info 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