Search Results pn_var_constr_templates_pk

Overview

The PN_VAR_CONSTR_TEMPLATES_ALL table is a core data object within the Oracle E-Business Suite Property Manager (PN) module. It serves as the master repository for variable construction templates. These templates are critical for standardizing and automating the creation of variable lease components, such as operating expenses (OpEx), common area maintenance (CAM), or tax reimbursements, which are calculated based on variable factors over the lease term. The table's "ALL" suffix indicates it is a multi-organization table, storing data partitioned by the ORG_ID column to support deployments across multiple operating units. Its role is to provide a reusable definition for variable payment structures, ensuring consistency and reducing manual data entry during lease setup.

Key Information Stored

The table stores the defining attributes for each variable construction template. The primary key, CONSTR_TEMPLATE_ID, uniquely identifies each template record. While the provided ETRM metadata does not list all columns, standard Property Manager table design suggests the table will contain columns for the template name, description, active status (e.g., ACTIVE_FLAG), and the associated ORG_ID. Crucially, it will store references to the type of variable being constructed (e.g., expense recovery type) and the specific calculation methodology or formula to be applied. The presence of an ORG_ID column is confirmed by the multi-org "ALL" designation, which is a standard architectural pattern in EBS.

Common Use Cases and Queries

This table is primarily accessed during the lease administration process. A common use case is the creation of a new lease, where an administrator selects a predefined variable construction template to automatically populate complex reimbursement terms. For reporting, administrators may query this table to audit available templates or identify unused ones. A typical query would join on ORG_ID to filter for templates specific to an operating unit.

• Listing active templates for an operating unit: SELECT constr_template_id, template_name FROM pn_var_constr_templates_all WHERE org_id = :p_org_id AND active_flag = 'Y';
• Identifying templates used in specific leases would involve joining to child tables like PN_VAR_CONSTR_ALL.

Related Objects

The primary documented relationship for PN_VAR_CONSTR_TEMPLATES_ALL is its primary key constraint, PN_VAR_CONSTR_TEMPLATES_PK, on the column CONSTR_TEMPLATE_ID. This key is almost certainly referenced by foreign key constraints in related transactional tables. Based on Property Manager's data model, the most direct child table is PN_VAR_CONSTR_ALL, which stores the actual variable construction details for individual leases. The foreign key in PN_VAR_CONSTR_ALL (likely named CONSTR_TEMPLATE_ID) would join to this table's primary key, allowing each lease-specific variable term to inherit its structure from a master template. Other related objects may include views such as PN_VAR_CONSTR_TEMPLATES, which provides a single-organization perspective on this data.