USP_STUDENTPROGRESSION_DELETE

Executes the "Student Progression Delete" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the ID of the record being deleted.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the delete.

Definition

Copy



                CREATE procedure dbo.USP_STUDENTPROGRESSION_DELETE
                (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier
                )
                as begin
                    --check deletion rules, if any

                    declare @STUDENTID as uniqueidentifier
                    declare @ENTRYCOUNT as int

                    set @STUDENTID = (SELECT dbo.EDUCATIONALHISTORY.[CONSTITUENTID] FROM dbo.STUDENTPROGRESSION INNER JOIN dbo.EDUCATIONALHISTORY on dbo.STUDENTPROGRESSION.[ENROLLMENTID] = dbo.EDUCATIONALHISTORY.[ID]  WHERE dbo.STUDENTPROGRESSION.[ID] = @ID) 
                    set @ENTRYCOUNT = dbo.UFN_STUDENTPROGRESSION_RECORDCOUNT(@STUDENTID)

                    if @ENTRYCOUNT = 1 begin
                        raiserror('BBERR_STUDENTPROGRESSION_ATLEASTONE', 13, 1)
                    end

                    if dbo.UFN_STUDENTPROGRESSION_INUSE(@ID) = 1
                            raiserror('BBERR_STUDENTPROGRESSION_INUSE', 13, 1)

                    -- use the system generated delete routine to allow proper recording of the deleting agent

                    exec USP_STUDENTPROGRESSION_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID
                    return 0;

                end