Search Results pn_var_grp_dates_all




Overview
Explore in AI Chat

Overview

The PN_VAR_GRP_DATES_ALL table is a core data repository within the Oracle E-Business Suite Property Manager (PN) module, specifically for the variable rent management functionality. Its primary role is to store critical date information generated by the system's periods generation program for variable rent agreements. This table acts as a central hub for date-related data, linking the definition of a variable rent agreement to its calculated periods, deductions, volume history, and summary rent calculations. It is a multi-organization table, as indicated by the "_ALL" suffix, meaning it stores data for all operating units accessible to a user, contingent on Multi-Org Access Control (MOAC) settings.

Key Information Stored

While the specific column list is not detailed in the provided excerpt, the table's structure and relationships indicate it holds several critical pieces of information. The primary key, GRP_DATE_ID, uniquely identifies each date record. The foreign key VAR_RENT_ID links the date to its parent variable rent agreement in the PN_VAR_RENTS_ALL table. The PERIOD_ID foreign key associates the date with a specific calculation period defined in PN_VAR_PERIODS_ALL. The table likely contains date columns that define key milestones for rent calculation, such as the period start date, period end date, invoice date, due date, or other date triggers specified within the variable rent terms. These dates are essential for the automated generation of billing schedules and performance-based rent calculations.

Common Use Cases and Queries

This table is central to reporting and troubleshooting the variable rent calculation engine. Common use cases include auditing the dates generated for a specific variable rent agreement, reconciling billed amounts by period, and identifying periods where date-driven conditions (like sales volume thresholds) were met. A typical query would join this table to its related entities to produce a comprehensive rent schedule. For example:

  • Retrieving Period Dates for a Variable Rent Agreement:
    SELECT vrgd.* FROM pn_var_grp_dates_all vrgd, pn_var_rents_all vr WHERE vrgd.var_rent_id = vr.var_rent_id AND vr.var_rent_num = 'VR-10001';
  • Reporting Rent Summary with Associated Dates:
    SELECT vs.rent, vrgd.period_start_date, vrgd.period_end_date FROM pn_var_rent_summ_all vs, pn_var_grp_dates_all vrgd WHERE vs.grp_date_id = vrgd.grp_date_id;

Related Objects

The PN_VAR_GRP_DATES_ALL table is a pivotal junction within the variable rent schema, with documented relationships to several key tables.

  • Parent Tables (Foreign Key References From):
    • PN_VAR_RENTS_ALL: Via VAR_RENT_ID. This is the master definition table for the variable rent agreement.
    • PN_VAR_PERIODS_ALL: Via PERIOD_ID. This table stores the defined calculation periods for the agreement.
  • Child Tables (Foreign Key References To):
    • PN_VAR_DEDUCTIONS_ALL: Linked by GRP_DATE_ID. Stores deductions applied within a specific date group.
    • PN_VAR_VOL_HIST_ALL: Linked by GRP_DATE_ID. Stores historical volume data (e.g., sales figures) tied to the date period.
    • PN_VAR_RENT_SUMM_ALL: Linked by GRP_DATE_ID. Stores the calculated summary rent amounts for the period.

These relationships underscore the table's function as the connective tissue between a variable rent agreement's terms, its time-based periods, and the final calculated financial outcomes.