1. Tables and Views for HCM
  2. PER_JOBS_X

PER_JOBS_X

Details

  • Schema: FUSION

  • Object owner: PER

  • Object type: VIEW

Columns

Name

JOB_ID

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

JOB_CODE

NAME

BUSINESS_GROUP_ID

SET_ID

JOB_FAMILY_ID

BENCHMARK_JOB_ID

ACTION_OCCURRENCE_ID

ACTIVE_STATUS

BENCHMARK_JOB_FLAG

APPROVAL_AUTHORITY

MANAGER_LEVEL

MED_CHECKUP_REQ

REGULAR_TEMPORARY

FULL_PART_TIME

JOB_FUNCTION_CODE

Query

SQL_Statement

SELECT

JOBS.JOB_ID,

JOBS.EFFECTIVE_START_DATE,

JOBS.EFFECTIVE_END_DATE,

JOBS.JOB_CODE,

JOBS_TL.NAME,

JOBS.BUSINESS_GROUP_ID,

JOBS.SET_ID,

JOBS.JOB_FAMILY_ID,

JOBS.BENCHMARK_JOB_ID,

JOBS.ACTION_OCCURRENCE_ID,

JOBS.ACTIVE_STATUS,

JOBS.BENCHMARK_JOB_FLAG,

JOBS.APPROVAL_AUTHORITY,

JOBS.MANAGER_LEVEL,

JOBS.MED_CHECKUP_REQ,

JOBS.REGULAR_TEMPORARY,

JOBS.FULL_PART_TIME,

JOBS.JOB_FUNCTION_CODE

FROM

PER_JOBS_F JOBS,

PER_JOBS_F_TL JOBS_TL

WHERE

JOBS.JOB_ID = JOBS_TL.JOB_ID AND JOBS.EFFECTIVE_START_DATE = JOBS_TL.EFFECTIVE_START_DATE AND JOBS.EFFECTIVE_END_DATE = JOBS_TL.EFFECTIVE_END_DATE AND JOBS_TL.LANGUAGE = SYS_CONTEXT('USERENV', 'LANG') AND TRUNC(SYSDATE) BETWEEN JOBS.EFFECTIVE_START_DATE AND JOBS.EFFECTIVE_END_DATE