USP_SIMPLEDATALIST_DISCOUNTCONSTITUENCY

CREATE procedure dbo.USP_SIMPLEDATALIST_DISCOUNTCONSTITUENCY
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',
                'Major donor',
                'Loyal donor'
                )
          )            
    order by 
        LABEL;

    return 0;