USP_SIMPLEDATALIST_COMBINATIONCONSTITUENCY

CREATE procedure dbo.USP_SIMPLEDATALIST_COMBINATIONCONSTITUENCY
as
    set nocount on;

    select
        CONSTITUENCYDEFINITION.ID as VALUE,
        CONSTITUENCYDEFINITION.DESCRIPTION as LABEL
    from dbo.CONSTITUENCYDEFINITION
    where
        CONSTITUENCYDEFINITION.ISACTIVE = 1
        and (
            CONSTITUENCYDEFINITION.ISSYSTEM = 0
            or CONSTITUENCYDEFINITION.SYSTEMDESCRIPTION in (
                'Board member',
                'Donor',
                'Event registrant',
                'Fundraiser',
                'Major giving prospect',
                'Member',
                'Patron',
                'Recognized donor',
                'Staff',
                'Volunteer',
                'Student',
                'Alumnus',
                'Planned giver'
            )
        )
    order by LABEL