USP_DATAFORMTEMPLATE_VIEW_RECORDPROFILE

The load procedure used by the view dataform template "Record 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.
@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
@ISINACTIVE	bit	INOUT	ISINACTIVE
@DECEASEDDATE	UDT_FUZZYDATE	INOUT	DECEASEDDATE
@PICTURE	varbinary	INOUT	PICTURE
@LOOKUPID	nvarchar(100)	INOUT	Lookup ID
@ISSPOUSEDECEASED	bit	INOUT	Is spouse deceased
@ISDECEASED	bit	INOUT	ISDECEASED
@STUDENTCONSTITUENCYTEXT	nvarchar(100)	INOUT	STUDENTCONSTITUENCYTEXT
@PRIMARYEDUCATION	nvarchar(100)	INOUT	Primary education
@PRIMARYEDUCATIONID	uniqueidentifier	INOUT	PRIMARYEDUCATIONID
@CURRENTSCHOOL	nvarchar(100)	INOUT	School
@CURRENTENROLLMENTID	uniqueidentifier	INOUT	CURRENTENROLLMENTID
@CURRENTSCHOOL2	nvarchar(100)	INOUT	CURRENTSCHOOL2
@CURRENTENROLLMENTID2	uniqueidentifier	INOUT	CURRENTENROLLMENTID2
@CURRENTSCHOOL3	nvarchar(100)	INOUT	CURRENTSCHOOL3
@CURRENTENROLLMENTID3	uniqueidentifier	INOUT	CURRENTENROLLMENTID3
@PRIMARYBUSINESS	nvarchar(100)	INOUT	Primary business
@PRIMARYBUSINESSID	uniqueidentifier	INOUT	PRIMARYBUSINESSID
@PHONEISCONFIDENTIAL	bit	INOUT	PHONEISCONFIDENTIAL
@ADDRESSISCONFIDENTIAL	bit	INOUT	ADDRESSISCONFIDENTIAL
@ADDRESSID	uniqueidentifier	INOUT	ADDRESSID
@PHONENUMBERID	uniqueidentifier	INOUT	PHONENUMBERID
@EMAILADDRESSID	uniqueidentifier	INOUT	EMAILADDRESSID

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_RECORDPROFILE
(
    @ID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier = null,
    @DATALOADED bit = 0 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,
    @ISINACTIVE bit = null output,
    @DECEASEDDATE dbo.UDT_FUZZYDATE = null output,
    @PICTURE varbinary(max) = null output,
    @LOOKUPID nvarchar(100) = null output,
    @ISSPOUSEDECEASED bit = null output,
    @ISDECEASED bit = null output,
    @STUDENTCONSTITUENCYTEXT nvarchar(100) = null output,
    @PRIMARYEDUCATION nvarchar(100) = null output,
    @PRIMARYEDUCATIONID uniqueidentifier = null output,
    @CURRENTSCHOOL nvarchar(100) = null output,
    @CURRENTENROLLMENTID uniqueidentifier = null output,
    @CURRENTSCHOOL2 nvarchar(100) = null output,
    @CURRENTENROLLMENTID2 uniqueidentifier = null output,
    @CURRENTSCHOOL3 nvarchar(100) = null output,
    @CURRENTENROLLMENTID3 uniqueidentifier = null output,
    @PRIMARYBUSINESS nvarchar(100) = null output,
    @PRIMARYBUSINESSID uniqueidentifier = null output,
    @PHONEISCONFIDENTIAL bit = null output,
    @ADDRESSISCONFIDENTIAL bit = null output,
    @ADDRESSID uniqueidentifier = null output,
    @PHONENUMBERID uniqueidentifier = null output,
    @EMAILADDRESSID uniqueidentifier = null output

)
as
    set nocount on;

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

    set @DATALOADED = 0;

    exec dbo.USP_DATAFORMTEMPLATE_VIEW_INDIVIDUALPROFILE
        @ID,
        @CURRENTAPPUSERID = @CURRENTAPPUSERID,
        @DATALOADED = @DATALOADED output,
        @ISORGANIZATION = @ISORGANIZATION output,
        @ADDRESS = @ADDRESS output,
        @PHONENUMBER = @PHONENUMBER output,
        @PHONETYPE = @PHONETYPE output,
        @EMAILADDRESS = @EMAILADDRESS output,
        @DONOTMAIL = @DONOTMAIL output,
        @DONOTEMAIL = @DONOTEMAIL output,
        @DONOTPHONE = @DONOTPHONE output,
        @WEBADDRESS = @WEBADDRESS output,
        @RELATEDCONSTITUENT = @RELATEDCONSTITUENT output,
        @RELATEDCONSTITUENTID = @RELATEDCONSTITUENTID output,
        @ISINACTIVE = @ISINACTIVE output,
        @DECEASEDDATE = @DECEASEDDATE output,
        @PICTURE = @PICTURE output,
        @LOOKUPID = @LOOKUPID output,
        @ISSPOUSEDECEASED = @ISSPOUSEDECEASED output,
        @ISDECEASED = @ISDECEASED output,
        @STUDENTCONSTITUENCYTEXT = @STUDENTCONSTITUENCYTEXT output,
        @PRIMARYEDUCATION = @PRIMARYEDUCATION output,
        @PRIMARYEDUCATIONID = @PRIMARYEDUCATIONID output,
        @CURRENTSCHOOL = @CURRENTSCHOOL output,
        @CURRENTENROLLMENTID = @CURRENTENROLLMENTID output,
        @CURRENTSCHOOL2 = @CURRENTSCHOOL2 output,
        @CURRENTENROLLMENTID2 = @CURRENTENROLLMENTID2 output,
        @CURRENTSCHOOL3 = @CURRENTSCHOOL3 output,
        @CURRENTENROLLMENTID3 = @CURRENTENROLLMENTID3 output,
        @PRIMARYBUSINESS = @PRIMARYBUSINESS output,
        @PRIMARYBUSINESSID = @PRIMARYBUSINESSID output,
        @PHONEISCONFIDENTIAL = @PHONEISCONFIDENTIAL output,
        @ADDRESSISCONFIDENTIAL = @ADDRESSISCONFIDENTIAL output,
        @ADDRESSID = @ADDRESSID output,
        @PHONENUMBERID = @PHONENUMBERID output,
        @EMAILADDRESSID = @EMAILADDRESSID output        

    return 0;