Search Results pn_var_abat_defaults_pk

Overview

PN_VAR_ABAT_DEFAULTS_ALL is a Property Manager (PN) configuration table in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores setup information for abatements and allowances applied against variable rent agreements. In the context of lease and property management, abatements (such as free-rent periods) and allowances (such as tenant improvement contributions) are concession constructs that adjust the effective rent obligation for a lease. This table holds the default definitions that the application uses when generating or applying such concessions to variable rent records.

The table is owned by the PN schema and resides in the APPS-enabled data dictionary with a 31-column physical structure documented in ETRM 12.2.2. Its primary key is enforced through the constraint PN_VAR_ABAT_DEFAULTS_PK on the ABATEMENT_ID column, and a unique index, PN_VAR_ABAT_DEFAULTS_U1, also exists on ABATEMENT_ID, confirming it as the single business-key candidate. From a Data Vault modeling perspective, the metadata classifies this object as standalone, which suggests modeling it as a satellite table whose natural business key is the abatement identifier, rather than as a hub or link. The relationship metadata shows a foreign key from VAR_RENT_ID to PN_VAR_RENTS_ALL, indicating the table is functionally subordinate to variable rent definitions rather than a pure reference lookup.

Key Information Stored

The following columns represent the functionally significant content of the table:

• ABATEMENT_ID — Surrogate primary key, system-generated identifier for each abatement or allowance default record.
• VAR_RENT_ID — Foreign key to PN_VAR_RENTS_ALL, linking the abatement default to its parent variable rent definition.
• START_DATE and END_DATE — Effective period during which the abatement or allowance applies.
• TYPE_CODE — Classifies the concession, for example distinguishing an abatement from an allowance.
• AMOUNT — Monetary value associated with the abatement or allowance.
• ALLOWANCE_APPLIED — Indicator reflecting whether the allowance has been applied to the associated rent stream.
• DESCRIPTION and COMMENTS — Free-text narrative describing the concession's purpose or terms.
• ORG_ID — Operating unit identifier supporting multi-org data partitioning.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — Standard EBS descriptive flexfield columns for client-specific extensions.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN — Standard WHO audit columns tracking record creation and modification.

Common Use Cases and Queries

Typical usage involves setup validation, concession reporting, and reconciliation of variable rent against applied abatements. A common query pattern joins the table to its parent rent definition:

• Listing all abatements and allowances for a given variable rent: SELECT a.ABATEMENT_ID, a.TYPE_CODE, a.AMOUNT, a.START_DATE, a.END_DATE FROM PN_VAR_ABAT_DEFAULTS_ALL a WHERE a.VAR_RENT_ID = :var_rent_id;
• Reporting active concessions within an operating unit and effective date window: filter on ORG_ID, START_DATE, and END_DATE.
• Identifying concessions not yet applied using ALLOWANCE_APPLIED as a status flag for follow-up processing.
• Auditing configuration changes by querying LAST_UPDATE_DATE and LAST_UPDATED_BY.
• Inventorying all concession defaults by TYPE_CODE for financial or lease-administration reporting.

Related Objects

The most significant object associated with this table is its parent:

• PN_VAR_RENTS_ALL — Referenced through the VAR_RENT_ID foreign key; the variable rent definition to which each abatement or allowance default belongs.
• PN_VAR_ABAT_DEFAULTS_PK / PN_VAR_ABAT_DEFAULTS_U1 — Primary key constraint and unique index enforcing the ABATEMENT_ID business key.

Because the metadata identifies this object as standalone, no other documented foreign-key dependencies exist. Dependent behavior is therefore driven through the PN_VAR_RENTS_ALL relationship, and integrated reporting typically combines this table with the variable rent and lease-level structures it supports.