Search Results pay_payment_types

Overview

The PAY_PAYMENT_TYPES table is a core reference table within the Oracle E-Business Suite Payroll module (PAY). It serves as a master repository for defining the distinct categories of payments that the payroll system is capable of processing. Its primary role is to provide a standardized, validated list of payment types, such as Regular Salary, Bonus, Expense Reimbursement, or Advance, which are then referenced by transactional and configuration objects throughout the payroll engine. This ensures consistency in payment classification and reporting across all payroll operations.

Key Information Stored

The table's structure is designed to uniquely identify and describe each valid payment type. The critical columns, as indicated by the provided primary and unique key constraints, are PAYMENT_TYPE_ID and the combination of PAYMENT_TYPE_NAME and TERRITORY_CODE. The PAYMENT_TYPE_ID is the system-assigned numeric primary key used for all internal joins and references. The PAYMENT_TYPE_NAME holds the descriptive name of the payment type (e.g., 'Regular'), while the TERRITORY_CODE allows for localization, enabling the definition of territory-specific payment types to comply with regional legislative requirements. Other typical columns, inferred from standard practice, would include CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY for auditing purposes.

Common Use Cases and Queries

This table is fundamental for payroll setup, execution, and reporting. A common use case is validating or listing all available payment types during the configuration of an organization's payment methods or when defining element links. For reporting, it is frequently joined to transactional tables to categorize payment amounts. A typical query retrieves all payment types for a specific territory:

• SELECT payment_type_id, payment_type_name FROM pay_payment_types WHERE territory_code = 'US' ORDER BY payment_type_name;

Another critical query involves joining to PAY_PAYROLL_ACTIONS to analyze payroll runs by payment type, helping to segregate regular payroll from off-cycle or supplemental runs for reconciliation purposes.

Related Objects

The PAY_PAYMENT_TYPES table has documented foreign key relationships with several key transactional and setup tables, as per the provided metadata. These relationships are central to the payroll data model:

• PAY_ORG_PAYMENT_METHODS_F: This table stores the valid payment methods (e.g., Check, Direct Deposit) for an organization. It references PAY_PAYMENT_TYPES via PAYMENT_TYPE_ID to restrict which payment methods are applicable for a given type of payment.
• PAY_PAYROLL_ACTIONS: This is a fundamental transactional table that records every payroll process run. Each payroll action (such as a QuickPay or a regular payroll run) is associated with a specific PAYMENT_TYPE_ID from this table, classifying the nature of the payments generated by that action.

These relationships enforce data integrity, ensuring that all configured methods and processed payroll actions are tied to a valid, predefined payment type.