Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

Version 1 Next »


select sect.sectname as 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;





  • No labels