V_CONSTITUENCYDISPLAYORDER

This view returns all system and user-defined constituencies with their display name and sequence.
Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		ID
SYSTEMDESCRIPTION	nvarchar(100)		SYSTEMDESCRIPTION
DESCRIPTION	nvarchar(100)		DESCRIPTION
SEQUENCE	int	yes	SEQUENCE
ISSYSTEM	bit		ISSYSTEM
ISACTIVE	bit
Definition

Copy
/*
Generated by Blackbaud AppFx Platform
Date:  1/21/2016 5:06:32 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.154.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_CONSTITUENCYDISPLAYORDER AS



    select
        CONSTITUENCYDEFINITION.ID,
        CONSTITUENCYDEFINITION.SYSTEMDESCRIPTION,
        CONSTITUENCYDEFINITION.DESCRIPTION,
        coalesce(CONSTITUENCYDISPLAYORDER.SEQUENCE, 999) SEQUENCE,
        CONSTITUENCYDEFINITION.ISSYSTEM,
        CONSTITUENCYDEFINITION.ISACTIVE
    from
        dbo.CONSTITUENCYDEFINITION
        left join dbo.CONSTITUENCYDISPLAYORDER on CONSTITUENCYDISPLAYORDER.CONSTITUENCYCODEID = CONSTITUENCYDEFINITION.ID
    where
        CONSTITUENCYDEFINITION.ID <> '97641C45-04E1-4903-9A67-FEA42BDF7357' --Exclude Payables vendor temporarily

        and CONSTITUENCYDEFINITION.ID <> '55FE8E7C-2B68-44C8-B35C-818AD1944C03' -- Exclude 'Community member' constituency; no longer surfaced

        and NOT (CONSTITUENCYDEFINITION.ID = 'F828E957-5F5E-479A-8F23-2FFD6C7C6899' AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('4560756A-E63C-4804-82F0-9D7D0AB36997') = 0) --Advocate

        -- Allow the School constituency if either BasicEducation and DevelopmentEducationHistory are installed

        and NOT (CONSTITUENCYDEFINITION.ID = '4DB8F4FC-BC43-421D-B592-69BEF109B5FC' AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('F5AC53C4-D0CE-4E20-BCA6-AACDFC01B302') = 0 AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('B627E1AF-66E1-45c6-82F9-0C56D379B1E2') = 0) --Student

        and NOT (CONSTITUENCYDEFINITION.ID = '08D55D6A-10C8-4A72-92A0-EF87033AD7B6' AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('F5AC53C4-D0CE-4E20-BCA6-AACDFC01B302') = 0) --Faculty

        and NOT (CONSTITUENCYDEFINITION.ID = '97688220-0AFA-4354-A327-590D715961D7' AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('F5AC53C4-D0CE-4E20-BCA6-AACDFC01B302') = 0) --School


        and NOT (CONSTITUENCYDEFINITION.ID = 'D9982C99-15C1-4C90-873E-56FD4B164056' AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('3117d2c8-7f46-42f2-abeb-b654f2f63046') = 0 AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('6f77d512-d0d1-444f-9b46-b8603a6fe5f1') = 0) --Grantor

        and NOT (CONSTITUENCYDEFINITION.ID = 'CEE46FE7-3FBB-4DFE-97EB-BA67DD33C634' AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('3117d2c8-7f46-42f2-abeb-b654f2f63046') = 0 AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('6f77d512-d0d1-444f-9b46-b8603a6fe5f1') = 0) --Planned giver


        and NOT (CONSTITUENCYDEFINITION.ID = '46EC3424-BA54-4431-A7DC-C6CEBB3B4592' AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('3117D2C8-7F46-42F2-ABEB-B654F2F63046') = 0) --Alumnus


        and NOT (CONSTITUENCYDEFINITION.ID = '4D746A03-A0AB-45F3-A30B-1AD4F304E622' AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('3117D2C8-7F46-42F2-ABEB-B654F2F63046') = 0) --Sponsor

        and NOT (CONSTITUENCYDEFINITION.ID = '908E521C-B0A5-4832-B664-7D7B079D77C2' AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('3117D2C8-7F46-42F2-ABEB-B654F2F63046') = 0) --Sponsorship donor

        and NOT (CONSTITUENCYDEFINITION.ID = 'F89E03BC-E724-4E5D-943B-72D4D1E1E916' AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('3117D2C8-7F46-42F2-ABEB-B654F2F63046') = 0) --Sponsorship recipient


        and NOT (CONSTITUENCYDEFINITION.ID = '264818E9-3F59-44C1-9BBF-1BB1F9C78CA5' AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('a919502c-a2f6-4a56-9183-28e3f667916e') = 0) --Fundraising group

        and NOT (CONSTITUENCYDEFINITION.ID = 'A499228A-7619-40DF-AE75-BBA1EE20FB4E' AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('D418D0F9-8C9C-4D52-8972-09C4B6B1E0A1') = 0) --National fundraising group


        and NOT (CONSTITUENCYDEFINITION.ID = '2D11326E-8F3B-4322-9797-57C1AACFA5DF' AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('5E696818-62EE-4C90-8C28-B1F52D77176E') = 0) --Member

        and NOT (CONSTITUENCYDEFINITION.ID = '171AB3CD-C4E1-4825-B693-10F524A7A594' AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('0e85c527-e6e9-4c5f-a8e8-105fd0e18fe7') = 0 AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('F5138EB6-6666-497a-8FB2-BAE24389AAE4') = 0) --Bank

        and NOT (CONSTITUENCYDEFINITION.ID = '70165682-4324-46EC-9439-83FC0CC67E7F' AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('3117d2c8-7f46-42f2-abeb-b654f2f63046') = 0 AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('42c15648-749e-4859-a56d-3a6474814cc7') = 0) --Donor

        and NOT (CONSTITUENCYDEFINITION.ID = 'C49D4B46-72A7-4206-91AA-BEABA2323E3C' AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('3117d2c8-7f46-42f2-abeb-b654f2f63046') = 0 AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('42c15648-749e-4859-a56d-3a6474814cc7') = 0) --Event registrant

        and NOT (CONSTITUENCYDEFINITION.ID = '5435C96D-8617-46C3-9A62-5AFF08451A53' AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('3117d2c8-7f46-42f2-abeb-b654f2f63046') = 0 AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('42c15648-749e-4859-a56d-3a6474814cc7') = 0) --Vendor

        and NOT (CONSTITUENCYDEFINITION.ID = '2D04A9C5-27D0-4646-BF0F-6826E4C12632' AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('3117d2c8-7f46-42f2-abeb-b654f2f63046') = 0 AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('42c15648-749e-4859-a56d-3a6474814cc7') = 0) --Matching gift organization

        and NOT (CONSTITUENCYDEFINITION.ID = '3DFAC92E-78BD-4051-ABDC-02C675DEB8F6' AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('3117d2c8-7f46-42f2-abeb-b654f2f63046') = 0 AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('42c15648-749e-4859-a56d-3a6474814cc7') = 0) --Recognized Donor

        and NOT (CONSTITUENCYDEFINITION.ID = 'A843B859-4C6B-445B-97F3-179582E270A5' AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('3117d2c8-7f46-42f2-abeb-b654f2f63046') = 0 AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('42c15648-749e-4859-a56d-3a6474814cc7') = 0) --Patron

        and NOT (CONSTITUENCYDEFINITION.ID = 'AC9DB5A4-14E0-416A-9FB2-04038AC66799' AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('3117d2c8-7f46-42f2-abeb-b654f2f63046') = 0 AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('42c15648-749e-4859-a56d-3a6474814cc7') = 0) --Committee

        and NOT (CONSTITUENCYDEFINITION.ID = '093A3D4F-2974-447F-AD92-870EB4A04593' AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('3117d2c8-7f46-42f2-abeb-b654f2f63046') = 0 AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('42c15648-749e-4859-a56d-3a6474814cc7') = 0) --Committee Member

        and NOT (CONSTITUENCYDEFINITION.ID = '1A9BFE80-604D-4B5B-8065-E751DDF6EF39' AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('3117d2c8-7f46-42f2-abeb-b654f2f63046') = 0 AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('42c15648-749e-4859-a56d-3a6474814cc7') = 0) --Major Donor

        and NOT (CONSTITUENCYDEFINITION.ID = 'E5A0EA42-65BA-4B25-AFE2-9B709F99E72B' AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('3117d2c8-7f46-42f2-abeb-b654f2f63046') = 0 AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('42c15648-749e-4859-a56d-3a6474814cc7') = 0) --Loyal Donor

        and NOT (CONSTITUENCYDEFINITION.ID = 'CEE46FE7-3FBB-4DFE-97EB-BA67DD33C634' AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('3117d2c8-7f46-42f2-abeb-b654f2f63046') = 0 AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('0a07aa22-ed88-42b7-8c55-d80df4f4cea2') = 0) --Planned Giver

        and NOT (CONSTITUENCYDEFINITION.ID = 'D9982C99-15C1-4C90-873E-56FD4B164056' AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('3117d2c8-7f46-42f2-abeb-b654f2f63046') = 0 AND dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('9d9e2fee-e2e5-46d1-b087-25c538bf3334') = 0) --Grantor