USP_DATAFORMTEMPLATE_EDIT_MARKSTEPCOMPLETE_2

The save procedure used by the edit dataform template "Mark Step Complete Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@ACTUALDATE	datetime	IN	Actual date
@STATUSCODE	tinyint	IN	Status
@ACTUALSTARTTIME	UDT_HOURMINUTE	IN	Actual start time
@ACTUALENDTIME	UDT_HOURMINUTE	IN	Actual end time

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_MARKSTEPCOMPLETE_2
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @ACTUALDATE datetime,
    @STATUSCODE tinyint,
    @ACTUALSTARTTIME dbo.UDT_HOURMINUTE,
    @ACTUALENDTIME dbo.UDT_HOURMINUTE
) as begin
    set nocount on;

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

    update dbo.INTERACTION set
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = getdate(),
        ACTUALDATE = @ACTUALDATE,
        STATUSCODE = @STATUSCODE,
        ACTUALSTARTTIME = @ACTUALSTARTTIME,
        ACTUALENDTIME = @ACTUALENDTIME
    where
        ID = @ID;

    return 0;

end