Results for “suspense_org_account_id”

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

Overview

The PSP_PRE_GEN_DIST_LINES_ARCH table resides in the PSP (Labor Distribution) schema of Oracle E-Business Suite and serves as the archival store for pre-generated labor distribution lines that have been moved out of the active history tables. It preserves the accounting and effort distribution detail generated during the labor distribution process, allowing organizations to retain a permanent audit trail of how payroll and effort costs were allocated across general ledger accounts, projects, tasks, awards, and expenditure organizations.

In EBS 12.1.1 and 12.2.2, the object is registered as a VALID table within the PSP product. Its role is predominantly historical: current distribution activity is captured in the operational PSP_PRE_GEN_DIST_LINES structure, and completed or superseded lines are migrated into this archive companion. The heuristic Data Vault classification mined from the foreign-key structure is standalone; a modeling suggestion would be to treat this object as a satellite capturing descriptive attributes attached to the distribution interface, payroll control, time period, award, and effort report hubs/links, rather than as a hub or link in its own right. The primary key PSP_PRE_GEN_DIST_LINES_ARCH_PK is defined on PRE_GEN_DIST_LINE_ID, which also appears as a unique index candidate (PSP_PRE_GEN_DIST_LINES_ARCH_U1), confirming that the pre-generated distribution line identifier is the natural business key.

Key Information Stored

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

• PRE_GEN_DIST_LINE_ID — Surrogate primary key and unique business key for each archived distribution line.
• DISTRIBUTION_INTERFACE_ID — Foreign key linking the line to PSP_DISTRIBUTION_INTERFACE, identifying the originating distribution run.
• PAYROLL_CONTROL_ID — FK to PSP_PAYROLL_CONTROLS, associating the line with the payroll cycle that drove the distribution.
• TIME_PERIOD_ID — FK to PER_TIME_PERIODS, the accounting or effort period in which the distribution is reported.
• AWARD_ID — FK to IGF_AW_AWARD_ALL, used for effort reporting and sponsored-project allocations.
• EFFORT_REPORT_ID — FK to PSP_EFF_REPORTS, tying the line to a specific effort certification document.
• PERSON_ID and ASSIGNMENT_ID — The employee and assignment generating the distributed cost.
• DISTRIBUTION_AMOUNT and DR_CR_FLAG — The distributed monetary value and its debit/credit indicator.
• GL_CODE_COMBINATION_ID and SET_OF_BOOKS_ID — The accounting flexfield and ledger receiving the charge.
• STATUS_CODE, SOURCE_TYPE, and SOURCE_CODE — Control indicators describing the line's state and origin.
• PROJECT_ID, TASK_ID, and EXPENDITURE_TYPE — Project accounting attributes for capitalizable and sponsored distributions.
• REVERSAL_ENTRY_FLAG and VERSION_NUM — Used for reversal handling and multi-version distributions.
• ATTRIBUTE1 through ATTRIBUTE10 and ATTRIBUTE_CATEGORY — Descriptive flexfield support for client-specific extensions.

Common Use Cases and Queries

Typical scenarios include reconstructing the distribution history for a payroll period, validating effort certification against distributed costs, and supporting internal or external audit of labor cost allocations. Sample patterns:

• Retrieve archived lines for a specific payroll cycle:
  SELECT PRE_GEN_DIST_LINE_ID, DISTRIBUTION_AMOUNT, DR_CR_FLAG, GL_CODE_COMBINATION_ID FROM PSP.PSP_PRE_GEN_DIST_LINES_ARCH WHERE PAYROLL_CONTROL_ID = :p_payroll_control_id;
• Link distributed amounts to effort reports for sponsored awards:
  SELECT a.PRE_GEN_DIST_LINE_ID, a.DISTRIBUTION_AMOUNT, e.EFFORT_REPORT_ID FROM PSP.PSP_PRE_GEN_DIST_LINES_ARCH a, PSP.PSP_EFF_REPORTS e WHERE a.EFFORT_REPORT_ID = e.EFFORT_REPORT_ID AND a.AWARD_ID = :p_award_id;
• Report all archived distributions by accounting period:
  SELECT t.PERIOD_NAME, SUM(a.DISTRIBUTION_AMOUNT) FROM PSP.PSP_PRE_GEN_DIST_LINES_ARCH a, PER.PER_TIME_PERIODS t WHERE a.TIME_PERIOD_ID = t.TIME_PERIOD_ID GROUP BY t.PERIOD_NAME;

Related Objects

The following objects participate in documented foreign-key or business relationships with this table:

• PSP_DISTRIBUTION_INTERFACE — joined via DISTRIBUTION_INTERFACE_ID.
• PSP_PAYROLL_CONTROLS — joined via PAYROLL_CONTROL_ID.
• PER_TIME_PERIODS — joined via TIME_PERIOD_ID.
• IGF_AW_AWARD_ALL — joined via AWARD_ID.
• PSP_EFF_REPORTS — joined via EFFORT_REPORT_ID.

These relationships make PSP_PRE_GEN_DIST_LINES_ARCH a useful integration point for reconciliation across labor distribution, payroll, effort reporting, and general ledger accounting within Oracle EBS.