Search Results pay_action_information




Here's a description of the PAY_ACTION_INFORMATION table in Oracle E-Business Suite (EBS):

PAY_ACTION_INFORMATION Table Overview:
- Purpose: Stores supplemental payroll-related information for payroll processing actions
- Module: Payroll (HR)
- Used for: Tracking additional details about payroll transactions and calculations

Key Columns:
1. ACTION_INFORMATION_ID (Primary Key)
- Unique identifier for each record
- Sequentially generated

2. PAYROLL_ACTION_ID
- Links to the specific payroll action
- Foreign key to PAY_PAYROLL_ACTIONS table

3. ACTION_INFORMATION_CATEGORY
- Categorizes the type of information
- Examples: 'BALANCE', 'EARNINGS', 'DEDUCTIONS'

4. ACTION_INFORMATION_TYPE
- Specifies the specific type of information within a category
- Used to classify detailed information

5. TAX_UNIT_ID
- Identifies the tax unit associated with the action

6. ASSIGNMENT_ID
- Links to the specific employee assignment

7. ELEMENT_ENTRY_VALUE
- Stores numeric or monetary values related to the action

8. ELEMENT_TYPE_ID
- Identifies the element type for the action

9. EFFECTIVE_DATE
- Date when the information becomes effective

Additional Characteristics:
- Supports flexible tracking of payroll-related information
- Used extensively in payroll processing and reporting
- Can store custom or standard payroll action details

Typical Use Cases:
- Tracking earnings and deductions
- Storing balance information
- Supporting tax and compliance reporting
- Capturing supplemental payroll transaction details