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

PER_JOB_EXTRA_INFO_F

HCMUsed in 0 subject areas75 reporting columnsBICC incremental-ready

Person / Worker (PER).

Likely primary key: JOB_EXTRA_INFO_ID, EFFECTIVE_START_DATE (inferred from Oracle naming conventions — verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE

Columns

ColumnKeyIn reportsDescription (inferred)
ACTION_OCCURRENCE_ID●Identifier for the action occurrence.
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.
INFORMATION_TYPE●Type of information.
JEI_ATTRIBUTE1●Jei attribute1.
JEI_ATTRIBUTE10●Jei attribute10.
JEI_ATTRIBUTE11●Jei attribute11.
JEI_ATTRIBUTE12●Jei attribute12.
JEI_ATTRIBUTE13●Jei attribute13.
JEI_ATTRIBUTE14●Jei attribute14.
JEI_ATTRIBUTE15●Jei attribute15.
JEI_ATTRIBUTE16●Jei attribute16.
JEI_ATTRIBUTE17●Jei attribute17.
JEI_ATTRIBUTE18●Jei attribute18.
JEI_ATTRIBUTE19●Jei attribute19.
JEI_ATTRIBUTE2●Jei attribute2.
JEI_ATTRIBUTE20●Jei attribute20.
JEI_ATTRIBUTE21●Jei attribute21.
JEI_ATTRIBUTE22●Jei attribute22.
JEI_ATTRIBUTE23●Jei attribute23.
JEI_ATTRIBUTE24●Jei attribute24.
JEI_ATTRIBUTE25●Jei attribute25.
JEI_ATTRIBUTE26●Jei attribute26.
JEI_ATTRIBUTE27●Jei attribute27.
JEI_ATTRIBUTE28●Jei attribute28.
JEI_ATTRIBUTE29●Jei attribute29.
JEI_ATTRIBUTE3●Jei attribute3.
JEI_ATTRIBUTE30●Jei attribute30.
JEI_ATTRIBUTE4●Jei attribute4.
JEI_ATTRIBUTE5●Jei attribute5.
JEI_ATTRIBUTE6●Jei attribute6.
JEI_ATTRIBUTE7●Jei attribute7.
JEI_ATTRIBUTE8●Jei attribute8.
JEI_ATTRIBUTE9●Jei attribute9.
JEI_ATTRIBUTE_CATEGORY●Jei attribute category.
JEI_INFORMATION1●Jei information1.
JEI_INFORMATION10●Jei information10.
JEI_INFORMATION11●Jei information11.
JEI_INFORMATION12●Jei information12.
JEI_INFORMATION13●Jei information13.
JEI_INFORMATION14●Jei information14.
JEI_INFORMATION15●Jei information15.
JEI_INFORMATION16●Jei information16.
JEI_INFORMATION17●Jei information17.
JEI_INFORMATION18●Jei information18.
JEI_INFORMATION19●Jei information19.
JEI_INFORMATION2●Jei information2.
JEI_INFORMATION20●Jei information20.
JEI_INFORMATION21●Jei information21.
JEI_INFORMATION22●Jei information22.
JEI_INFORMATION23●Jei information23.
JEI_INFORMATION24●Jei information24.
JEI_INFORMATION25●Jei information25.
JEI_INFORMATION26●Jei information26.
JEI_INFORMATION27●Jei information27.
JEI_INFORMATION28●Jei information28.
JEI_INFORMATION29●Jei information29.
JEI_INFORMATION3●Jei information3.
JEI_INFORMATION30●Jei information30.
JEI_INFORMATION4●Jei information4.
JEI_INFORMATION5●Jei information5.
JEI_INFORMATION6●Jei information6.
JEI_INFORMATION7●Jei information7.
JEI_INFORMATION8●Jei information8.
JEI_INFORMATION9●Jei information9.
JEI_INFORMATION_CATEGORY●Jei information category.
JOB_EXTRA_INFO_IDPK?●Identifier for the job extra info.
JOB_ID●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.
LEGISLATION_CODE●Code identifying the legislation.
OBJECT_VERSION_NUMBER●Optimistic-locking version number, incremented on each update.

Used by reports

No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.

Subject areas

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