USP_ITINERARYITEM_INVALIDREASONCODE_GETLIST
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 1/27/2010 6:48:26 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.5.465.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE PROCEDURE dbo.USP_ITINERARYITEM_INVALIDREASONCODE_GETLIST
AS
select 0 'ID', 'Not invalid' 'DESCRIPTION'
union
select 1 'ID', 'Event or program is inactive' 'DESCRIPTION'
union
select 2 'ID', 'Event does not have the capacity for this itinerary' 'DESCRIPTION'
union
select 3 'ID', 'Event is blocked by another itinerary' 'DESCRIPTION'
union
select 4 'ID', 'Event is missing a price type needed by this itinerary' 'DESCRIPTION'
union
select 5 'ID', 'Event not scheduled on this date and time' 'DESCRIPTION'
union
select 6 'ID', 'Daily admission program is inactive' 'DESCRIPTION'
union
select 8 'ID', 'Event is not on sale' 'DESCRIPTION'
union
select 9 'ID', 'Daily admission program is not on sale' 'DESCRIPTION'
union
select 10 'ID', 'Creates resource or location conflict with other event or itinerary item' 'DESCRIPTION'
union
select 11 'ID', 'Daily admission program is missing a price type needed by this itinerary' 'DESCRIPTION'