Search Results pn_index_lease_terms_all




Overview
Explore in AI Chat

Overview

The PN_INDEX_LEASE_TERMS_ALL table is a core data repository within the Oracle E-Business Suite Property Manager (PN) module. It functions as the central storage entity for index payment terms, which are critical components of lease agreements that include periodic rent adjustments linked to an external economic index. This table enables the system to define, track, and calculate rent increases or decreases based on predefined index formulas and schedules. Its role is integral to the automated management of complex, variable-rate lease contracts, ensuring accurate financial calculations and billing.

Key Information Stored

The table's primary identifier is the INDEX_LEASE_TERM_ID. Its structure is defined by key foreign key relationships that link the term to its parent agreements and calculation periods. The most critical columns include INDEX_LEASE_ID, which ties the term to its master index lease definition, and INDEX_PERIOD_ID, which associates it with a specific calculation period. The LEASE_TERM_ID and RENT_INCREASE_TERM_ID columns link to standard payment term templates in the PN_PAYMENT_TERMS_ALL table, defining the base and adjusted payment schedules, respectively. This design allows the system to store both the original lease payment terms and the specific terms generated by an index-based rent review.

Common Use Cases and Queries

A primary use case is generating reports on upcoming or historical index-based rent adjustments for a portfolio of leases. Financial analysts may query this table to audit the calculation of rent increases. A common SQL pattern involves joining to the index lease and period tables to list all adjustment terms for a specific property or lessee.

  • Identifying all active index adjustment terms for a given lease: SELECT * FROM pn_index_lease_terms_all WHERE index_lease_id = <lease_id>;
  • Reporting on adjustment terms within a date range: SELECT ilt.*, ilp.period_name FROM pn_index_lease_terms_all ilt, pn_index_lease_periods_all ilp WHERE ilt.index_period_id = ilp.index_period_id AND ilp.start_date BETWEEN :p_start_date AND :p_end_date;

Related Objects

The PN_INDEX_LEASE_TERMS_ALL table maintains documented foreign key relationships with several key Property Manager tables, forming a critical part of the lease index data model.

  • PN_INDEX_LEASES_ALL: Joined via INDEX_LEASE_ID. This is the parent table containing the master definition of the index-linked lease.
  • PN_INDEX_LEASE_PERIODS_ALL: Joined via INDEX_PERIOD_ID. This table defines the specific time period for which an index review and rent adjustment is calculated.
  • PN_PAYMENT_TERMS_ALL (Two Relationships): Joined via LEASE_TERM_ID to reference the base lease payment terms, and joined via RENT_INCREASE_TERM_ID to reference the payment terms created for the rent increase amount.