vRespondLog Approval Berjenjang

/****** Object:  View [dbo].[vRespondLog]    Script Date: 27/11/2023 14:10:32 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



CREATE VIEW [dbo].[vRespondLog]
AS
SELECT *
FROM
(   SELECT
        rl.RespondLogID AS RespondID,
        rl.CurrentResponderID AS ResponderID,
        rl.RespondType,
        rl.RespondTypeID,
        rl.RespondeeID,
        er.FirstName + ' ' + er.LastName AS ResponderName,
        rl.CurrentResponderLevel AS ResponderLevel,
        rl.isApproved AS isApprove,
        rl.Remark,
        rl.RespondDate,
        rl.isLayeredApproval
    FROM
        RespondLog rl
    JOIN
        Employee er ON rl.CurrentResponderID = er.EmployeeID
    --WHERE
    --    rl.RespondeeID = @EmployeeID
    --    AND rl.RespondTypeID = @AttendanceID
    --    AND rl.RespondType = @strApprType
    --ORDER BY
    --  rl.RespondDate ASC
) as result
GO