declare @TempPerson varchar(50)
set @TempPerson = 'Enter_UserID_here'
declare @TempLike varchar(50)
set @TempLike = ('%' + @TempPerson + '%')

--		email
select *
from email
where email.personid = @TempPerson and isprimary = 1

--		PERSON
select supervisor, personid, displayname, title, department, status, delegate 
from person
where (supervisor = @tempperson) or (delegate = @TempPerson)

--		PERSONGROUP
select *
from persongroupteam
where persongroupteam.respparty = @TempPerson

--		JOBPLAN
Select jp.jpnum, jp.orgid, jp.siteid, jp.pluscrevnum, jp.status, jp.supervisor, jp.owner, jp.laborcode, *
from jobplan jp left join joblabor jl on jp.jobplanid = jl.jobplanid
where (jp.status not in ('REVISED') and ((jp.supervisor = @TempPerson) or (jp.owner = @TempPerson) or (jp.laborcode = @TempPerson) or (jl.laborcode = @TempPerson)))

--		PM
Select *
from pm
where ((pm.supervisor = @TempPerson) or (pm.owner = @TempPerson) or (pm.lead = @TempPerson))

--		POLine
select poline.ponum, po.siteid, poline.revisionnum, poline.polinenum, poline.requestedby, 
po.description, po.status, poline.location, po.receipts, poline.gldebitacct, poline.refwo, po.changedate  
from poline inner join po on poline.ponum = po.ponum and poline.revisionnum = po.revisionnum
where ((poline.requestedby = @TempPerson) 
	and (po.historyflag = 0))
order by poline.ponum, poline.revisionnum, poline.polinenum;

--		PRLine
select prline.prnum, pr.status, prline.siteid, prline.prlinenum, prline.description, prline.requestedby, prline.enterdate
from prline inner join pr on prline.prnum = pr.prnum and prline.siteid = pr.siteid
where ((prline.requestedby = @TempPerson)
	and (pr.historyflag = 0));

--		SR & Incidents & Investigations
select class, ticketid, siteid, assetsiteid, ticket.affectedperson, ticket.owner, tickettype, STATUS, reportdate,  
targetstart, targetfinish, reportedpriority--, *
from ticket
where ( (owner = @TempPerson) and (historyflag = 0) ); 

--		MRLine
select mrline.mrnum, mr.status, mrline.siteid, mrline.gldebitacct, mrline.mrlinenum, mrline.mrlineid, mrline.description, mrline.enterby, mr.type, mrline.complete 
from mrline inner join mr on mrline.mrnum = mr.mrnum and mrline.siteid = mr.siteid
where ((mrline.enterby = @TempPerson)
	and (mr.historyflag = 0) and (mr.type = 'STANDARD'));

--		WO's where userid = wpitem.requestedby
SELECT workorder.wonum, workorder.status, workorder.statusdate, wpitem.linetype, wpitem.itemnum, wpitem.description, wpitem.requestby, 
wpitem.issueto, wpitem.manufacturer, wpitem.modelnum 
FROM workorder INNER JOIN wpitem ON workorder.wonum = wpitem.wonum
WHERE ( (wpitem.pr is null) 
	AND (wpitem.requestby = @TempPerson or wpitem.issueto = @TempPerson) )
order by workorder.wonum;

--		active or future assignment for any/all apps
select assignmentid, assignment.siteid, assignment.laborcode, assignment.craft, assignment.wonum, assignment.status, workorder.status as wo_stat 
from assignment left join workorder on assignment.wonum = workorder.wonum and assignment.siteid = workorder.siteid
where laborcode = @TempPerson and assignment.status in ('ASSIGNED')

--		scheduled reports by/to user
declare @tempPrsnSearch varchar(50)
set @tempPrsnSearch = '%'+ @TempPerson + '%' 
declare @tempEmailFull varchar(250)
set @tempEmailFull = '%' + (select emailaddress from email where personid = @TempPerson and isprimary = 1 and type = 'WORK') + '%'
SELECT reportsched.userid as UserID, reportsched.appname as AppName, reportsched.type as RptType, crontaskinstance.schedule,  
report.description as RptDesc, reportsched.emailsubject as EmailSubj, reportsched.emailusers, --reportsched.emailcomments, 
reportsched.emailfiletype as Format, reportsched.emailtype as FileType, reportsched.reportname as RptName 
FROM report INNER JOIN 	(reportsched INNER JOIN crontaskinstance ON (reportsched.instancename = crontaskinstance.instancename) AND (reportsched.crontaskname = crontaskinstance.crontaskname)) 
	ON (report.appname = reportsched.appname) AND (report.reportname = reportsched.reportname)
where reportsched.emailusers like @tempPrsnSearch or reportsched.emailusers like @tempEmailFull
order by reportsched.userid, reportsched.appname;

--		on distribution list from communication template
SELECT commtemplate.templateid, commtemplate.description,commtemplate.objectname, commtmpltsendto.type, 
COMMTMPLTSENDTO.SENDTOVALUE, commtmpltsendto.sendto, commtmpltsendto.cc, commtmpltsendto.bcc
FROM commtemplate INNER JOIN commtmpltsendto ON commtemplate.templateid = commtmpltsendto.templateid
where commtmpltsendto.sendtovalue = @TempPerson;

--		contract named user
select contract.contractnum, contract.revisionnum, contract.description, contract.vendor, contract.status, namedusers.personid  
from namedusers join contract on contract.contractnum = namedusers.contractnum and contract.revisionnum = namedusers.revisionnum 
where namedusers.personid = @TempPerson
 
--		asset owner/custodian
select  asset.assetnum, asset.description, asset.siteid, asset.location, 
asset.status, assetlocusercust.personid, assetlocusercust.isprimary, assetlocusercust.iscustodian, assetlocusercust.isuser 
from asset inner join assetlocusercust on asset.assetnum = assetlocusercust.assetnum 
where assetlocusercust.personid = @TempPerson

--		location owner/custodian
select  locations.location, locations.description, locations.siteid, locations.status, 
assetlocusercust.personid, assetlocusercust.isprimary, assetlocusercust.iscustodian, assetlocusercust.isuser 
from locations inner join assetlocusercust on locations.location = assetlocusercust.location 
where assetlocusercust.personid = @TempPerson

--		InvReserve
select invreserveid, requestnum, itemnum, siteid, location, wonum, requestedby, issueto, requesteddate, requireddate 
from invreserve
where (invreserve.requestedby = @TempPerson) or (invreserve.issueto = @TempPerson)


--		queries tied to UserID
select query.*
from query inner join person on query.owner = person.personid
where person.status = 'active' and query.clause like @TempLike

--		public queries

--		queries tied to result sets

--		PM email notifications