Results for “psb_cost_distributions_i”

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

Overview

PSB_COST_DISTRIBUTIONS_I is an interface (staging) table owned by the PSB schema within the Oracle E-Business Suite Public Sector Budgeting module. In Oracle EBS 12.1.1 and 12.2.2, it serves as the inbound staging structure for position salary cost distributions — the record set that assigns a position or assignment's salary cost across accounts, projects, tasks, awards, and expenditure types using a proportion split. Records are loaded into this interface, validated and processed by Public Sector Budgeting concurrent programs, and then written to the corresponding production distribution tables.

The table maps cleanly to a Data Vault satellite-leaning classification, as suggested by the mined foreign-key structure. The composite grain of DATA_EXTRACT_ID plus ASSIGNMENT_ID represents a descriptive, time-variant attribute set attached to a parent business key, rather than a hub or a pure link. Under a Data Vault model, DATA_EXTRACT_ID would function as the driving hub reference, while the distribution, allocation, and segment columns belong to a satellite.

Key Information Stored

The table documents 50 columns in the 12.1.1 physical schema. The most significant are:

• DATA_EXTRACT_ID — foreign key to PSB_DATA_EXTRACTS; the batch or extract that owns this distribution row. This effectively acts as the surrogate key in the interface load context.
• ASSIGNMENT_ID — the position or assignment whose salary is being distributed; the primary business-key candidate alongside DATA_EXTRACT_ID.
• BUSINESS_GROUP_ID — the HR business group that scopes the assignment.
• COSTING_LEVEL — identifies at what level the cost distribution applies.
• PROPORTION — the percentage or fractional share allocated to this distribution line.
• CHART_OF_ACCOUNTS_ID and COST_ALLOCATION_KEYFLEX_ID — reference the accounting flexfield and cost allocation keyflex structures that carry the account combination.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — date-range validity for the distribution line.
• PROJECT_ID, TASK_ID, AWARD_ID — project, task, and award context, supporting both Projects and Grants accounting.
• EXPENDITURE_TYPE and EXPENDITURE_ORGANIZATION_ID — expenditure categorization and the owning organization for the spend.
• SEGMENT1 through SEGMENT30 — the accounting flexfield segments denormalized into the interface for direct validation and transfer to GL.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE — standard EBS audit columns.

Common Use Cases and Queries

Typical uses include verifying distribution completeness before import, reconciling proportions per assignment, and reporting on award or project funding splits. A representative query sums the allocated proportion per assignment to detect incomplete distributions:

• SELECT assignment_id, SUM(proportion) FROM psb.psb_cost_distributions_i GROUP BY assignment_id HAVING SUM(proportion) <> 1;
• Join to PSB_DATA_EXTRACTS to identify which extract batch introduced a set of rows, using DATA_EXTRACT_ID.
• Join to IGF_AW_AWARD_ALL on AWARD_ID to report award-funded salary distributions.
• Join to PAY_COST_ALLOCATION_KEYFLEX on COST_ALLOCATION_KEYFLEX_ID to reconstruct the cost allocation structure.

Related Objects

• PSB_DATA_EXTRACTS — parent extract batch, joined on DATA_EXTRACT_ID.
• IGF_AW_AWARD_ALL — award header, joined on AWARD_ID.
• PAY_COST_ALLOCATION_KEYFLEX — cost allocation flexfield, joined on COST_ALLOCATION_KEYFLEX_ID.
• GL_MGT_SEG_UPGRADE_H — referenced through CHART_OF_ACCOUNTS_ID for management segment history.
• PER_ALL_ASSIGNMENTS_F — the HR assignment source for ASSIGNMENT_ID.
• PA_PROJECTS_ALL / PA_TASKS — project and task context via PROJECT_ID and TASK_ID.

These joins mirror the interface-to-production flow that Public Sector Budgeting uses to move staged position salary distributions into budget and accounting structures.