USP_DATAFORMTEMPLATE_ADD_STUDENT_PRELOAD

The load procedure used by the edit dataform template "Student Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ADDRESS_COUNTRYID	uniqueidentifier	INOUT	Country
@VALIDATIONCOUNTRIES	xml	INOUT
@ZIPLOOKUPCOUNTRIES	xml	INOUT
@DATEENROLLED	UDT_FUZZYDATE	INOUT	Date enrolled
@ISSINGLESCHOOL	bit	INOUT
@CONSTITUENTTYPE	int	INOUT
@RELATION_CONSTITUENTTYPE	int	INOUT
@ADDITIONALRELATION_CONSTITUENTTYPE	int	INOUT

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_STUDENT_PRELOAD 
                (
                    @ADDRESS_COUNTRYID uniqueidentifier = null output,
                    @VALIDATIONCOUNTRIES xml = null output,
                    @ZIPLOOKUPCOUNTRIES xml = null output,
                    @DATEENROLLED dbo.UDT_FUZZYDATE = null output,
                    @ISSINGLESCHOOL bit = null output,
                    @CONSTITUENTTYPE int = null output,
                    @RELATION_CONSTITUENTTYPE int = null output,
                    @ADDITIONALRELATION_CONSTITUENTTYPE int = null output
                ) as
                    set nocount on;

                    exec @ADDRESS_COUNTRYID = dbo.UFN_COUNTRY_GETDEFAULT;
                    set @VALIDATIONCOUNTRIES = dbo.UFN_COUNTRY_GETVALIDATIONCOUNTRIES_TOITEMLISTXML();
                    set @ZIPLOOKUPCOUNTRIES = dbo.UFN_ZIPCITYSTATE_GETCOUNTRIES_TOITEMLISTXML();
                    set @DATEENROLLED = convert(varchar(8), getdate(), 112);
                    set @ISSINGLESCHOOL = dbo.UFN_SCHOOL_ISSINGLESCHOOL();
                    set @CONSTITUENTTYPE = 4;
                    set @RELATION_CONSTITUENTTYPE = 0;
                    set @ADDITIONALRELATION_CONSTITUENTTYPE = 0;

                    return 0;