USP_SCHOOL_DELETE

Executes the "School: 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_SCHOOL_DELETE
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier
                    )
                    as
                        set nocount on;

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

                        exec dbo.USP_SCHOOL_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;

                        --Calling the same method used in constituent delete record operation:

                        -- Record Operation ID: 569202FA-082A-4203-A2AE-91843E7C08CA

                        -- File name:  \Blackbaud.AppFx.Constituent.Catalog\ConstituentDelete.RecordOperation.xml

                        exec dbo.USP_CONSTITUENT_DELETE @ID, @CHANGEAGENTID;

                        exec dbo.USP_EDUCATIONALINSTITUTION_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;                        
                        return 0;