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

PAY_ELEMENT_ENTRIES_F

PayrollUsed in 0 subject areas155 reporting columnsBICC incremental-ready

Payroll (PAY).

Primary key: not yet catalogued for PAY_ELEMENT_ENTRIES_F, reference Oracle Tables & Views guide. · Incremental key: LAST_UPDATE_DATE

Columns

ColumnKeyIn reportsDescription (inferred)
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.
BALANCE_ADJ_COST_FLAG●Indicator (Y/N) for the balance adj cost.
BATCH_ACTION_ID●Identifier for the batch action.
BATCH_ID●Identifier for the batch.
CREATED_BY●User who created the row.
CREATION_DATE●Date and time the row was created.
CREATOR_ID●Identifier for the creator.
CREATOR_TYPE●Type of creator.
DATE_EARNED●Date earned.
EFFECTIVE_END_DATE●End date of the effective-dated record.
EFFECTIVE_START_DATE●Start date of the effective-dated record.
ELEMENT_ENTRY_ID●Identifier for the element entry.
ELEMENT_TYPE_ID●Identifier for the element type.
ENTERPRISE_ID●Identifier for the enterprise.
ENTRY_INFORMATION1●Entry information1.
ENTRY_INFORMATION10●Entry information10.
ENTRY_INFORMATION11●Entry information11.
ENTRY_INFORMATION12●Entry information12.
ENTRY_INFORMATION13●Entry information13.
ENTRY_INFORMATION14●Entry information14.
ENTRY_INFORMATION15●Entry information15.
ENTRY_INFORMATION16●Entry information16.
ENTRY_INFORMATION17●Entry information17.
ENTRY_INFORMATION18●Entry information18.
ENTRY_INFORMATION19●Entry information19.
ENTRY_INFORMATION2●Entry information2.
ENTRY_INFORMATION20●Entry information20.
ENTRY_INFORMATION21●Entry information21.
ENTRY_INFORMATION22●Entry information22.
ENTRY_INFORMATION23●Entry information23.
ENTRY_INFORMATION24●Entry information24.
ENTRY_INFORMATION25●Entry information25.
ENTRY_INFORMATION26●Entry information26.
ENTRY_INFORMATION27●Entry information27.
ENTRY_INFORMATION28●Entry information28.
ENTRY_INFORMATION29●Entry information29.
ENTRY_INFORMATION3●Entry information3.
ENTRY_INFORMATION30●Entry information30.
ENTRY_INFORMATION4●Entry information4.
ENTRY_INFORMATION5●Entry information5.
ENTRY_INFORMATION6●Entry information6.
ENTRY_INFORMATION7●Entry information7.
ENTRY_INFORMATION8●Entry information8.
ENTRY_INFORMATION9●Entry information9.
ENTRY_INFORMATION_CATEGORY●Entry information category.
ENTRY_INFORMATION_DATE1●Entry information date1.
ENTRY_INFORMATION_DATE10●Entry information date10.
ENTRY_INFORMATION_DATE11●Entry information date11.
ENTRY_INFORMATION_DATE12●Entry information date12.
ENTRY_INFORMATION_DATE13●Entry information date13.
ENTRY_INFORMATION_DATE14●Entry information date14.
ENTRY_INFORMATION_DATE15●Entry information date15.
ENTRY_INFORMATION_DATE2●Entry information date2.
ENTRY_INFORMATION_DATE3●Entry information date3.
ENTRY_INFORMATION_DATE4●Entry information date4.
ENTRY_INFORMATION_DATE5●Entry information date5.
ENTRY_INFORMATION_DATE6●Entry information date6.
ENTRY_INFORMATION_DATE7●Entry information date7.
ENTRY_INFORMATION_DATE8●Entry information date8.
ENTRY_INFORMATION_DATE9●Entry information date9.
ENTRY_INFORMATION_NUMBER1●Entry information number1.
ENTRY_INFORMATION_NUMBER10●Entry information number10.
ENTRY_INFORMATION_NUMBER11●Entry information number11.
ENTRY_INFORMATION_NUMBER12●Entry information number12.
ENTRY_INFORMATION_NUMBER13●Entry information number13.
ENTRY_INFORMATION_NUMBER14●Entry information number14.
ENTRY_INFORMATION_NUMBER15●Entry information number15.
ENTRY_INFORMATION_NUMBER16●Entry information number16.
ENTRY_INFORMATION_NUMBER17●Entry information number17.
ENTRY_INFORMATION_NUMBER18●Entry information number18.
ENTRY_INFORMATION_NUMBER19●Entry information number19.
ENTRY_INFORMATION_NUMBER2●Entry information number2.
ENTRY_INFORMATION_NUMBER20●Entry information number20.
ENTRY_INFORMATION_NUMBER3●Entry information number3.
ENTRY_INFORMATION_NUMBER4●Entry information number4.
ENTRY_INFORMATION_NUMBER5●Entry information number5.
ENTRY_INFORMATION_NUMBER6●Entry information number6.
ENTRY_INFORMATION_NUMBER7●Entry information number7.
ENTRY_INFORMATION_NUMBER8●Entry information number8.
ENTRY_INFORMATION_NUMBER9●Entry information number9.
ENTRY_TYPE●Type of entry.
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.
MULTIPLE_ENTRY_COUNT●Multiple entry count.
OBJECT_VERSION_NUMBER●Optimistic-locking version number, incremented on each update.
PERSON_ID●Identifier for the person.
REASON●Reason.
SUBPRIORITY●Subpriority.
TARGET_ENTRY_ID●Identifier for the target entry.

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 PAY_ELEMENT_ENTRIES_F?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us
Problems that run through this table
The report that lies quietly · Approval history vanishes · What the extract does not carry