Search Results pn_space_allocations_all




Overview
Explore in AI Chat

Overview

The PN_SPACE_ALLOCATIONS_ALL table is a core data repository within the Oracle E-Business Suite Property Manager (PN) module. It serves as the central table for recording and managing all physical space assignments within an organization's property portfolio. The table's primary role is to document the allocation of specific building or location spaces to various occupants, which can include employees, contractors, or cost centers. This data is fundamental for tracking occupancy, managing lease utilization, calculating occupancy costs for chargeback, and supporting space planning and optimization initiatives. As an "ALL" table, it is designed to support multi-organization (Multi-Org) architecture, storing data partitioned by the ORG_ID column.

Key Information Stored

The table stores transactional details for each unique space assignment. While the full column list is extensive, key fields include SPACE_ALLOCATION_ID (the primary key), LOCATION_ID (a foreign key to PN_LOCATIONS_ALL identifying the specific physical space), and ASSIGNEE_TYPE to distinguish between an employee, contractor, or cost center occupant. Critical dates such as ASSIGNMENT_DATE and TERMINATION_DATE define the assignment period. The table also holds quantitative data like the AREA and AREA_UOM (Unit of Measure) for the allocated space, and links to financial and assignment details through columns like CUST_ACCOUNT_ID (for lessees), ASSIGNMENT_ID, and STATUS. The ORG_ID column is essential for data segregation in Multi-Org implementations.

Common Use Cases and Queries

This table is central to space management reporting and processes. Common use cases include generating occupancy reports to identify vacant or underutilized spaces, calculating prorated occupancy costs for departmental chargebacks, and auditing space assignments for specific employees or cost centers. A typical query might join to PN_LOCATIONS_ALL and HR tables to list current assignments.

  • Sample Query for Active Assignments:
    SELECT psa.space_allocation_id, psa.assignment_date, psa.area, pl.location_code, pl.description
    FROM pn_space_allocations_all psa, pn_locations_all pl
    WHERE psa.location_id = pl.location_id
    AND psa.status = 'ACTIVE'
    AND psa.org_id = :org_id;
  • Reporting Use Case: Integrating data from PN_SPACE_ALLOCATIONS_ALL with lease payment terms (PN_PAYMENT_TERMS) is a standard practice for allocating real estate costs to internal business units based on their actual consumed space.

Related Objects

The PN_SPACE_ALLOCATIONS_ALL table has integral relationships with several other Property Manager objects. As per the provided metadata, it maintains a critical foreign key relationship with PN_LOCATIONS_ALL via the LOCATION_ID column, which defines the physical space being allocated. It is also commonly joined to assignment-related tables such as PN_ASSIGNMENTS_ALL. For financial and occupant context, it relates to tables like HZ_CUST_ACCOUNTS (for lessee customers) and HR_ORGANIZATION_UNITS or PER_ALL_PEOPLE_F (for cost center and employee assignments). The primary key constraint PN_SPACE_ALLOCATIONS_PK ensures the uniqueness of each SPACE_ALLOCATION_ID.