Results for “psb_position_pay_distributions”

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

Overview

PSB_POSITION_PAY_DISTRIBUTIONS is a Public Sector Budgeting (PSB) table that stores position cost distribution rules. It defines how the labor costs associated with a position are allocated across the accounting and project dimensions used during budget preparation. Each row captures a distribution line for a position, expressing the proportion of that position's pay cost that should be charged to a specific account combination, project, task, award, or expenditure type.

Because the table carries foreign keys to both PSB_POSITIONS and PSB_DATA_EXTRACTS, its role is fundamentally associative: it links positions to the distribution targets they are assigned within a given budgeting data extract. Applying Data Vault modeling heuristics to the documented foreign-key structure, this object is best classified as a link table. It resolves a many-to-many relationship between positions and their cost distribution destinations, and it is versioned in the sense that distribution rules carry effective start and end dates.

Key Information Stored

The surrogate primary key is DISTRIBUTION_ID, enforced by the constraint PSB_POSITION_PAY_DISTR_PK. The principal business keys are POSITION_ID, which references PSB_POSITIONS, and DATA_EXTRACT_ID, which references PSB_DATA_EXTRACTS. Together with the effective dating columns, these form the natural identity of a distribution rule within an extract.

• DISTRIBUTION_ID — surrogate primary key uniquely identifying each distribution rule.
• POSITION_ID — the position whose pay costs are being distributed.
• DATA_EXTRACT_ID — the budgeting data extract context for the rule.
• WORKSHEET_ID — the budget worksheet associated with the distribution.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — validity window for the rule.
• CHART_OF_ACCOUNTS_ID / CODE_COMBINATION_ID — the accounting flexfield target of the distribution.
• PROJECT_ID / TASK_ID / AWARD_ID — project accounting dimensions for the allocation.
• EXPENDITURE_TYPE — the expenditure category charged.
• DISTRIBUTION_PERCENT — the percentage of cost assigned to this line.
• GLOBAL_DEFAULT_FLAG / DISTRIBUTION_DEFAULT_RULE_ID — defaulting behavior and source rule.
• LAST_UPDATE_DATE / CREATED_BY / CREATION_DATE — standard audit columns.

Common Use Cases and Queries

The most common use is reporting the distribution of position costs across accounts and projects during budget preparation. A typical query joins distributions to positions and extracts to list active rules for a given extract:

• Retrieving all distribution lines for a position within an extract, joined on POSITION_ID and DATA_EXTRACT_ID.
• Validating that DISTRIBUTION_PERCENT values sum to 100 percent per position, a frequent budget integrity check.
• Reporting cost allocation by CODE_COMBINATION_ID, PROJECT_ID, or AWARD_ID for budget versus actual analysis.
• Filtering by EFFECTIVE_START_DATE and EFFECTIVE_END_DATE to isolate rules active for a fiscal period.
• Identifying rules flagged by GLOBAL_DEFAULT_FLAG for auditing default propagation.

A representative pattern selects from PSB_POSITION_PAY_DISTRIBUTIONS, filtering on POSITION_ID and DATA_EXTRACT_ID, and aggregating DISTRIBUTION_PERCENT grouped by CODE_COMBINATION_ID to confirm allocation completeness.

Related Objects

• PSB_POSITIONS — parent of POSITION_ID; the master position definition.
• PSB_DATA_EXTRACTS — parent of DATA_EXTRACT_ID; the extract that scopes the rule.
• PSB_DISTRIBUTION_DEFAULT_RULES — referenced by DISTRIBUTION_DEFAULT_RULE_ID for defaulting logic.
• PSB_WORKSHEETS — related through WORKSHEET_ID for budget worksheet context.
• GL_CODE_COMBINATIONS — provides valid account combinations for CODE_COMBINATION_ID.
• PA_PROJECTS / PA_TASKS / PA_AWARDS — supply project accounting dimension values.

These relationships position PSB_POSITION_PAY_DISTRIBUTIONS as the central allocation link within the Public Sector Budgeting position-costing model, connecting positions and extract contexts to accounting and project dimensions.