Search FP&M:

Filters:

Loading list...

Request Date	Request #	WO/PR/CP	Requestor	Building/Room	Description	Status	Contacts	Construction Dates
05/21/2013	SR311741	WA44941	Angela Jean Witt	HUB	No Power to the Light in the West Vestibule	Open	Don Hoffmann 460-8534
10/08/2012	SR298089	PR016559	Cheryl Renee Ervin	HUB	Missing/Uneven/Broken Brick in Patio & N.Corners & Ck Roof Drain	Approved Billing Info	Chris Strawhacker 4-7071	Start: Due:
03/21/2013	SR308053	PR016982	Mark A. Reddish	HUB	Repair Leaking Reheat Coil in Attic	Scheduled Billing Info	Rich Corcoran 509-9983	Start: 4/22/2013 Due: 5/24/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='HUB' 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='HUB' 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='HUB' and active='Y' order by enter_date

Copyright © 1995-2013, Iowa State University, all rights reserved.
www.fpm.iastate.edu/forms/servicerequest/requests_projects.asp