USP_FEPPROCESS_SUBSECTORCODE_GETLIST
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 4/29/2010 7:19:26 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.6.1444.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE PROCEDURE dbo.USP_FEPPROCESS_SUBSECTORCODE_GETLIST
AS
select 0 'ID', 'Arts, Culture and Humanities' 'DESCRIPTION'
union
select 1 'ID', 'Education' 'DESCRIPTION'
union
select 2 'ID', 'Environment' 'DESCRIPTION'
union
select 3 'ID', 'Animal-Related' 'DESCRIPTION'
union
select 4 'ID', 'Health Care' 'DESCRIPTION'
union
select 5 'ID', 'Mental Health and Crisis Intervention' 'DESCRIPTION'
union
select 6 'ID', 'Voluntary Health Associations and Medical Disciplines' 'DESCRIPTION'
union
select 7 'ID', 'Medical Research' 'DESCRIPTION'
union
select 8 'ID', 'Crime and Legal-Related' 'DESCRIPTION'
union
select 9 'ID', 'Employment' 'DESCRIPTION'
union
select 10 'ID', 'Food, Agriculture and Nutrition' 'DESCRIPTION'
union
select 11 'ID', 'Housing and Shelter' 'DESCRIPTION'
union
select 12 'ID', 'Public Safety, Disaster Preparedness and Relief' 'DESCRIPTION'
union
select 13 'ID', 'Recreation and Sports' 'DESCRIPTION'
union
select 14 'ID', 'Youth Development' 'DESCRIPTION'
union
select 15 'ID', 'Human Services' 'DESCRIPTION'
union
select 16 'ID', 'International, Foreign Affairs and National Security' 'DESCRIPTION'
union
select 17 'ID', 'Civil Rights, Social Action and Advocacy' 'DESCRIPTION'
union
select 18 'ID', 'Community Improvement and Capacity Building' 'DESCRIPTION'
union
select 19 'ID', 'Philanthropy, Voluntarism and Grantmaking Foundations' 'DESCRIPTION'
union
select 20 'ID', 'Science and Technology' 'DESCRIPTION'
union
select 21 'ID', 'Social Science' 'DESCRIPTION'
union
select 22 'ID', 'Public and Societal Benefit' 'DESCRIPTION'
union
select 23 'ID', 'Religion-Related' 'DESCRIPTION'
union
select 24 'ID', 'Mutual and Membership Benefit' 'DESCRIPTION'
union
select 25 'ID', 'Unknown (Other)' 'DESCRIPTION'