USP_DATAFORMTEMPLATE_VIEW_EDUATIONALINSTITUTIONPROFILE

The load procedure used by the view dataform template "Educational Institution Summary Profile View Form"

Parameters

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.
@ISCONSTITUENTPROFILE	bit	INOUT	ISCONSTITUENTPROFILE
@ISORGANIZATION	bit	INOUT	ISORGANIZATION
@ADDRESS	nvarchar(300)	INOUT	ADDRESS
@PHONENUMBER	nvarchar(100)	INOUT	PHONENUMBER
@PHONETYPE	nvarchar(100)	INOUT	PHONETYPE
@EMAILADDRESS	UDT_EMAILADDRESS	INOUT	EMAILADDRESS
@DONOTMAIL	bit	INOUT	DONOTMAIL
@DONOTEMAIL	bit	INOUT	DONOTEMAIL
@DONOTPHONE	bit	INOUT	DONOTPHONE
@WEBADDRESS	UDT_WEBADDRESS	INOUT	WEBADDRESS
@RELATEDCONSTITUENT	nvarchar(154)	INOUT	RELATEDCONSTITUENT
@RELATEDCONSTITUENTID	uniqueidentifier	INOUT	RELATEDCONSTITUENTID
@BOARDMEMBERCONSTITUENCYTEXT	nvarchar(100)	INOUT	BOARDMEMBERCONSTITUENCYTEXT
@RELATIONCONSTITUENCYTEXT	nvarchar(100)	INOUT	RELATIONCONSTITUENCYTEXT
@STAFFCONSTITUENCYTEXT	nvarchar(100)	INOUT	STAFFCONSTITUENCYTEXT
@DONORCONSTITUENCYTEXT	nvarchar(100)	INOUT	DONORCONSTITUENCYTEXT
@FUNDRAISERCONSTITUENCYTEXT	nvarchar(100)	INOUT	FUNDRAISERCONSTITUENCYTEXT
@PROSPECTCONSTITUENCYTEXT	nvarchar(100)	INOUT	PROSPECTCONSTITUENCYTEXT
@VOLUNTEERCONSTITUENCYTEXT	nvarchar(100)	INOUT	VOLUNTEERCONSTITUENCYTEXT
@COMMUNITYMEMBERCONSTITUENCYTEXT	nvarchar(16)	INOUT	COMMUNITYMEMBERCONSTITUENCYTEXT
@USERDEFINEDCONSTITUENCYTEXT	nvarchar(4000)	INOUT	USERDEFINEDCONSTITUENCYTEXT
@ALUMNUSSTATUSTEXT	nvarchar(14)	INOUT	ALUMNUSSTATUSTEXT
@REGISTRANTSTATUSTEXT	nvarchar(16)	INOUT	REGISTRANTSTATUSTEXT
@VENDORSTATUSTEXT	nvarchar(6)	INOUT	VENDORSTATUSTEXT
@ISINACTIVE	bit	INOUT	ISINACTIVE
@DECEASEDDATE	UDT_FUZZYDATE	INOUT	DECEASEDDATE
@PICTURE	varbinary	INOUT	PICTURE
@PRIMARYEDUCATION	nvarchar(100)	INOUT	PRIMARYEDUCATION
@PRIMARYBUSINESS	nvarchar(100)	INOUT	PRIMARYBUSINESS
@PRIMARYBUSINESSID	uniqueidentifier	INOUT	PRIMARYBUSINESSID
@LOOKUPID	nvarchar(100)	INOUT	Lookup ID
@WEALTHPOINTUPDATEPENDING	bit	INOUT	WEALTHPOINTUPDATEPENDING
@PRIMARYEDUCATIONID	uniqueidentifier	INOUT	PRIMARYEDUCATIONID
@EDUCATIONATTRIBUTEDEFINED	bit	INOUT	EDUCATIONATTRIBUTEDEFINED
@MATCHFINDERCONSTITUENCYTEXT	nvarchar(30)	INOUT	MATCHFINDERCONSTITUENCYTEXT
@MATCHFINDERONLINERECORDID	int	INOUT	MATCHFINDERONLINERECORDID
@SOLICITCODECOUNT	int	INOUT	SOLICITCODECOUNT
@HOUSEHOLDTEXT	nvarchar(154)	INOUT	HOUSEHOLDTEXT
@HOUSEHOLDID	uniqueidentifier	INOUT	HOUSEHOLDID
@ISGROUP	bit	INOUT	ISGROUP
@GROUPTYPE	nvarchar(300)	INOUT	Group type
@GROUPMEMBERCOUNT	int	INOUT	No. of members
@ISHOUSEHOLD	bit	INOUT	Is Household
@GIVESANONYMOUSLY	bit	INOUT	Gives anonymously
@MEMBERCONSTITUENCYTEXT	nvarchar(10)	INOUT	MEMBERCONSTITUENCYTEXT
@RECOGNITIONCONSTITUENCYTEXT	nvarchar(16)	INOUT	RECOGNITIONCONSTITUENCYTEXT
@STUDENTCONSTITUENCYTEXT	nvarchar(16)	INOUT	STUDENTCONSTITUENCYTEXT
@FACULTYCONSTITUENCYTEXT	nvarchar(16)	INOUT	FACULTYCONSTITUENCYTEXT
@SCHOOLCONSTITUENCYTEXT	nvarchar(16)	INOUT	SCHOOLCONSTITUENCYTEXT

Definition

Copy



        CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_EDUATIONALINSTITUTIONPROFILE
        (
            @ID uniqueidentifier,
            @CURRENTAPPUSERID uniqueidentifier=null,
            @DATALOADED bit = 0 output,
            @ISCONSTITUENTPROFILE bit = null output,
            @ISORGANIZATION bit = null output,
            @ADDRESS nvarchar(300) = null output,
            @PHONENUMBER nvarchar(100) = null output,
            @PHONETYPE nvarchar(100) = null output,
            @EMAILADDRESS dbo.UDT_EMAILADDRESS = null output,
            @DONOTMAIL bit = null output,
            @DONOTEMAIL bit = null output,
            @DONOTPHONE bit = null output,
            @WEBADDRESS dbo.UDT_WEBADDRESS = null output,
            @RELATEDCONSTITUENT nvarchar(154) = null output,
            @RELATEDCONSTITUENTID uniqueidentifier = null output,
            @BOARDMEMBERCONSTITUENCYTEXT nvarchar(100) = null output,
            @RELATIONCONSTITUENCYTEXT nvarchar(100) = null output,
            @STAFFCONSTITUENCYTEXT nvarchar(100) = null output,
            @DONORCONSTITUENCYTEXT nvarchar(100) = null output,
            @FUNDRAISERCONSTITUENCYTEXT nvarchar(100) = null output,
            @PROSPECTCONSTITUENCYTEXT nvarchar(100) = null output,
            @VOLUNTEERCONSTITUENCYTEXT nvarchar(100) = null output,
            @COMMUNITYMEMBERCONSTITUENCYTEXT nvarchar(16) = null output,
            @USERDEFINEDCONSTITUENCYTEXT nvarchar(4000) = null output,
            @ALUMNUSSTATUSTEXT nvarchar(14) = null output,
            @REGISTRANTSTATUSTEXT nvarchar(16) = null output,
            @VENDORSTATUSTEXT nvarchar(6) = null output,
            @ISINACTIVE bit = null output,
            @DECEASEDDATE dbo.UDT_FUZZYDATE = null output,
            @PICTURE varbinary(max) = null output,
            @PRIMARYEDUCATION nvarchar(100) = null output,
            @PRIMARYBUSINESS nvarchar(100) = null output,
            @PRIMARYBUSINESSID uniqueidentifier = null output,
            @LOOKUPID nvarchar(100) = null output,
            @WEALTHPOINTUPDATEPENDING bit = null output,
            @PRIMARYEDUCATIONID uniqueidentifier = null output,
            @EDUCATIONATTRIBUTEDEFINED bit = null output,
            @MATCHFINDERCONSTITUENCYTEXT nvarchar(30) = null output,
            @MATCHFINDERONLINERECORDID int = null output,
            @SOLICITCODECOUNT int = null output,
            @HOUSEHOLDTEXT nvarchar(154) = null output,
            @HOUSEHOLDID uniqueidentifier = null output,
            @ISGROUP bit = null output,
            @GROUPTYPE nvarchar(300) = null output,
            @GROUPMEMBERCOUNT integer = null output,
            @ISHOUSEHOLD bit = null output,
            @GIVESANONYMOUSLY bit = null output,
            @MEMBERCONSTITUENCYTEXT nvarchar(10) = null output,
            @RECOGNITIONCONSTITUENCYTEXT nvarchar(16) = null output,
            @STUDENTCONSTITUENCYTEXT nvarchar(16) = null output,
            @FACULTYCONSTITUENCYTEXT nvarchar(16) = null output,
            @SCHOOLCONSTITUENCYTEXT nvarchar(16) = null output
        )
        as
            set nocount on;

            -- be sure to set this, in case the select returns no rows

            set @DATALOADED = 0;

            --Load the generic constituent data

            exec USP_DATAFORMTEMPLATE_VIEW_INDIVIDUALPROFILE @ID, @CURRENTAPPUSERID, @DATALOADED output, @ISCONSTITUENTPROFILE output, @ISORGANIZATION output, @ADDRESS output, @PHONENUMBER output, @PHONETYPE output, @EMAILADDRESS output, @DONOTMAIL output, @DONOTEMAIL output, @DONOTPHONE output, @WEBADDRESS output, @RELATEDCONSTITUENT output, @RELATEDCONSTITUENTID output, @BOARDMEMBERCONSTITUENCYTEXT output, @RELATIONCONSTITUENCYTEXT output, @STAFFCONSTITUENCYTEXT output, @DONORCONSTITUENCYTEXT output, @FUNDRAISERCONSTITUENCYTEXT output, @PROSPECTCONSTITUENCYTEXT output, @VOLUNTEERCONSTITUENCYTEXT output, @COMMUNITYMEMBERCONSTITUENCYTEXT output, @USERDEFINEDCONSTITUENCYTEXT output, @ALUMNUSSTATUSTEXT output, @REGISTRANTSTATUSTEXT output, @VENDORSTATUSTEXT output, @ISINACTIVE output, @DECEASEDDATE output, @PICTURE output, @PRIMARYEDUCATION output, @PRIMARYBUSINESS output, @PRIMARYBUSINESSID output, @LOOKUPID output, @WEALTHPOINTUPDATEPENDING output, @PRIMARYEDUCATIONID output, @EDUCATIONATTRIBUTEDEFINED output, @MATCHFINDERCONSTITUENCYTEXT output, @MATCHFINDERONLINERECORDID output, @SOLICITCODECOUNT output, @HOUSEHOLDTEXT output, @HOUSEHOLDID output, @ISGROUP output, @GROUPTYPE output, @GROUPMEMBERCOUNT output, @ISHOUSEHOLD output, @GIVESANONYMOUSLY output, @MEMBERCONSTITUENCYTEXT output, @RECOGNITIONCONSTITUENCYTEXT output, @STUDENTCONSTITUENCYTEXT output, @FACULTYCONSTITUENCYTEXT output, @SCHOOLCONSTITUENCYTEXT output;

            return 0;