Results for “costable_flag”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PAY_ELEMENT_CLASSIFICATIONS is a core configuration table in the Oracle EBS Payroll (PAY) module, owned by the HR schema. It stores the element classifications that Oracle Payroll uses for legislative compliance and information reporting needs. In payroll terminology, an element classification is the highest-level grouping applied to an element (the building block used to represent earnings, deductions, and other payroll components). Classifications drive system behavior: they determine the balances an element feeds, the taxability rules applied to it, whether it is costable or distributable, and whether it qualifies as a payment. Because of this, PAY_ELEMENT_CLASSIFICATIONS sits at the center of the payroll rules engine and is referenced by numerous rule and configuration tables.

In Data Vault modeling terms, the FK relationship structure suggests that PAY_ELEMENT_CLASSIFICATIONS should be classified as a hub. It holds the stable business key and identity of each element classification, and is referenced from many dependent tables rather than aggregating transactions itself.

Key Information Stored

Each row represents a single element classification, scoped to a business group and legislation. The most significant columns include:

• CLASSIFICATION_ID — surrogate primary key (PAY_ELEMENT_CLASSIFICATION_PK).
• CLASSIFICATION_NAME — the business identifier for the classification (e.g., Earnings, Deduction, Balance Initialization). Combined with BUSINESS_GROUP_ID, LEGISLATION_CODE, and ZD_EDITION_NAME in the unique key PAY_ELEMENT_CLASSIFICATION_UK2.
• BUSINESS_GROUP_ID — the enterprise/legislative business group owning the classification.
• LEGISLATION_CODE — the country/legislation the classification applies to.
• DESCRIPTION — free-text explanation of the classification's purpose.
• PARENT_CLASSIFICATION_ID — self-referencing FK enabling hierarchical groupings of classifications.
• COSTABLE_FLAG, DISTRIBUTABLE_OVER_FLAG, NON_PAYMENTS_FLAG, BALANCE_INITIALIZATION_FLAG, CREATE_BY_DEFAULT_FLAG — behavioral flags controlling costing, distribution, payment treatment, balance initialization, and default creation.
• COSTING_DEBIT_OR_CREDIT — indicates the debit/credit side for costing entries.
• DEFAULT_HIGH_PRIORITY, DEFAULT_LOW_PRIORITY, DEFAULT_PRIORITY — priority settings applied by default to elements of this classification.
• FREQ_RULE_ENABLED — controls frequency rule processing.
• LEGISLATION_SUBGROUP — further subdivides classifications within a legislation.
• Standard WHO/audit columns: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE, OBJECT_VERSION_NUMBER, and ZD_EDITION_NAME (supporting edition-based redefinition in 12.2).

Common Use Cases and Queries

Typical uses include auditing classification configuration, building element-to-balance impact reports, and troubleshooting why an element behaves a certain way (costing, taxability, payment status). A common query lists classifications for a legislation:

• List classifications by legislation: SELECT classification_id, classification_name, legislation_code, costable_flag FROM pay_element_classifications WHERE legislation_code = :leg AND business_group_id = :bg;
• Find elements by classification: join to PAY_ELEMENT_TYPES_F on CLASSIFICATION_ID.
• Trace balance mapping: join to PAY_BALANCE_CLASSIFICATIONS on CLASSIFICATION_ID to see which balances feed from a classification.
• Review hierarchy: self-join via PARENT_CLASSIFICATION_ID to render parent/child classification trees.
• Taxability audit: join to PAY_TAXABILITY_RULES on CLASSIFICATION_ID or SECONDARY_CLASSIFICATION_ID.

These queries are frequently embedded in Fast Formulas diagnostics, costing reconciliation reports, and payroll implementation health checks.

Related Objects

PAY_ELEMENT_CLASSIFICATIONS is heavily referenced across the payroll schema. The most significant dependent objects, with join columns, are:

• PAY_ELEMENT_TYPES_F (CLASSIFICATION_ID) — links each element to its classification.
• PAY_BALANCE_CLASSIFICATIONS (CLASSIFICATION_ID) — maps classifications to balance feeds.
• PAY_ELE_CLASSIFICATION_RULES (CLASSIFICATION_ID) — defines rules applied at classification level.
• PAY_SUB_CLASSIFICATION_RULES_F (CLASSIFICATION_ID) — governs sub-classification logic.
• PAY_TAXABILITY_RULES (CLASSIFICATION_ID, SECONDARY_CLASSIFICATION_ID) — taxability treatment per classification.
• PAY_MX_EARN_EXEMPTION_RULES_F (ELEMENT_CLASSIFICATION_ID) — Mexico-specific earning exemption rules.
• PAY_ELEMENT_CLASSIFICATIONS (PARENT_CLASSIFICATION_ID) — self-referential hierarchy.

Together these relationships establish PAY_ELEMENT_CLASSIFICATIONS as a foundational hub for payroll element, balance, and taxation configuration.