Search Results pay_element_types_f
Overview
The PAY_ELEMENT_TYPES_F table is the core repository for element definitions within Oracle E-Business Suite Payroll. It represents the fundamental building blocks of compensation and benefits, storing the master definitions for all earnings, deductions, employer liabilities, and non-payroll inputs used in payroll processing. As a date-effective table (indicated by the '_F' suffix and the EFFECTIVE_START_DATE and EFFECTIVE_END_DATE columns), it maintains a full history of changes to each element's definition over time, allowing for accurate retroactive processing and historical reporting. This table is central to the configuration and operation of the payroll engine, as every payroll calculation references the rules and attributes defined here for each applicable element.
Key Information Stored
The table's structure is designed to define an element's identity, classification, processing rules, and validity. The primary key is a composite of ELEMENT_TYPE_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE, ensuring unique identification of each element definition across time. Critical columns include ELEMENT_NAME, which, combined with BUSINESS_GROUP_ID, LEGISLATION_CODE, and the effective dates, forms a unique key (PAY_ELEMENT_TYPES_F_UK2). Other essential columns define an element's behavior: CLASSIFICATION_ID links to PAY_ELEMENT_CLASSIFICATIONS (e.g., Earnings, Voluntary Deductions), BENEFIT_CLASSIFICATION_ID links to BEN_BENEFIT_CLASSIFICATIONS for benefits-related elements, and PRORATION_GROUP_ID links to PAY_EVENT_GROUPS to control proration rules. Additional columns (implied by standard practice but not listed in the provided metadata) typically govern reporting, taxation, costing, and processing priorities.
Common Use Cases and Queries
This table is frequently queried for configuration audits, troubleshooting, and building custom payroll reports. A common use case is identifying all active elements for a specific business group and classification. A typical query pattern retrieves the current effective definition:
- SELECT element_name, classification_id, processing_type FROM pay_element_types_f WHERE SYSDATE BETWEEN effective_start_date AND effective_end_date AND business_group_id = &bg_id;
Another critical scenario involves analyzing historical changes to an element's definition for audit purposes, joining the table to itself on ELEMENT_TYPE_ID across different effective date ranges. Developers use this table to validate element existence and attributes before creating element entries via the PAY_ELEMENT_ENTRIES_API or during custom fast formula execution. Reporting often joins PAY_ELEMENT_TYPES_F to transactional tables like PAY_RUN_RESULTS to present earnings or deductions with their descriptive names.
Related Objects
PAY_ELEMENT_TYPES_F sits at the center of a key data model. It has direct foreign key relationships to several configuration tables, as documented: PAY_ELEMENT_CLASSIFICATIONS, BEN_BENEFIT_CLASSIFICATIONS, and PAY_EVENT_GROUPS. It is the parent table for PAY_ELEMENT_ENTRIES_F, which stores instances of these elements assigned to employees. The table is heavily referenced by payroll calculation results in PAY_RUN_RESULTS. For custom development, the primary interface is the PAY_ELEMENT_TYPES_API package, which provides procedures for creating and maintaining element definitions. The standard view PAY_ELEMENT_TYPES_F_VL provides a translatable, user-friendly perspective on this data.
-
Table: PAY_ELEMENT_TYPES_F
12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_ELEMENT_TYPES_F, object_name:PAY_ELEMENT_TYPES_F, status:VALID, product: PAY - Payroll , description: Element definitions. , implementation_dba_data: HR.PAY_ELEMENT_TYPES_F ,
-
Table: PAY_ELEMENT_TYPES_F
12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_ELEMENT_TYPES_F, object_name:PAY_ELEMENT_TYPES_F, status:VALID, product: PAY - Payroll , description: Element definitions. , implementation_dba_data: HR.PAY_ELEMENT_TYPES_F ,
-
APPS.PAY_DK_HOLIDAY_PAY_PKG dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.PAY_PAYWSLEE_PKG dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.PQP_US_STUDENT_EARNINGS dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.PAY_KW_PIFSS_REPORT dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.HR_PTO_VIEWS dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.HR_PAY_INTERFACE_PKG dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.PAY_ELEMENT_TYPES_MIG dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.HRASSACT dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.HRI_OLTP_DISC_SALARY dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.PAY_PAYUSDED_XMLP_PKG dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.PAY_GB_RTI_FPS_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.HXT_TIM_COL_UTIL dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.PAY_QPI_API dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.PAY_GB_COURT_ORDER_UPGRADE dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.BEN_DM_UPLOAD_DK dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.PAY_US_VERTEX_INTERFACE dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.PAY_JP_ITAX_DPNT_INTERFACE_PKG dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.PQH_EMPLOYEE_SALARY dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.PAY_P45_PKG2 dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.HRDYNDBI dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.HXC_ABSENCE_TYPE_ALIAS dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.PAY_IP_BAL_UPL_STRUCT dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.SSP_APAD_PKG dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.PAY_FRR_DATA_PUMP dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.HXT_HXT956E_XMLP_PKG dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.PY_NO_TAX_CARD dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.PAY_GB_ENROLL_PENSION dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.PER_RI_CRP_DEFAULT_SETTINGS dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.PAY_JP_ITWB_ARCHIVE_PKG dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.PAY_CA_PAYREG_EXTRACT_PKG dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.PAY_KR_PAYSLIP_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.HR_AMEUTIL_SS dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.PAY_KR_WG_REPORT_PKG dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.PY_DK_TAX_CARD dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.PAY_US_TAXABILITY_RULES_PKG dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.PAY_KR_DIM_PKG dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.HXT_RETRO_MIX dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.PQP_USTIAA_PKG dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.PAY_GB_DEO dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.HXT_HXT956D_XMLP_PKG dependencies on PAY_ELEMENT_TYPES_F
12.2.2
-
APPS.PAY_US_USER_INIT_DEDN dependencies on PAY_ELEMENT_TYPES_F
12.1.1
-
APPS.PQP_NL_PGGM_TEMPLATE dependencies on PAY_ELEMENT_TYPES_F
12.1.1
-
APPS.PQP_GB_SS_ABSENCE_TEMPLATE dependencies on PAY_ELEMENT_TYPES_F
12.1.1
-
APPS.PAY_JP_CREATE_CMA_PKG dependencies on PAY_ELEMENT_TYPES_F
12.1.1
-
APPS.PQP_GB_TP_PENSION_EXTRACTS dependencies on PAY_ELEMENT_TYPES_F
12.1.1
-
APPS.PER_PAY_PROPOSALS_POPULATE dependencies on PAY_ELEMENT_TYPES_F
12.1.1