Search Results template_detail_id




Overview
Explore in AI Chat

Overview

The PSP_REPORT_TEMPLATE_DETAILS table is a core data structure within the Oracle E-Business Suite (EBS) Labor Distribution module (PSP). It functions as the detail-level repository for Effort Report templates. In the context of sponsored projects and grant management, Effort Reporting is a critical compliance process for certifying employee work effort. This table stores the specific line items or sections that constitute a report template, enabling the system to generate standardized, compliant reports for distribution and certification of labor costs against awards. Its role is to define the precise structure and content of these templates, which are then applied to individual employee assignments.

Key Information Stored

The table's primary purpose is to link a template header with its constituent elements. The key columns, as indicated by the provided metadata, include the primary key TEMPLATE_DETAIL_ID, which uniquely identifies each detail record. The foreign key TEMPLATE_ID links the detail line to its parent template in the PSP_REPORT_TEMPLATES table. While the full column list is not provided in the excerpt, typical data stored in such a detail table would include sequence numbers (to order sections), section identifiers or codes, descriptive text for report lines, and flags controlling the display or calculation of specific effort categories (e.g., sponsored, departmental, committed). This structure allows a single template header to govern multiple, ordered reporting components.

Common Use Cases and Queries

This table is primarily accessed for template configuration and report generation. Common operational scenarios include auditing the components of a specific Effort Report template or troubleshooting report output. A typical query would join to the header table to retrieve a full template definition. For example, to list all sections of a template named 'STANDARD_UNIV':

  • SELECT d.template_detail_id, d.segment_num, d.segment_name
  • FROM psp_report_template_details d, psp_report_templates t
  • WHERE d.template_id = t.template_id
  • AND t.template_name = 'STANDARD_UNIV'
  • ORDER BY d.segment_num;

Reporting use cases often involve analyzing which templates are in use and their complexity (number of detail lines). Direct data manipulation (DML) on this table is typically performed only by the application's template management functions, not manually.

Related Objects

The PSP_REPORT_TEMPLATE_DETAILS table has a direct, dependent relationship with the PSP_REPORT_TEMPLATES table, as enforced by its foreign key constraint. It is a child entity to that header table. The primary key constraint PSP_REPORT_TEMPLATE_DETAILS_PK ensures data integrity for its own records. This table is fundamental to the Effort Reporting engine; therefore, it is referenced by various application program interfaces (APIs), forms, and concurrent programs within the PSP module that generate, display, and process Effort Reports. Other related objects likely include key flexfield tables (if templates use descriptive flexfields for customization) and the PSP_EFFORT_REPORTS table, which holds the instantiated reports created from these templates.