如何替换现有工龄表单为司龄
【适用版本】8.8
【解决方案】
数据集路径:用户账号/administrator账号:开发平台-数据集配置
新增数据集配置,选择自定义sql
select a.fjoincompanyyears as 司龄,a.FPERSONID as 人员, c.fname_l2 as 行政组织,c.fid as 行政组织编码,(case when (a.fjoincompanyyears >0 and a.fjoincompanyyears<=1) then '0~1' when (a.fjoincompanyyears >1 and a.fjoincompanyyears<=3) then '1~3' when (a.fjoincompanyyears >3 and a.fjoincompanyyears<=5) then '3~5' when (a.fjoincompanyyears >5 and a.fjoincompanyyears<=10) then '5~10' when (a.fjoincompanyyears >10 and a.fjoincompanyyears<=20) then '10~20'else '20以上' end) as 范围,(case when (a.fjoincompanyyears >0 and a.fjoincompanyyears<=1) then '1' when (a.fjoincompanyyears >1 and a.fjoincompanyyears<=3) then '2' when (a.fjoincompanyyears >3 and a.fjoincompanyyears<=5) then '3' when (a.fjoincompanyyears >5 and a.fjoincompanyyears<=10) then '4' when (a.fjoincompanyyears >10 and a.fjoincompanyyears<=20) then '5'else '6' end) as 排序码from T_ORG_ADMIN c inner join T_ORG_Admin child on ( charindex(concat(c.flongnumber,'!'), child.flongnumber) = 1 or c.flongnumber = child.flongnumber)left join T_HR_EmpOrgRelation b on b.FADMINORGID = child.fidleft join T_HR_PersonPosition a on b.fpersonid = a.fpersonidwhere c.fid in ({org})
也可以直接脚本导入下列附件
如何替换现有工龄表单为司龄
本文2024-09-22 21:10:01发表“s-hr cloud知识”栏目。
本文链接：https://wenku.my7c.com/article/kingdee-shr-118333.html
