Iowa State University
Facilities Planning and Management
FP&M Home Campus Space Data Planning / Design / Construction Operation / Maintenance / Repair Utility Services

Request for Services Form

View Requests and Projects

Filters:
Status:
Building: ISU Campus All
Requestor:
Department:
Loading list
Loading list...
Request Date Request # WO/PR/CP Requestor Building/Room Description Status Contacts Construction Dates
12/19/2012SR302836WA24622Charles Jarmon  KS DINE Code Compliance Audit - Ks DineOpen
Billing Info		Scott Jarmon
4-5359		 

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='KS DINE' 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='KS DINE' 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='KS DINE' and active='Y' order by enter_date