UFN_CONSTITUENT_GETCONSTITUENCIES_FORUPDATEBATCH

This function returns a constituent's constituencies for the update batch given its ID.
Return

Return Type
table
Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN
Definition

Copy


            CREATE function dbo.UFN_CONSTITUENT_GETCONSTITUENCIES_FORUPDATEBATCH(@CONSTITUENTID uniqueidentifier)
            returns table
            as return
                select
                    C.[CONSTITUENCYCODEID],
                    C.[DATEFROM],
                    C.[DATETO],
                    C.ID as ORIGINALCONSTITUENCYID,
                    C.ADDEDBYID,
                    C.CHANGEDBYID,
                    C.DATEADDED,
                    C.DATECHANGED
                from
                    dbo.[CONSTITUENCY] C
                where
                    C.[CONSTITUENTID] = @CONSTITUENTID

                union all

                select
                    'F828E957-5F5E-479A-8F23-2FFD6C7C68FF' as [CONSTITUENCYCODEID],
                    C.[DATEFROM],
                    C.[DATETO],
                    C.ID as ORIGINALCONSTITUENCYID,
                    C.ADDEDBYID,
                    C.CHANGEDBYID,
                    C.DATEADDED,
                    C.DATECHANGED
                from
                    dbo.[BOARDMEMBERDATERANGE] C
                where
                    C.[CONSTITUENTID] = @CONSTITUENTID

                union all

                select
                    '6093915E-ADE9-42BE-88AE-304731754467' as [CONSTITUENCYCODEID],
                    C.[DATEFROM],
                    C.[DATETO],
                    C.ID as ORIGINALCONSTITUENCYID,
                    C.ADDEDBYID,
                    C.CHANGEDBYID,
                    C.DATEADDED,
                    C.DATECHANGED
                from
                    dbo.[STAFFDATERANGE] C
                where
                    C.[CONSTITUENTID] = @CONSTITUENTID

                union all

                select
                    'D2DCA06A-BE6E-40B3-B95D-59A926181923' as [CONSTITUENCYCODEID],
                    C.[DATEFROM],
                    C.[DATETO],
                    C.ID as ORIGINALCONSTITUENCYID,
                    C.ADDEDBYID,
                    C.CHANGEDBYID,
                    C.DATEADDED,
                    C.DATECHANGED
                from
                    dbo.[FUNDRAISERDATERANGE] C
                where
                    C.[CONSTITUENTID] = @CONSTITUENTID

                union all

                select
                    '00E748FB-940D-4A7D-A133-C148B29410A8' as [CONSTITUENCYCODEID],
                    C.[DATEFROM],
                    C.[DATETO],
                    C.ID as ORIGINALCONSTITUENCYID,
                    C.ADDEDBYID,
                    C.CHANGEDBYID,
                    C.DATEADDED,
                    C.DATECHANGED
                from
                    dbo.[PROSPECTDATERANGE] C
                where
                    C.[CONSTITUENTID] = @CONSTITUENTID

                union all

                select
                    'E7489703-3D63-4017-A2BC-88C092563C5D' as [CONSTITUENCYCODEID],
                    C.[DATEFROM],
                    C.[DATETO],
                    C.ID as ORIGINALCONSTITUENCYID,
                    C.ADDEDBYID,
                    C.CHANGEDBYID,
                    C.DATEADDED,
                    C.DATECHANGED
                from
                    dbo.[VOLUNTEERDATERANGE] C
                where
                    C.[CONSTITUENTID] = @CONSTITUENTID

                union all

                select
                    'AC9DB5A4-14E0-416A-9FB2-04038AC66799' as [CONSTITUENCYCODEID],
                    C.[DATEFROM],
                    C.[DATETO],
                    C.ID as ORIGINALCONSTITUENCYID,
                    C.ADDEDBYID,
                    C.CHANGEDBYID,
                    C.DATEADDED,
                    C.DATECHANGED
                from
                    dbo.[COMMITTEEDATERANGE] C
                where
                    C.[CONSTITUENTID] = @CONSTITUENTID;