Results for “bkpt_start_date”

40 results




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

Overview

The table PN.PN_VAR_BKPTS_DET_ALL is an Oracle E-Business Suite transactional table belonging to the Property Manager (PN) module. It stores breakpoint-related detail information used in the calculation of variable rent for each line item. In property management, variable rent is typically derived from sales volume thresholds, and breakpoints define the tiers of sales volume against which a rent rate is applied. This table therefore holds the tier-level definition rows that drive the variable rent computation for a given line item.

From a Data Vault modeling perspective, the metadata's FK structure suggests this object behaves as a link table — it sits at the intersection of breakpoint headers, variable rent records, and breakpoint defaults, carrying its own measures and descriptors. The table is owned by the PN schema and is status VALID in the documented 12.2.2 physical schema, where it comprises 36 columns.

Key Information Stored

The surrogate primary key is BKPT_DETAIL_ID, enforced by PN_VAR_BKPTS_DET_PK. A unique index, PN_VAR_BKPTS_DET_U1, also exists on BKPT_DETAIL_ID, making it the documented business-key candidate as well. The most significant columns are:

Common Use Cases and Queries

Typical use cases include retrieving all breakpoint tiers for a given variable rent line item, reporting effective rent rates within a volume band, and reconciling breakpoint configurations against defaults. A common query pattern joins detail to header and rent records:

  • Fetch tiers for a variable rent: SELECT * FROM PN_VAR_BKPTS_DET_ALL WHERE VAR_RENT_ID = :p_rent_id ORDER BY BKPT_DETAIL_NUM;
  • Volume-band lookup: filter on PERIOD_BKPT_VOL_START <= :sales AND PERIOD_BKPT_VOL_END > :sales for a given BKPT_HEADER_ID.
  • Date-effective tiers: filter using BKPT_START_DATE and BKPT_END_DATE against a reporting period.
  • Audit/reporting: join to PN_VAR_BKPTS_HEAD_ALL on BKPT_HEADER_ID to surface header context alongside tier rates.

Related Objects

The following objects are most significant to PN_VAR_BKPTS_DET_ALL, based on documented foreign key relationships:

  • PN_VAR_BKPTS_HEAD_ALL — parent breakpoint header; joined via BKPT_HEADER_ID.
  • PN_VAR_RENTS_ALL — variable rent record; joined via VAR_RENT_ID.
  • PN_VAR_BKDT_DEFAULTS_ALL — breakpoint defaults source; joined via BKDT_DEFAULT_ID.
  • PN_VAR_TRX_DETAILS_ALL — references this table via BKPT_DETAIL_ID, linking calculated transaction details back to a breakpoint tier.

These relationships position PN_VAR_BKPTS_DET_ALL as a central link between header definitions, rent records, defaults, and calculated transaction details within the variable rent calculation flow.