USP_DATAFORMTEMPLATE_ADD_STUDENTENROLLCONSTITUENT_PRELOAD

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

Parameters

Parameter Parameter Type Mode Description
@CONSTITUENTID uniqueidentifier IN Input parameter indicating the context ID for the record being added.
@DATEENROLLED UDT_FUZZYDATE INOUT Date enrolled
@ISSINGLESCHOOL bit INOUT

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_STUDENTENROLLCONSTITUENT_PRELOAD
                (
                    @CONSTITUENTID uniqueidentifier,
                    @DATEENROLLED dbo.UDT_FUZZYDATE = null output,
                    @ISSINGLESCHOOL bit = null output
                )
                as
                    set nocount on;
                    set @DATEENROLLED = convert(varchar(8), getdate(), 112);
                    set @ISSINGLESCHOOL = dbo.UFN_SCHOOL_ISSINGLESCHOOL();

                    return 0;