Results for “psp_pre_gen_dist_lines”

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

Overview

PSP_PRE_GEN_DIST_LINES is a key Oracle EBS table within the PSP (Labor Distribution) product module, which is part of the Oracle Time and Labor / Payroll / Projects integration stack. This table stores pre-generated distribution lines that have been calculated by the labor distribution process but have not yet been transferred to the General Ledger (GL) or Grants Accounting (IGF). It functions as a staging and holding area between the payroll costing process and the final accounting interface, allowing organizations to review, adjust, and validate labor cost distributions before they become permanent accounting entries.

From a Data Vault modeling perspective, this table would most appropriately be classified as a link entity, as it serves to connect multiple business entities — payroll controls, effort reports, projects, and GL code combinations — into a single transactional record representing a distribution event. Its structure includes numerous foreign key relationships that map directly to master and reference entities across the EBS schema.

Key Information Stored

The table contains 43 documented columns in the 12.2.2 schema. The most important columns include:

• PRE_GEN_DIST_LINE_ID — The surrogate primary key (PSP_PRE_GEN_DIST_LINES_PK) that uniquely identifies each distribution line. This is also the basis of the unique index PSP_PRE_GEN_DIST_LINES_U1.
• DISTRIBUTION_INTERFACE_ID — Foreign key to PSP_DISTRIBUTION_INTERFACE, linking the line to the distribution process run that generated it.
• DISTRIBUTION_AMOUNT — The monetary value of the cost distribution to be posted.
• DR_CR_FLAG — Indicates whether the line represents a debit or credit entry.
• GL_CODE_COMBINATION_ID — The accounting flexfield combination to which the cost will be charged in the GL.
• PROJECT_ID / TASK_ID / AWARD_ID / EXPENDITURE_TYPE — Collectively identify the project, task, award, and expenditure type for grants and project accounting purposes.
• EXPENDITURE_ORGANIZATION_ID — The organization owning the expenditure.
• PERSON_ID / ASSIGNMENT_ID — Identify the employee whose labor costs are being distributed.
• PAYROLL_CONTROL_ID — Links to the payroll run that triggered the distribution.
• TIME_PERIOD_ID — The accounting period to which the distribution belongs.
• EFFORT_REPORT_ID / VERSION_NUM — Used when effort reporting drives the distribution, tracking the report and version.
• SUMMARY_LINE_ID — Ties the detail line back to its summarized parent record in PSP_SUMMARY_LINES.
• STATUS_CODE / REVERSAL_ENTRY_FLAG — Control the processing state and reversal handling of each line.
• SUSPENSE_ORG_ACCOUNT_ID / SUSPENSE_REASON_CODE — Capture suspense accounting details when a valid charge account cannot be determined.

Common Use Cases and Queries

Typical use cases revolve around pre-transfer validation, reconciliation, and reporting. Labor distribution administrators frequently query this table to verify that payroll costs have been correctly mapped before running the transfer to GL or Grants Accounting. A representative query joining to GL_CODE_COMBINATIONS and PER_TIME_PERIODS might resemble:

SELECT ppgdl.pre_gen_dist_line_id, ppgdl.distribution_amount, ppgdl.dr_cr_flag, gcc.concatenated_segments, ptp.period_name FROM psp.psp_pre_gen_dist_lines ppgdl, gl.gl_code_combinations_kfv gcc, per.per_time_periods ptp WHERE ppgdl.gl_code_combination_id = gcc.code_combination_id AND ppgdl.time_period_id = ptp.time_period_id AND ppgdl.status_code = 'NEW';

Other common scenarios include investigating suspense entries (where SUSPENSE_ORG_ACCOUNT_ID is populated), reconciling effort report distributions to payroll (joining to PSP_EFFORT_REPORTS), and analyzing distribution amounts by project or award for grants reporting.

Related Objects

The most significant related objects, based on the documented foreign key relationships, are:

• PSP_DISTRIBUTION_INTERFACE — joined via DISTRIBUTION_INTERFACE_ID; parent process record.
• PSP_SUMMARY_LINES — joined via SUMMARY_LINE_ID; summarized distribution data.
• PSP_EFFORT_REPORTS — joined via EFFORT_REPORT_ID and VERSION_NUM.
• PSP_PAYROLL_CONTROLS — joined via PAYROLL_CONTROL_ID.
• PSP_ORGANIZATION_ACCOUNTS — joined via SUSPENSE_ORG_ACCOUNT_ID.
• GL_CODE_COMBINATIONS — joined via GL_CODE_COMBINATION_ID.
• PA_PROJECTS_ALL, PA_TASKS, PA_EXPENDITURE_TYPES — project accounting dimensions.
• IGF_AW_AWARD_ALL — grants award reference via AWARD_ID.
• PER_TIME_PERIODS — joined via TIME_PERIOD_ID.
• GL_SETS_OF_BOOKS — joined via SET_OF_BOOKS_ID.