USP_DATAFORMTEMPLATE_VIEW_SCHOOLPROFILE

The load procedure used by the view dataform template "School 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.
@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	Parent School
@RELATEDCONSTITUENTID	uniqueidentifier	INOUT	RELATEDCONSTITUENTID
@ISINACTIVE	bit	INOUT	ISINACTIVE
@PICTURE	varbinary	INOUT	PICTURE
@LOOKUPID	nvarchar(100)	INOUT	Lookup ID
@SCHOOLGRADELEVELS	nvarchar(max)	INOUT	Grade levels
@SCHOOLGENDER	nvarchar(100)	INOUT	School gender
@SCHOOLCOMMENTS	nvarchar(20)	INOUT	Grade comment entry
@SCHOOLINACTIVITYREASON	nvarchar(63)	INOUT	Inactive reason
@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_SCHOOLPROFILE
(
    @ID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier=null,
    @DATALOADED bit = 0 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,
    @PICTURE varbinary(max) = null output,
    @LOOKUPID nvarchar(100) = null output,
    @SCHOOLGRADELEVELS nvarchar(max) = null output,
    @SCHOOLGENDER nvarchar(100) = null output,
    @SCHOOLCOMMENTS nvarchar(20) = null output,
    @SCHOOLINACTIVITYREASON nvarchar(63) = 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;

    --Load the generic constituent data

    exec USP_DATAFORMTEMPLATE_VIEW_INDIVIDUALPROFILE 
      @ID, 
      @CURRENTAPPUSERID, 
      @DATALOADED = @DATALOADED 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, 
      @PICTURE = @PICTURE output, 
      @LOOKUPID = @LOOKUPID output,
      @CONSTITUENTINACTIVITYREASON = @SCHOOLINACTIVITYREASON output,
      @ADDRESSISCONFIDENTIAL = @ADDRESSISCONFIDENTIAL output,
      @ADDRESSID = @ADDRESSID output,
      @PHONEISCONFIDENTIAL = @PHONEISCONFIDENTIAL output,
      @PHONENUMBERID = @PHONENUMBERID output,
      @EMAILADDRESSID = @EMAILADDRESSID output;

    -- Load the School detail data if the constituent data succeeded

    if (@DATALOADED = 1)
    begin
        exec USP_DATAFORMTEMPLATE_VIEW_SCHOOLDETAILS @ID, @DATALOADED output, null,    @SCHOOLGRADELEVELS output, @SCHOOLGENDER output, @SCHOOLCOMMENTS output;
    end

    return 0;