Search Results per_letter_gen_statuses




Overview
Explore in AI Chat

Overview

The PER_LETTER_GEN_STATUSES table is a core data object within the Oracle E-Business Suite Human Resources (PER) module. It functions as a configuration and control table that governs the automated generation of employment-related correspondence. Specifically, it defines the permissible associations between a specific type of letter (e.g., a promotion letter, termination letter) and the specific status type changes within an employee's assignment or employment record that should trigger the generation of that letter. This table is essential for enabling workflow-driven, event-based communication in HR processes, ensuring that standardized letters are produced automatically when key personnel actions are processed, thereby enforcing policy and maintaining data consistency.

Key Information Stored

The table stores the mapping rules that link letter types to status transitions. While the full column list is not detailed in the provided metadata, the documented foreign keys and primary key reveal its critical structure. The primary key, LETTER_GEN_STATUS_ID, uniquely identifies each mapping rule. The LETTER_TYPE_ID column is a foreign key to PER_LETTER_TYPES, identifying the specific letter template or type to be generated. The BUSINESS_GROUP_ID is a foreign key to HR_ALL_ORGANIZATION_UNITS, scoping each rule to a specific business group, a fundamental security and data partitioning construct in Oracle HRMS. Additional columns, implied by the table's description, would store references to the relevant status types (e.g., assignment status, employment category) that define the triggering event for the letter.

Common Use Cases and Queries

The primary use case is the background logic for letter generation during HR transactions. For instance, when a user finalizes a promotion action changing an employee's assignment status, the application queries this table to determine if a "Promotion Confirmation" letter type is linked to that status change and business group. Administratively, HR system administrators may query this table to audit or configure their letter-generation rules. A typical query would join to PER_LETTER_TYPES to get a readable description.

SELECT plgs.letter_type_id, plt.name letter_type_name, plgs.business_group_id
FROM per_letter_gen_statuses plgs,
     per_letter_types plt
WHERE plgs.letter_type_id = plt.letter_type_id
AND plgs.business_group_id = :p_bg_id
ORDER BY plt.name;

Related Objects

  • PER_LETTER_TYPES: Provides the definition of the letter template or type. Joined via PER_LETTER_GEN_STATUSES.LETTER_TYPE_ID = PER_LETTER_TYPES.LETTER_TYPE_ID.
  • HR_ALL_ORGANIZATION_UNITS: Defines the business group for security and data isolation. Joined via PER_LETTER_GEN_STATUSES.BUSINESS_GROUP_ID = HR_ALL_ORGANIZATION_UNITS.ORGANIZATION_ID.
  • The table's primary key, PER_LETTER_GEN_STATUSES_PK on LETTER_GEN_STATUS_ID, is referenced by other objects (like child tables or APIs) not listed in the excerpt but inherent to the module's design.