Content Comparison

selectThe sect.sectnameReport asServer section, role.roledescr, pers.perslastname as lastname, pers.persfirstname as firstname, 
pers.persuhuuid as uhnumber, pers.persitsusername as username, pers.persemail as email
from personnel pers, persposition ppos, section sect, role
where pers.persid = ppos.persid
and ppos.pposstatus = 'A'
and pers.roleid = role.roleid
and ppos.sectid = sect.sectid
union all 
-- all students
select sect.sectname as section, role.roledescr, std.stdlastname as lastname, std.stdfirstname as firstname, 
pers.persuhuuid as uhnumber, pers.persitsusername as username, pers.persemail as email
from personnel pers, persposition ppos, section sect, role,
seceadm.student@secedb_link.db.uh std,
seceadm.placement@secedb_link.db.uh plc
where pers.roleid = 9
and pers.roleid = role.roleid
and pers.persid = ppos.persid
and pers.persuhuuid = std.stduhuuid
and std.stdid = plc.stdid
and plc.plcstatus = 'A'
and plc.plcid = ppos.empid
and ppos.sectid = sect.sectid 
order by section, lastname, firstname; URL is: https://rps01.its.hawaii.edu
Access is managed by:  Clyde Kawano