USP_RECORDOPERATION_DESIGNATIONMARKINACTIVE
Executes the "Designation: Mark Inactive" record operation.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | Input parameter indicating the ID of the record being updated. |
| @CHANGEAGENTID | uniqueidentifier | IN | Input parameter indicating the ID of the change agent invoking the update. |
Definition
Copy
CREATE procedure dbo.USP_RECORDOPERATION_DESIGNATIONMARKINACTIVE (
@ID uniqueidentifier
,@CHANGEAGENTID uniqueidentifier = null
)
as
set nocount on;
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
update dbo.DESIGNATION
set ISACTIVE = 0
,CHANGEDBYID = @CHANGEAGENTID
,DATECHANGED = getdate()
where DESIGNATION.ID = @ID
and DESIGNATION.SYSTEMGENERATED = 0;
return 0;