PQH IPEDS Report - Staff Survey (S1) - Part F(obsoleted)

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Public Sector HR
Source: IPEDS Report - Staff Survey (S1) - Part F (XML) (obsoleted)
Short Name: PQIPED8_XML
DB package: PQH_PQIPED8_XMLP_PKG
Run PQH IPEDS Report - Staff Survey (S1) - Part F(obsoleted) and other Oracle EBS reports with Blitz Report™ on our demo environment
/*select hl.lookup_code AcRank,
ht.lookup_code TenStat,
decode( hl.lookup_code, '01', 'Other Faculty', hl.meaning) AcMeaning,
decode (ht.lookup_code, '01', 'Faculty with Tenure', '02', 'Non-Tenured Faculty (Those on tenure track)',  '03',  'Non-Tenured Faculty (Those not on tenure track)', ht.meaning) TenMeaning, 
	PQH_PQIPED8_XMLP_PKG.cf_grouptottitleformula(ht.lookup_code) CF_GroupTotTitle, 
	PQH_PQIPED8_XMLP_PKG.cf_grouplinenumformula(ht.lookup_code) CF_groupLineNum, 
	PQH_PQIPED8_XMLP_PKG.cf_1formula() line
from hr_lookups hl,
hr_lookups ht
where hl.lookup_type = 'PQH_ACADEMIC_RANK'
and ht.lookup_type = 'PQH_TENURE_STATUS'
and ht.lookup_code in ('01', '02','03')
order by TenStat,TenMeaning,AcRank desc,AcMeaning desc*/
select AcRank,TenStat,AcMeaning,TenMeaning,CF_GroupTotTitle,CF_groupLineNum,PQH_PQIPED8_XMLP_PKG.cf_1formula() line,rownum from 
( select hl.lookup_code AcRank,
ht.lookup_code TenStat,
decode( hl.lookup_code, '01', 'Other Faculty', hl.meaning) AcMeaning,
decode (ht.lookup_code, '01', 'Faculty with Tenure', '02', 'Non-Tenured Faculty (Those on tenure track)',  '03',  'Non-Tenured Faculty (Those not on tenure track)', ht.meaning) TenMeaning, 
	PQH_PQIPED8_XMLP_PKG.cf_grouptottitleformula(ht.lookup_code) CF_GroupTotTitle, 
	PQH_PQIPED8_XMLP_PKG.cf_grouplinenumformula(ht.lookup_code) CF_groupLineNum
	from hr_lookups hl,
hr_lookups ht
where hl.lookup_type = 'PQH_ACADEMIC_RANK'
and ht.lookup_type = 'PQH_TENURE_STATUS'
and ht.lookup_code in ('01', '02','03')
order by TenStat,TenMeaning,AcRank desc,AcMeaning desc)
Parameter Name SQL text Validation
Reporting Date 
 
 Date
Download
Related Blitz Reports
CAC Shipping Network (Inter-Org) Accounts Setup CAC WIP Accounts Setup AR Profile Option Migration CAC Subinventory Accounts Setup CAC Purchase Price Variance CAC ICP PII WIP Pending Cost Adjustment CAC WIP Pending Cost Adjustment CAC Item List Price vs. Item Cost CAC Category Accounts Setup CAC Calculate ICP PII Item Costs
Blitz Report™

Blitz Report™ provides multiple benefits: