Analytics Catalog/Data dictionary/PER_JOBS_F
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion · Data dictionary

PER_JOBS_F

HCMUsed in 4 subject areas98 reporting columnsBICC incremental-ready

Person / Worker (PER).

Primary key: JOB_ID, EFFECTIVE_START_DATE · Incremental key: LAST_UPDATE_DATE

Columns

ColumnKeyIn reportsDescription (inferred)
ACTION_OCCURRENCE_ID●Identifier for the action occurrence.
ACTIVE_STATUS●Status of the active.
ANNUAL_WORKING_DURATION_UNITS●Annual working duration units.
APPROVAL_AUTHORITY●Approval authority.
ATTRIBUTE1●Descriptive flexfield segment.
ATTRIBUTE10●Descriptive flexfield segment.
ATTRIBUTE11●Descriptive flexfield segment.
ATTRIBUTE12●Descriptive flexfield segment.
ATTRIBUTE13●Descriptive flexfield segment.
ATTRIBUTE14●Descriptive flexfield segment.
ATTRIBUTE15●Descriptive flexfield segment.
ATTRIBUTE16●Descriptive flexfield segment.
ATTRIBUTE17●Descriptive flexfield segment.
ATTRIBUTE18●Descriptive flexfield segment.
ATTRIBUTE19●Descriptive flexfield segment.
ATTRIBUTE2●Descriptive flexfield segment.
ATTRIBUTE20●Descriptive flexfield segment.
ATTRIBUTE21●Descriptive flexfield segment.
ATTRIBUTE22●Descriptive flexfield segment.
ATTRIBUTE23●Descriptive flexfield segment.
ATTRIBUTE24●Descriptive flexfield segment.
ATTRIBUTE25●Descriptive flexfield segment.
ATTRIBUTE26●Descriptive flexfield segment.
ATTRIBUTE27●Descriptive flexfield segment.
ATTRIBUTE28●Descriptive flexfield segment.
ATTRIBUTE29●Descriptive flexfield segment.
ATTRIBUTE3●Descriptive flexfield segment.
ATTRIBUTE30●Descriptive flexfield segment.
ATTRIBUTE4●Descriptive flexfield segment.
ATTRIBUTE5●Descriptive flexfield segment.
ATTRIBUTE6●Descriptive flexfield segment.
ATTRIBUTE7●Descriptive flexfield segment.
ATTRIBUTE8●Descriptive flexfield segment.
ATTRIBUTE9●Descriptive flexfield segment.
ATTRIBUTE_CATEGORY●Descriptive flexfield context (structure definition).
ATTRIBUTE_DATE1●Descriptive flexfield segment.
ATTRIBUTE_DATE10●Descriptive flexfield segment.
ATTRIBUTE_DATE11●Descriptive flexfield segment.
ATTRIBUTE_DATE12●Descriptive flexfield segment.
ATTRIBUTE_DATE13●Descriptive flexfield segment.
ATTRIBUTE_DATE14●Descriptive flexfield segment.
ATTRIBUTE_DATE15●Descriptive flexfield segment.
ATTRIBUTE_DATE2●Descriptive flexfield segment.
ATTRIBUTE_DATE3●Descriptive flexfield segment.
ATTRIBUTE_DATE4●Descriptive flexfield segment.
ATTRIBUTE_DATE5●Descriptive flexfield segment.
ATTRIBUTE_DATE6●Descriptive flexfield segment.
ATTRIBUTE_DATE7●Descriptive flexfield segment.
ATTRIBUTE_DATE8●Descriptive flexfield segment.
ATTRIBUTE_DATE9●Descriptive flexfield segment.
ATTRIBUTE_NUMBER1●Descriptive flexfield segment.
ATTRIBUTE_NUMBER10●Descriptive flexfield segment.
ATTRIBUTE_NUMBER11●Descriptive flexfield segment.
ATTRIBUTE_NUMBER12●Descriptive flexfield segment.
ATTRIBUTE_NUMBER13●Descriptive flexfield segment.
ATTRIBUTE_NUMBER14●Descriptive flexfield segment.
ATTRIBUTE_NUMBER15●Descriptive flexfield segment.
ATTRIBUTE_NUMBER16●Descriptive flexfield segment.
ATTRIBUTE_NUMBER17●Descriptive flexfield segment.
ATTRIBUTE_NUMBER18●Descriptive flexfield segment.
ATTRIBUTE_NUMBER19●Descriptive flexfield segment.
ATTRIBUTE_NUMBER2●Descriptive flexfield segment.
ATTRIBUTE_NUMBER20●Descriptive flexfield segment.
ATTRIBUTE_NUMBER3●Descriptive flexfield segment.
ATTRIBUTE_NUMBER4●Descriptive flexfield segment.
ATTRIBUTE_NUMBER5●Descriptive flexfield segment.
ATTRIBUTE_NUMBER6●Descriptive flexfield segment.
ATTRIBUTE_NUMBER7●Descriptive flexfield segment.
ATTRIBUTE_NUMBER8●Descriptive flexfield segment.
ATTRIBUTE_NUMBER9●Descriptive flexfield segment.
BENCHMARK_JOB_FLAG●Indicator (Y/N) for the benchmark job.
BENCHMARK_JOB_ID●Identifier for the benchmark job.
BUSINESS_GROUP_ID●Identifier for the business group.
CATEGORY_CODE●Code identifying the category.
CREATED_BY●User who created the row.
CREATION_DATE●Date and time the row was created.
EFFECTIVE_END_DATE●End date of the effective-dated record.
EFFECTIVE_START_DATEPK●Start date of the effective-dated record.
FULL_PART_TIME●Full part time.
GRADE_LADDER_ID●Identifier for the grade ladder.
JOB_CODE●Code identifying the job.
JOB_FAMILY_ID●Identifier for the job family.
JOB_FUNCTION_CODE●Code identifying the job function.
JOB_IDPK●Identifier for the job.
LAST_UPDATED_BY●User who last updated the row.
LAST_UPDATE_DATEINCR●Date and time the row was last updated (the incremental-extract key).
LAST_UPDATE_LOGIN●Session login of the user who last updated the row.
MANAGER_LEVEL●Manager level.
MED_CHECKUP_REQ●Med checkup req.
OBJECT_VERSION_NUMBER●Optimistic-locking version number, incremented on each update.
PROGRESSION_JOB_ID●Identifier for the progression job.
REGULAR_TEMPORARY●Regular temporary.
REQUISITION_TEMPLATE_ID●Identifier for the requisition template.
SCHEDULING_GROUP●Scheduling group.
SET_ID●Identifier for the set.
STANDARD_WORKING_FREQUENCY●Standard working frequency.
STANDARD_WORKING_HOURS●Standard working hours.
STD_ANNUAL_WORKING_DURATION●Std annual working duration.

2 reports read from this table

Change a column here and these are the reports that move with it — the blast radius for any change to PER_JOBS_F.

Where this surfaces in OTBI

The OTBI subject areas that expose this table. You can't join across them in OTBI — the owned conformed model joins them on shared keys.

Need the extract + dbt staging for PER_JOBS_F?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us