考勤异常人次
<p><a href="https://www.showdoc.com.cn/zbtx?page_id=7009130915939878" title="返回 指标总览">返回 指标总览</a></p>
<pre><code>- 判断规则：参建方系统中设置了考核规则的人，不满足考勤规则的考勤次数</code></pre>
<ul>
<li>
<p>数据来源
数据库名称：工程大数据分析系统 yugao_data_analysis_data
数据表名称：考勤记录表 attendance_record （查看详情）</p>
</li>
<li>
<p>限制条件
1、数据有效记录计数，is_delete=0
2、考勤异常，is_abnormal=1</p>
</li>
<li>代码实现（参考）
<pre><code>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</code></pre></li>
</ul>