USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTSHAREDVIEWASPAGEDATA

The load procedure used by the view dataform template "Constituent Shared View as Page Expression View Form"

Parameters

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTSHAREDVIEWASPAGEDATA
                (
                    @ID uniqueidentifier,
                    @CURRENTAPPUSERID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @VIEWAS_BOARDMEMBERCONSTITUENCYTEXT nvarchar(100) = null output,
                    @VIEWAS_RELATIONCONSTITUENCYTEXT nvarchar(100) = null output,
                    @VIEWAS_STAFFCONSTITUENCYTEXT nvarchar(100) = null output,
                    @VIEWAS_DONORCONSTITUENCYTEXT nvarchar(100) = null output,
                    @VIEWAS_FUNDRAISERCONSTITUENCYTEXT nvarchar(100) = null output,
                    @VIEWAS_PROSPECTCONSTITUENCYTEXT nvarchar(100) = null output,
                    @VIEWAS_VOLUNTEERCONSTITUENCYTEXT nvarchar(100) = null output,
                    @VIEWAS_COMMUNITYMEMBERCONSTITUENCYTEXT nvarchar(100) = null output,
                    @VIEWAS_MATCHFINDERCONSTITUENCYTEXT nvarchar(100) = null output,
                    @VIEWAS_MEMBERCONSTITUENCYTEXT nvarchar(100) = null output,
                    @VIEWAS_RECOGNITIONCONSTITUENCYTEXT nvarchar(100) = null output,
                    @VIEWAS_PLANNEDGIVERCONSTITUENCYTEXT nvarchar(100)=null output,
                    @VIEWAS_BANKCONSTITUENCYTEXT nvarchar(100) = null output,
                    @VIEWAS_PATRONCONSTITUENCYTEXT nvarchar(100) = null output,
                    @VIEWAS_REGISTRANTCONSTITUENCYTEXT nvarchar(100) = null output,
                    @VIEWAS_VENDORCONSTITUENCYTEXT nvarchar(100) = null output,
                    @VIEWAS_COMMITTEECONSTITUENCYTEXT nvarchar(100) = null output,
                    @VIEWAS_GRANTORCONSTITUENCYTEXT nvarchar(100) = null output,
                    @VIEWAS_SPONSORCONSTITUENCYTEXT nvarchar(100) = null output,
                    @VIEWAS_COMMITTEEMEMBERCONSTITUENCYTEXT nvarchar(100) = null output,
                    @VIEWAS_STUDENTALUMNUSCONSTITUENCYTEXT nvarchar(100) = null output,
                    @VIEWAS_FACULTYCONSTITUENCYTEXT nvarchar(100) = null output,
                    @VIEWAS_LOYALDONORCONSTITUENCYTEXT nvarchar(100) = null output,
                    @VIEWAS_MAJORDONORCONSTITUENCYTEXT nvarchar(100) = null output,
                    @VIEWAS_ADVOCATECONSTITUENCYTEXT nvarchar(100) = null output,
                    @VIEWAS_NFGCONSTITUENCYTEXT nvarchar(100) = null output,
                    @VIEWAS_FUNDRAISINGGROUPCONSTITUENCYTEXT nvarchar(100) = null output
                )
                as
                  set nocount on;

                  declare @SPONSORTYPECODE tinyint = dbo.UFN_CONSTITUENT_SPONSORTYPECODE(@ID);

                  if @SPONSORTYPECODE = 99
                    set @SPONSORTYPECODE = case when dbo.UFN_CONSTITUENT_ISFORMERSPONSOR(@ID) = 1 then 0 else 99 end;

                  select
                      @DATALOADED = 1,
                      @VIEWAS_PLANNEDGIVERCONSTITUENCYTEXT = dbo.UFN_CONSTITUENCY_GETDESCRIPTION('CEE46FE7-3FBB-4DFE-97EB-BA67DD33C634'),
                      @VIEWAS_RECOGNITIONCONSTITUENCYTEXT = dbo.UFN_CONSTITUENCY_GETDESCRIPTION('3dfac92e-78bd-4051-abdc-02c675deb8f6'),
                      @VIEWAS_STUDENTALUMNUSCONSTITUENCYTEXT = 
                              case when dbo.UFN_CONSTITUENT_ISALUMNUS(@ID) = 1 then dbo.UFN_CONSTITUENCY_GETDESCRIPTION('46EC3424-BA54-4431-A7DC-C6CEBB3B4592')
                              else dbo.UFN_CONSTITUENCY_GETDESCRIPTION('4DB8F4FC-BC43-421D-B592-69BEF109B5FC') end,
                      @VIEWAS_FACULTYCONSTITUENCYTEXT = dbo.UFN_CONSTITUENCY_GETDESCRIPTION('08D55D6A-10C8-4a72-92A0-EF87033AD7B6'),
                      @VIEWAS_MEMBERCONSTITUENCYTEXT = dbo.UFN_CONSTITUENCY_GETDESCRIPTION('2d11326e-8f3b-4322-9797-57c1aacfa5df'),
                      @VIEWAS_BOARDMEMBERCONSTITUENCYTEXT = dbo.UFN_CONSTITUENCY_GETDESCRIPTION('F828E957-5F5E-479A-8F23-2FFD6C7C68FF'),
                      @VIEWAS_STAFFCONSTITUENCYTEXT = dbo.UFN_CONSTITUENCY_GETDESCRIPTION('6093915E-ADE9-42BE-88AE-304731754467'),
                      @VIEWAS_SPONSORCONSTITUENCYTEXT = 
                              case @SPONSORTYPECODE
                               when 0 then dbo.UFN_CONSTITUENCY_GETDESCRIPTION('4D746A03-A0AB-45F3-A30B-1AD4F304E622') --Sponsor
                               when 1 then dbo.UFN_CONSTITUENCY_GETDESCRIPTION('F89E03BC-E724-4e5d-943B-72D4D1E1E916') --Sponsorship recipient
                               when 2 then dbo.UFN_CONSTITUENCY_GETDESCRIPTION('908E521C-B0A5-4832-B664-7D7B079D77C2') --Sponsorship donor
                              else null end,
                      @VIEWAS_DONORCONSTITUENCYTEXT = dbo.UFN_CONSTITUENCY_GETDESCRIPTION('70165682-4324-46EC-9439-83FC0CC67E7F'),
                      @VIEWAS_LOYALDONORCONSTITUENCYTEXT = dbo.UFN_CONSTITUENCY_GETDESCRIPTION('E5A0EA42-65BA-4B25-AFE2-9B709F99E72B'),
                      @VIEWAS_MAJORDONORCONSTITUENCYTEXT = dbo.UFN_CONSTITUENCY_GETDESCRIPTION('1A9BFE80-604D-4B5B-8065-E751DDF6EF39'),
                      @VIEWAS_FUNDRAISERCONSTITUENCYTEXT = dbo.UFN_CONSTITUENCY_GETDESCRIPTION('D2DCA06A-BE6E-40B3-B95D-59A926181923'),
                      @VIEWAS_PROSPECTCONSTITUENCYTEXT = dbo.UFN_CONSTITUENCY_GETDESCRIPTION('00E748FB-940D-4A7D-A133-C148B29410A8'),
                      @VIEWAS_VOLUNTEERCONSTITUENCYTEXT = dbo.UFN_CONSTITUENCY_GETDESCRIPTION('E7489703-3D63-4017-A2BC-88C092563C5D'),
                      @VIEWAS_COMMUNITYMEMBERCONSTITUENCYTEXT = dbo.UFN_CONSTITUENCY_GETDESCRIPTION('55FE8E7C-2B68-44C8-B35C-818AD1944C03'),
                      @VIEWAS_PATRONCONSTITUENCYTEXT = dbo.UFN_CONSTITUENCY_GETDESCRIPTION('A843B859-4C6B-445B-97F3-179582E270A5'),
                      @VIEWAS_REGISTRANTCONSTITUENCYTEXT = dbo.UFN_CONSTITUENCY_GETDESCRIPTION('C49D4B46-72A7-4206-91AA-BEABA2323E3C'),
                      @VIEWAS_VENDORCONSTITUENCYTEXT = dbo.UFN_CONSTITUENCY_GETDESCRIPTION('5435C96D-8617-46C3-9A62-5AFF08451A53'),
                      @VIEWAS_MATCHFINDERCONSTITUENCYTEXT = dbo.UFN_CONSTITUENCY_GETDESCRIPTION('2D04A9C5-27D0-4646-BF0F-6826E4C12632'),
                      @VIEWAS_COMMITTEECONSTITUENCYTEXT = dbo.UFN_CONSTITUENCY_GETDESCRIPTION('AC9DB5A4-14E0-416A-9FB2-04038AC66799'),
                      @VIEWAS_GRANTORCONSTITUENCYTEXT = dbo.UFN_CONSTITUENCY_GETDESCRIPTION('D9982C99-15C1-4C90-873E-56FD4B164056'),
                      @VIEWAS_COMMITTEEMEMBERCONSTITUENCYTEXT = dbo.UFN_CONSTITUENCY_GETDESCRIPTION('093A3D4F-2974-447F-AD92-870EB4A04593'),
                      @VIEWAS_BANKCONSTITUENCYTEXT = dbo.UFN_CONSTITUENCY_GETDESCRIPTION('171AB3CD-C4E1-4825-B693-10F524A7A594'),
                      @VIEWAS_ADVOCATECONSTITUENCYTEXT = dbo.UFN_CONSTITUENCY_GETDESCRIPTION('F828E957-5F5E-479A-8F23-2FFD6C7C6899'),
                      @VIEWAS_NFGCONSTITUENCYTEXT = dbo.UFN_CONSTITUENCY_GETDESCRIPTION('A499228A-7619-40DF-AE75-BBA1EE20FB4E'),
                      @VIEWAS_FUNDRAISINGGROUPCONSTITUENCYTEXT = dbo.UFN_CONSTITUENCY_GETDESCRIPTION('264818E9-3F59-44C1-9BBF-1BB1F9C78CA5')

              return 0;

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@VIEWAS_BOARDMEMBERCONSTITUENCYTEXT	nvarchar(100)	INOUT	VIEWAS_BOARDMEMBERCONSTITUENCYTEXT
@VIEWAS_RELATIONCONSTITUENCYTEXT	nvarchar(100)	INOUT	VIEWAS_RELATIONCONSTITUENCYTEXT
@VIEWAS_STAFFCONSTITUENCYTEXT	nvarchar(100)	INOUT	VIEWAS_STAFFCONSTITUENCYTEXT
@VIEWAS_DONORCONSTITUENCYTEXT	nvarchar(100)	INOUT	VIEWAS_DONORCONSTITUENCYTEXT
@VIEWAS_FUNDRAISERCONSTITUENCYTEXT	nvarchar(100)	INOUT	VIEWAS_FUNDRAISERCONSTITUENCYTEXT
@VIEWAS_PROSPECTCONSTITUENCYTEXT	nvarchar(100)	INOUT	VIEWAS_PROSPECTCONSTITUENCYTEXT
@VIEWAS_VOLUNTEERCONSTITUENCYTEXT	nvarchar(100)	INOUT	VIEWAS_VOLUNTEERCONSTITUENCYTEXT
@VIEWAS_COMMUNITYMEMBERCONSTITUENCYTEXT	nvarchar(100)	INOUT	VIEWAS_COMMUNITYMEMBERCONSTITUENCYTEXT
@VIEWAS_MATCHFINDERCONSTITUENCYTEXT	nvarchar(100)	INOUT	VIEWAS_MATCHFINDERCONSTITUENCYTEXT
@VIEWAS_MEMBERCONSTITUENCYTEXT	nvarchar(100)	INOUT	VIEWAS_MEMBERCONSTITUENCYTEXT
@VIEWAS_RECOGNITIONCONSTITUENCYTEXT	nvarchar(100)	INOUT	VIEWAS_RECOGNITIONCONSTITUENCYTEXT
@VIEWAS_PLANNEDGIVERCONSTITUENCYTEXT	nvarchar(100)	INOUT	VIEWAS_PLANNEDGIVERCONSTITUENCYTEXT
@VIEWAS_BANKCONSTITUENCYTEXT	nvarchar(100)	INOUT	VIEWAS_BANKCONSTITUENCYTEXT
@VIEWAS_PATRONCONSTITUENCYTEXT	nvarchar(100)	INOUT	VIEWAS_PATRONCONSTITUENCYTEXT
@VIEWAS_REGISTRANTCONSTITUENCYTEXT	nvarchar(100)	INOUT	VIEWAS_REGISTRANTCONSTITUENCYTEXT
@VIEWAS_VENDORCONSTITUENCYTEXT	nvarchar(100)	INOUT	VIEWAS_VENDORCONSTITUENCYTEXT
@VIEWAS_COMMITTEECONSTITUENCYTEXT	nvarchar(100)	INOUT	VIEWAS_COMMITTEECONSTITUENCYTEXT
@VIEWAS_GRANTORCONSTITUENCYTEXT	nvarchar(100)	INOUT	VIEWAS_GRANTORCONSTITUENCYTEXT
@VIEWAS_SPONSORCONSTITUENCYTEXT	nvarchar(100)	INOUT	VIEWAS_SPONSORCONSTITUENCYTEXT
@VIEWAS_COMMITTEEMEMBERCONSTITUENCYTEXT	nvarchar(100)	INOUT	VIEWAS_COMMITTEEMEMBERCONSTITUENCYTEXT
@VIEWAS_STUDENTALUMNUSCONSTITUENCYTEXT	nvarchar(100)	INOUT	VIEWAS_STUDENTALUMNUSCONSTITUENCYTEXT
@VIEWAS_FACULTYCONSTITUENCYTEXT	nvarchar(100)	INOUT	VIEWAS_FACULTYCONSTITUENCYTEXT
@VIEWAS_LOYALDONORCONSTITUENCYTEXT	nvarchar(100)	INOUT	VIEWAS_LOYALDONORCONSTITUENCYTEXT
@VIEWAS_MAJORDONORCONSTITUENCYTEXT	nvarchar(100)	INOUT	VIEWAS_MAJORDONORCONSTITUENCYTEXT
@VIEWAS_ADVOCATECONSTITUENCYTEXT	nvarchar(100)	INOUT	VIEWAS_ADVOCATECONSTITUENCYTEXT
@VIEWAS_NFGCONSTITUENCYTEXT	nvarchar(100)	INOUT
@VIEWAS_FUNDRAISINGGROUPCONSTITUENCYTEXT	nvarchar(100)	INOUT