NC部门考勤月报定制sql

最新推荐文章于 2022-12-12 17:22:50 发布

WaiteH

最新推荐文章于 2022-12-12 17:22:50 发布

阅读量662

点赞数

CC 4.0 BY-SA版权

分类专栏： SQL Oracle

本文链接：https://blog.youkuaiyun.com/hwq293/article/details/80176523

本文详细介绍了如何在NC系统中定制考勤月报的SQL查询，包括涉及的表结构、关键字段解析及数据处理逻辑，帮助用户自定义生成符合需求的考勤报表。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SELECT t_1.pk_psndoc pk_psndoc,
       t_1.pk_group pk_group,
       t_1.pyear pyear,
       t_1.month month,
       t_1.code psncode,
       t_1.name psnname,
       t_1.glbdef1 glbdef1,
       t_1.thisyearyial thisyearyial,
       t_1.lastal lastal,
       t_1.lastbx lastbx,
       nvl(t_1.annualleave, 0) annualleave,
       nvl(t_1.absenceleave, 0) absenceleave,
       nvl(t_1.sickleave, 0) sickleave,
       nvl(t_1.compensatedleave, 0) compensatedleave,
       t_1.yxhunjia yxhunjia,
       t_1.yxsangjia yxsangjia,
       t_1.yxgongshang yxgongshang,
       t_1.yxchanjia yxchanjia,
       t_1.yxchanjian yxchanjian,
       t_1.yxpeichan yxpeichan,
       t_1.yxshijia yxshijia,
       t_1.yxbingjia yxbingjia,
       t_1.yxnianjia yxnianjia,
       t_1.jynianjia jynianjia,
       t_1.jybuxiu jybuxiu,
       hi_psnjob.pk_dept pk_dept
  FROM (SELECT ld.ym               ym,
               psn.pk_group        pk_group,
               psn.pk_psndoc       pk_psndoc,
               psn.code            code,
               psn.name            name,
               psn.glbdef1         glbdef1,
               bal.thisyearyial    thisyearyial,
               bal.lastal          lastal,
               tbbxv.lastbx        lastbx,
               bal.yxhunjia        yxhunjia,
               bal.yxsangjia       yxsangjia,
               bal.yxgongshang     yxgongshang,
               bal.yxchanjia       yxchanjia,
               bal.yxchanjian      yxchanjian,
               bal.yxpeichan       yxpeichan,
               bal.yxshijia        yxshijia,
               bal.yxbingjia       yxbingjia,
               bal.yxnianjia       yxnianjia,
               bal.jynianjia       jynianjia,
               bal.jybuxiu         jybuxiu,
               ld.annualleave      annualleave,
               ld.absenceleave     absenceleave,
               ld.sickleave        sickleave,
               ld.compensatedleave compensatedleave
          FROM bd_psndoc psn
         INNER JOIN leave_daily ld
            ON ld.pk_psnodc = psn.pk_psndoc
           AND ld.pk_org = psn.pk_org
         INNER