View Requests and Projects
Filters:

Loading list...
| Request Date |
Request # |
WO/PR/CP |
Requestor |
Building/Room |
Description |
Status |
Contacts |
Construction Dates |
| 04/19/2012 | SR286338 | PR015979 | Michael J. Olson | N CHWP | ISU Campus and North Campus Chilled Water Plant Arc Flash Study | Open Billing Info | Mike Olson 4-6312 | Start: Due: |
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='N CHWP' 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='N CHWP' 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='N CHWP' and active='Y' order by enter_date