USP_PROSPECTRESEARCHTEMPLATESECTION_SECTIONCODE_GETLIST
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 10/23/2017 7:38:51 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.173.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE PROCEDURE dbo.USP_PROSPECTRESEARCHTEMPLATESECTION_SECTIONCODE_GETLIST
AS
select 1 'ID', 'Prospect overview' 'DESCRIPTION'
union
select 2 'ID', 'Research summary' 'DESCRIPTION'
union
select 3 'ID', 'Additional prospect details' 'DESCRIPTION'
union
select 4 'ID', 'Spouse details' 'DESCRIPTION'
union
select 5 'ID', 'Giving summary' 'DESCRIPTION'
union
select 6 'ID', 'Model scores and ratings' 'DESCRIPTION'
union
select 7 'ID', 'Wealth point summary' 'DESCRIPTION'
union
select 8 'ID', 'Philanthropic sapacity' 'DESCRIPTION'
union
select 9 'ID', 'Constituencies' 'DESCRIPTION'
union
select 10 'ID', 'Interests' 'DESCRIPTION'
union
select 11 'ID', 'Constituent attributes' 'DESCRIPTION'
union
select 12 'ID', 'Educational history' 'DESCRIPTION'
union
select 13 'ID', 'Philanthropic gifts (collapsed)' 'DESCRIPTION'
union
select 14 'ID', 'Whos Who biographical summary' 'DESCRIPTION'
union
select 15 'ID', 'Whos Who biographical details' 'DESCRIPTION'
union
select 16 'ID', 'Real estate' 'DESCRIPTION'
union
select 17 'ID', 'Business ownership' 'DESCRIPTION'
union
select 18 'ID', 'Securities' 'DESCRIPTION'
union
select 19 'ID', 'Income' 'DESCRIPTION'
union
select 20 'ID', 'Affluence indicators' 'DESCRIPTION'
union
select 21 'ID', 'Nonprofit affiliations' 'DESCRIPTION'
union
select 22 'ID', 'Private foundations' 'DESCRIPTION'
union
select 23 'ID', 'Political donations' 'DESCRIPTION'
union
select 24 'ID', 'Other assets' 'DESCRIPTION'
union
select 25 'ID', 'Relationships' 'DESCRIPTION'
union
select 26 'ID', 'Extended network' 'DESCRIPTION'
union
select 27 'ID', 'Notes' 'DESCRIPTION'
union
select 28 'ID', 'Contact Information' 'DESCRIPTION'
union
select 29 'ID', 'Giving Summary Chart' 'DESCRIPTION'
union
select 30 'ID', 'Asset Distribution Chart' 'DESCRIPTION'
union
select 31 'ID', 'Philanthropic gifts (expanded)' 'DESCRIPTION'