USP_DATAFORMTEMPLATE_ADD_STUDENTSIMPLIFIED_PRELOAD

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

Parameters

Parameter Parameter Type Mode Description
@DATEENROLLED UDT_FUZZYDATE INOUT Date enrolled
@ISSINGLESCHOOL bit INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_STUDENTSIMPLIFIED_PRELOAD
(
    @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;