Results for “psp_element_type_accounts”

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

Overview

PSP_ELEMENT_TYPE_ACCOUNTS is a Labor Distribution (PSP) table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores global element accounts. It defines the accounting attributes associated with element types used by Oracle Labor Distribution to distribute labor costs to the General Ledger. Each row represents a valid accounting rule — a combination of element type, set of books, code combination, project, task, expenditure organization, expenditure type, and award — effective over a date range. This table is central to how Labor Distribution determines the debit and credit accounts for distributed payroll and labor transactions.

From a Data Vault modeling perspective, the FK structure suggests this object is satellite-leaning. It carries descriptive and effective-dated accounting attributes (code combination, percent, start and end dates) tied to an element type hub and to dimension hubs such as projects, tasks, organizations, and awards. The heuristic classification should be read as a modeling suggestion rather than a documented Oracle construct.

Key Information Stored

The table contains 37 documented columns. The most significant are:

• ELEMENT_ACCOUNT_ID — surrogate primary key (PSP_ELEMENT_TYPE_ACCOUNTS_PK / unique index U1), the value propagated to distribution and encumbrance lines.
• ELEMENT_TYPE_ID — foreign key to PSP_ELEMENT_TYPES identifying the element type the account rule applies to.
• START_DATE_ACTIVE / END_DATE_ACTIVE — effective dating for the account rule.
• SET_OF_BOOKS_ID — the ledger the accounting rule belongs to (GL_SETS_OF_BOOKS).
• GL_CODE_COMBINATION_ID — the accounting flexfield combination charged or credited (GL_CODE_COMBINATIONS).
• PROJECT_ID, TASK_ID, EXPENDITURE_TYPE — project, task, and expenditure type dimensions (PA_PROJECTS_ALL, PA_TASKS, PA_EXPENDITURE_TYPES).
• EXPENDITURE_ORGANIZATION_ID — the expenditure organization (HR_ALL_ORGANIZATION_UNITS).
• AWARD_ID — grants award linkage (IGF_AW_AWARD_ALL).
• PERCENT — split percentage applied to the rule.
• BUSINESS_GROUP_ID and the WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) — standard multi-org security and audit tracking.
• POETA_START_DATE / POETA_END_DATE — additional effective dating specific to the element account rule.

Common Use Cases and Queries

Typical uses include validating that every distribution line resolves to an active account rule, reconciling Labor Distribution output to GL, and auditing overlapping or expired rules.

• List active rules for an element type: SELECT * FROM psp_element_type_accounts WHERE element_type_id = :id AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE).
• Join to distribution lines to confirm account resolution: SELECT d.*, a.gl_code_combination_id FROM psp_distribution_lines d, psp_element_type_accounts a WHERE d.element_account_id = a.element_account_id.
• Detect date-range overlaps per element type/ledger for a given code combination.
• Report rules by project, task, or award for grants and project costing analysis.

Related Objects

• PSP_ELEMENT_TYPES — joined on ELEMENT_TYPE_ID; parent of the element hierarchy.
• PSP_DISTRIBUTION_LINES and PSP_DISTRIBUTION_LINES_HISTORY — reference ELEMENT_ACCOUNT_ID, consuming the resolved accounts.
• PSP_ENC_LINES, PSP_ENC_LINES_HISTORY, and archived variants (PSP_ENC_LINES_ARCH, PSP_DISTRIBUTION_LINES_ARCH) — encumbrance and historical line references.
• GL_CODE_COMBINATIONS and GL_SETS_OF_BOOKS — provide the accounting flexfield and ledger context.
• PA_PROJECTS_ALL, PA_TASKS, PA_EXPENDITURE_TYPES, HR_ALL_ORGANIZATION_UNITS, and IGF_AW_AWARD_ALL — the project, task, expenditure, organization, and award dimensions referenced by each rule.