USP_DATAFORMTEMPLATE_ADD_SCHOOL

The save procedure used by the add dataform template "School Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAME	nvarchar(100)	IN	Name
@WEBADDRESS	UDT_WEBADDRESS	IN	Website
@PARENTSCHOOLID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@GENDERCODE	tinyint	IN	School gender
@SCHOOLGRADELEVELS	xml	IN
@ADDRESS_ADDRESSTYPECODEID	uniqueidentifier	IN	Address type
@ADDRESS_DONOTMAIL	bit	IN	Do not send mail to this address
@ADDRESS_COUNTRYID	uniqueidentifier	IN	Country
@ADDRESS_STATEID	uniqueidentifier	IN	State
@ADDRESS_ADDRESSBLOCK	nvarchar(150)	IN	Address
@ADDRESS_CITY	nvarchar(50)	IN	City
@ADDRESS_POSTCODE	nvarchar(12)	IN	ZIP
@PHONE_PHONETYPECODEID	uniqueidentifier	IN	Phone type
@PHONE_NUMBER	nvarchar(100)	IN	Phone number
@SKIP_ADDING_SECURITYGROUPS	bit	IN	Skip adding security groups
@EMAILADDRESS_EMAILADDRESSTYPECODEID	uniqueidentifier	IN	Email type
@EMAILADDRESS_EMAILADDRESS	UDT_EMAILADDRESS	IN	Email address
@OMITFROMVALIDATION	bit	IN	Omit this address from validation
@CART	nvarchar(10)	IN
@DPC	nvarchar(8)	IN
@LOT	nvarchar(5)	IN
@COUNTYCODEID	uniqueidentifier	IN
@CONGRESSIONALDISTRICTCODEID	uniqueidentifier	IN
@LASTVALIDATIONATTEMPTDATE	datetime	IN
@VALIDATIONMESSAGE	nvarchar(100)	IN
@CERTIFICATIONDATA	int	IN
@ADDRESS_DONOTMAILREASONCODEID	uniqueidentifier	IN	Reason
@ISPRIMARY	bit	IN
@COMMENTCODE	tinyint	IN	Grade comment entry

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_SCHOOL (
                        @ID uniqueidentifier = null output,
                        @CURRENTAPPUSERID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @NAME nvarchar(100),
                        @WEBADDRESS dbo.UDT_WEBADDRESS = '',
                        @PARENTSCHOOLID uniqueidentifier,
                        @GENDERCODE tinyint = 0,
                        @SCHOOLGRADELEVELS xml = null,
                        @ADDRESS_ADDRESSTYPECODEID uniqueidentifier = null,
                        @ADDRESS_DONOTMAIL bit = 0,
                        @ADDRESS_COUNTRYID uniqueidentifier = null,
                        @ADDRESS_STATEID uniqueidentifier = null,
                        @ADDRESS_ADDRESSBLOCK nvarchar(150) = '',
                        @ADDRESS_CITY nvarchar(50) = '',
                        @ADDRESS_POSTCODE nvarchar(12) = '',
                        @PHONE_PHONETYPECODEID uniqueidentifier = null,
                        @PHONE_NUMBER nvarchar(100) = '',
                        @SKIP_ADDING_SECURITYGROUPS bit=0,
                        @EMAILADDRESS_EMAILADDRESSTYPECODEID uniqueidentifier = null,
                        @EMAILADDRESS_EMAILADDRESS dbo.UDT_EMAILADDRESS = '',
                        @OMITFROMVALIDATION bit = 0,
                        @CART nvarchar(10) = '',
                        @DPC nvarchar(8) = '',
                        @LOT nvarchar(5) = '',
                        @COUNTYCODEID uniqueidentifier = null,
                        @CONGRESSIONALDISTRICTCODEID uniqueidentifier = null,
                        @LASTVALIDATIONATTEMPTDATE datetime = null,
                        @VALIDATIONMESSAGE nvarchar(100) = '',
                        @CERTIFICATIONDATA integer = 0,
                        @ADDRESS_DONOTMAILREASONCODEID uniqueidentifier = null, 
                        @ISPRIMARY bit = 0,
                        @COMMENTCODE tinyint = 1
                    ) as
                        set nocount on;

            exec dbo.USP_EDUCATIONALINSTITUTION_ADD @ID output, @CHANGEAGENTID, @NAME, '', 1, @WEBADDRESS, @PARENTSCHOOLID, @GENDERCODE, @SCHOOLGRADELEVELS, @ADDRESS_ADDRESSTYPECODEID, @ADDRESS_DONOTMAIL, @ADDRESS_COUNTRYID, @ADDRESS_STATEID, @ADDRESS_ADDRESSBLOCK, @ADDRESS_CITY, @ADDRESS_POSTCODE, @PHONE_PHONETYPECODEID, @PHONE_NUMBER, @SKIP_ADDING_SECURITYGROUPS, @EMAILADDRESS_EMAILADDRESSTYPECODEID, @EMAILADDRESS_EMAILADDRESS, @OMITFROMVALIDATION, @CART, @DPC, @LOT, @COUNTYCODEID, @CONGRESSIONALDISTRICTCODEID, @LASTVALIDATIONATTEMPTDATE, @VALIDATIONMESSAGE, @CERTIFICATIONDATA, @ADDRESS_DONOTMAILREASONCODEID, @ISPRIMARY, @COMMENTCODE;

                        return 0;