Results for “acct_group_id”

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

Overview

PSP_TEMP_ORIG_SUMLINES is a transient staging table owned by the PSP (Labor Distribution) schema in Oracle E-Business Suite. It stores labor distribution lines that have been grouped and summarized by General Ledger and Oracle Grants Management accounting attributes, acting as an intermediate work area between raw expenditure detail and the final summarized distribution rows. Each row represents a unique combination of a run identifier and an accounting group identifier, allowing the Labor Distribution engine to aggregate original charge lines before further processing, adjustment, or transfer into permanent distribution tables.

From a data modeling perspective, the metadata's heuristic Data Vault classification places this table as standalone. This is a modeling suggestion only: the table does not function as a strict hub, link, or satellite because it carries both descriptive context and transactional measures keyed by a run-scoped composite. The presence of a two-column primary key (RUN_ID, ACCT_GROUP_ID) suggests the table behaves more like a run-partitioned staging snapshot than a durable reference entity.

Key Information Stored

PSP_TEMP_ORIG_SUMLINES contains 27 documented columns. The most operationally significant include:

• RUN_ID — Identifier of the Labor Distribution run that produced the rows; part of the primary key.
• ACCT_GROUP_ID — Grouping key for the summarized account set; the second half of the primary key.
• GL_CODE_COMBINATION_ID — The General Ledger code combination to which the grouping applies.
• PROJECT_ID, TASK_ID, AWARD_ID — Project, task, and award context from Grants Management.
• EXPENDITURE_ORGANIZATION_ID and EXPENDITURE_TYPE — The expenditure org and type defining the summarized charges.
• DISTRIBUTION_SUM — The aggregated distribution amount for the group.
• SET_OF_BOOKS_ID and BUSINESS_GROUP_ID — Ledger and business group ownership of the summarized lines.
• DR_CR_FLAG — Debit/credit indicator for the summarized amount.
• ELEMENT_TYPE_ID, ELEMENT_GROUP_ID, ADJ_SET_NUMBER — Payroll element context and adjustment set linkage.
• ADJSET_FREEZE_FLAG — Indicates whether the summarized line is frozen from further adjustment.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE10 — Descriptive flexfield columns available for extension.

The surrogate primary key is PSP_TEMP_ORIG_SUMLINES_PK (RUN_ID, ACCT_GROUP_ID). A unique index, PSP_TEMP_ORIG_SUMLINES_U1, exists on the same columns, confirming that this composite is the only documented business-key candidate; no separate single-column surrogate is exposed in the metadata.

Common Use Cases and Queries

Typical scenarios include validating summarized labor distribution output, reconciling GL/grants groupings against raw detail, and diagnosing runs that produced unexpected distributions.

SELECT run_id, acct_group_id, gl_code_combination_id,
       project_id, task_id, award_id, distribution_sum
FROM   psp.psp_temp_orig_sumlines
WHERE  run_id = :p_run_id
ORDER  BY acct_group_id;

Aggregation by ledger and account group supports financial reporting:

SELECT set_of_books_id, acct_group_id,
       SUM(DECODE(dr_cred_flag, 'C', -1, 1) * distribution_sum) net_amount
FROM   psp.psp_temp_orig_sumlines
GROUP  BY set_of_books_id, acct_group_id;

Joining to awards allows grant-level analysis, while joining to element groups supports payroll element reconciliation.

Related Objects

• IGF_AW_AWARD_ALL — joined on AWARD_ID to retrieve award attributes.
• PSP_ELEMENT_GROUPS — joined on ELEMENT_GROUP_ID to resolve element group definitions.
• PSP_TEMP_ORIG_SUMLINES_PK / _U1 — primary key and unique index enforcing the (RUN_ID, ACCT_GROUP_ID) uniqueness.
• GL_CODE_COMBINATIONS — joined on GL_CODE_COMBINATION_ID for chart of accounts detail.
• PA_PROJECTS_ALL / PA_TASKS — joined on PROJECT_ID and TASK_ID for project and task context.
• GL_SETS_OF_BOOKS — joined on SET_OF_BOOKS_ID to identify the ledger.