【泛微E9】入职流程开通人员账号后自动更新人员信息卡片中的各级部门

归档——节点前附加操作：编辑DML接口

DML类型：自定义类型

自定义DML语句如下：

UPDATE cus_fielddata c  
inner join hrmresource a on a.id = c.id
left join view_bmcjpath v ON a.departmentid = v.id 
SET 
	c.field26 = v.field1,  
	c.field27 = v.field2,  
	c.field28 = v.field3,  
	c.field31 = v.field4,  
	c.field32 = v.field5,  
	c.field33 = v.field6  
WHERE  c.scopeid = -1
and a.workcode = '{?rybh}';