USP_DATAFORMTEMPLATE_ADD_OUTSIDEEDUCATION

The save procedure used by the add dataform template "Outside Education Add Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@STUDENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@EDUCATIONALINSTITUTIONID	uniqueidentifier	IN	Educational institution
@GRADELEVELENROLLEDID	uniqueidentifier	IN	Grade enrolled
@GRADELEVELLEFTID	uniqueidentifier	IN	Grade left
@EDUCATIONALREASONLEFTCODEID	uniqueidentifier	IN	Reason left
@EDUCATIONALHISTORYSTATUSID	uniqueidentifier	IN	Current status
@DATEATTENDEDFROM	UDT_FUZZYDATE	IN	From
@DATEATTENDEDTO	UDT_FUZZYDATE	IN	To
@GRADUATIONDATE	UDT_FUZZYDATE	IN	Graduation date
@CLASSOF	UDT_YEAR	IN	Class of

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_OUTSIDEEDUCATION
                    (
                        @ID uniqueidentifier = null output,
                        @STUDENTID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @EDUCATIONALINSTITUTIONID uniqueidentifier,
                        @GRADELEVELENROLLEDID uniqueidentifier,
                        @GRADELEVELLEFTID uniqueidentifier = null,
                        @EDUCATIONALREASONLEFTCODEID uniqueidentifier = null,
                        @EDUCATIONALHISTORYSTATUSID uniqueidentifier,
                        @DATEATTENDEDFROM UDT_FUZZYDATE = null,
                        @DATEATTENDEDTO UDT_FUZZYDATE = null,
                        @GRADUATIONDATE UDT_FUZZYDATE = null,
                        @CLASSOF UDT_YEAR = null
                    )
                    as

                    set nocount on;

                    if @ID is null
                        set @ID = newid()

                    if @CHANGEAGENTID is null  
                        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

                    declare @CURRENTDATE datetime
                    set @CURRENTDATE = getdate()

                    declare @SOURCEID uniqueidentifier
                    exec dbo.USP_EDUCATIONALHISTORY_RO_EDUCATIONALSOURCEID @SOURCEID output

                    begin try    
                        -- handle inserting the educational history record

                        insert into dbo.EDUCATIONALHISTORY
                            (ID,
                             CONSTITUENTID,
                             EDUCATIONALINSTITUTIONID,
                             GRADELEVELENROLLEDID,
                             GRADELEVELLEFTID,
                             EDUCATIONALREASONLEFTCODEID,
                             STARTDATE,
                             DATELEFT,
                             DATEGRADUATED,
                             CLASSOF,
                                           EDUCATIONALSOURCECODEID,
                                           EDUCATIONALSOURCEDATE,
                             ADDEDBYID,
                             CHANGEDBYID,
                             DATEADDED,
                             DATECHANGED)
                        values
                            (@ID,
                             @STUDENTID,
                             @EDUCATIONALINSTITUTIONID,
                             @GRADELEVELENROLLEDID,
                             @GRADELEVELLEFTID,
                             @EDUCATIONALREASONLEFTCODEID,
                             @DATEATTENDEDFROM,
                             @DATEATTENDEDTO,
                             @GRADUATIONDATE,
                             @CLASSOF,
                                           @SOURCEID,
                                           convert(varchar(8), getdate(), 112),
                             @CHANGEAGENTID,
                             @CHANGEAGENTID,
                             @CURRENTDATE,
                             @CURRENTDATE);

                        declare @STATUSDATE datetime;
                        if (@DATEATTENDEDFROM = '00000000')
                        begin
                          set @STATUSDATE = getdate();
                        end
                        else
                        begin
                          set @STATUSDATE = dbo.UFN_DATE_FROMFUZZYDATE(@DATEATTENDEDFROM);
                        end

                        -- Insert the correct educational history status history record

                        insert into dbo.EDUCATIONALHISTORYSTATUSHISTORY
                          (ID,
                           EDUCATIONALHISTORYID,
                           EDUCATIONALHISTORYSTATUSID,
                           STATUSDATE,
                           ADDEDBYID,
                           CHANGEDBYID,
       DATEADDED,
                           DATECHANGED)
                        values
                          (newid(),
                           @ID,
                           @EDUCATIONALHISTORYSTATUSID,
                           @STATUSDATE,
                           @CHANGEAGENTID,
                           @CHANGEAGENTID,
                           @CURRENTDATE,
                           @CURRENTDATE);

                    end try

                    begin catch
                        exec dbo.USP_RAISE_ERROR
                        return 1
                    end catch

                    return 0