员工信息表(ｈｒ)

纵横四海

select trim(b.person_id) as Person_ID,
       b.effective_start_date,
       b.effective_end_date,
       e.segment2 as department_code,
       e.segment2 || '-' || replace(d.name, '_', '') as department_name,
       apps.cux_common_use.getDepType(e.segment2) as department_type,
       g.employee_number employee_number,
       g.last_name as employee_name,
       apps.cux_common_use.getEmployeeTypeByNumber(g.employee_number) as employee_type,
       decode(g.SEX, 'F', '女', 'M', '男', '') "性别",
       g.EMAIL_ADDRESS "电子邮件",
       g.DATE_OF_BIRTH "生日",
       1 as jishu
  from apps.per_assignments_f           b,
       apps.HR_ORGANIZATION_UNITS       d,
       apps.PAY_COST_ALLOCATION_KEYFLEX e,
       apps.per_people_f                g
WHERE b.PERSON_ID = g.PERSON_ID
   and b.ORGANIZATION_ID = d.organization_id
   and d.cost_allocation_keyflex_id = e.cost_allocation_keyflex_id
   and employee_number not like 'XN%'
   and sysdate between b.EFFECTIVE_START_DATE and b.EFFECTIVE_END_DATE