V_BUSINESSPROCESSPARAMETERSETS

/* 
Generated by Blackbaud AppFx Platform
Date:  2/6/2025 8:55:10 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3901.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_BUSINESSPROCESSPARAMETERSETS WITH SCHEMABINDING AS
select [ACKNOWLEDGEMENTPROCESS].[ID] as [PARAMETERSETID], [ACKNOWLEDGEMENTPROCESS].[NAME] as [NAME], '02e8a918-fb90-4c3d-a70e-821db5da7a1f' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [ACKNOWLEDGEMENTPROCESS].[ADDEDBYID], [ACKNOWLEDGEMENTPROCESS].[CHANGEDBYID], [ACKNOWLEDGEMENTPROCESS].[DATEADDED], [ACKNOWLEDGEMENTPROCESS].[DATECHANGED], [ACKNOWLEDGEMENTPROCESS].[TSLONG]
from dbo.[ACKNOWLEDGEMENTPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [ACKNOWLEDGEMENTPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [ADDOPPORTUNITIESPROCESS].[ID] as [PARAMETERSETID], [ADDOPPORTUNITIESPROCESS].[NAME] as [NAME], '41d4787b-c66b-4b83-8f49-788013bdad40' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [ADDOPPORTUNITIESPROCESS].[ADDEDBYID], [ADDOPPORTUNITIESPROCESS].[CHANGEDBYID], [ADDOPPORTUNITIESPROCESS].[DATEADDED], [ADDOPPORTUNITIESPROCESS].[DATECHANGED], [ADDOPPORTUNITIESPROCESS].[TSLONG]
from dbo.[ADDOPPORTUNITIESPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [ADDOPPORTUNITIESPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [ADDPROSPECTPLANSPROCESS].[ID] as [PARAMETERSETID], [ADDPROSPECTPLANSPROCESS].[NAME] as [NAME], '59ba0c29-3410-4c65-adf8-25242a005ebc' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [ADDPROSPECTPLANSPROCESS].[ADDEDBYID], [ADDPROSPECTPLANSPROCESS].[CHANGEDBYID], [ADDPROSPECTPLANSPROCESS].[DATEADDED], [ADDPROSPECTPLANSPROCESS].[DATECHANGED], [ADDPROSPECTPLANSPROCESS].[TSLONG]
from dbo.[ADDPROSPECTPLANSPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [ADDPROSPECTPLANSPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [ADDREQUESTSFORMULTIPLESTUDENTSPROCESS].[ID] as [PARAMETERSETID], [ADDREQUESTSFORMULTIPLESTUDENTSPROCESS].[NAME] as [NAME], '5a8f1271-b682-440f-92f1-5e9af30a820c' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [ADDREQUESTSFORMULTIPLESTUDENTSPROCESS].[ADDEDBYID], [ADDREQUESTSFORMULTIPLESTUDENTSPROCESS].[CHANGEDBYID], [ADDREQUESTSFORMULTIPLESTUDENTSPROCESS].[DATEADDED], [ADDREQUESTSFORMULTIPLESTUDENTSPROCESS].[DATECHANGED], [ADDREQUESTSFORMULTIPLESTUDENTSPROCESS].[TSLONG]
from dbo.[ADDREQUESTSFORMULTIPLESTUDENTSPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [ADDREQUESTSFORMULTIPLESTUDENTSPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [ADDRESSVALIDATIONPROCESS].[ID] as [PARAMETERSETID], [ADDRESSVALIDATIONPROCESS].[NAME] as [NAME], '3e0ecea2-194e-4260-a9d6-4fc21de8867c' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [ADDRESSVALIDATIONPROCESS].[ADDEDBYID], [ADDRESSVALIDATIONPROCESS].[CHANGEDBYID], [ADDRESSVALIDATIONPROCESS].[DATEADDED], [ADDRESSVALIDATIONPROCESS].[DATECHANGED], [ADDRESSVALIDATIONPROCESS].[TSLONG]
from dbo.[ADDRESSVALIDATIONPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [ADDRESSVALIDATIONPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [ADDSTEWARDSHIPPLANSPROCESS].[ID] as [PARAMETERSETID], [ADDSTEWARDSHIPPLANSPROCESS].[NAME] as [NAME], '30c7d3e1-bfd3-4534-8004-a3f5e5cf9e48' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [ADDSTEWARDSHIPPLANSPROCESS].[ADDEDBYID], [ADDSTEWARDSHIPPLANSPROCESS].[CHANGEDBYID], [ADDSTEWARDSHIPPLANSPROCESS].[DATEADDED], [ADDSTEWARDSHIPPLANSPROCESS].[DATECHANGED], [ADDSTEWARDSHIPPLANSPROCESS].[TSLONG]
from dbo.[ADDSTEWARDSHIPPLANSPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [ADDSTEWARDSHIPPLANSPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [ADDSTEWARDSHIPPLANSTEPSPROCESS].[ID] as [PARAMETERSETID], [ADDSTEWARDSHIPPLANSTEPSPROCESS].[NAME] as [NAME], '4ebbd25a-4c8a-4313-a211-f74ed0f01dd4' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [ADDSTEWARDSHIPPLANSTEPSPROCESS].[ADDEDBYID], [ADDSTEWARDSHIPPLANSTEPSPROCESS].[CHANGEDBYID], [ADDSTEWARDSHIPPLANSTEPSPROCESS].[DATEADDED], [ADDSTEWARDSHIPPLANSTEPSPROCESS].[DATECHANGED], [ADDSTEWARDSHIPPLANSTEPSPROCESS].[TSLONG]
from dbo.[ADDSTEWARDSHIPPLANSTEPSPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [ADDSTEWARDSHIPPLANSTEPSPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [ADHOCQUERY].[ID] as [PARAMETERSETID], [ADHOCQUERY].[NAME] as [NAME], '4b57e99d-4009-46bc-acfb-6f62972079c2' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [ADHOCQUERY].[ADDEDBYID], [ADHOCQUERY].[CHANGEDBYID], [ADHOCQUERY].[DATEADDED], [ADHOCQUERY].[DATECHANGED], [ADHOCQUERY].[TSLONG]
from dbo.[ADHOCQUERY] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [ADHOCQUERY].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [ADHOCQUERYDEPENDENCYBUSINESSPROCESS].[ID] as [PARAMETERSETID], [ADHOCQUERYDEPENDENCYBUSINESSPROCESS].[NAME] as [NAME], '340c7430-3e0a-4edf-936a-747ba0fc32aa' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [ADHOCQUERYDEPENDENCYBUSINESSPROCESS].[ADDEDBYID], [ADHOCQUERYDEPENDENCYBUSINESSPROCESS].[CHANGEDBYID], [ADHOCQUERYDEPENDENCYBUSINESSPROCESS].[DATEADDED], [ADHOCQUERYDEPENDENCYBUSINESSPROCESS].[DATECHANGED], [ADHOCQUERYDEPENDENCYBUSINESSPROCESS].[TSLONG]
from dbo.[ADHOCQUERYDEPENDENCYBUSINESSPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [ADHOCQUERYDEPENDENCYBUSINESSPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [ALERTTYPE].[ID] as [PARAMETERSETID], [ALERTTYPE].[NAME] as [NAME], '2602d52f-bf84-485f-9051-f5474351dd9e' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [ALERTTYPE].[ADDEDBYID], [ALERTTYPE].[CHANGEDBYID], [ALERTTYPE].[DATEADDED], [ALERTTYPE].[DATECHANGED], [ALERTTYPE].[TSLONG]
from dbo.[ALERTTYPE] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [ALERTTYPE].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [ASSIGNCONSTITSECURITYATTRIBUTESPROCESS].[ID] as [PARAMETERSETID], [ASSIGNCONSTITSECURITYATTRIBUTESPROCESS].[NAME] as [NAME], '7787a828-36a0-4e86-b86e-c501e528963c' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [ASSIGNCONSTITSECURITYATTRIBUTESPROCESS].[ADDEDBYID], [ASSIGNCONSTITSECURITYATTRIBUTESPROCESS].[CHANGEDBYID], [ASSIGNCONSTITSECURITYATTRIBUTESPROCESS].[DATEADDED], [ASSIGNCONSTITSECURITYATTRIBUTESPROCESS].[DATECHANGED], [ASSIGNCONSTITSECURITYATTRIBUTESPROCESS].[TSLONG]
from dbo.[ASSIGNCONSTITSECURITYATTRIBUTESPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [ASSIGNCONSTITSECURITYATTRIBUTESPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [ASSIGNLETTERCODESPROCESS].[ID] as [PARAMETERSETID], [ASSIGNLETTERCODESPROCESS].[NAME] as [NAME], 'a3a2d937-b5ff-4b2e-8a1b-640f895c2183' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [ASSIGNLETTERCODESPROCESS].[ADDEDBYID], [ASSIGNLETTERCODESPROCESS].[CHANGEDBYID], [ASSIGNLETTERCODESPROCESS].[DATEADDED], [ASSIGNLETTERCODESPROCESS].[DATECHANGED], [ASSIGNLETTERCODESPROCESS].[TSLONG]
from dbo.[ASSIGNLETTERCODESPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [ASSIGNLETTERCODESPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [ASSIGNPLANNEDGIFTLETTERCODESPROCESS].[ID] as [PARAMETERSETID], [ASSIGNPLANNEDGIFTLETTERCODESPROCESS].[NAME] as [NAME], '37910a93-c849-4b83-8664-bb22bd12eafc' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [ASSIGNPLANNEDGIFTLETTERCODESPROCESS].[ADDEDBYID], [ASSIGNPLANNEDGIFTLETTERCODESPROCESS].[CHANGEDBYID], [ASSIGNPLANNEDGIFTLETTERCODESPROCESS].[DATEADDED], [ASSIGNPLANNEDGIFTLETTERCODESPROCESS].[DATECHANGED], [ASSIGNPLANNEDGIFTLETTERCODESPROCESS].[TSLONG]
from dbo.[ASSIGNPLANNEDGIFTLETTERCODESPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [ASSIGNPLANNEDGIFTLETTERCODESPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [AWARDMANAGEMENTINTEGRATIONPROCESS].[ID] as [PARAMETERSETID], [AWARDMANAGEMENTINTEGRATIONPROCESS].[NAME] as [NAME], '015aaeee-e1d8-4cd3-98c6-cd5046bc9ceb' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [AWARDMANAGEMENTINTEGRATIONPROCESS].[ADDEDBYID], [AWARDMANAGEMENTINTEGRATIONPROCESS].[CHANGEDBYID], [AWARDMANAGEMENTINTEGRATIONPROCESS].[DATEADDED], [AWARDMANAGEMENTINTEGRATIONPROCESS].[DATECHANGED], [AWARDMANAGEMENTINTEGRATIONPROCESS].[TSLONG]
from dbo.[AWARDMANAGEMENTINTEGRATIONPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [AWARDMANAGEMENTINTEGRATIONPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [BATCH].[ID] as [PARAMETERSETID], [BATCH].[BATCHNUMBER] as [NAME], '2d0785f5-bf9f-4e1f-81cf-d2e5fc01dc85' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [BATCH].[ADDEDBYID], [BATCH].[CHANGEDBYID], [BATCH].[DATEADDED], [BATCH].[DATECHANGED], [BATCH].[TSLONG]
from dbo.[BATCH] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [BATCH].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [BATCHESCOMMITPROCESS].[ID] as [PARAMETERSETID], [BATCHESCOMMITPROCESS].[NAME] as [NAME], '8bda5883-5fc0-4b1e-b88a-b6cba975f515' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [BATCHESCOMMITPROCESS].[ADDEDBYID], [BATCHESCOMMITPROCESS].[CHANGEDBYID], [BATCHESCOMMITPROCESS].[DATEADDED], [BATCHESCOMMITPROCESS].[DATECHANGED], [BATCHESCOMMITPROCESS].[TSLONG]
from dbo.[BATCHESCOMMITPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [BATCHESCOMMITPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [BBNCTRANSACTIONDOWNLOADEXCEPTION].[ID] as [PARAMETERSETID], [BBNCTRANSACTIONDOWNLOADEXCEPTION].[EXCEPTIONNAME] as [NAME], 'cb98f8cd-24f2-4cfa-97a3-eb8cc217846e' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [BBNCTRANSACTIONDOWNLOADEXCEPTION].[ADDEDBYID], [BBNCTRANSACTIONDOWNLOADEXCEPTION].[CHANGEDBYID], [BBNCTRANSACTIONDOWNLOADEXCEPTION].[DATEADDED], [BBNCTRANSACTIONDOWNLOADEXCEPTION].[DATECHANGED], [BBNCTRANSACTIONDOWNLOADEXCEPTION].[TSLONG]
from dbo.[BBNCTRANSACTIONDOWNLOADEXCEPTION] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [BBNCTRANSACTIONDOWNLOADEXCEPTION].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [BILLINGGENERATETRANSACTIONSPROCESS].[ID] as [PARAMETERSETID], [BILLINGGENERATETRANSACTIONSPROCESS].[NAME] as [NAME], '2f045f7c-60d3-4c0a-ad81-4a29c7a05079' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [BILLINGGENERATETRANSACTIONSPROCESS].[ADDEDBYID], [BILLINGGENERATETRANSACTIONSPROCESS].[CHANGEDBYID], [BILLINGGENERATETRANSACTIONSPROCESS].[DATEADDED], [BILLINGGENERATETRANSACTIONSPROCESS].[DATECHANGED], [BILLINGGENERATETRANSACTIONSPROCESS].[TSLONG]
from dbo.[BILLINGGENERATETRANSACTIONSPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [BILLINGGENERATETRANSACTIONSPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [BUSINESSPROCESSJOBSCHEDULECONVERSIONPROCESS].[ID] as [PARAMETERSETID], [BUSINESSPROCESSJOBSCHEDULECONVERSIONPROCESS].[NAME] as [NAME], '7c68f8da-0d7a-44c3-8378-714c0af439fa' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [BUSINESSPROCESSJOBSCHEDULECONVERSIONPROCESS].[ADDEDBYID], [BUSINESSPROCESSJOBSCHEDULECONVERSIONPROCESS].[CHANGEDBYID], [BUSINESSPROCESSJOBSCHEDULECONVERSIONPROCESS].[DATEADDED], [BUSINESSPROCESSJOBSCHEDULECONVERSIONPROCESS].[DATECHANGED], [BUSINESSPROCESSJOBSCHEDULECONVERSIONPROCESS].[TSLONG]
from dbo.[BUSINESSPROCESSJOBSCHEDULECONVERSIONPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [BUSINESSPROCESSJOBSCHEDULECONVERSIONPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [CLEARMATCHINGGIFTCLAIMSPROCESS].[ID] as [PARAMETERSETID], [CLEARMATCHINGGIFTCLAIMSPROCESS].[NAME] as [NAME], 'febdf7ba-8182-44bb-8347-37a147c0c75c' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [CLEARMATCHINGGIFTCLAIMSPROCESS].[ADDEDBYID], [CLEARMATCHINGGIFTCLAIMSPROCESS].[CHANGEDBYID], [CLEARMATCHINGGIFTCLAIMSPROCESS].[DATEADDED], [CLEARMATCHINGGIFTCLAIMSPROCESS].[DATECHANGED], [CLEARMATCHINGGIFTCLAIMSPROCESS].[TSLONG]
from dbo.[CLEARMATCHINGGIFTCLAIMSPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [CLEARMATCHINGGIFTCLAIMSPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [COAUPDATECREATEPROCESS].[ID] as [PARAMETERSETID], [COAUPDATECREATEPROCESS].[NAME] as [NAME], '476deb56-3869-4216-9592-02ddae091f53' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [COAUPDATECREATEPROCESS].[ADDEDBYID], [COAUPDATECREATEPROCESS].[CHANGEDBYID], [COAUPDATECREATEPROCESS].[DATEADDED], [COAUPDATECREATEPROCESS].[DATECHANGED], [COAUPDATECREATEPROCESS].[TSLONG]
from dbo.[COAUPDATECREATEPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [COAUPDATECREATEPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [COAUPDATEGETPROCESS].[ID] as [PARAMETERSETID], [COAUPDATEGETPROCESS].[NAME] as [NAME], '9940fd4a-adf6-4031-ac2b-72766a808367' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [COAUPDATEGETPROCESS].[ADDEDBYID], [COAUPDATEGETPROCESS].[CHANGEDBYID], [COAUPDATEGETPROCESS].[DATEADDED], [COAUPDATEGETPROCESS].[DATECHANGED], [COAUPDATEGETPROCESS].[TSLONG]
from dbo.[COAUPDATEGETPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [COAUPDATEGETPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [COAUPDATERESUBMITPROCESS].[ID] as [PARAMETERSETID], [COAUPDATERESUBMITPROCESS].[NAME] as [NAME], '5d22b518-d8bd-40ae-a5da-8d586513b030' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [COAUPDATERESUBMITPROCESS].[ADDEDBYID], [COAUPDATERESUBMITPROCESS].[CHANGEDBYID], [COAUPDATERESUBMITPROCESS].[DATEADDED], [COAUPDATERESUBMITPROCESS].[DATECHANGED], [COAUPDATERESUBMITPROCESS].[TSLONG]
from dbo.[COAUPDATERESUBMITPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [COAUPDATERESUBMITPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [COAUPDATESUBMITPROCESS].[ID] as [PARAMETERSETID], [COAUPDATESUBMITPROCESS].[NAME] as [NAME], '113412a7-daa5-4ef6-9c0d-8aaa9024e06a' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [COAUPDATESUBMITPROCESS].[ADDEDBYID], [COAUPDATESUBMITPROCESS].[CHANGEDBYID], [COAUPDATESUBMITPROCESS].[DATEADDED], [COAUPDATESUBMITPROCESS].[DATECHANGED], [COAUPDATESUBMITPROCESS].[TSLONG]
from dbo.[COAUPDATESUBMITPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [COAUPDATESUBMITPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [CONFIGURATIONEXPORTPROCESS].[ID] as [PARAMETERSETID], [CONFIGURATIONEXPORTPROCESS].[NAME] as [NAME], 'ed318c58-4035-41d0-a38f-a5310f3cc9dd' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [CONFIGURATIONEXPORTPROCESS].[ADDEDBYID], [CONFIGURATIONEXPORTPROCESS].[CHANGEDBYID], [CONFIGURATIONEXPORTPROCESS].[DATEADDED], [CONFIGURATIONEXPORTPROCESS].[DATECHANGED], [CONFIGURATIONEXPORTPROCESS].[TSLONG]
from dbo.[CONFIGURATIONEXPORTPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [CONFIGURATIONEXPORTPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [CONFIGURATIONIMPORTPROCESS].[ID] as [PARAMETERSETID], [CONFIGURATIONIMPORTPROCESS].[NAME] as [NAME], '791a584e-7e52-4d98-b3ce-4bb8273dd74b' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [CONFIGURATIONIMPORTPROCESS].[ADDEDBYID], [CONFIGURATIONIMPORTPROCESS].[CHANGEDBYID], [CONFIGURATIONIMPORTPROCESS].[DATEADDED], [CONFIGURATIONIMPORTPROCESS].[DATECHANGED], [CONFIGURATIONIMPORTPROCESS].[TSLONG]
from dbo.[CONFIGURATIONIMPORTPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [CONFIGURATIONIMPORTPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [CONSTITUENCYREFRESHPROCESS].[ID] as [PARAMETERSETID], [CONSTITUENCYREFRESHPROCESS].[NAME] as [NAME], '138ffc16-980c-41da-87ee-eb5c26b0238e' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [CONSTITUENCYREFRESHPROCESS].[ADDEDBYID], [CONSTITUENCYREFRESHPROCESS].[CHANGEDBYID], [CONSTITUENCYREFRESHPROCESS].[DATEADDED], [CONSTITUENCYREFRESHPROCESS].[DATECHANGED], [CONSTITUENCYREFRESHPROCESS].[TSLONG]
from dbo.[CONSTITUENCYREFRESHPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [CONSTITUENCYREFRESHPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [CONSTITUENTDUPLICATESEARCHPROCESS].[ID] as [PARAMETERSETID], [CONSTITUENTDUPLICATESEARCHPROCESS].[NAME] as [NAME], 'ecca871d-beb3-4649-9546-6d1e9676227c' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [CONSTITUENTDUPLICATESEARCHPROCESS].[ADDEDBYID], [CONSTITUENTDUPLICATESEARCHPROCESS].[CHANGEDBYID], [CONSTITUENTDUPLICATESEARCHPROCESS].[DATEADDED], [CONSTITUENTDUPLICATESEARCHPROCESS].[DATECHANGED], [CONSTITUENTDUPLICATESEARCHPROCESS].[TSLONG]
from dbo.[CONSTITUENTDUPLICATESEARCHPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [CONSTITUENTDUPLICATESEARCHPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [CONSTITUENTMERGEPROCESS].[ID] as [PARAMETERSETID], [CONSTITUENTMERGEPROCESS].[NAME] as [NAME], 'eeeb65a5-ef28-4610-8c22-2c634b8a58c5' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [CONSTITUENTMERGEPROCESS].[ADDEDBYID], [CONSTITUENTMERGEPROCESS].[CHANGEDBYID], [CONSTITUENTMERGEPROCESS].[DATEADDED], [CONSTITUENTMERGEPROCESS].[DATECHANGED], [CONSTITUENTMERGEPROCESS].[TSLONG]
from dbo.[CONSTITUENTMERGEPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [CONSTITUENTMERGEPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [CONSTITUENTRECOGNITIONPROCESS].[ID] as [PARAMETERSETID], [CONSTITUENTRECOGNITIONPROCESS].[NAME] as [NAME], '7616d877-034b-45a2-ab6d-3fcb63157de2' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [CONSTITUENTRECOGNITIONPROCESS].[ADDEDBYID], [CONSTITUENTRECOGNITIONPROCESS].[CHANGEDBYID], [CONSTITUENTRECOGNITIONPROCESS].[DATEADDED], [CONSTITUENTRECOGNITIONPROCESS].[DATECHANGED], [CONSTITUENTRECOGNITIONPROCESS].[TSLONG]
from dbo.[CONSTITUENTRECOGNITIONPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [CONSTITUENTRECOGNITIONPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [CORRESPONDENCEPROCESS].[ID] as [PARAMETERSETID], [CORRESPONDENCEPROCESS].[NAME] as [NAME], '52776e74-df72-451c-82d5-519549dae34b' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [CORRESPONDENCEPROCESS].[ADDEDBYID], [CORRESPONDENCEPROCESS].[CHANGEDBYID], [CORRESPONDENCEPROCESS].[DATEADDED], [CORRESPONDENCEPROCESS].[DATECHANGED], [CORRESPONDENCEPROCESS].[TSLONG]
from dbo.[CORRESPONDENCEPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [CORRESPONDENCEPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [CREDITCARDPROCESSING].[ID] as [PARAMETERSETID], [CREDITCARDPROCESSING].[NAME] as [NAME], '8c1e67b1-fb82-4c44-ab03-417d7e70ce94' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [CREDITCARDPROCESSING].[ADDEDBYID], [CREDITCARDPROCESSING].[CHANGEDBYID], [CREDITCARDPROCESSING].[DATEADDED], [CREDITCARDPROCESSING].[DATECHANGED], [CREDITCARDPROCESSING].[TSLONG]
from dbo.[CREDITCARDPROCESSING] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [CREDITCARDPROCESSING].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [CURRENCYEXCHANGERATEDOWNLOADPROCESS].[ID] as [PARAMETERSETID], [CURRENCYEXCHANGERATEDOWNLOADPROCESS].[NAME] as [NAME], '2f711aa7-afbb-4c5b-a336-6f0b5527cf6f' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [CURRENCYEXCHANGERATEDOWNLOADPROCESS].[ADDEDBYID], [CURRENCYEXCHANGERATEDOWNLOADPROCESS].[CHANGEDBYID], [CURRENCYEXCHANGERATEDOWNLOADPROCESS].[DATEADDED], [CURRENCYEXCHANGERATEDOWNLOADPROCESS].[DATECHANGED], [CURRENCYEXCHANGERATEDOWNLOADPROCESS].[TSLONG]
from dbo.[CURRENCYEXCHANGERATEDOWNLOADPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [CURRENCYEXCHANGERATEDOWNLOADPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [DATABASEGROWTHANALYSISPROCESS].[ID] as [PARAMETERSETID], [DATABASEGROWTHANALYSISPROCESS].[NAME] as [NAME], '23c3cae9-fec7-4eab-ba79-e50c997a5bbf' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [DATABASEGROWTHANALYSISPROCESS].[ADDEDBYID], [DATABASEGROWTHANALYSISPROCESS].[CHANGEDBYID], [DATABASEGROWTHANALYSISPROCESS].[DATEADDED], [DATABASEGROWTHANALYSISPROCESS].[DATECHANGED], [DATABASEGROWTHANALYSISPROCESS].[TSLONG]
from dbo.[DATABASEGROWTHANALYSISPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [DATABASEGROWTHANALYSISPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [DECEASEDFINDERCREATEPROCESS].[ID] as [PARAMETERSETID], [DECEASEDFINDERCREATEPROCESS].[NAME] as [NAME], '89462a7a-835e-4843-a63a-e34f883d68fc' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [DECEASEDFINDERCREATEPROCESS].[ADDEDBYID], [DECEASEDFINDERCREATEPROCESS].[CHANGEDBYID], [DECEASEDFINDERCREATEPROCESS].[DATEADDED], [DECEASEDFINDERCREATEPROCESS].[DATECHANGED], [DECEASEDFINDERCREATEPROCESS].[TSLONG]
from dbo.[DECEASEDFINDERCREATEPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [DECEASEDFINDERCREATEPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [DECEASEDFINDERGETPROCESS].[ID] as [PARAMETERSETID], [DECEASEDFINDERGETPROCESS].[NAME] as [NAME], '3c0acebd-236b-4da3-b5d5-45e73ce5acd1' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [DECEASEDFINDERGETPROCESS].[ADDEDBYID], [DECEASEDFINDERGETPROCESS].[CHANGEDBYID], [DECEASEDFINDERGETPROCESS].[DATEADDED], [DECEASEDFINDERGETPROCESS].[DATECHANGED], [DECEASEDFINDERGETPROCESS].[TSLONG]
from dbo.[DECEASEDFINDERGETPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [DECEASEDFINDERGETPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [DECEASEDFINDERRESUBMITPROCESS].[ID] as [PARAMETERSETID], [DECEASEDFINDERRESUBMITPROCESS].[NAME] as [NAME], '8b3cc14a-210d-43af-97f2-e434017a4d68' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [DECEASEDFINDERRESUBMITPROCESS].[ADDEDBYID], [DECEASEDFINDERRESUBMITPROCESS].[CHANGEDBYID], [DECEASEDFINDERRESUBMITPROCESS].[DATEADDED], [DECEASEDFINDERRESUBMITPROCESS].[DATECHANGED], [DECEASEDFINDERRESUBMITPROCESS].[TSLONG]
from dbo.[DECEASEDFINDERRESUBMITPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [DECEASEDFINDERRESUBMITPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [DECEASEDFINDERSUBMITPROCESS].[ID] as [PARAMETERSETID], [DECEASEDFINDERSUBMITPROCESS].[NAME] as [NAME], '18f4fbe4-8afb-4ffe-84e1-f1fc59948775' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [DECEASEDFINDERSUBMITPROCESS].[ADDEDBYID], [DECEASEDFINDERSUBMITPROCESS].[CHANGEDBYID], [DECEASEDFINDERSUBMITPROCESS].[DATEADDED], [DECEASEDFINDERSUBMITPROCESS].[DATECHANGED], [DECEASEDFINDERSUBMITPROCESS].[TSLONG]
from dbo.[DECEASEDFINDERSUBMITPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [DECEASEDFINDERSUBMITPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [DONORCHALLENGEENCUMBERPROCESS].[ID] as [PARAMETERSETID], [DONORCHALLENGEENCUMBERPROCESS].[NAME] as [NAME], 'f4877be6-6bee-447c-b620-bc90b3996651' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [DONORCHALLENGEENCUMBERPROCESS].[ADDEDBYID], [DONORCHALLENGEENCUMBERPROCESS].[CHANGEDBYID], [DONORCHALLENGEENCUMBERPROCESS].[DATEADDED], [DONORCHALLENGEENCUMBERPROCESS].[DATECHANGED], [DONORCHALLENGEENCUMBERPROCESS].[TSLONG]
from dbo.[DONORCHALLENGEENCUMBERPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [DONORCHALLENGEENCUMBERPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [EMAILFINDERGETPROCESS].[ID] as [PARAMETERSETID], [EMAILFINDERGETPROCESS].[NAME] as [NAME], 'f4911109-3b6a-4c99-ad34-9a69cbc28545' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [EMAILFINDERGETPROCESS].[ADDEDBYID], [EMAILFINDERGETPROCESS].[CHANGEDBYID], [EMAILFINDERGETPROCESS].[DATEADDED], [EMAILFINDERGETPROCESS].[DATECHANGED], [EMAILFINDERGETPROCESS].[TSLONG]
from dbo.[EMAILFINDERGETPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [EMAILFINDERGETPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [EMAILFINDERRESUBMITPROCESS].[ID] as [PARAMETERSETID], [EMAILFINDERRESUBMITPROCESS].[NAME] as [NAME], 'b8dbebaf-16d7-4024-adf1-efe0b3872806' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [EMAILFINDERRESUBMITPROCESS].[ADDEDBYID], [EMAILFINDERRESUBMITPROCESS].[CHANGEDBYID], [EMAILFINDERRESUBMITPROCESS].[DATEADDED], [EMAILFINDERRESUBMITPROCESS].[DATECHANGED], [EMAILFINDERRESUBMITPROCESS].[TSLONG]
from dbo.[EMAILFINDERRESUBMITPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [EMAILFINDERRESUBMITPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [EMAILFINDERSUBMITPROCESS].[ID] as [PARAMETERSETID], [EMAILFINDERSUBMITPROCESS].[NAME] as [NAME], '2be9f4ad-5f54-444c-9176-1807e7a895d9' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [EMAILFINDERSUBMITPROCESS].[ADDEDBYID], [EMAILFINDERSUBMITPROCESS].[CHANGEDBYID], [EMAILFINDERSUBMITPROCESS].[DATEADDED], [EMAILFINDERSUBMITPROCESS].[DATECHANGED], [EMAILFINDERSUBMITPROCESS].[TSLONG]
from dbo.[EMAILFINDERSUBMITPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [EMAILFINDERSUBMITPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [ETLREFRESHPROCESS].[ID] as [PARAMETERSETID], [ETLREFRESHPROCESS].[SOURCENAME] as [NAME], '039352db-1a0b-49ce-96ab-09fba6b9d332' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [ETLREFRESHPROCESS].[ADDEDBYID], [ETLREFRESHPROCESS].[CHANGEDBYID], [ETLREFRESHPROCESS].[DATEADDED], [ETLREFRESHPROCESS].[DATECHANGED], [ETLREFRESHPROCESS].[TSLONG]
from dbo.[ETLREFRESHPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [ETLREFRESHPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [EXCHANGECALENDARSYNC].[ID] as [PARAMETERSETID], [EXCHANGECALENDARSYNC].[NAME] as [NAME], '196fe9c6-1fb7-441c-965b-760042ddd1c0' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [EXCHANGECALENDARSYNC].[ADDEDBYID], [EXCHANGECALENDARSYNC].[CHANGEDBYID], [EXCHANGECALENDARSYNC].[DATEADDED], [EXCHANGECALENDARSYNC].[DATECHANGED], [EXCHANGECALENDARSYNC].[TSLONG]
from dbo.[EXCHANGECALENDARSYNC] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [EXCHANGECALENDARSYNC].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [EXCHANGECONTACTSYNC].[ID] as [PARAMETERSETID], [EXCHANGECONTACTSYNC].[NAME] as [NAME], 'b531b950-2534-4e95-b104-805db1328806' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [EXCHANGECONTACTSYNC].[ADDEDBYID], [EXCHANGECONTACTSYNC].[CHANGEDBYID], [EXCHANGECONTACTSYNC].[DATEADDED], [EXCHANGECONTACTSYNC].[DATECHANGED], [EXCHANGECONTACTSYNC].[TSLONG]
from dbo.[EXCHANGECONTACTSYNC] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [EXCHANGECONTACTSYNC].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [EXCHANGEDOWNLOADPROCESS].[ID] as [PARAMETERSETID], [EXCHANGEDOWNLOADPROCESS].[NAME] as [NAME], '60c090d3-5a0e-49e9-8cfb-8c89719b5281' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [EXCHANGEDOWNLOADPROCESS].[ADDEDBYID], [EXCHANGEDOWNLOADPROCESS].[CHANGEDBYID], [EXCHANGEDOWNLOADPROCESS].[DATEADDED], [EXCHANGEDOWNLOADPROCESS].[DATECHANGED], [EXCHANGEDOWNLOADPROCESS].[TSLONG]
from dbo.[EXCHANGEDOWNLOADPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [EXCHANGEDOWNLOADPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [EXPORTPROCESS].[ID] as [PARAMETERSETID], [EXPORTPROCESS].[NAME] as [NAME], '64faa344-9c75-4c98-afe3-a40ec2df9249' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [EXPORTPROCESS].[ADDEDBYID], [EXPORTPROCESS].[CHANGEDBYID], [EXPORTPROCESS].[DATEADDED], [EXPORTPROCESS].[DATECHANGED], [EXPORTPROCESS].[TSLONG]
from dbo.[EXPORTPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [EXPORTPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [FENXTSYNCPROCESS].[ID] as [PARAMETERSETID], [FENXTSYNCPROCESS].[NAME] as [NAME], '1f2c9c11-0194-4d32-9d23-173a385e054d' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [FENXTSYNCPROCESS].[ADDEDBYID], [FENXTSYNCPROCESS].[CHANGEDBYID], [FENXTSYNCPROCESS].[DATEADDED], [FENXTSYNCPROCESS].[DATECHANGED], [FENXTSYNCPROCESS].[TSLONG]
from dbo.[FENXTSYNCPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [FENXTSYNCPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [FEPSUBMITPROCESS].[ID] as [PARAMETERSETID], [FEPSUBMITPROCESS].[NAME] as [NAME], 'cad79b29-5309-4650-b452-d03f379bdc60' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [FEPSUBMITPROCESS].[ADDEDBYID], [FEPSUBMITPROCESS].[CHANGEDBYID], [FEPSUBMITPROCESS].[DATEADDED], [FEPSUBMITPROCESS].[DATECHANGED], [FEPSUBMITPROCESS].[TSLONG]
from dbo.[FEPSUBMITPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [FEPSUBMITPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [GENERATEBACSFILEPROCESS].[ID] as [PARAMETERSETID], [GENERATEBACSFILEPROCESS].[NAME] as [NAME], '5fcc159b-d9f7-46ae-8980-fb5d74515c15' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [GENERATEBACSFILEPROCESS].[ADDEDBYID], [GENERATEBACSFILEPROCESS].[CHANGEDBYID], [GENERATEBACSFILEPROCESS].[DATEADDED], [GENERATEBACSFILEPROCESS].[DATECHANGED], [GENERATEBACSFILEPROCESS].[TSLONG]
from dbo.[GENERATEBACSFILEPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [GENERATEBACSFILEPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [GENERATEBATCHPROCESS].[ID] as [PARAMETERSETID], [GENERATEBATCHPROCESS].[NAME] as [NAME], 'b226b0a0-043d-47bf-9dc4-6594ba5bbcbd' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [GENERATEBATCHPROCESS].[ADDEDBYID], [GENERATEBATCHPROCESS].[CHANGEDBYID], [GENERATEBATCHPROCESS].[DATEADDED], [GENERATEBATCHPROCESS].[DATECHANGED], [GENERATEBATCHPROCESS].[TSLONG]
from dbo.[GENERATEBATCHPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [GENERATEBATCHPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [GENERATEBATCHPROCESSCUB].[ID] as [PARAMETERSETID], [GENERATEBATCHPROCESSCUB].[NAME] as [NAME], '44ccccea-9e4b-4935-9ab0-60c9f23a543d' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [GENERATEBATCHPROCESSCUB].[ADDEDBYID], [GENERATEBATCHPROCESSCUB].[CHANGEDBYID], [GENERATEBATCHPROCESSCUB].[DATEADDED], [GENERATEBATCHPROCESSCUB].[DATECHANGED], [GENERATEBATCHPROCESSCUB].[TSLONG]
from dbo.[GENERATEBATCHPROCESSCUB] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [GENERATEBATCHPROCESSCUB].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [GENERATEEFTFILEPROCESS].[ID] as [PARAMETERSETID], [GENERATEEFTFILEPROCESS].[NAME] as [NAME], 'b7974f4f-60d8-4df5-ad5b-7b1839abe16a' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [GENERATEEFTFILEPROCESS].[ADDEDBYID], [GENERATEEFTFILEPROCESS].[CHANGEDBYID], [GENERATEEFTFILEPROCESS].[DATEADDED], [GENERATEEFTFILEPROCESS].[DATECHANGED], [GENERATEEFTFILEPROCESS].[TSLONG]
from dbo.[GENERATEEFTFILEPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [GENERATEEFTFILEPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [GENERATESTEPUPDATEBATCHPROCESS].[ID] as [PARAMETERSETID], [GENERATESTEPUPDATEBATCHPROCESS].[NAME] as [NAME], 'd6aa3069-2c4a-4492-bb40-85e50c948ab9' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [GENERATESTEPUPDATEBATCHPROCESS].[ADDEDBYID], [GENERATESTEPUPDATEBATCHPROCESS].[CHANGEDBYID], [GENERATESTEPUPDATEBATCHPROCESS].[DATEADDED], [GENERATESTEPUPDATEBATCHPROCESS].[DATECHANGED], [GENERATESTEPUPDATEBATCHPROCESS].[TSLONG]
from dbo.[GENERATESTEPUPDATEBATCHPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [GENERATESTEPUPDATEBATCHPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [GENERATETRANSACTIONSPROCESS].[ID] as [PARAMETERSETID], [GENERATETRANSACTIONSPROCESS].[NAME] as [NAME], 'f1606b58-8d50-4614-8752-57e1cf85dae4' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [GENERATETRANSACTIONSPROCESS].[ADDEDBYID], [GENERATETRANSACTIONSPROCESS].[CHANGEDBYID], [GENERATETRANSACTIONSPROCESS].[DATEADDED], [GENERATETRANSACTIONSPROCESS].[DATECHANGED], [GENERATETRANSACTIONSPROCESS].[TSLONG]
from dbo.[GENERATETRANSACTIONSPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [GENERATETRANSACTIONSPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [GIFTAIDREFRESHPROCESS].[ID] as [PARAMETERSETID], [GIFTAIDREFRESHPROCESS].[NAME] as [NAME], '9c973934-79a3-4a74-9ea5-fc432cfa7e9d' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [GIFTAIDREFRESHPROCESS].[ADDEDBYID], [GIFTAIDREFRESHPROCESS].[CHANGEDBYID], [GIFTAIDREFRESHPROCESS].[DATEADDED], [GIFTAIDREFRESHPROCESS].[DATECHANGED], [GIFTAIDREFRESHPROCESS].[TSLONG]
from dbo.[GIFTAIDREFRESHPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [GIFTAIDREFRESHPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [GLACCOUNTMAPPINGERRORUPDATEPROCESS].[ID] as [PARAMETERSETID], [GLACCOUNTMAPPINGERRORUPDATEPROCESS].[NAME] as [NAME], 'f03491cd-dfbb-4d15-9b66-03e92992bdf7' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], cast(null as uniqueidentifier) as [ADDEDBYID], cast(null as uniqueidentifier) as [CHANGEDBYID], cast(null as datetime) as [DATEADDED], cast(null as datetime) as [DATECHANGED], cast(0 as bigint) as [TSLONG]
from dbo.[GLACCOUNTMAPPINGERRORUPDATEPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [GLACCOUNTMAPPINGERRORUPDATEPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [GLOBALCHANGE].[ID] as [PARAMETERSETID], [GLOBALCHANGE].[NAME] as [NAME], '3269a1d1-31cb-4d28-945c-b7623a3efcca' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [GLOBALCHANGE].[ADDEDBYID], [GLOBALCHANGE].[CHANGEDBYID], [GLOBALCHANGE].[DATEADDED], [GLOBALCHANGE].[DATECHANGED], [GLOBALCHANGE].[TSLONG]
from dbo.[GLOBALCHANGE] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [GLOBALCHANGE].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [GLPOSTPROCESS].[ID] as [PARAMETERSETID], [GLPOSTPROCESS].[NAME] as [NAME], '39063031-b407-4726-9b3e-46f8b2244d9e' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [GLPOSTPROCESS].[ADDEDBYID], [GLPOSTPROCESS].[CHANGEDBYID], [GLPOSTPROCESS].[DATEADDED], [GLPOSTPROCESS].[DATECHANGED], [GLPOSTPROCESS].[TSLONG]
from dbo.[GLPOSTPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [GLPOSTPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [HTMLTEMPLATETODOCXMERGEPROCESS].[ID] as [PARAMETERSETID], [HTMLTEMPLATETODOCXMERGEPROCESS].[NAME] as [NAME], '713da853-01cf-4b08-be37-bdcda9fbd463' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [HTMLTEMPLATETODOCXMERGEPROCESS].[ADDEDBYID], [HTMLTEMPLATETODOCXMERGEPROCESS].[CHANGEDBYID], [HTMLTEMPLATETODOCXMERGEPROCESS].[DATEADDED], [HTMLTEMPLATETODOCXMERGEPROCESS].[DATECHANGED], [HTMLTEMPLATETODOCXMERGEPROCESS].[TSLONG]
from dbo.[HTMLTEMPLATETODOCXMERGEPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [HTMLTEMPLATETODOCXMERGEPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [IMPORTPROCESS].[ID] as [PARAMETERSETID], [IMPORTPROCESS].[NAME] as [NAME], '2873772c-37bf-4c20-855d-49be32f186cd' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [IMPORTPROCESS].[ADDEDBYID], [IMPORTPROCESS].[CHANGEDBYID], [IMPORTPROCESS].[DATEADDED], [IMPORTPROCESS].[DATECHANGED], [IMPORTPROCESS].[TSLONG]
from dbo.[IMPORTPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [IMPORTPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [IMPORTPROCESS].[ID] as [PARAMETERSETID], [IMPORTPROCESS].[NAME] as [NAME], 'c5b4af35-5239-4380-a784-bf2336d9cb7c' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [IMPORTPROCESS].[ADDEDBYID], [IMPORTPROCESS].[CHANGEDBYID], [IMPORTPROCESS].[DATEADDED], [IMPORTPROCESS].[DATECHANGED], [IMPORTPROCESS].[TSLONG]
from dbo.[IMPORTPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [IMPORTPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [IMPORTSELECTIONPROCESS].[ID] as [PARAMETERSETID], [IMPORTSELECTIONPROCESS].[NAME] as [NAME], '9ccda190-5811-4b9a-89db-e04e0a364ba9' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [IMPORTSELECTIONPROCESS].[ADDEDBYID], [IMPORTSELECTIONPROCESS].[CHANGEDBYID], [IMPORTSELECTIONPROCESS].[DATEADDED], [IMPORTSELECTIONPROCESS].[DATECHANGED], [IMPORTSELECTIONPROCESS].[TSLONG]
from dbo.[IMPORTSELECTIONPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [IMPORTSELECTIONPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [INVITATION].[ID] as [PARAMETERSETID], [INVITATION].[NAME] as [NAME], '116332af-bb79-4608-9709-4203bd2ba318' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [INVITATION].[ADDEDBYID], [INVITATION].[CHANGEDBYID], [INVITATION].[DATEADDED], [INVITATION].[DATECHANGED], [INVITATION].[TSLONG]
from dbo.[INVITATION] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [INVITATION].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [IRSFORM1099MISCPROCESSTEMPLATE].[ID] as [PARAMETERSETID], [IRSFORM1099MISCPROCESSTEMPLATE].[NAME] as [NAME], '161f3456-7a5b-4390-bf8f-69d324464d11' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [IRSFORM1099MISCPROCESSTEMPLATE].[ADDEDBYID], [IRSFORM1099MISCPROCESSTEMPLATE].[CHANGEDBYID], [IRSFORM1099MISCPROCESSTEMPLATE].[DATEADDED], [IRSFORM1099MISCPROCESSTEMPLATE].[DATECHANGED], [IRSFORM1099MISCPROCESSTEMPLATE].[TSLONG]
from dbo.[IRSFORM1099MISCPROCESSTEMPLATE] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [IRSFORM1099MISCPROCESSTEMPLATE].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [KPIINSTANCE].[ID] as [PARAMETERSETID], [KPIINSTANCE].[NAME] as [NAME], 'ec9c5403-d3bb-43d4-a667-c452aa360771' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], cast(null as uniqueidentifier) as [SITEID], 'N/A' as [SITE], [KPIINSTANCE].[ADDEDBYID], [KPIINSTANCE].[CHANGEDBYID], [KPIINSTANCE].[DATEADDED], [KPIINSTANCE].[DATECHANGED], [KPIINSTANCE].[TSLONG]
from dbo.[KPIINSTANCE] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [KPIINSTANCE].[ID] 


union all
select [LUMINATEONLINEDATACONNECTORPARAMETERSET].[ID] as [PARAMETERSETID], [LUMINATEONLINEDATACONNECTORPARAMETERSET].[NAME] as [NAME], '79c4818a-ed3b-48c2-8a9a-ae56211b2c0c' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [LUMINATEONLINEDATACONNECTORPARAMETERSET].[ADDEDBYID], [LUMINATEONLINEDATACONNECTORPARAMETERSET].[CHANGEDBYID], [LUMINATEONLINEDATACONNECTORPARAMETERSET].[DATEADDED], [LUMINATEONLINEDATACONNECTORPARAMETERSET].[DATECHANGED], [LUMINATEONLINEDATACONNECTORPARAMETERSET].[TSLONG]
from dbo.[LUMINATEONLINEDATACONNECTORPARAMETERSET] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [LUMINATEONLINEDATACONNECTORPARAMETERSET].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS].[ID] as [PARAMETERSETID], [MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS].[NAME] as [NAME], 'e2f6ff31-29ec-4480-b9a2-293c35fd2ca3' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS].[ADDEDBYID], [MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS].[CHANGEDBYID], [MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS].[DATEADDED], [MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS].[DATECHANGED], [MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS].[TSLONG]
from dbo.[MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [MKTACKNOWLEDGEMENTMAILINGPROCESS].[ID] as [PARAMETERSETID], [MKTACKNOWLEDGEMENTMAILINGPROCESS].[NAME] as [NAME], '1f72bad2-f10a-4f43-9210-ab3b5cbbb576' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [MKTACKNOWLEDGEMENTMAILINGPROCESS].[ADDEDBYID], [MKTACKNOWLEDGEMENTMAILINGPROCESS].[CHANGEDBYID], [MKTACKNOWLEDGEMENTMAILINGPROCESS].[DATEADDED], [MKTACKNOWLEDGEMENTMAILINGPROCESS].[DATECHANGED], [MKTACKNOWLEDGEMENTMAILINGPROCESS].[TSLONG]
from dbo.[MKTACKNOWLEDGEMENTMAILINGPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [MKTACKNOWLEDGEMENTMAILINGPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [MKTCONSTITUENTFILEIMPORTPROCESS].[ID] as [PARAMETERSETID], [MKTCONSTITUENTFILEIMPORTPROCESS].[NAME] as [NAME], 'accd0506-8d32-4297-aebd-2fbe6138968f' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [MKTCONSTITUENTFILEIMPORTPROCESS].[ADDEDBYID], [MKTCONSTITUENTFILEIMPORTPROCESS].[CHANGEDBYID], [MKTCONSTITUENTFILEIMPORTPROCESS].[DATEADDED], [MKTCONSTITUENTFILEIMPORTPROCESS].[DATECHANGED], [MKTCONSTITUENTFILEIMPORTPROCESS].[TSLONG]
from dbo.[MKTCONSTITUENTFILEIMPORTPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [MKTCONSTITUENTFILEIMPORTPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [MKTFINDERFILEIMPORTPROCESS].[ID] as [PARAMETERSETID], [MKTFINDERFILEIMPORTPROCESS].[NAME] as [NAME], '4dcececb-2866-4108-abe8-138961051272' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [MKTFINDERFILEIMPORTPROCESS].[ADDEDBYID], [MKTFINDERFILEIMPORTPROCESS].[CHANGEDBYID], [MKTFINDERFILEIMPORTPROCESS].[DATEADDED], [MKTFINDERFILEIMPORTPROCESS].[DATECHANGED], [MKTFINDERFILEIMPORTPROCESS].[TSLONG]
from dbo.[MKTFINDERFILEIMPORTPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [MKTFINDERFILEIMPORTPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [MKTMAILINGPREACTIVATIONPROCESS].[ID] as [PARAMETERSETID], [MKTMAILINGPREACTIVATIONPROCESS].[NAME] as [NAME], '92befbfa-43b4-42a4-80ff-88350d540824' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [MKTSEGMENTATION].[SITEID], isnull([SITE].[NAME], '') as [SITE], [MKTMAILINGPREACTIVATIONPROCESS].[ADDEDBYID], [MKTMAILINGPREACTIVATIONPROCESS].[CHANGEDBYID], [MKTMAILINGPREACTIVATIONPROCESS].[DATEADDED], [MKTMAILINGPREACTIVATIONPROCESS].[DATECHANGED], [MKTMAILINGPREACTIVATIONPROCESS].[TSLONG]
from dbo.[MKTMAILINGPREACTIVATIONPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [MKTMAILINGPREACTIVATIONPROCESS].[ID] 
left outer join dbo.[MKTSEGMENTATION] on [MKTSEGMENTATION].[ID] = [MKTMAILINGPREACTIVATIONPROCESS].[SEGMENTATIONID]left outer join dbo.[SITE] on [SITE].[ID] = [MKTSEGMENTATION].[SITEID]

union all
select [MKTMEMBERSHIPMAILINGPROCESS].[ID] as [PARAMETERSETID], [MKTMEMBERSHIPMAILINGPROCESS].[NAME] as [NAME], '854a7703-89d1-4ef7-a7c6-b8836a887092' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [MKTMEMBERSHIPMAILINGPROCESS].[ADDEDBYID], [MKTMEMBERSHIPMAILINGPROCESS].[CHANGEDBYID], [MKTMEMBERSHIPMAILINGPROCESS].[DATEADDED], [MKTMEMBERSHIPMAILINGPROCESS].[DATECHANGED], [MKTMEMBERSHIPMAILINGPROCESS].[TSLONG]
from dbo.[MKTMEMBERSHIPMAILINGPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [MKTMEMBERSHIPMAILINGPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [MKTMEMBERSHIPRENEWALEFFORTPROCESS].[ID] as [PARAMETERSETID], [MKTMEMBERSHIPRENEWALEFFORTPROCESS].[NAME] as [NAME], 'ff236838-354e-455b-9ebc-0b3118c928c2' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [MKTMEMBERSHIPRENEWALEFFORTPROCESS].[ADDEDBYID], [MKTMEMBERSHIPRENEWALEFFORTPROCESS].[CHANGEDBYID], [MKTMEMBERSHIPRENEWALEFFORTPROCESS].[DATEADDED], [MKTMEMBERSHIPRENEWALEFFORTPROCESS].[DATECHANGED], [MKTMEMBERSHIPRENEWALEFFORTPROCESS].[TSLONG]
from dbo.[MKTMEMBERSHIPRENEWALEFFORTPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [MKTMEMBERSHIPRENEWALEFFORTPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [MKTSEGMENTATIONACTIVATEPROCESS].[ID] as [PARAMETERSETID], [MKTSEGMENTATIONACTIVATEPROCESS].[NAME] as [NAME], '22c3d75c-a956-4bfc-a5fd-4b866baef509' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [MKTSEGMENTATION].[SITEID], isnull([SITE].[NAME], '') as [SITE], [MKTSEGMENTATIONACTIVATEPROCESS].[ADDEDBYID], [MKTSEGMENTATIONACTIVATEPROCESS].[CHANGEDBYID], [MKTSEGMENTATIONACTIVATEPROCESS].[DATEADDED], [MKTSEGMENTATIONACTIVATEPROCESS].[DATECHANGED], [MKTSEGMENTATIONACTIVATEPROCESS].[TSLONG]
from dbo.[MKTSEGMENTATIONACTIVATEPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [MKTSEGMENTATIONACTIVATEPROCESS].[ID] 
left outer join dbo.[MKTSEGMENTATION] on [MKTSEGMENTATION].[ID] = [MKTSEGMENTATIONACTIVATEPROCESS].[SEGMENTATIONID]left outer join dbo.[SITE] on [SITE].[ID] = [MKTSEGMENTATION].[SITEID]

union all
select [MKTSEGMENTATIONEXCLUSIONSPROCESS].[ID] as [PARAMETERSETID], [MKTSEGMENTATIONEXCLUSIONSPROCESS].[NAME] as [NAME], '80988580-b272-4a6f-bd65-4613ce579236' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [MKTSEGMENTATION].[SITEID], isnull([SITE].[NAME], '') as [SITE], [MKTSEGMENTATIONEXCLUSIONSPROCESS].[ADDEDBYID], [MKTSEGMENTATIONEXCLUSIONSPROCESS].[CHANGEDBYID], [MKTSEGMENTATIONEXCLUSIONSPROCESS].[DATEADDED], [MKTSEGMENTATIONEXCLUSIONSPROCESS].[DATECHANGED], [MKTSEGMENTATIONEXCLUSIONSPROCESS].[TSLONG]
from dbo.[MKTSEGMENTATIONEXCLUSIONSPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [MKTSEGMENTATIONEXCLUSIONSPROCESS].[ID] 
left outer join dbo.[MKTSEGMENTATION] on [MKTSEGMENTATION].[ID] = [MKTSEGMENTATIONEXCLUSIONSPROCESS].[SEGMENTATIONID]left outer join dbo.[SITE] on [SITE].[ID] = [MKTSEGMENTATION].[SITEID]

union all
select [MKTSEGMENTATIONEXPORTPROCESS].[ID] as [PARAMETERSETID], [MKTSEGMENTATIONEXPORTPROCESS].[NAME] as [NAME], 'c5ecedd7-2510-4c02-bb7e-998928e3038c' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [MKTSEGMENTATION].[SITEID], isnull([SITE].[NAME], '') as [SITE], [MKTSEGMENTATIONEXPORTPROCESS].[ADDEDBYID], [MKTSEGMENTATIONEXPORTPROCESS].[CHANGEDBYID], [MKTSEGMENTATIONEXPORTPROCESS].[DATEADDED], [MKTSEGMENTATIONEXPORTPROCESS].[DATECHANGED], [MKTSEGMENTATIONEXPORTPROCESS].[TSLONG]
from dbo.[MKTSEGMENTATIONEXPORTPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [MKTSEGMENTATIONEXPORTPROCESS].[ID] 
left outer join dbo.[MKTSEGMENTATION] on [MKTSEGMENTATION].[ID] = [MKTSEGMENTATIONEXPORTPROCESS].[SEGMENTATIONID]left outer join dbo.[SITE] on [SITE].[ID] = [MKTSEGMENTATION].[SITEID]

union all
select [MKTSEGMENTATIONREFRESHPROCESS].[ID] as [PARAMETERSETID], [MKTSEGMENTATIONREFRESHPROCESS].[NAME] as [NAME], 'f49185ff-9f54-43ea-b798-8c13e659cd8f' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [MKTSEGMENTATION].[SITEID], isnull([SITE].[NAME], '') as [SITE], [MKTSEGMENTATIONREFRESHPROCESS].[ADDEDBYID], [MKTSEGMENTATIONREFRESHPROCESS].[CHANGEDBYID], [MKTSEGMENTATIONREFRESHPROCESS].[DATEADDED], [MKTSEGMENTATIONREFRESHPROCESS].[DATECHANGED], [MKTSEGMENTATIONREFRESHPROCESS].[TSLONG]
from dbo.[MKTSEGMENTATIONREFRESHPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [MKTSEGMENTATIONREFRESHPROCESS].[ID] 
left outer join dbo.[MKTSEGMENTATION] on [MKTSEGMENTATION].[ID] = [MKTSEGMENTATIONREFRESHPROCESS].[SEGMENTATIONID]left outer join dbo.[SITE] on [SITE].[ID] = [MKTSEGMENTATION].[SITEID]

union all
select [MKTSEGMENTATIONSEGMENTCALCULATEPROCESS].[ID] as [PARAMETERSETID], [MKTSEGMENTATIONSEGMENTCALCULATEPROCESS].[NAME] as [NAME], '585d30cc-c822-4441-a161-f8a2306bda8d' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [MKTSEGMENTATION].[SITEID], isnull([SITE].[NAME], '') as [SITE], [MKTSEGMENTATIONSEGMENTCALCULATEPROCESS].[ADDEDBYID], [MKTSEGMENTATIONSEGMENTCALCULATEPROCESS].[CHANGEDBYID], [MKTSEGMENTATIONSEGMENTCALCULATEPROCESS].[DATEADDED], [MKTSEGMENTATIONSEGMENTCALCULATEPROCESS].[DATECHANGED], [MKTSEGMENTATIONSEGMENTCALCULATEPROCESS].[TSLONG]
from dbo.[MKTSEGMENTATIONSEGMENTCALCULATEPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [MKTSEGMENTATIONSEGMENTCALCULATEPROCESS].[ID] 
left outer join dbo.[MKTSEGMENTATION] on [MKTSEGMENTATION].[ID] = [MKTSEGMENTATIONSEGMENTCALCULATEPROCESS].[SEGMENTATIONID]left outer join dbo.[SITE] on [SITE].[ID] = [MKTSEGMENTATION].[SITEID]

union all
select [MKTSEGMENTATIONSEGMENTREFRESHPROCESS].[ID] as [PARAMETERSETID], [MKTSEGMENTATIONSEGMENTREFRESHPROCESS].[NAME] as [NAME], '427c0269-0299-4f9a-924a-3141032a9ec4' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [MKTSEGMENTATION].[SITEID], isnull([SITE].[NAME], '') as [SITE], [MKTSEGMENTATIONSEGMENTREFRESHPROCESS].[ADDEDBYID], [MKTSEGMENTATIONSEGMENTREFRESHPROCESS].[CHANGEDBYID], [MKTSEGMENTATIONSEGMENTREFRESHPROCESS].[DATEADDED], [MKTSEGMENTATIONSEGMENTREFRESHPROCESS].[DATECHANGED], [MKTSEGMENTATIONSEGMENTREFRESHPROCESS].[TSLONG]
from dbo.[MKTSEGMENTATIONSEGMENTREFRESHPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [MKTSEGMENTATIONSEGMENTREFRESHPROCESS].[ID] 
left outer join dbo.[MKTSEGMENTATION] on [MKTSEGMENTATION].[ID] = [MKTSEGMENTATIONSEGMENTREFRESHPROCESS].[SEGMENTATIONID]left outer join dbo.[SITE] on [SITE].[ID] = [MKTSEGMENTATION].[SITEID]

union all
select [MKTSEGMENTGROUPREFRESHPROCESS].[ID] as [PARAMETERSETID], [MKTSEGMENTGROUPREFRESHPROCESS].[NAME] as [NAME], '6d70a1ea-38b7-419f-963e-3e183753223d' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [MKTSEGMENTGROUPREFRESHPROCESS].[ADDEDBYID], [MKTSEGMENTGROUPREFRESHPROCESS].[CHANGEDBYID], [MKTSEGMENTGROUPREFRESHPROCESS].[DATEADDED], [MKTSEGMENTGROUPREFRESHPROCESS].[DATECHANGED], [MKTSEGMENTGROUPREFRESHPROCESS].[TSLONG]
from dbo.[MKTSEGMENTGROUPREFRESHPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [MKTSEGMENTGROUPREFRESHPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [MKTSEGMENTLISTDEDUPEPROCESS].[ID] as [PARAMETERSETID], [MKTSEGMENTLISTDEDUPEPROCESS].[NAME] as [NAME], 'd8689991-7929-45b5-86b0-66f90e392f55' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [MKTSEGMENTLISTDEDUPEPROCESS].[ADDEDBYID], [MKTSEGMENTLISTDEDUPEPROCESS].[CHANGEDBYID], [MKTSEGMENTLISTDEDUPEPROCESS].[DATEADDED], [MKTSEGMENTLISTDEDUPEPROCESS].[DATECHANGED], [MKTSEGMENTLISTDEDUPEPROCESS].[TSLONG]
from dbo.[MKTSEGMENTLISTDEDUPEPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [MKTSEGMENTLISTDEDUPEPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [MKTSEGMENTLISTIMPORTPROCESS].[ID] as [PARAMETERSETID], [MKTSEGMENTLISTIMPORTPROCESS].[NAME] as [NAME], 'ca0dd398-85c2-409b-a847-9f09a78a150f' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [MKTSEGMENTLISTIMPORTPROCESS].[ADDEDBYID], [MKTSEGMENTLISTIMPORTPROCESS].[CHANGEDBYID], [MKTSEGMENTLISTIMPORTPROCESS].[DATEADDED], [MKTSEGMENTLISTIMPORTPROCESS].[DATECHANGED], [MKTSEGMENTLISTIMPORTPROCESS].[TSLONG]
from dbo.[MKTSEGMENTLISTIMPORTPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [MKTSEGMENTLISTIMPORTPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [MKTSEGMENTREFRESHPROCESS].[ID] as [PARAMETERSETID], [MKTSEGMENTREFRESHPROCESS].[NAME] as [NAME], 'e27cc00c-2cbc-44c6-9ce6-398b9198a183' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [MKTSEGMENTREFRESHPROCESS].[ADDEDBYID], [MKTSEGMENTREFRESHPROCESS].[CHANGEDBYID], [MKTSEGMENTREFRESHPROCESS].[DATEADDED], [MKTSEGMENTREFRESHPROCESS].[DATECHANGED], [MKTSEGMENTREFRESHPROCESS].[TSLONG]
from dbo.[MKTSEGMENTREFRESHPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [MKTSEGMENTREFRESHPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [MKTSEGMENTSREFRESHPROCESS].[ID] as [PARAMETERSETID], [MKTSEGMENTSREFRESHPROCESS].[NAME] as [NAME], 'f2e4036b-a903-47a2-a9d3-e0e106080596' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [MKTSEGMENTSREFRESHPROCESS].[ADDEDBYID], [MKTSEGMENTSREFRESHPROCESS].[CHANGEDBYID], [MKTSEGMENTSREFRESHPROCESS].[DATEADDED], [MKTSEGMENTSREFRESHPROCESS].[DATECHANGED], [MKTSEGMENTSREFRESHPROCESS].[TSLONG]
from dbo.[MKTSEGMENTSREFRESHPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [MKTSEGMENTSREFRESHPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [MKTSEGMENTWHITEMAILREFRESHALLPROCESS].[ID] as [PARAMETERSETID], [MKTSEGMENTWHITEMAILREFRESHALLPROCESS].[NAME] as [NAME], '73846879-0334-43eb-a332-2e1b989b4822' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [MKTSEGMENTWHITEMAILREFRESHALLPROCESS].[ADDEDBYID], [MKTSEGMENTWHITEMAILREFRESHALLPROCESS].[CHANGEDBYID], [MKTSEGMENTWHITEMAILREFRESHALLPROCESS].[DATEADDED], [MKTSEGMENTWHITEMAILREFRESHALLPROCESS].[DATECHANGED], [MKTSEGMENTWHITEMAILREFRESHALLPROCESS].[TSLONG]
from dbo.[MKTSEGMENTWHITEMAILREFRESHALLPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [MKTSEGMENTWHITEMAILREFRESHALLPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [MKTSEGMENTWHITEMAILREFRESHPROCESS].[ID] as [PARAMETERSETID], [MKTSEGMENTWHITEMAILREFRESHPROCESS].[NAME] as [NAME], '074e87e1-2417-453e-9c70-1b7dd04eaa1d' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [MKTSEGMENTWHITEMAILREFRESHPROCESS].[ADDEDBYID], [MKTSEGMENTWHITEMAILREFRESHPROCESS].[CHANGEDBYID], [MKTSEGMENTWHITEMAILREFRESHPROCESS].[DATEADDED], [MKTSEGMENTWHITEMAILREFRESHPROCESS].[DATECHANGED], [MKTSEGMENTWHITEMAILREFRESHPROCESS].[TSLONG]
from dbo.[MKTSEGMENTWHITEMAILREFRESHPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [MKTSEGMENTWHITEMAILREFRESHPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [MKTSOURCEANALYSISRULES].[ID] as [PARAMETERSETID], [MKTSOURCEANALYSISRULES].[NAME] as [NAME], '589eacdb-3461-42db-8bc0-f39939e61019' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [MKTSOURCEANALYSISRULES].[ADDEDBYID], [MKTSOURCEANALYSISRULES].[CHANGEDBYID], [MKTSOURCEANALYSISRULES].[DATEADDED], [MKTSOURCEANALYSISRULES].[DATECHANGED], [MKTSOURCEANALYSISRULES].[TSLONG]
from dbo.[MKTSOURCEANALYSISRULES] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [MKTSOURCEANALYSISRULES].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [MKTSPONSORSHIPMAILINGPROCESS].[ID] as [PARAMETERSETID], [MKTSPONSORSHIPMAILINGPROCESS].[NAME] as [NAME], 'b043b938-9cbe-4c3d-81e3-e3f59e0e56dc' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [MKTSPONSORSHIPMAILINGPROCESS].[ADDEDBYID], [MKTSPONSORSHIPMAILINGPROCESS].[CHANGEDBYID], [MKTSPONSORSHIPMAILINGPROCESS].[DATEADDED], [MKTSPONSORSHIPMAILINGPROCESS].[DATECHANGED], [MKTSPONSORSHIPMAILINGPROCESS].[TSLONG]
from dbo.[MKTSPONSORSHIPMAILINGPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [MKTSPONSORSHIPMAILINGPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [MKTUPDATEMAILINGCOUNTSPROCESS].[ID] as [PARAMETERSETID], [MKTUPDATEMAILINGCOUNTSPROCESS].[NAME] as [NAME], '4cd4d8de-d0b7-4378-a7f2-23cc99a75e6d' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [MKTUPDATEMAILINGCOUNTSPROCESS].[ADDEDBYID], [MKTUPDATEMAILINGCOUNTSPROCESS].[CHANGEDBYID], [MKTUPDATEMAILINGCOUNTSPROCESS].[DATEADDED], [MKTUPDATEMAILINGCOUNTSPROCESS].[DATECHANGED], [MKTUPDATEMAILINGCOUNTSPROCESS].[TSLONG]
from dbo.[MKTUPDATEMAILINGCOUNTSPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [MKTUPDATEMAILINGCOUNTSPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [NETCOMMUNITYTRANSACTIONPROCESSOR].[ID] as [PARAMETERSETID], [NETCOMMUNITYTRANSACTIONPROCESSOR].[NAME] as [NAME], '396353b8-deb2-43ce-be19-8b53b096b9d3' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [NETCOMMUNITYTRANSACTIONPROCESSOR].[ADDEDBYID], [NETCOMMUNITYTRANSACTIONPROCESSOR].[CHANGEDBYID], [NETCOMMUNITYTRANSACTIONPROCESSOR].[DATEADDED], [NETCOMMUNITYTRANSACTIONPROCESSOR].[DATECHANGED], [NETCOMMUNITYTRANSACTIONPROCESSOR].[TSLONG]
from dbo.[NETCOMMUNITYTRANSACTIONPROCESSOR] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [NETCOMMUNITYTRANSACTIONPROCESSOR].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [OLAPDATASOURCEVALIDATIONPARAMETERS].[ID] as [PARAMETERSETID], [OLAPDATASOURCEVALIDATIONPARAMETERS].[NAME] as [NAME], 'e0580695-2479-4805-859c-6cd9abea3d82' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [OLAPDATASOURCEVALIDATIONPARAMETERS].[ADDEDBYID], [OLAPDATASOURCEVALIDATIONPARAMETERS].[CHANGEDBYID], [OLAPDATASOURCEVALIDATIONPARAMETERS].[DATEADDED], [OLAPDATASOURCEVALIDATIONPARAMETERS].[DATECHANGED], [OLAPDATASOURCEVALIDATIONPARAMETERS].[TSLONG]
from dbo.[OLAPDATASOURCEVALIDATIONPARAMETERS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [OLAPDATASOURCEVALIDATIONPARAMETERS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [OLAPREFRESHPROCESS].[ID] as [PARAMETERSETID], [OLAPREFRESHPROCESS].[SOURCENAME] as [NAME], 'd7aca596-92e1-48e3-901b-ccd91bb54f7e' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [OLAPREFRESHPROCESS].[ADDEDBYID], [OLAPREFRESHPROCESS].[CHANGEDBYID], [OLAPREFRESHPROCESS].[DATEADDED], [OLAPREFRESHPROCESS].[DATECHANGED], [OLAPREFRESHPROCESS].[TSLONG]
from dbo.[OLAPREFRESHPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [OLAPREFRESHPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [PAPERLESSMANDATESINSTRUCTIONPROCESS].[ID] as [PARAMETERSETID], [PAPERLESSMANDATESINSTRUCTIONPROCESS].[NAME] as [NAME], 'bb21918c-8f47-48fd-9ed0-ba36ba484338' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [PAPERLESSMANDATESINSTRUCTIONPROCESS].[ADDEDBYID], [PAPERLESSMANDATESINSTRUCTIONPROCESS].[CHANGEDBYID], [PAPERLESSMANDATESINSTRUCTIONPROCESS].[DATEADDED], [PAPERLESSMANDATESINSTRUCTIONPROCESS].[DATECHANGED], [PAPERLESSMANDATESINSTRUCTIONPROCESS].[TSLONG]
from dbo.[PAPERLESSMANDATESINSTRUCTIONPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [PAPERLESSMANDATESINSTRUCTIONPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [PEOPLEFINDERGETPROCESS].[ID] as [PARAMETERSETID], [PEOPLEFINDERGETPROCESS].[NAME] as [NAME], '9c1bacec-ab82-43ef-a851-5b2ea92f1fae' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [PEOPLEFINDERGETPROCESS].[ADDEDBYID], [PEOPLEFINDERGETPROCESS].[CHANGEDBYID], [PEOPLEFINDERGETPROCESS].[DATEADDED], [PEOPLEFINDERGETPROCESS].[DATECHANGED], [PEOPLEFINDERGETPROCESS].[TSLONG]
from dbo.[PEOPLEFINDERGETPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [PEOPLEFINDERGETPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [PEOPLEFINDERRESUBMITPROCESS].[ID] as [PARAMETERSETID], [PEOPLEFINDERRESUBMITPROCESS].[NAME] as [NAME], '7edf6b16-6522-489e-b80f-85b533fd3ffe' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [PEOPLEFINDERRESUBMITPROCESS].[ADDEDBYID], [PEOPLEFINDERRESUBMITPROCESS].[CHANGEDBYID], [PEOPLEFINDERRESUBMITPROCESS].[DATEADDED], [PEOPLEFINDERRESUBMITPROCESS].[DATECHANGED], [PEOPLEFINDERRESUBMITPROCESS].[TSLONG]
from dbo.[PEOPLEFINDERRESUBMITPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [PEOPLEFINDERRESUBMITPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [PEOPLEFINDERSUBMITPROCESS].[ID] as [PARAMETERSETID], [PEOPLEFINDERSUBMITPROCESS].[NAME] as [NAME], 'ecbaa00e-ae64-489a-9545-377c024f7e7c' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [PEOPLEFINDERSUBMITPROCESS].[ADDEDBYID], [PEOPLEFINDERSUBMITPROCESS].[CHANGEDBYID], [PEOPLEFINDERSUBMITPROCESS].[DATEADDED], [PEOPLEFINDERSUBMITPROCESS].[DATECHANGED], [PEOPLEFINDERSUBMITPROCESS].[TSLONG]
from dbo.[PEOPLEFINDERSUBMITPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [PEOPLEFINDERSUBMITPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [PHONEFINDERGETPROCESS].[ID] as [PARAMETERSETID], [PHONEFINDERGETPROCESS].[NAME] as [NAME], '1b4e38e5-74ae-4743-b716-94800c008e66' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [PHONEFINDERGETPROCESS].[ADDEDBYID], [PHONEFINDERGETPROCESS].[CHANGEDBYID], [PHONEFINDERGETPROCESS].[DATEADDED], [PHONEFINDERGETPROCESS].[DATECHANGED], [PHONEFINDERGETPROCESS].[TSLONG]
from dbo.[PHONEFINDERGETPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [PHONEFINDERGETPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [PHONEFINDERRESUBMITPROCESS].[ID] as [PARAMETERSETID], [PHONEFINDERRESUBMITPROCESS].[NAME] as [NAME], '44e99271-3171-4a34-993b-3b41f49138c1' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [PHONEFINDERRESUBMITPROCESS].[ADDEDBYID], [PHONEFINDERRESUBMITPROCESS].[CHANGEDBYID], [PHONEFINDERRESUBMITPROCESS].[DATEADDED], [PHONEFINDERRESUBMITPROCESS].[DATECHANGED], [PHONEFINDERRESUBMITPROCESS].[TSLONG]
from dbo.[PHONEFINDERRESUBMITPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [PHONEFINDERRESUBMITPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [PHONEFINDERSUBMITPROCESS].[ID] as [PARAMETERSETID], [PHONEFINDERSUBMITPROCESS].[NAME] as [NAME], '7b8f15bb-9c5e-49e3-82d1-999b7b1a6843' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [PHONEFINDERSUBMITPROCESS].[ADDEDBYID], [PHONEFINDERSUBMITPROCESS].[CHANGEDBYID], [PHONEFINDERSUBMITPROCESS].[DATEADDED], [PHONEFINDERSUBMITPROCESS].[DATECHANGED], [PHONEFINDERSUBMITPROCESS].[TSLONG]
from dbo.[PHONEFINDERSUBMITPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [PHONEFINDERSUBMITPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [PLANNEDGIFTACKNOWLEDGEMENTPROCESS].[ID] as [PARAMETERSETID], [PLANNEDGIFTACKNOWLEDGEMENTPROCESS].[NAME] as [NAME], '8c332468-7d1f-4434-9ecd-c828fc3b6099' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [PLANNEDGIFTACKNOWLEDGEMENTPROCESS].[ADDEDBYID], [PLANNEDGIFTACKNOWLEDGEMENTPROCESS].[CHANGEDBYID], [PLANNEDGIFTACKNOWLEDGEMENTPROCESS].[DATEADDED], [PLANNEDGIFTACKNOWLEDGEMENTPROCESS].[DATECHANGED], [PLANNEDGIFTACKNOWLEDGEMENTPROCESS].[TSLONG]
from dbo.[PLANNEDGIFTACKNOWLEDGEMENTPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [PLANNEDGIFTACKNOWLEDGEMENTPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [PLEDGEREMINDERPROCESS].[ID] as [PARAMETERSETID], [PLEDGEREMINDERPROCESS].[NAME] as [NAME], '84414bd2-3196-4697-998a-2493c29a302a' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [PLEDGEREMINDERPROCESS].[ADDEDBYID], [PLEDGEREMINDERPROCESS].[CHANGEDBYID], [PLEDGEREMINDERPROCESS].[DATEADDED], [PLEDGEREMINDERPROCESS].[DATECHANGED], [PLEDGEREMINDERPROCESS].[TSLONG]
from dbo.[PLEDGEREMINDERPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [PLEDGEREMINDERPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [PLEDGEWRITEOFFPROCESS].[ID] as [PARAMETERSETID], [PLEDGEWRITEOFFPROCESS].[NAME] as [NAME], '17cc2c7f-8b70-4a07-a0e7-164060d215f5' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [PLEDGEWRITEOFFPROCESS].[ADDEDBYID], [PLEDGEWRITEOFFPROCESS].[CHANGEDBYID], [PLEDGEWRITEOFFPROCESS].[DATEADDED], [PLEDGEWRITEOFFPROCESS].[DATECHANGED], [PLEDGEWRITEOFFPROCESS].[TSLONG]
from dbo.[PLEDGEWRITEOFFPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [PLEDGEWRITEOFFPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [POSTTOGLPROCESS].[ID] as [PARAMETERSETID], [POSTTOGLPROCESS].[NAME] as [NAME], 'b4acd31d-d511-465e-89f1-733cded5f975' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [POSTTOGLPROCESS].[ADDEDBYID], [POSTTOGLPROCESS].[CHANGEDBYID], [POSTTOGLPROCESS].[DATEADDED], [POSTTOGLPROCESS].[DATECHANGED], [POSTTOGLPROCESS].[TSLONG]
from dbo.[POSTTOGLPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [POSTTOGLPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [POSTTOGLPROCESS].[ID] as [PARAMETERSETID], [POSTTOGLPROCESS].[NAME] as [NAME], '48ef5b33-14cc-41cd-96bf-29f490b0a60f' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [POSTTOGLPROCESS].[ADDEDBYID], [POSTTOGLPROCESS].[CHANGEDBYID], [POSTTOGLPROCESS].[DATEADDED], [POSTTOGLPROCESS].[DATECHANGED], [POSTTOGLPROCESS].[TSLONG]
from dbo.[POSTTOGLPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [POSTTOGLPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [PRENOTIFICATIONPROCESS].[ID] as [PARAMETERSETID], [PRENOTIFICATIONPROCESS].[NAME] as [NAME], 'f327e3a6-06f8-4816-be25-bc004e73c802' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [PRENOTIFICATIONPROCESS].[ADDEDBYID], [PRENOTIFICATIONPROCESS].[CHANGEDBYID], [PRENOTIFICATIONPROCESS].[DATEADDED], [PRENOTIFICATIONPROCESS].[DATECHANGED], [PRENOTIFICATIONPROCESS].[TSLONG]
from dbo.[PRENOTIFICATIONPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [PRENOTIFICATIONPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [PRINTMEMBERSHIPCARDSPROCESS].[ID] as [PARAMETERSETID], [PRINTMEMBERSHIPCARDSPROCESS].[NAME] as [NAME], '8debf336-c3c9-4097-80c2-c76c9532486f' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [PRINTMEMBERSHIPCARDSPROCESS].[ADDEDBYID], [PRINTMEMBERSHIPCARDSPROCESS].[CHANGEDBYID], [PRINTMEMBERSHIPCARDSPROCESS].[DATEADDED], [PRINTMEMBERSHIPCARDSPROCESS].[DATECHANGED], [PRINTMEMBERSHIPCARDSPROCESS].[TSLONG]
from dbo.[PRINTMEMBERSHIPCARDSPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [PRINTMEMBERSHIPCARDSPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [PROSPECTASSIGNMENTPROCESS].[ID] as [PARAMETERSETID], [PROSPECTASSIGNMENTPROCESS].[NAME] as [NAME], '49b35224-eed4-499a-9f8d-af1e40d01bd1' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [PROSPECTASSIGNMENTPROCESS].[ADDEDBYID], [PROSPECTASSIGNMENTPROCESS].[CHANGEDBYID], [PROSPECTASSIGNMENTPROCESS].[DATEADDED], [PROSPECTASSIGNMENTPROCESS].[DATECHANGED], [PROSPECTASSIGNMENTPROCESS].[TSLONG]
from dbo.[PROSPECTASSIGNMENTPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [PROSPECTASSIGNMENTPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [QUERYVIEWADDATTRIBUTEEXTENSIONPROCESS].[ID] as [PARAMETERSETID], [QUERYVIEWADDATTRIBUTEEXTENSIONPROCESS].[NAME] as [NAME], 'e1b2487a-2070-413f-bac6-34c824b31563' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [QUERYVIEWADDATTRIBUTEEXTENSIONPROCESS].[ADDEDBYID], [QUERYVIEWADDATTRIBUTEEXTENSIONPROCESS].[CHANGEDBYID], [QUERYVIEWADDATTRIBUTEEXTENSIONPROCESS].[DATEADDED], [QUERYVIEWADDATTRIBUTEEXTENSIONPROCESS].[DATECHANGED], [QUERYVIEWADDATTRIBUTEEXTENSIONPROCESS].[TSLONG]
from dbo.[QUERYVIEWADDATTRIBUTEEXTENSIONPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [QUERYVIEWADDATTRIBUTEEXTENSIONPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [QUEUEPROCESS].[ID] as [PARAMETERSETID], [QUEUEPROCESS].[NAME] as [NAME], '1b4480fc-b7ab-4edb-a0bf-c897eded1f58' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [QUEUEPROCESS].[ADDEDBYID], [QUEUEPROCESS].[CHANGEDBYID], [QUEUEPROCESS].[DATEADDED], [QUEUEPROCESS].[DATECHANGED], [QUEUEPROCESS].[TSLONG]
from dbo.[QUEUEPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [QUEUEPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [R68].[ID] as [PARAMETERSETID], [R68].[NAME] as [NAME], '5f83e4c6-7cad-4b2c-95a6-506bb18130ab' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [R68].[ADDEDBYID], [R68].[CHANGEDBYID], [R68].[DATEADDED], [R68].[DATECHANGED], [R68].[TSLONG]
from dbo.[R68] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [R68].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [R68ONLINESUBMISSIONPARAMETERS].[ID] as [PARAMETERSETID], [R68ONLINESUBMISSIONPARAMETERS].[NAME] as [NAME], '468fec91-e83d-4191-9411-c5dada98b2e0' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [R68ONLINESUBMISSIONPARAMETERS].[ADDEDBYID], [R68ONLINESUBMISSIONPARAMETERS].[CHANGEDBYID], [R68ONLINESUBMISSIONPARAMETERS].[DATEADDED], [R68ONLINESUBMISSIONPARAMETERS].[DATECHANGED], [R68ONLINESUBMISSIONPARAMETERS].[TSLONG]
from dbo.[R68ONLINESUBMISSIONPARAMETERS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [R68ONLINESUBMISSIONPARAMETERS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [R68PROCESSCOMMITPARAMETERS].[ID] as [PARAMETERSETID], [R68PROCESSCOMMITPARAMETERS].[NAME] as [NAME], '68792139-1c34-4284-939b-0b47a5267018' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [R68PROCESSCOMMITPARAMETERS].[ADDEDBYID], [R68PROCESSCOMMITPARAMETERS].[CHANGEDBYID], [R68PROCESSCOMMITPARAMETERS].[DATEADDED], [R68PROCESSCOMMITPARAMETERS].[DATECHANGED], [R68PROCESSCOMMITPARAMETERS].[TSLONG]
from dbo.[R68PROCESSCOMMITPARAMETERS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [R68PROCESSCOMMITPARAMETERS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [RE7ATTRIBUTEPROCESS].[ID] as [PARAMETERSETID], [RE7ATTRIBUTEPROCESS].[SOURCENAME] as [NAME], '3aee84af-e99a-4f93-9a1e-4b7ce2c3dea8' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [RE7ATTRIBUTEPROCESS].[ADDEDBYID], [RE7ATTRIBUTEPROCESS].[CHANGEDBYID], [RE7ATTRIBUTEPROCESS].[DATEADDED], [RE7ATTRIBUTEPROCESS].[DATECHANGED], [RE7ATTRIBUTEPROCESS].[TSLONG]
from dbo.[RE7ATTRIBUTEPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [RE7ATTRIBUTEPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [RECEIPTINGPROCESS].[ID] as [PARAMETERSETID], [RECEIPTINGPROCESS].[NAME] as [NAME], '83048ded-208e-45c9-852c-e7d5c7317882' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [RECEIPTINGPROCESS].[ADDEDBYID], [RECEIPTINGPROCESS].[CHANGEDBYID], [RECEIPTINGPROCESS].[DATEADDED], [RECEIPTINGPROCESS].[DATECHANGED], [RECEIPTINGPROCESS].[TSLONG]
from dbo.[RECEIPTINGPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [RECEIPTINGPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [RECURRINGGIFTSTATUSUPDATEPROCESS].[ID] as [PARAMETERSETID], [RECURRINGGIFTSTATUSUPDATEPROCESS].[NAME] as [NAME], '2a13ea65-e2a3-4edc-8407-ab09ac62d7bb' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [RECURRINGGIFTSTATUSUPDATEPROCESS].[ADDEDBYID], [RECURRINGGIFTSTATUSUPDATEPROCESS].[CHANGEDBYID], [RECURRINGGIFTSTATUSUPDATEPROCESS].[DATEADDED], [RECURRINGGIFTSTATUSUPDATEPROCESS].[DATECHANGED], [RECURRINGGIFTSTATUSUPDATEPROCESS].[TSLONG]
from dbo.[RECURRINGGIFTSTATUSUPDATEPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [RECURRINGGIFTSTATUSUPDATEPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [RESEARCHGROUPPOPULATEPROCESS].[ID] as [PARAMETERSETID], [RESEARCHGROUPPOPULATEPROCESS].[NAME] as [NAME], 'ed71de51-3ae2-4c8a-a1c5-3687bc7c4c3c' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [RESEARCHGROUPPOPULATEPROCESS].[ADDEDBYID], [RESEARCHGROUPPOPULATEPROCESS].[CHANGEDBYID], [RESEARCHGROUPPOPULATEPROCESS].[DATEADDED], [RESEARCHGROUPPOPULATEPROCESS].[DATECHANGED], [RESEARCHGROUPPOPULATEPROCESS].[TSLONG]
from dbo.[RESEARCHGROUPPOPULATEPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [RESEARCHGROUPPOPULATEPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [REVALUECOMMITMENTSPROCESS].[ID] as [PARAMETERSETID], [REVALUECOMMITMENTSPROCESS].[NAME] as [NAME], '396acd18-86ca-40f5-831a-1ed6e1955fee' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [REVALUECOMMITMENTSPROCESS].[ADDEDBYID], [REVALUECOMMITMENTSPROCESS].[CHANGEDBYID], [REVALUECOMMITMENTSPROCESS].[DATEADDED], [REVALUECOMMITMENTSPROCESS].[DATECHANGED], [REVALUECOMMITMENTSPROCESS].[TSLONG]
from dbo.[REVALUECOMMITMENTSPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [REVALUECOMMITMENTSPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [REVENUELIFECYCLEPROCESS].[ID] as [PARAMETERSETID], [REVENUELIFECYCLEPROCESS].[NAME] as [NAME], '96212661-d4b2-4c2e-a650-b83a2c1424f1' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [REVENUELIFECYCLEPROCESS].[ADDEDBYID], [REVENUELIFECYCLEPROCESS].[CHANGEDBYID], [REVENUELIFECYCLEPROCESS].[DATEADDED], [REVENUELIFECYCLEPROCESS].[DATECHANGED], [REVENUELIFECYCLEPROCESS].[TSLONG]
from dbo.[REVENUELIFECYCLEPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [REVENUELIFECYCLEPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [SALESDEPOSITPROCESS].[ID] as [PARAMETERSETID], [SALESDEPOSITPROCESS].[NAME] as [NAME], '434ac0dd-a3f3-480c-b7da-204c40205a68' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [SALESDEPOSITPROCESS].[ADDEDBYID], [SALESDEPOSITPROCESS].[CHANGEDBYID], [SALESDEPOSITPROCESS].[DATEADDED], [SALESDEPOSITPROCESS].[DATECHANGED], [SALESDEPOSITPROCESS].[TSLONG]
from dbo.[SALESDEPOSITPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [SALESDEPOSITPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [SMARTFIELD].[ID] as [PARAMETERSETID], [SMARTFIELD].[NAME] as [NAME], '2505c856-deb9-415e-bd7c-d2fed90622f5' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], cast(null as uniqueidentifier) as [SITEID], (select case when exists (select top 1 1 from dbo.[SMARTFIELDSITE] where [SMARTFIELDSITE].[SMARTFIELDID] = [SMARTFIELD].[ID]) then stuff((select ', ' + [SITE].[NAME] from dbo.[SMARTFIELDSITE] inner join dbo.[SITE] on [SITE].[ID] = [SMARTFIELDSITE].[SITEID] where [SMARTFIELDSITE].[SMARTFIELDID] = [SMARTFIELD].[ID] order by [SITE].[HIERARCHYPATH] for xml path('')), 1, 2, '') else 'All sites' end) as [SITE], [SMARTFIELD].[ADDEDBYID], [SMARTFIELD].[CHANGEDBYID], [SMARTFIELD].[DATEADDED], [SMARTFIELD].[DATECHANGED], [SMARTFIELD].[TSLONG]
from dbo.[SMARTFIELD] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [SMARTFIELD].[ID] 


union all
select [SMARTQUERYINSTANCE].[ID] as [PARAMETERSETID], [SMARTQUERYINSTANCE].[NAME] as [NAME], '5ec0527d-219b-4766-88f1-010944431107' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [SMARTQUERYINSTANCE].[ADDEDBYID], [SMARTQUERYINSTANCE].[CHANGEDBYID], [SMARTQUERYINSTANCE].[DATEADDED], [SMARTQUERYINSTANCE].[DATECHANGED], [SMARTQUERYINSTANCE].[TSLONG]
from dbo.[SMARTQUERYINSTANCE] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [SMARTQUERYINSTANCE].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [SPONSORSHIPLOCATIONCLOSEPROCESS].[ID] as [PARAMETERSETID], [SPONSORSHIPLOCATIONCLOSEPROCESS].[NAME] as [NAME], '758a02e5-ac14-4d26-87f3-deac65eda13e' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [SPONSORSHIPLOCATIONCLOSEPROCESS].[ADDEDBYID], [SPONSORSHIPLOCATIONCLOSEPROCESS].[CHANGEDBYID], [SPONSORSHIPLOCATIONCLOSEPROCESS].[DATEADDED], [SPONSORSHIPLOCATIONCLOSEPROCESS].[DATECHANGED], [SPONSORSHIPLOCATIONCLOSEPROCESS].[TSLONG]
from dbo.[SPONSORSHIPLOCATIONCLOSEPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [SPONSORSHIPLOCATIONCLOSEPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [SPONSORSHIPOPPORTUNITYRESERVEPROCESS].[ID] as [PARAMETERSETID], [SPONSORSHIPOPPORTUNITYRESERVEPROCESS].[NAME] as [NAME], 'f785c153-c4b5-4434-811c-02b2ac7b3e2e' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [SPONSORSHIPOPPORTUNITYRESERVEPROCESS].[ADDEDBYID], [SPONSORSHIPOPPORTUNITYRESERVEPROCESS].[CHANGEDBYID], [SPONSORSHIPOPPORTUNITYRESERVEPROCESS].[DATEADDED], [SPONSORSHIPOPPORTUNITYRESERVEPROCESS].[DATECHANGED], [SPONSORSHIPOPPORTUNITYRESERVEPROCESS].[TSLONG]
from dbo.[SPONSORSHIPOPPORTUNITYRESERVEPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [SPONSORSHIPOPPORTUNITYRESERVEPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [SPONSORSHIPOPPORTUNITYRESERVEPROCESS].[ID] as [PARAMETERSETID], [SPONSORSHIPOPPORTUNITYRESERVEPROCESS].[NAME] as [NAME], '90cdcaa3-9279-4a7d-ab33-14097fb7f3af' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [SPONSORSHIPOPPORTUNITYRESERVEPROCESS].[ADDEDBYID], [SPONSORSHIPOPPORTUNITYRESERVEPROCESS].[CHANGEDBYID], [SPONSORSHIPOPPORTUNITYRESERVEPROCESS].[DATEADDED], [SPONSORSHIPOPPORTUNITYRESERVEPROCESS].[DATECHANGED], [SPONSORSHIPOPPORTUNITYRESERVEPROCESS].[TSLONG]
from dbo.[SPONSORSHIPOPPORTUNITYRESERVEPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [SPONSORSHIPOPPORTUNITYRESERVEPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [SPONSORSHIPOPPORTUNITYTRANSFERPROCESS].[ID] as [PARAMETERSETID], [SPONSORSHIPOPPORTUNITYTRANSFERPROCESS].[NAME] as [NAME], '7ee47ea0-8e7f-475c-a1c3-3b4b127e9136' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [SPONSORSHIPOPPORTUNITYTRANSFERPROCESS].[ADDEDBYID], [SPONSORSHIPOPPORTUNITYTRANSFERPROCESS].[CHANGEDBYID], [SPONSORSHIPOPPORTUNITYTRANSFERPROCESS].[DATEADDED], [SPONSORSHIPOPPORTUNITYTRANSFERPROCESS].[DATECHANGED], [SPONSORSHIPOPPORTUNITYTRANSFERPROCESS].[TSLONG]
from dbo.[SPONSORSHIPOPPORTUNITYTRANSFERPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [SPONSORSHIPOPPORTUNITYTRANSFERPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [SPONSORSHIPTERMINATEPROCESS].[ID] as [PARAMETERSETID], [SPONSORSHIPTERMINATEPROCESS].[NAME] as [NAME], '69c2165c-f0d6-446d-9b59-5208e27fb71c' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [SPONSORSHIPTERMINATEPROCESS].[ADDEDBYID], [SPONSORSHIPTERMINATEPROCESS].[CHANGEDBYID], [SPONSORSHIPTERMINATEPROCESS].[DATEADDED], [SPONSORSHIPTERMINATEPROCESS].[DATECHANGED], [SPONSORSHIPTERMINATEPROCESS].[TSLONG]
from dbo.[SPONSORSHIPTERMINATEPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [SPONSORSHIPTERMINATEPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [SPONSORSHIPTRANSFERPROCESS].[ID] as [PARAMETERSETID], [SPONSORSHIPTRANSFERPROCESS].[NAME] as [NAME], 'f4f46f81-dbc8-4362-a2b0-672d62bb4cbe' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [SPONSORSHIPTRANSFERPROCESS].[ADDEDBYID], [SPONSORSHIPTRANSFERPROCESS].[CHANGEDBYID], [SPONSORSHIPTRANSFERPROCESS].[DATEADDED], [SPONSORSHIPTRANSFERPROCESS].[DATECHANGED], [SPONSORSHIPTRANSFERPROCESS].[TSLONG]
from dbo.[SPONSORSHIPTRANSFERPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [SPONSORSHIPTRANSFERPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [STANDINGORDERSEXPORTPROCESS].[ID] as [PARAMETERSETID], [STANDINGORDERSEXPORTPROCESS].[NAME] as [NAME], 'e55b96e9-7fda-4b19-ac2c-d38fe75469af' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [STANDINGORDERSEXPORTPROCESS].[ADDEDBYID], [STANDINGORDERSEXPORTPROCESS].[CHANGEDBYID], [STANDINGORDERSEXPORTPROCESS].[DATEADDED], [STANDINGORDERSEXPORTPROCESS].[DATECHANGED], [STANDINGORDERSEXPORTPROCESS].[TSLONG]
from dbo.[STANDINGORDERSEXPORTPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [STANDINGORDERSEXPORTPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [STANDINGORDERSIMPORTPROCESS].[ID] as [PARAMETERSETID], [STANDINGORDERSIMPORTPROCESS].[NAME] as [NAME], '3ba4c1f9-bb99-47a4-b196-4e327dd74a62' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [STANDINGORDERSIMPORTPROCESS].[ADDEDBYID], [STANDINGORDERSIMPORTPROCESS].[CHANGEDBYID], [STANDINGORDERSIMPORTPROCESS].[DATEADDED], [STANDINGORDERSIMPORTPROCESS].[DATECHANGED], [STANDINGORDERSIMPORTPROCESS].[TSLONG]
from dbo.[STANDINGORDERSIMPORTPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [STANDINGORDERSIMPORTPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [STEWARDSHIPPACKAGEPROCESS].[ID] as [PARAMETERSETID], [STEWARDSHIPPACKAGEPROCESS].[NAME] as [NAME], 'b4184abe-c618-466f-90a2-b96b88644a17' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [STEWARDSHIPPACKAGEPROCESS].[ADDEDBYID], [STEWARDSHIPPACKAGEPROCESS].[CHANGEDBYID], [STEWARDSHIPPACKAGEPROCESS].[DATEADDED], [STEWARDSHIPPACKAGEPROCESS].[DATECHANGED], [STEWARDSHIPPACKAGEPROCESS].[TSLONG]
from dbo.[STEWARDSHIPPACKAGEPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [STEWARDSHIPPACKAGEPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [STEWARDSHIPPLANASSIGNMENTPROCESS].[ID] as [PARAMETERSETID], [STEWARDSHIPPLANASSIGNMENTPROCESS].[NAME] as [NAME], '57859e94-bf48-4fa3-97d8-0c1b49673d33' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [STEWARDSHIPPLANASSIGNMENTPROCESS].[ADDEDBYID], [STEWARDSHIPPLANASSIGNMENTPROCESS].[CHANGEDBYID], [STEWARDSHIPPLANASSIGNMENTPROCESS].[DATEADDED], [STEWARDSHIPPLANASSIGNMENTPROCESS].[DATECHANGED], [STEWARDSHIPPLANASSIGNMENTPROCESS].[TSLONG]
from dbo.[STEWARDSHIPPLANASSIGNMENTPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [STEWARDSHIPPLANASSIGNMENTPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [SURVEYDOWNLOADPROCESS].[ID] as [PARAMETERSETID], [SURVEYDOWNLOADPROCESS].[NAME] as [NAME], 'ce06a9f5-8a55-4294-b041-90a58ac83f73' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [SURVEYDOWNLOADPROCESS].[ADDEDBYID], [SURVEYDOWNLOADPROCESS].[CHANGEDBYID], [SURVEYDOWNLOADPROCESS].[DATEADDED], [SURVEYDOWNLOADPROCESS].[DATECHANGED], [SURVEYDOWNLOADPROCESS].[TSLONG]
from dbo.[SURVEYDOWNLOADPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [SURVEYDOWNLOADPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [SYNCMERCHANTACCOUNTSPROCESS].[ID] as [PARAMETERSETID], [SYNCMERCHANTACCOUNTSPROCESS].[NAME] as [NAME], '415859cc-8f9f-4d43-a0ac-e7f2365481ec' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [SYNCMERCHANTACCOUNTSPROCESS].[ADDEDBYID], [SYNCMERCHANTACCOUNTSPROCESS].[CHANGEDBYID], [SYNCMERCHANTACCOUNTSPROCESS].[DATEADDED], [SYNCMERCHANTACCOUNTSPROCESS].[DATECHANGED], [SYNCMERCHANTACCOUNTSPROCESS].[TSLONG]
from dbo.[SYNCMERCHANTACCOUNTSPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [SYNCMERCHANTACCOUNTSPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [TRIBUTEACKNOWLEDGEMENTPROCESS].[ID] as [PARAMETERSETID], [TRIBUTEACKNOWLEDGEMENTPROCESS].[NAME] as [NAME], '1db992dd-f90f-4ad7-bbe1-8213d2a27ec0' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [TRIBUTEACKNOWLEDGEMENTPROCESS].[ADDEDBYID], [TRIBUTEACKNOWLEDGEMENTPROCESS].[CHANGEDBYID], [TRIBUTEACKNOWLEDGEMENTPROCESS].[DATEADDED], [TRIBUTEACKNOWLEDGEMENTPROCESS].[DATECHANGED], [TRIBUTEACKNOWLEDGEMENTPROCESS].[TSLONG]
from dbo.[TRIBUTEACKNOWLEDGEMENTPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [TRIBUTEACKNOWLEDGEMENTPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [UPDATEMULTIPLECONSTITUENTFROMMFOPROCESS].[ID] as [PARAMETERSETID], [UPDATEMULTIPLECONSTITUENTFROMMFOPROCESS].[NAME] as [NAME], '378f370f-421f-4b4a-9f07-e22bca4e2bf8' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [UPDATEMULTIPLECONSTITUENTFROMMFOPROCESS].[ADDEDBYID], [UPDATEMULTIPLECONSTITUENTFROMMFOPROCESS].[CHANGEDBYID], [UPDATEMULTIPLECONSTITUENTFROMMFOPROCESS].[DATEADDED], [UPDATEMULTIPLECONSTITUENTFROMMFOPROCESS].[DATECHANGED], [UPDATEMULTIPLECONSTITUENTFROMMFOPROCESS].[TSLONG]
from dbo.[UPDATEMULTIPLECONSTITUENTFROMMFOPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [UPDATEMULTIPLECONSTITUENTFROMMFOPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [USAGEREPORTPROCESS].[ID] as [PARAMETERSETID], [USAGEREPORTPROCESS].[NAME] as [NAME], '6fba9d47-2a2c-4865-98cf-ad9e3530833a' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [USAGEREPORTPROCESS].[ADDEDBYID], [USAGEREPORTPROCESS].[CHANGEDBYID], [USAGEREPORTPROCESS].[DATEADDED], [USAGEREPORTPROCESS].[DATECHANGED], [USAGEREPORTPROCESS].[TSLONG]
from dbo.[USAGEREPORTPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [USAGEREPORTPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [WPBATCHSCREENINGPROCESS].[ID] as [PARAMETERSETID], [WPBATCHSCREENINGPROCESS].[NAME] as [NAME], 'ba2fe2cf-af1d-4fbb-b2c0-03dc40fea991' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [WPBATCHSCREENINGPROCESS].[ADDEDBYID], [WPBATCHSCREENINGPROCESS].[CHANGEDBYID], [WPBATCHSCREENINGPROCESS].[DATEADDED], [WPBATCHSCREENINGPROCESS].[DATECHANGED], [WPBATCHSCREENINGPROCESS].[TSLONG]
from dbo.[WPBATCHSCREENINGPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [WPBATCHSCREENINGPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]

union all
select [WPRESEARCHGROUPSEARCHPROCESS].[ID] as [PARAMETERSETID], [WPRESEARCHGROUPSEARCHPROCESS].[NAME] as [NAME], '73a0edeb-1773-4053-90de-b7d8cf7efbf3' as [BUSINESSPROCESSID], [BUSINESSPROCESSINSTANCE].[OWNERID], [BUSINESSPROCESSINSTANCE].[SITEID], isnull([SITE].[NAME], 'All sites') as [SITE], [WPRESEARCHGROUPSEARCHPROCESS].[ADDEDBYID], [WPRESEARCHGROUPSEARCHPROCESS].[CHANGEDBYID], [WPRESEARCHGROUPSEARCHPROCESS].[DATEADDED], [WPRESEARCHGROUPSEARCHPROCESS].[DATECHANGED], [WPRESEARCHGROUPSEARCHPROCESS].[TSLONG]
from dbo.[WPRESEARCHGROUPSEARCHPROCESS] 
left outer join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [WPRESEARCHGROUPSEARCHPROCESS].[ID] 
left outer join dbo.[SITE] on [SITE].[ID] = [BUSINESSPROCESSINSTANCE].[SITEID]