View Requests and Projects
Filters:

Loading list...
| Request Date |
Request # |
WO/PR/CP |
Requestor |
Building/Room |
Description |
Status |
Contacts |
Construction Dates |
| 12/19/2012 | SR302838 | WA24625 | Charles Jarmon | MWL COM | Code Compliance Audit - Mwl Com | Open Billing Info | Scott Jarmon 4-5359 | |
| 05/21/2013 | SR311774 | WA44997 | David Mark Bunker | MWL COM | Install Swale Next to the Sidewalk to Help Drainage | Open | Barb Steiner 290-2307 | |
| 02/08/2013 | SR305627 | PR016865 | Shellie Black | MWL COM | Replacement of the Elevated Walkways | Approved | Shellie Black 4-1677 | 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='MWL COM' 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='MWL COM' 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='MWL COM' and active='Y' order by enter_date