Search Results pn_var_bkhd_defaults_pk

Overview

PN_VAR_BKHD_DEFAULTS_ALL is a Property Manager (PN) setup table in Oracle EBS 12.1.1 and 12.2.2 that stores default breakpoint header information at the organization level. Breakpoints are structural definitions used in variable rent and participation agreements, allowing landlords and tenants to tier rent calculations across defined thresholds or natural break rates. This table captures the default configuration that drives how breakpoint headers are generated for lease and agreement templates. Because it operates as a defaults store rather than a transaction or history table, its rows represent reusable setup definitions that are propagated into operational records.

The heuristic Data Vault classification for this table is standalone, suggesting a modeling approach in which it functions independently rather than as a dependent hub, link, or satellite. Although it contains foreign keys to several other PN tables, the mined classification indicates that its own identity is not driven by a parent business key. The presence of ORG_ID confirms multi-organization partitioning, making it a shared setup object across operating units.

Key Information Stored

The table is defined with 39 columns and is uniquely identified by the primary key PN_VAR_BKHD_DEFAULTS_PK on BKHD_DEFAULT_ID, which is the surrogate key. A unique index, PN_VAR_BKHD_DEFAULTS_U1, also exists on BKHD_DEFAULT_ID, making it the sole documented business-key candidate.

• BKHD_DEFAULT_ID — Surrogate primary key for each breakpoint header default record.
• ORG_ID — Operating unit or organization that owns the default, enabling multi-org filtering.
• BKHD_DETAIL_NUM — Sequence or detail number used to order breakpoint header defaults.
• LINE_DEFAULT_ID — FK to PN_VAR_LINE_DEFAULTS_ALL, linking the breakpoint default to a line-level default.
• LINE_TEMPLATE_ID — FK to PN_VAR_LINE_TEMPLATES_ALL, identifying the associated line template.
• AGREEMENT_TEMPLATE_ID — FK to PN_VAR_TEMPLATES_ALL, tying the default to an agreement template.
• VAR_RENT_ID — FK to PN_VAR_RENTS_ALL, associating the default with a variable rent definition.
• BKHD_START_DATE / BKHD_END_DATE — Effective date range for the default.
• BREAK_TYPE / BREAKPOINT_TYPE — Classification of the breakpoint (for example natural break versus participation).
• BASE_RENT_TYPE / BASE_RENT / NATURAL_BREAK_RATE — Rent basis values used in breakpoint calculations.
• BREAKPOINT_LEVEL — Level or tier at which the breakpoint applies.
• BKPT_HEAD_TEMPLATE_ID / BKPT_UPDATE_FLAG / PROCESSED_FLAG — Template reference and processing control flags.
• ATTRIBUTE1 through ATTRIBUTE15 — Standard EBS descriptive flexfield (DFF) columns for user-defined setup attributes.

Common Use Cases and Queries

Typical use cases include reviewing breakpoint header defaults by operating unit, validating template-to-default mappings before creating agreements, and auditing effective-dated defaults. A common query joins to the variable rent definition to confirm coverage:

• List active defaults for an organization: SELECT bkhd_default_id, bkhd_detail_num, break_type, base_rent FROM pn_var_bkhd_defaults_all WHERE org_id = :org_id AND SYSDATE BETWEEN bkhd_start_date AND bkhd_end_date;
• Join to variable rents: SELECT d.bkhd_default_id, r.var_rent_id FROM pn_var_bkhd_defaults_all d, pn_var_rents_all r WHERE d.var_rent_id = r.var_rent_id;
• Template mapping report: join AGREEMENT_TEMPLATE_ID to PN_VAR_TEMPLATES_ALL and LINE_TEMPLATE_ID to PN_VAR_LINE_TEMPLATES_ALL to confirm complete setup chains.

Reporting often filters on PROCESSED_FLAG to identify defaults not yet propagated to detail records.

Related Objects

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

• PN_VAR_BKDT_DEFAULTS_ALL — References this table via BKHD_DEFAULT_ID, storing breakpoint detail defaults.
• PN_VAR_LINE_DEFAULTS_ALL — Joined via LINE_DEFAULT_ID.
• PN_VAR_LINE_TEMPLATES_ALL — Joined via LINE_TEMPLATE_ID.
• PN_VAR_TEMPLATES_ALL — Joined via AGREEMENT_TEMPLATE_ID.
• PN_VAR_RENTS_ALL — Joined via VAR_RENT_ID.