USP_SIMPLEDATALIST_CONSTITUENCY
This simple list returns all the date range definable constituency types in the system (system and userdefined).
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @INCLUDEINACTIVE | bit | IN | |
| @CONSTITUENTTYPE | tinyint | IN |
Definition
Copy
CREATE procedure dbo.USP_SIMPLEDATALIST_CONSTITUENCY
(
@INCLUDEINACTIVE bit,
@CONSTITUENTTYPE tinyint = null
)
as
select
CONSTITUENCYCODE.ID as VALUE,
CONSTITUENCYCODE.DESCRIPTION as LABEL
from
dbo.CONSTITUENCYCODE
where
(CONSTITUENCYCODE.ACTIVE = 1 or @INCLUDEINACTIVE = 1)
union all
select
CONSTITUENCYDEFINITION.ID as VALUE,
CONSTITUENCYDEFINITION.DESCRIPTION as LABEL
from
dbo.CONSTITUENCYDEFINITION
where
(CONSTITUENCYDEFINITION.ISACTIVE = 1 or @INCLUDEINACTIVE = 1)
and
(
(
@CONSTITUENTTYPE is null
and
CONSTITUENCYDEFINITION.ID in (
'F828E957-5F5E-479A-8F23-2FFD6C7C68FF',
'6093915E-ADE9-42BE-88AE-304731754467',
'D2DCA06A-BE6E-40B3-B95D-59A926181923',
'00E748FB-940D-4A7D-A133-C148B29410A8',
'E7489703-3D63-4017-A2BC-88C092563C5D',
'AC9DB5A4-14E0-416A-9FB2-04038AC66799')
)
or
(
@CONSTITUENTTYPE in (0, 1) --Individual, Organization
and
CONSTITUENCYDEFINITION.ID in (
'F828E957-5F5E-479A-8F23-2FFD6C7C68FF',
'6093915E-ADE9-42BE-88AE-304731754467',
'D2DCA06A-BE6E-40B3-B95D-59A926181923',
'00E748FB-940D-4A7D-A133-C148B29410A8',
'E7489703-3D63-4017-A2BC-88C092563C5D')
)
or
(
@CONSTITUENTTYPE in (2) --Household
and
CONSTITUENCYDEFINITION.ID = '00E748FB-940D-4A7D-A133-C148B29410A8' --Major giving prospect
)
or
(
@CONSTITUENTTYPE in (3) --Group
and
CONSTITUENCYDEFINITION.ID in ('00E748FB-940D-4A7D-A133-C148B29410A8', --Major giving prospect
'AC9DB5A4-14E0-416A-9FB2-04038AC66799' --Committee
)
)
)
order by
LABEL