Search Results psp_element_type_accounts




Overview
Explore in AI Chat

Overview

The PSP_ELEMENT_TYPE_ACCOUNTS table is a core data structure within the Oracle E-Business Suite (EBS) Labor Distribution module (PSP). It serves as the central repository for defining and storing the default accounting flexfield (AFF) combinations and project-related attributes associated with global earning elements. Its primary role is to provide the pre-defined, system-level account mappings used to automatically charge labor costs during the payroll distribution process. By linking an earning element type to specific General Ledger accounts and optional project details, this table ensures labor expenses are consistently and accurately posted to the correct financial and project accounting segments, forming the foundation for automated labor costing.

Key Information Stored

The table's structure captures the relationship between an earning element and its financial destination. The key columns include the surrogate primary key, ELEMENT_ACCOUNT_ID, and the unique identifier ELEMENT_TYPE_ID, which links to the PSP_ELEMENT_TYPES table. The core accounting data is held in GL_CODE_COMBINATION_ID, which stores the specific AFF combination for the charge account. For project-related labor charges, critical project accounting columns are PROJECT_ID, TASK_ID, AWARD_ID, EXPENDITURE_TYPE, and EXPENDITURE_ORGANIZATION_ID. The START_DATE_ACTIVE column enables the effective-dating of account assignments, allowing mappings to be updated over time. The SET_OF_BOOKS_ID, referenced via a foreign key, ensures the account combination is valid for the correct ledger.

Common Use Cases and Queries

A primary use case is troubleshooting labor distribution errors or validating the default accounts used for payroll runs. Analysts frequently query this table to audit or report on the configured account mappings for a set of element types. A common pattern is joining to element and code combination descriptions for readability.

  • Sample Query for Account Mapping:
    SELECT peta.element_type_id, pet.element_name, peta.gl_code_combination_id, gcc.concatenated_segments, peta.project_id, peta.expenditure_type FROM psp_element_type_accounts peta, psp_element_types pet, gl_code_combinations gcc WHERE peta.element_type_id = pet.element_type_id AND peta.gl_code_combination_id = gcc.code_combination_id AND SYSDATE BETWEEN peta.start_date_active AND NVL(peta.end_date_active, SYSDATE) ORDER BY pet.element_name;
  • Integration Point: During the "Transfer to GL" process, the PSP_DISTRIBUTION_LINES table uses the ELEMENT_ACCOUNT_ID from this table to determine the accounting lines for journal import.

Related Objects

PSP_ELEMENT_TYPE_ACCOUNTS sits at the center of a key relationship network. It is a child of PSP_ELEMENT_TYPES, defining accounts for each global element. Its GL_CODE_COMBINATION_ID validates against GL_CODE_COMBINATIONS, and its SET_OF_BOOKS_ID validates against GL_SETS_OF_BOOKS. For project accounting, it references PA_PROJECTS_ALL, PA_TASKS, PA_EXPENDITURE_TYPES, and HR_ALL_ORGANIZATION_UNITS. Most critically, it is the parent table for PSP_DISTRIBUTION_LINES and PSP_DISTRIBUTION_LINES_HISTORY; these tables store the actual labor distribution details that consume the predefined account rules established here. This relationship is the operational link between payroll earnings and financial/post-award accounting.