Search Results psp_template_awards_pk

Overview

The PSP_TEMPLATE_AWARDS table is a core data object within the Oracle E-Business Suite (EBS) Labor Distribution module (PSP). Its primary function is to manage the association between Effort Reporting Templates and specific awards. This table enables the configuration of templates to automatically include or reference multiple grants, contracts, or other funding sources (collectively termed "awards") based on predefined selection criteria. By storing these relationships, it streamlines the complex process of effort certification and cost distribution for sponsored projects, ensuring that labor costs are accurately allocated and reported against the correct funding awards according to institutional and regulatory requirements.

Key Information Stored

The table's structure is designed to maintain a many-to-many relationship between templates and awards. The documented metadata indicates two critical columns forming a composite primary key. The TEMPLATE_ID column stores the unique identifier linking to a specific effort reporting template defined in the PSP_EFFORT_REPORT_TEMPLATES table. The AWARD_ID column stores the identifier for the associated award, which typically corresponds to a grant or project award from modules like Grants Accounting (GMS). The combination of these two columns ensures that each award is uniquely assigned to a given template, preventing duplicate associations.

Common Use Cases and Queries

A primary use case is the generation of effort reports, where the system queries this table to determine all awards that should be included on a report generated from a particular template. This is essential for employees working on multiple sponsored projects. Administrators may also query this table to audit or modify award assignments for compliance. A typical SQL query would join this table with the template and award master tables to list all associations:

• SELECT t.template_name, a.award_number FROM psp_template_awards ta, psp_effort_report_templates t, gms_awards_all a WHERE ta.template_id = t.template_id AND ta.award_id = a.award_id ORDER BY t.template_name;

Another common operational query is to verify the awards linked to a specific template before mass-generating reports, ensuring the correct funding sources are included.

Related Objects

PSP_TEMPLATE_AWARDS has defined relationships with other key tables in the Labor Distribution module, as per the provided metadata. Its primary foreign key relationship is with the PSP_EFFORT_REPORT_TEMPLATES table via the TEMPLATE_ID column. This enforces referential integrity, ensuring every entry in PSP_TEMPLATE_AWARDS corresponds to a valid, existing template. While the AWARD_ID column's specific foreign key to an award master table (such as GMS_AWARDS) is not explicitly detailed in the excerpt, it is a logical dependency critical for the table's function. The table itself is referenced by the primary key constraint PSP_TEMPLATE_AWARDS_PK on the columns (TEMPLATE_ID, AWARD_ID).