教师信息匹配

#### 主题:教师信息匹配
#### 执行时间:81s,shape(617146, 2),新脱敏库
#### 需求方: 伦红叶
#### created_by:汪国强
#### update by:
#### checkd by:
SELECT
        jt.hrm_teacher_id HRM_ID,
        t.teacher_no 教师编号,
        (case t.is_train when 0 then '未培训' when 1 then '已培训' when 2 then '培训中' end) 培训状态,
        (case t.is_perfect when 1 then '未完善' when 2 then '已完善' when 3 then '待审核' when 4 then '入职资料待完善' when 5 then '入职资料待审核' when 6 then '入职资料已通过' end) 资料是否完善,
        (case jx.check_status when 3 then '已入库' else '未入库' end) 入库状态
FROM
        jx_teacher_hrm_id jt
LEFT JOIN
        view_teacher t ON jt.teacher_id = t.teacher_id
LEFT JOIN
        jx_teacher_contract jx ON jx.teacher_id = jt.teacher_id
WHERE
        jt.hrm_teacher_id in {}
group by
        HRM_ID

学员地区匹配

#### 主题:学员地区匹配
#### 执行时间:xxxs,shapexxx,新脱敏库
#### 需求方:杨璐
#### created_by:汪国强
#### update by:
#### checkd by:王娟
select
        vs.student_no,
        mpc.regLoc 城市,
      (select 
        provincename 
    from area_domain ad 
    where mpc.provincenum = ad.provinceid/10000
        ) 省份
from
    view_student vs
left join 
        view_user_info ui on ui.user_id = vs.student_id
left join
        map_phone_city mpc on mpc.phone7=ui.phone7
where
        vs.student_no in {}
文档更新时间: 2019-03-29 11:13   作者:admin