Search Results pn_rec_arcl_all




Overview
Explore in AI Chat

Overview

The PN_REC_ARCL_ALL table is a core data structure within the Oracle E-Business Suite Property Manager (PN) module. It serves as the master repository for area class header information. In the context of lease and property management, an area class is a critical classification used to define and categorize different types of space within a property, such as retail, office, storage, or common area. This table establishes the definition and organizational context for these classifications, enabling detailed tracking, allocation, and billing of space based on its designated use. Its role is foundational to the module's ability to manage complex lease agreements where rental calculations and expense recoveries are often tied to specific area types.

Key Information Stored

While the provided metadata does not list specific columns beyond key identifiers, the table's primary purpose and foreign key relationships indicate the nature of its critical data points. The primary key, AREA_CLASS_ID, uniquely identifies each area class definition. The table is multi-org enabled, as indicated by the ORG_ID foreign key to HR_ALL_ORGANIZATION_UNITS, ensuring data is partitioned by operating unit. The PROPERTY_ID foreign key to PN_PROPERTIES_ALL links each area class to a specific property. Other essential columns typically found in such header tables include NAME and DESCRIPTION for the area class, effective dates (START_DATE, END_DATE), and standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY) for auditing.

Common Use Cases and Queries

This table is central to reporting and transactional processes involving leased space. Common use cases include generating rent rolls segmented by area type, configuring expense recovery pools based on area class, and ensuring lease clauses are applied to the correct space classifications. A frequent reporting query involves joining the area class header to its details and associated leases. For example, to list all area classes for a property, a query might be: SELECT prca.area_class_id, prca.name, prca.description FROM pn_rec_arcl_all prca WHERE prca.property_id = :p_property_id AND prca.org_id = :p_org_id;. For integration or data migration, the table is typically accessed via public APIs or views to ensure business rule validation.

Related Objects

The PN_REC_ARCL_ALL table has extensive relationships within the Property Manager schema, acting as a parent to several key transactional tables. As per the metadata, its primary foreign key relationships are:

  • Parent Tables: PN_PROPERTIES_ALL (via PROPERTY_ID), HR_ALL_ORGANIZATION_UNITS (via ORG_ID).
  • Child Tables (Key Dependencies):

These relationships underscore the table's central role in the lease management data model, where the area class defined in the header propagates to lease terms, billing calculations, and expense allocations.