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

PAY_ELEMENT_TYPES_F

PayrollUsed in 0 subject areas182 reporting columnsBICC incremental-ready

Payroll (PAY).

Likely primary key: ELEMENT_TYPE_CODE, EFFECTIVE_START_DATE (inferred from Oracle naming conventions, verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE
Joins (inferred from key columns): FORMULA_ID → FF_FORMULAS_VL · LEGISLATIVE_DATA_GROUP_ID → PER_LEGISLATIVE_DATA_GROUPS

Columns

ColumnKeyIn reportsDescription (inferred)
ADDITIONAL_ENTRY_ALLOWED_FLAG●Indicator (Y/N) for the additional entry allowed.
ADJUSTMENT_ONLY_FLAG●Indicator (Y/N) for the adjustment only.
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.
BASE_ELEMENT_NAME●Name of the base element.
CALCULATION_FORMULA_ID●Identifier for the calculation formula.
CLASSIFICATION_ID●Identifier for the classification.
CLOSED_FOR_ENTRY_FLAG●Indicator (Y/N) for the closed for entry.
CREATED_BY●User who created the row.
CREATION_DATE●Date and time the row was created.
CREATOR_TYPE●Type of creator.
DEDUCTION_OR_EXEMPTION●Deduction or exemption.
DEDUCTION_TYPE_ID●Identifier for the deduction type.
DEFAULTING_FORMULA_ID●Identifier for the defaulting formula.
EFFECTIVE_END_DATE●End date of the effective-dated record.
EFFECTIVE_START_DATEPK?●Start date of the effective-dated record.
ELEMENT_INFORMATION1●Element information1.
ELEMENT_INFORMATION10●Element information10.
ELEMENT_INFORMATION11●Element information11.
ELEMENT_INFORMATION12●Element information12.
ELEMENT_INFORMATION13●Element information13.
ELEMENT_INFORMATION14●Element information14.
ELEMENT_INFORMATION15●Element information15.
ELEMENT_INFORMATION16●Element information16.
ELEMENT_INFORMATION17●Element information17.
ELEMENT_INFORMATION18●Element information18.
ELEMENT_INFORMATION19●Element information19.
ELEMENT_INFORMATION2●Element information2.
ELEMENT_INFORMATION20●Element information20.
ELEMENT_INFORMATION21●Element information21.
ELEMENT_INFORMATION22●Element information22.
ELEMENT_INFORMATION23●Element information23.
ELEMENT_INFORMATION24●Element information24.
ELEMENT_INFORMATION25●Element information25.
ELEMENT_INFORMATION26●Element information26.
ELEMENT_INFORMATION27●Element information27.
ELEMENT_INFORMATION28●Element information28.
ELEMENT_INFORMATION29●Element information29.
ELEMENT_INFORMATION3●Element information3.
ELEMENT_INFORMATION30●Element information30.
ELEMENT_INFORMATION4●Element information4.
ELEMENT_INFORMATION5●Element information5.
ELEMENT_INFORMATION6●Element information6.
ELEMENT_INFORMATION7●Element information7.
ELEMENT_INFORMATION8●Element information8.
ELEMENT_INFORMATION9●Element information9.
ELEMENT_INFORMATION_CATEGORY●Element information category.
ELEMENT_INFORMATION_DATE1●Element information date1.
ELEMENT_INFORMATION_DATE10●Element information date10.
ELEMENT_INFORMATION_DATE11●Element information date11.
ELEMENT_INFORMATION_DATE12●Element information date12.
ELEMENT_INFORMATION_DATE13●Element information date13.
ELEMENT_INFORMATION_DATE14●Element information date14.
ELEMENT_INFORMATION_DATE15●Element information date15.
ELEMENT_INFORMATION_DATE2●Element information date2.
ELEMENT_INFORMATION_DATE3●Element information date3.
ELEMENT_INFORMATION_DATE4●Element information date4.
ELEMENT_INFORMATION_DATE5●Element information date5.
ELEMENT_INFORMATION_DATE6●Element information date6.
ELEMENT_INFORMATION_DATE7●Element information date7.
ELEMENT_INFORMATION_DATE8●Element information date8.
ELEMENT_INFORMATION_DATE9●Element information date9.
ELEMENT_INFORMATION_NUMBER1●Element information number1.
ELEMENT_INFORMATION_NUMBER10●Element information number10.
ELEMENT_INFORMATION_NUMBER11●Element information number11.
ELEMENT_INFORMATION_NUMBER12●Element information number12.
ELEMENT_INFORMATION_NUMBER13●Element information number13.
ELEMENT_INFORMATION_NUMBER14●Element information number14.
ELEMENT_INFORMATION_NUMBER15●Element information number15.
ELEMENT_INFORMATION_NUMBER16●Element information number16.
ELEMENT_INFORMATION_NUMBER17●Element information number17.
ELEMENT_INFORMATION_NUMBER18●Element information number18.
ELEMENT_INFORMATION_NUMBER19●Element information number19.
ELEMENT_INFORMATION_NUMBER2●Element information number2.
ELEMENT_INFORMATION_NUMBER20●Element information number20.
ELEMENT_INFORMATION_NUMBER3●Element information number3.
ELEMENT_INFORMATION_NUMBER4●Element information number4.
ELEMENT_INFORMATION_NUMBER5●Element information number5.
ELEMENT_INFORMATION_NUMBER6●Element information number6.
ELEMENT_INFORMATION_NUMBER7●Element information number7.
ELEMENT_INFORMATION_NUMBER8●Element information number8.
ELEMENT_INFORMATION_NUMBER9●Element information number9.
ELEMENT_TYPE_CODEPK?○Code identifying the element type.
ELEMENT_TYPE_ID●Identifier for the element type.
ENDING_TIME_DEF_ID●Identifier for the ending time def.
FORMULA_ID●Identifier for the formula.
GROSSUP_FLAG●Indicator (Y/N) for the grossup.
INDIRECT_ONLY_FLAG●Indicator (Y/N) for the indirect only.
INPUT_CURRENCY_CODE●Currency code for the input.
ITERATIVE_FLAG●Indicator (Y/N) for the iterative.
ITERATIVE_FORMULA_ID●Identifier for the iterative formula.
ITERATIVE_PRIORITY●Iterative priority.
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.
LEGISLATIVE_DATA_GROUP_ID●Identifier for the legislative data group.
MODULE_ID●Identifier for the module.
MULTIPLE_ENTRIES_ALLOWED_FLAG●Indicator (Y/N) for the multiple entries allowed.
OBJECT_VERSION_NUMBER●Optimistic-locking version number, incremented on each update.
ONCE_EACH_PERIOD_FLAG●Indicator (Y/N) for the once each period.
OUTPUT_CURRENCY_CODE●Currency code for the output.
PROCESSING_PRIORITY●Processing priority.
PROCESSING_TYPE●Type of processing.
PROCESS_IN_RUN_FLAG●Indicator (Y/N) for the process in run.
PROCESS_MODE●Process mode.
PRORATION_FORMULA_ID●Identifier for the proration formula.
PRORATION_GROUP_ID●Identifier for the proration group.
RECALC_EVENT_GROUP_ID●Identifier for the recalc event group.
SECONDARY_CLASSIFICATION_ID●Identifier for the secondary classification.
STANDARD_LINK_FLAG●Indicator (Y/N) for the standard link.
STARTING_TIME_DEF_ID●Identifier for the starting time def.
TIME_DEFINITION_ID●Identifier for the time definition.
TIME_DEFINITION_TYPE●Type of time definition.
USE_AT_ASG_LEVEL●Use at asg level.
USE_AT_REL_LEVEL●Use at rel level.
USE_AT_TERM_LEVEL●Use at term level.
VALIDATION_FORMULA_ID●Identifier for the validation formula.
VALIDATION_OVERRIDE_MESSAGE●Validation override message.

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_TYPES_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