Skip to main content
OracleOps AI
← All tables
Oracle Fusion/HCM/Payroll

PAY_ELEMENT_TYPES_F

Element definitions — earnings, deductions and information elements, with their classification.

Key Columns

ELEMENT_TYPE_IDBASE_ELEMENT_NAMECLASSIFICATION_IDEFFECTIVE_START_DATELEGISLATIVE_DATA_GROUP_ID

Child Tables

PAY_ELEMENT_ENTRIES_F

Element entries — an element assigned to a person / assignment, driving what payroll picks up each period.

Common Joins

PAY_ELEMENT_ENTRIES_Fvia ELEMENT_TYPE_ID

The per-person entries assigned for this element.

Used In

PayrollCompensation

Related

Fusion Payroll run results data model

A payroll process is a payroll action (PAY_PAYROLL_ACTIONS) with a per-person row (PAY_PAYROLL_REL_ACTIONS) for each payroll relationship. Each element processed becomes a run result (PAY_RUN_RESULTS) whose numbers are in PAY_RUN_RESULT_VALUES. Elements are defined in PAY_ELEMENT_TYPES_F and assigned via PAY_ELEMENT_ENTRIES_F.

Ask Oracle AI about PAY_ELEMENT_TYPES_F