Search Results pay_status_processing_rules_f

Overview

The PAY_STATUS_PROCESSING_RULES_F table is a core configuration table within the Oracle E-Business Suite Payroll module (PAY). It defines the rules that govern whether a payroll element can be processed for an assignment based on its current status. This table is date-effective, as indicated by the '_F' suffix and the presence of EFFECTIVE_START_DATE and EFFECTIVE_END_DATE columns, allowing rules to be maintained over time. Its primary role is to enforce business logic by linking specific element types to permissible assignment statuses, thereby controlling payroll processing eligibility and ensuring compliance with legislative or organizational policies.

Key Information Stored

The table's structure centers on establishing relationships between key payroll entities and defining the associated rule. The primary identifier is the STATUS_PROCESSING_RULE_ID. The most critical columns for defining the rule's scope are ELEMENT_TYPE_ID, which references the payroll element, and ASSIGNMENT_STATUS_TYPE_ID, which references a valid assignment status. The rule's applicability is further scoped by BUSINESS_GROUP_ID and LEGISLATION_CODE. The PROCESSING_RULE column holds the core logic, typically specifying if the element is 'PROCESSABLE' or 'EXCLUDED' for the given status. The date-effective columns manage the rule's validity period, and standard WHO columns (not listed but typically present) track creation and modification metadata.

Common Use Cases and Queries

A primary use case is validating an element's processability during payroll runs. For example, a 'Sick Pay' element may be configured as 'EXCLUDED' for an assignment with a 'Terminated' status. System administrators use this table to audit or troubleshoot payroll validation errors. Common queries include listing all rules for a specific element or status, and identifying active rules within a business group. A sample SQL pattern to find active processing rules for a specific element type would be:

• SELECT pspr.assignment_status_type_id, pspr.processing_rule
• FROM pay_status_processing_rules_f pspr
• WHERE pspr.element_type_id = :p_element_type_id
• AND SYSDATE BETWEEN pspr.effective_start_date AND pspr.effective_end_date;

Reporting use cases often involve joining to PER_ASSIGNMENT_STATUS_TYPES and PAY_ELEMENT_TYPES_F to display meaningful names for IDs.

Related Objects

This table has direct foreign key relationships and logical dependencies with several other HR and Payroll objects. As per the metadata, it has a foreign key to PER_ASSIGNMENT_STATUS_TYPES on the ASSIGNMENT_STATUS_TYPE_ID column. It also implicitly references PAY_ELEMENT_TYPES_F via the ELEMENT_TYPE_ID. The primary keys ensure unique rule definitions. The table is central to the payroll validation engine and is likely referenced by internal Payroll APIs and processes that determine element eligibility. Key related objects include:

• PER_ASSIGNMENT_STATUS_TYPES: Provides the valid statuses referenced in the rules.
• PAY_ELEMENT_TYPES_F: Defines the payroll elements controlled by the rules.
• Business Group and Legislation tables, which provide context for the BUSINESS_GROUP_ID and LEGISLATION_CODE scoping.