Query	Module	4	5.1	Name	Description	Category	4.1 + Query	5.1 + Query
1	Any Module		X	ROW LIMIT <200	Row Limit <=200	Row Limit		WHERE  (crewid like 'MCB%1401' and historyflag = 'N' and istask = 'Y') and rownum <= 200
2	EQUIPMENT		X	HAZZID	Equip where HAZZARDID =?	Hazzard		WHERE (eq9 like 'MEH%') and eqnum in (select eqnum from safetylexicon where hazardid='SCS-EVT')
3	EQUIPMENT		X	REPLACE EQ PUR	REPLACE EQ IF total cost is > purchase price	Flagged		WHERE  (equipment.purchaseprice>1) and (equipment.totalcost>purchaseprice)
4	EQUIPMENT		X	REPLACE EQ REPL	REPLACE EQ if total cost is > replacement price	Flagged		WHERE  (equipment.replacecost>1) and (equipment.totalcost>replacecost)
5	Labor Reporting		X	Search by Crew	Search By Crew	Crew		WHERE  LABORCODE in (select LABORCODE from LABTRANS where ((CREWID like'%MMM%') and (LABORCODE = LABOR.LABORCODE)))
6	WorkOrder	X		All YTD	ALL Jobs YTD	All jobs	WHERE WORKORDER.REPORTDATE >= '2003-01-01-0.00.00' AND WORKORDER.SUPERVISOR LIKE 'MMM%1401'
7	WorkOrder	X		Not Planned YTD.	All Reactive Jobs Not in PM, PD	All jobs	WHERE WORKORDER.REPORTDATE >= '2003-01-01-0.00.00' AND WORKORDER.WORKTYPE Not In ('PM','PD') AND WORKORDER.SUPERVISOR LIKE 'MMM%1401'
8	WorkOrder	X		Planned YTD..	All Preventive	All jobs	WHERE WORKORDER.REPORTDATE >= '2003-01-01-0.00.00' AND WORKORDER.WORKTYPE In ('PM','PD') AND WORKORDER.SUPERVISOR LIKE 'MMM%1401'
9	WorkOrder		X	BKLG fwd 3days	Backlog look ahead 3 days	Backlog		WHERE  (worktype not in ('OH','SO')) and (status not in ('COMP','MACLOSE','CAN') and upper(crewid) like 'MMM%' and historyflag = 'N' and targcompdate < trunc(sysdate +4) and targcompdate >= trunc(sysdate) and istask = 'N')
10	WorkOrder	X		Comp between Date	Completed BETWEEN ACTUAL FINISH DATE	Completed	WHERE WORKORDER. ACTFINISH BETWEEN '2003-08-13-0.00.00' AND '2003-08-13-23.59.59' AND WORKORDER.SUPERVISOR LIKE 'MMM%1401'
11	WorkOrder	X		Fin between Dates	BETWEEN ACTUAL FINISH DATE	Completed	WHERE WORKORDER. ACTFINISH BETWEEN '2003-08-13-0.00.00' AND '2003-08-13-23.59.59' AND WORKORDER.SUPERVISOR LIKE 'MMM%1401'
12	WorkOrder	X		LABOR	Closed WITHOUT labor between dates	Completed	WHERE WORKORDER.STATUS = 'CLOSE' AND WORKORDER.REPORTDATE BETWEEN '2004-01-01-0.00.00' AND '2004-09-07-23.59.59' AND WORKORDER.SUPERVISOR LIKE 'MCB%1401' AND WORKORDER.ACTLABHRS = 0
13	WorkOrder	X		LABOR.	Comp WITHOUT labor Year	Completed	WHERE WORKORDER.STATUS = 'CLOSE' AND WORKORDER.STATUS = 'COMP' AND WORKORDER.ACTLABHRS = 0 AND WORKORDER.REPORTDATE > '2004-01-01-0.00.00' AND WORKORDER.SUPERVISOR LIKE 'MCB%1401' AND WORKORDER.ACTLABHRS = 0
14	WorkOrder	X		OPEN	OPEN !=COMP	Completed	WHERE WORKORDER.STATUS != 'COMP' AND WORKORDER.SUPERVISOR LIKE 'MMM%1401' and (HISTORYFLAG = 'N')
15	WorkOrder	X		OPEN JOBS	Total open Jobs including 'COMP'	Completed	WHERE WORKORDER.SUPERVISOR LIKE 'MMM%1401' and (HISTORYFLAG = 'N')
16	WorkOrder		X	Workorders created	Workorders created by BEMSID all	Find jobs		WHERE  wonum in (select wonum from wostatus where (status like '%WAPPR%') and (changeby='M206755'))
17	WorkOrder		X	PJ created by	Planned jobs that has been created BEMSID	Find jobs		Where (istask = 'N' and worktype like '%P%') and wonum in (select wonum from wostatus where (status like '%WAPPR%') and (changeby in ('M485244','M398006')))
18	WorkOrder		X	Created 48Hrs	Created by BEMSID '48hrs' (Not PM's)	Find jobs		WHERE  reportdate >=trunc(sysdate-2) and wonum in (select wonum from wostatus where status='WAPPR' and changeby='M206755') and istask = 'N'
19	WorkOrder	X	X	Created by	Created by BEMSID 'TODAY' (Not PM's)	Find jobs	Where reportdate >=trunc(sysdate) and wonum in (select wonum from wostatus where status='WAPPR' and changeby='M206755')	WHERE  reportdate >=trunc(sysdate) and wonum in (select wonum from wostatus where status='WAPPR' and changeby='M206755') and istask = 'N'
20	WorkOrder	X	X	PC'S CREATED	Worktype 'PC' created by  '773025'	Find jobs	Where workorder.worktype = 'PC' and workorder.reportdate between '2004-01-01-00.00.00' and '2004-12-31-23.59.59' and wonum in (select wonum from wostatus where status='WAPPR' and changeby='M773025')	Where (historyflag = 'N' and istask = 'N' and worktype like '%PC%') and wonum in (select wonum from wostatus where (status like '%WAPPR%') and (changeby='M773025'))
21	WorkOrder		X	APPR today Crew	Aproved today on your Crew	Find jobs		WHERE  (upper(crewid) like 'MCB%1401') and wonum in (select wonum from wostatus where status='APPR' and changedate >trunc(sysdate-0) and istask='N')
22	WorkOrder	X	X	NEW JOBS	New Jobs for today (SYSDATE) open or closed	Find jobs	WHERE WORKORDER.REPORTDATE >=trunc(sysdate) AND WORKORDER.SUPERVISOR LIKE 'MCB%1401'	WHERE  workorder.reportdate >=trunc(sysdate) and (upper(crewid) like 'MCB%1401') and (istask = 'N' )
23	WorkOrder	X	X	NEW...	Created by BEMSID ALL	Find jobs	Where wonum in (select wonum from wostatus where status='WAPPR' and changeby='M773025')	WHERE wonum in (select wonum from wostatus where (status like '%WAPPR%') and (changeby='M206755')) and (historyflag = 'N' and istask = 'N')
24	WorkOrder		X	WAPPR  ALL	Current WAPPR jobs in your crew	Find jobs		WHERE  workorder.status = 'WAPPR' and (upper(crewid) like 'MCB%1401')
25	WorkOrder	X	X	PC'S CREATED	PC Worktype created by '773025'	Find jobs	Where workorder.worktype = 'PC' and workorder.reportdate between '2004-01-01-00.00.00' and '2004-12-31-23.59.59' and wonum in (select wonum from wostatus where status='WAPPR' and changeby='M773025')	Where (historyflag = 'N' and istask = 'N' and worktype like '%PC%') and wonum in (select wonum from wostatus where (status like '%WAPPR%') and (changeby='M773025'))
26	WorkOrder		X	WAPPR NEW	New Jobs for today (SYSDATE) WAPPR	Find jobs		WHERE WORKORDER.STATUS = 'WAPPR' AND WORKORDER.REPORTDATE >=trunc(sysdate) AND (upper(crewid) like 'MCB%1401') and istask = 'N'
27	WorkOrder	X	X	NEW...	Created by ID today	Find jobs	Where reportdate >=trunc(sysdate) and wonum in (select wonum from wostatus where status='WAPPR' and changeby='M773025')	WHERE  workorder.reportdate >=trunc(sysdate) and wonum in (select wonum from wostatus where (status like '%WAPPR%') and (changeby='M206755'))
28	WorkOrder	X	X	Wappr Status Between	Workorders Statused by BEMSID BetweenDates	Find jobs	WHERE  wonum in(select wonum from wostatus where status = 'WAPPR' and changedate <= TO_DATE ('2005-08-04' , 'YYYY-MM-DD') and changedate >= TO_DATE ('2005-08-02' , 'YYYY-MM-DD') and changeby in('M49288', 'M16171', 'M80165', 'M87231', 'M88926', 'M42165', 'M126741', 'M123346', 'M125223', 'M21956'))	WHERE  wonum in(select wonum from wostatus where status = 'WAPPR' and changedate <= TO_DATE ('2005-08-04' , 'YYYY-MM-DD') and changedate >= TO_DATE ('2005-08-02' , 'YYYY-MM-DD') and changeby in('M49288', 'M16171', 'M80165', 'M87231', 'M88926', 'M42165', 'M126741', 'M123346', 'M125223', 'M21956'))
29	WorkOrder	X		CLOSED	Closed Today (SYSDATE)	Find jobs	WHERE WORKORDER. ACTFINISH >=trunc(sysdate) AND WORKORDER.SUPERVISOR LIKE 'MCB%1401'
30	WorkOrder	X		MaintGrp	Search By Maintain Grp	Find jobs	WHERE WORKORDER.WOEQ9 = 'MMMXXXXX' and (HISTORYFLAG = 'N')
31	WorkOrder	X		NEW.	BETWEEN REPORT DATE	Find jobs	WHERE WORKORDER.REPORTDATE BETWEEN '2003-08-13-00.00.00' AND '2003-08-13-23.59.59' AND WORKORDER.SUPERVISOR LIKE 'MMM%1401'
32	WorkOrder	X	X	NEW PMS	New PMs for today (SYSDATE)	Find PM's	WHERE WORKORDER.REPORTDATE >=trunc(sysdate) AND WORKORDER.WORKTYPE in ('PM','PD') AND WORKORDER.SUPERVISOR LIKE 'MCB%1401'	WHERE  workorder.reportdate >=trunc(sysdate) and workorder.worktype in ('PM','PD') and (upper(crewid) like 'MCB%1401') and (historyflag = 'N' and istask = 'N')
33	WorkOrder		X	NEW UNASS PM	NEW Unassigned PM's Released today	Find PM's		WHERE  leadcraft is null and workorder.reportdate >=trunc(sysdate) and workorder.worktype in ('PM','PD') and (upper(crewid) like 'MCB%1401') and (historyflag = 'N' and istask = 'N')
34	WorkOrder		X	NEW UNSC PMs	NEW UnScheduled  PM's Released today	Find PM's		WHERE  schedstart is null and workorder.reportdate >=trunc(sysdate) and workorder.worktype in ('PM','PD') and (upper(crewid) like 'MCB%1401') and (historyflag = 'N' and istask = 'N')
35	WorkOrder		X	UNASSIGN PM	All Unassigned PM's	Find PM's		WHERE  leadcraft is null and workorder.worktype in ('PM','PD') and (upper(crewid) like 'MCB%1401') and (historyflag = 'N' and istask = 'N')
36	WorkOrder		X	UNSCHED PM	All UN-Scheduled PM's	Find PM's		WHERE  schedstart is null and workorder.worktype in ('PM','PD') and (upper(crewid) like 'MCB%1401') and (historyflag = 'N' and istask = 'N')
37	WorkOrder	X		NEW PM'S	New PM's BETWEEN Report Dates	Find PM's	WHERE WORKORDER.REPORTDATE BETWEEN '2004-01-29-00.00.00' AND '2004-01-29-23.59.59' AND WORKORDER.SUPERVISOR LIKE 'MMM%1401' and WORKORDER.WORKTYPE in ('PM','PD')
38	WorkOrder	X		ALL JOBS.	MAINTENANCE HISTORY	History	WHERE WORKORDER.SUPERVISOR LIKE 'M%'
39	WorkOrder	X		ALL JOBS..	MAINTENANCE HISTORY - year	History	WHERE WORKORDER. ACTFINISH >= '2003-01-01-0.00.00' AND WORKORDER.SUPERVISOR LIKE 'M%'
40	WorkOrder	X	X	PlansTab	Plans tab -LaborCode search by crew	Labor code	WHERE WORKORDER.REPORTDATE BETWEEN '2004-03-31-00.00.00' AND '2005-03-31-23.59.59' AND WORKORDER.SUPERVISOR LIKE 'MMMC1401' and wonum in(select wonum from WPlabor where laborcode ='CBTR') and WORKORDER.WORKTYPE = 'PM'	WHERE  (status not like '%C%O%')and   workorder.crewid like 'MSGS1801' and wonum in(select wonum from wplabor where laborcode ='ELEV') and workorder.worktype in ('RD','PJ','PM') and istask='N'
41	WorkOrder		X	UNASSIGN PM	All UNASSIGNED PM'S for Crew	Leadcraft		WHERE  leadcraft IS NULL and workorder.worktype in ('PM','PD') and (upper(crewid) like 'MCB%1401') and (historyflag = 'N' and istask = 'N')
42	WorkOrder	X		NULL	Bad Data Incomplete fields (All Jobs)	Null	WHERE (SUPERVISOR Like 'MCB%1401') AND ((STATUS Not In ('COMP','CLOSE','CAN')) AND (WOPRIORITY Is Null) OR (LEADCRAFT IS NULL) OR (TARGSTARTDATE Is Null) OR (TARGCOMPDATE Is Null) OR (SCHEDSTART Is Null) OR (SCHEDFINISH Is Null))
43	WorkOrder	X		NULL.	Bad Data Incomplete fields	Null	WHERE (SUPERVISOR Like 'MCB%1401') AND WORKTYPE NOT IN ('OH','SO') AND ((STATUS Not In ('COMP','CLOSE','CAN')) AND (WOPRIORITY Is Null) OR (TARGSTARTDATE Is Null) OR (TARGCOMPDATE Is Null) OR (SCHEDSTART Is Null) OR (SCHEDFINISH Is Null))
44	WorkOrder	X		PROBLEM CODE	PROBLEM CODE IS NOT NULL	Null	WHERE WORKORDER.PROBLEMCODE IS NOT NULL AND WORKORDER.SUPERVISOR LIKE 'MM%'
45	WorkOrder	X	X	MR COUNT	MR- Count WorkOrders with MR's	Reqs	Where WORKORDER.SUPERVISOR Like 'MCB%1401' and wonum in (select wonum from mr where MR.MRNUM Is Not Null)	Where upper(crewid) like 'MCB%1401' and wonum in (select wonum from mr where MR.MRNUM Is Not Null)
46	WorkOrder		X	NULL S. DATES	No Schedule Dates	Schedule date		WHERE  (upper(crewid) like 'MCB%1401' and historyflag = 'N' and schedstart is null and istask = 'N' and worktype not like '%O%')
47	WorkOrder		X	NULL S. DATES	No Schedule Dates Excludes OH, SO and Excludes status of comp, close, Maclose	Schedule date		WHERE  ((status not like '%C%O%' and crewid like 'MCB%1401') and historyflag = 'N' and schedstart is null and istask = 'N' and worktype not like '%O%')
48	WorkOrder	X	X	BACKLOG All	All Open Backlog >0 days old	Target date	WHERE WORKORDER.TARGCOMPDATE < trunc(sysdate) AND WORKORDER.SUPERVISOR LIKE 'MCB%1401' and (HISTORYFLAG = 'N')	WHERE  (worktype not in ('OH','SO')) and (status not in ('COMP','MACLOSE','CAN') and upper(crewid) like 'MCB%1401' and historyflag = 'N' and targcompdate < trunc(sysdate-0) and istask = 'N')
49	WorkOrder	X	X	BACKLOG 14D	Backlog >=14 Days Old	Target date	WHERE WORKORDER.STATUS != 'COMP' AND WORKORDER.TARGCOMPDATE < trunc(sysdate-13) AND WORKORDER.SUPERVISOR LIKE 'MCB%1401' AND WORKORDER.WORKTYPE not in ('OH', 'SO') and (HISTORYFLAG = 'N')	WHERE  (status != 'COMP' and upper(crewid) like 'MEHE1002%' and historyflag = 'N' and targcompdate < trunc(sysdate-13) and istask = 'N')
50	WorkOrder		X	BKLG 4Cast 7D	Backlog +7days look ahead	Target date		WHERE  (worktype not in ('OH','SO')) and (status not in ('COMP','MACLOSE','CAN') and upper(crewid) like 'MCB%' and historyflag = 'N' and targcompdate < trunc(sysdate +7) and targcompdate >= trunc(sysdate) and istask = 'N')
51	WorkOrder		X	Created by PJ	Planned jobs that Individuals has created	Types Created		Where (istask = 'N' and worktype like '%P%') and wonum in (select wonum from wostatus where (status like '%WAPPR%') and (changeby in ('M485244','M398006')))
52	WorkOrder	X	X	COMP- NO VAR	COMPed jobs NO variance	Completed	WHERE WORKORDER.STATUS = 'COMP' AND WORKORDER.SUPERVISOR LIKE 'MCB%1401' AND WORKORDER.WO5 is null and (HISTORYFLAG = 'N')	WHERE  (workorder.status = 'COMP' and upper(crewid) like 'MCB%1401') and workorder.wo5 is null and (historyflag = 'N' and istask = 'N')
53	WorkOrder	X	X	COMP Var	COMPed jobs WITH a variance	Completed	WHERE WORKORDER.STATUS = 'COMP' AND WORKORDER.SUPERVISOR LIKE 'MCB%1401' AND WORKORDER.WO5 is not null and (HISTORYFLAG = 'N') and (HISTORYFLAG = 'N')	WHERE  (workorder.status = 'COMP' and upper(crewid) like 'MCB%1401') and workorder.wo5 is not null and (historyflag = 'N')