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

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
/*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