View Requests and Projects
Filters:

Loading list...
| Request Date |
Request # |
WO/PR/CP |
Requestor |
Building/Room |
Description |
Status |
Contacts |
Construction Dates |
| 03/11/2013 | SR307436 | WA35299 | Blair Ashley Gershenson | SLOSS H 0205 | Water Damage on Ceiling | Scheduled | Ken Soll 460-8532 | |
| 04/30/2013 | SR310488 | WA42297 | Charles Jarmon | SLOSS H 0001 | Fire Extinguisher Maintenance - Sloss H | Open Billing Info | Scott Jarmon 4-5359 | |
| 05/24/2013 | SR311963 | WA45542 | Dps | SLOSS H | Zone 10 Temp Low Alarm - Confirm: Mike Hanson | Open Billing Info | Don Hoffmann 460-8534 | |
| 06/07/2013 | SR312730 | WA47186 | Kay Williams | SLOSS H A | Gutter Plugged and Full of Water | Scheduled | Ken Soll 460-8532 | |
| 10/04/2012 | SR297725 | PR016548 | Voort Michael Arden Vande | SLOSS H | 1st 2nd Floor: Paint Walls, Seal Wood Floors, Paint Trim | Complete Billing Info | Steve Rentschler 460-1237 | Start: 12/17/2012 Due: 4/30/2013 |
select enter_date, req_number, requestor, description, building, room, req_status, assigned_to, active from famis.famis_req req, famis.famis_sr_status rs where req_status=rs.status and req_number like 'SR%' and req_status<>'SCHEDULED' and req_status<>'CONV PROJ' and requestor is not null and building='SLOSS H' and active='Y' order by enter_date
select enter_date, req_number, wo_number, requestor, description, building, room, wo_status, assigned_to, ws.active from famis.famis_req req, famis.famis_wo_status ws where wo_status=ws.status and req_status='SCHEDULED' and requestor is not null and wo_status not like 'STAND%' and building='SLOSS H' and active='Y' order by enter_date
select p.enter_date, p.req_number, p.requestor, p.description, p.building, p.room, p.status, p.assigned_to, p.project_manager, p.const_start_date, p.due_date, ps.active from famis.famis_pr p, famis_pr_status ps where p.status=ps.status and building='SLOSS H' and active='Y' order by enter_date