Results for “first_yr_rent”

28 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PN_VAR_RENT_SUMM_ALL is a Property Manager (PN) transactional table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the calculated variable rent for a line item for a group date. Variable rent in Property Manager represents percentage or turnover rent derived from actual sales volume reported by tenants, calculated against a lease's rent lines and summarized by accounting period and grouping date. This table holds the summarized calculation output that then feeds downstream billing, invoicing, and true-up processing.

Owned by the PN schema with 36 documented columns, the table is registered as VALID. From a Data Vault modeling perspective, the heuristic classification derived from its foreign-key structure is a link. That interpretation is a modeling suggestion only: the table sits at the intersection of variable rent definitions, group dates, line items, and periods, resolving a many-to-many operational relationship rather than acting as a pure descriptive hub or a satellite of a single parent.

Key Information Stored

The surrogate primary key is VAR_RENT_SUMM_ID, enforced by the constraint PN_VAR_RENT_SUMM_PK and also backed by the unique index PN_VAR_RENT_SUMM_U1. In this schema the primary key column is the only documented business-key candidate; no separate natural unique key is exposed, so VAR_RENT_SUMM_ID is the canonical join key across related objects.

Common Use Cases and Queries

The most frequent access pattern is retrieval of calculated variable rent for a given lease line item or variable rent definition within a period. A typical reporting query joins the summary to its parents to resolve descriptive context:

  • Variable rent calculation review — select ACT_VAR_RENT, FOR_VAR_RENT, and TOT_ACT_VOL for a LINE_ITEM_ID and PERIOD_ID to validate turnover rent output.
  • True-up analysis — compare TRUEUP_VAR_RENT against ACT_VAR_RENT to reconcile adjustments.
  • Downstream billing — PN_VAR_TRX_HEADERS_ALL references VAR_RENT_SUMM_ID, so the summary feeds transaction and invoice generation.
  • Period and group-date reporting — aggregate by GROUP_DATE and PERIOD_ID for turnover rent trend reporting by operating unit (ORG_ID).

Sample pattern:

  • SELECT s.var_rent_summ_id, s.line_item_id, s.period_id, s.group_date, s.tot_act_vol, s.act_var_rent, s.trueup_var_rent FROM pn_var_rent_summ_all s WHERE s.org_id = :p_org_id AND s.period_id = :p_period_id;

Related Objects

The following relationships are documented via foreign keys and referencing constraints:

  • PN_VAR_GRP_DATES_ALL — joined on GRP_DATE_ID.
  • PN_VAR_LINES_ALL — joined on LINE_ITEM_ID.
  • PN_VAR_RENTS_ALL — joined on VAR_RENT_ID.
  • PN_VAR_PERIODS_ALL — joined on PERIOD_ID.
  • PN_VAR_TRX_HEADERS_ALL — references this table through VAR_RENT_SUMM_ID, making it the principal downstream consumer of summarized variable rent for transaction and invoice processing.