SELECT * FROM dbo.PL_REQUEST_DOC WHERE REQ_CODE='0004/2020/TTr-0690605'

SELECT * FROM dbo.PL_REQUEST_COSTCENTER WHERE REQ_ID='PLRD00000200104'
UPDATE dbo.PL_REQUEST_DOC SET PROCESS_ID='APPROVE',CHECKER_ID='phuctd',APPROVE_DT=CREATE_DT WHERE REQ_ID='PLRD00000200104'
INSERT INTO dbo.PL_REQUEST_PROCESS
(
    REQ_ID,
    PROCESS_ID,
    STATUS,
    ROLE_USER,
    BRANCH_ID,
    CHECKER_ID,
    APPROVE_DT,
    PARENT_PROCESS_ID,
    IS_LEAF,
    COST_ID,
    DVDM_ID,
    NOTES,
    IS_HAS_CHILD,
    DEP_ID
)
VALUES
(   'PLRD00000200104',        -- REQ_ID - varchar(15)
    'APPNEW',        -- PROCESS_ID - varchar(10)
    'P',        -- STATUS - varchar(5)
    'GDDV',        -- ROLE_USER - varchar(50)
    'DV0001',        -- BRANCH_ID - varchar(15)
    'phuctd',        -- CHECKER_ID - varchar(15)
   '2020-08-31 00:00:00.000', -- APPROVE_DT - datetime
    '',        -- PARENT_PROCESS_ID - varchar(10)
    '',        -- IS_LEAF - varchar(1)
    '',        -- COST_ID - varchar(15)
    '',        -- DVDM_ID - varchar(15)
    N'',       -- NOTES - nvarchar(500)
    NULL,      -- IS_HAS_CHILD - bit
    'DEP000000000015'         -- DEP_ID - varchar(20)
    )


	INSERT INTO dbo.PL_REQUEST_PROCESS
(
    REQ_ID,
    PROCESS_ID,
    STATUS,
    ROLE_USER,
    BRANCH_ID,
    CHECKER_ID,
    APPROVE_DT,
    PARENT_PROCESS_ID,
    IS_LEAF,
    COST_ID,
    DVDM_ID,
    NOTES,
    IS_HAS_CHILD,
    DEP_ID
)
VALUES
(   'PLRD00000200104',        -- REQ_ID - varchar(15)
    'DVCM',        -- PROCESS_ID - varchar(10)
    'P',        -- STATUS - varchar(5)
    'GDDV',        -- ROLE_USER - varchar(50)
    'DV0001',        -- BRANCH_ID - varchar(15)
    'hoacq',        -- CHECKER_ID - varchar(15)
   '2020-08-31 00:00:00.000', -- APPROVE_DT - datetime
    'APPNEW',        -- PARENT_PROCESS_ID - varchar(10)
    '',        -- IS_LEAF - varchar(1)
    '',        -- COST_ID - varchar(15)
    'DM0000000000004',        -- DVDM_ID - varchar(15)
    N'',       -- NOTES - nvarchar(500)
    NULL,      -- IS_HAS_CHILD - bit
    ''         -- DEP_ID - varchar(20)
    )

	INSERT INTO dbo.PL_REQUEST_PROCESS
(
    REQ_ID,
    PROCESS_ID,
    STATUS,
    ROLE_USER,
    BRANCH_ID,
    CHECKER_ID,
    APPROVE_DT,
    PARENT_PROCESS_ID,
    IS_LEAF,
    COST_ID,
    DVDM_ID,
    NOTES,
    IS_HAS_CHILD,
    DEP_ID
)
VALUES
(   'PLRD00000200104',        -- REQ_ID - varchar(15)
    'GDK_TT',        -- PROCESS_ID - varchar(10)
    'P',        -- STATUS - varchar(5)
    'GDK',        -- ROLE_USER - varchar(50)
    'DV0001',        -- BRANCH_ID - varchar(15)
    'tupa',        -- CHECKER_ID - varchar(15)
   '2020-08-31 00:00:00.000', -- APPROVE_DT - datetime
    'DVCM',        -- PARENT_PROCESS_ID - varchar(10)
    '',        -- IS_LEAF - varchar(1)
    '',        -- COST_ID - varchar(15)
    'DM0000000000015',        -- DVDM_ID - varchar(15)
    N'',       -- NOTES - nvarchar(500)
    NULL,      -- IS_HAS_CHILD - bit
    ''         -- DEP_ID - varchar(20)
    )


		INSERT INTO dbo.PL_REQUEST_PROCESS
(
    REQ_ID,
    PROCESS_ID,
    STATUS,
    ROLE_USER,
    BRANCH_ID,
    CHECKER_ID,
    APPROVE_DT,
    PARENT_PROCESS_ID,
    IS_LEAF,
    COST_ID,
    DVDM_ID,
    NOTES,
    IS_HAS_CHILD,
    DEP_ID
)
VALUES
(   'PLRD00000200104',        -- REQ_ID - varchar(15)
    'APPROVE',        -- PROCESS_ID - varchar(10)
    'C',        -- STATUS - varchar(5)
    '',        -- ROLE_USER - varchar(50)
    '',        -- BRANCH_ID - varchar(15)
    '',        -- CHECKER_ID - varchar(15)
   '2020-08-31 00:00:00.000', -- APPROVE_DT - datetime
    'GDK_TT',        -- PARENT_PROCESS_ID - varchar(10)
    '',        -- IS_LEAF - varchar(1)
    '',        -- COST_ID - varchar(15)
    'DM0000000000015',        -- DVDM_ID - varchar(15)
    N'',       -- NOTES - nvarchar(500)
    NULL,      -- IS_HAS_CHILD - bit
    ''         -- DEP_ID - varchar(20)
    )

	INSERT dbo.PL_PROCESS
	(
	    REQ_ID,
	    PROCESS_ID,
	    CHECKER_ID,
	    APPROVE_DT,
	    PROCESS_DESC,
	    NOTES
	)
	VALUES
	(   'PLRD00000200104',        -- REQ_ID - varchar(15)
	    'APPNEW',        -- PROCESS_ID - varchar(10)
	    'phuctd',        -- CHECKER_ID - varchar(15)
	   '2020-08-31 00:00:00.000', -- APPROVE_DT - datetime
	    N'Trưởng đơn vị phê duyệt',       -- PROCESS_DESC - nvarchar(1000)
	    N'Trưởng đơn vị phê duyệt'        -- NOTES - nvarchar(1000)
	    )

			INSERT dbo.PL_PROCESS
	(
	    REQ_ID,
	    PROCESS_ID,
	    CHECKER_ID,
	    APPROVE_DT,
	    PROCESS_DESC,
	    NOTES
	)
	VALUES
	(   'PLRD00000200104',        -- REQ_ID - varchar(15)
	    'DVCM',        -- PROCESS_ID - varchar(10)
	    'hoaqc',        -- CHECKER_ID - varchar(15)
	   '2020-08-31 00:00:00.000', -- APPROVE_DT - datetime
	    N'Đơn vị chuyên môn phê duyệt',       -- PROCESS_DESC - nvarchar(1000)
	    N'Đơn vị chuyên môn phê duyệt'        -- NOTES - nvarchar(1000)
	    )

		
			INSERT dbo.PL_PROCESS
	(
	    REQ_ID,
	    PROCESS_ID,
	    CHECKER_ID,
	    APPROVE_DT,
	    PROCESS_DESC,
	    NOTES
	)
	VALUES
	(   'PLRD00000200104',        -- REQ_ID - varchar(15)
	    'GDK_TT',        -- PROCESS_ID - varchar(10)
	    'hoaqc',        -- CHECKER_ID - varchar(15)
	   '2020-08-31 00:00:00.000', -- APPROVE_DT - datetime
	    N'Giám đốc khối phê duyệt',       -- PROCESS_DESC - nvarchar(1000)
	    N'Giám đốc khối phê duyệt'        -- NOTES - nvarchar(1000)
	    )