考勤异常人次

返回 指标总览

- 判断规则:参建方系统中设置了考核规则的人,不满足考勤规则的考勤次数
  • 数据来源
    数据库名称:工程大数据分析系统 yugao_data_analysis_data
    数据表名称:考勤记录表 attendance_record (查看详情)
  • 限制条件
    1、数据有效记录计数,is_delete=0
    2、考勤异常,is_abnormal=1

  • 代码实现(参考)

    select department_name,  count(1) as number 
    from attendance_record 
    WHERE ( business_project_id in ( select business_project_id  
          FROM project_cooperation  
          where is_delete=0  and  data_status=1   and  business_project_name not like "测试%" ) 
      and is_abnormal = 1 and attendance_week = "2021-06-14" and attendance_date <> "2021-06-21" and is_delete = 0 ) 
      group by department_name