Results for “cust_space_assign_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PN_REC_EXPCL_DTLLN_ALL is a Property Manager (PN) transaction table in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores expense class line details associated with a summary header, forming the granular level of the recoverable expense calculation model used for lease operating cost recovery. Each row represents an individual expense class line tied to a parent expense class detail record, with amounts, recovery percentages, and recovery classification codes that drive tenant billing and landlord recovery processing.

The "_ALL" suffix indicates the table is partitioned by operating unit and secured through the ORG_ID column, which references HR_ALL_ORGANIZATION_UNITS. The primary key is enforced by PN_REC_EXPCL_DTLLN_PK on EXPENSE_CLASS_LINE_ID, and a unique index PN_REC_EXPCL_DTLLN_U1 also covers EXPENSE_CLASS_LINE_ID. From a Data Vault modeling perspective, the heuristic classification is satellite-leaning, since the table carries descriptive and measurable attributes dependent on parent expense class detail and lease records rather than acting as an independent hub or pure link.

Key Information Stored

• EXPENSE_CLASS_LINE_ID — surrogate primary key and sole unique-index column; the business-key candidate for this table.
• EXPENSE_CLASS_DTL_ID — foreign key to PN_REC_EXPCL_DTL_ALL, linking the line to its parent expense class detail record.
• LEASE_ID — foreign key to PN_LEASES_ALL, identifying the lease to which the expense line applies.
• CUST_SPACE_ASSIGN_ID — foreign key to PN_SPACE_ASSIGN_CUST_ALL, associating the line with a customer space assignment.
• CUST_ACCOUNT_ID — foreign key to GL_CODE_COMBINATIONS, defining the accounting flexfield for the recoverable charge.
• LOCATION_ID — identifies the location tied to the expense line.
• BUDGETED_AMT — budgeted amount for the expense class line.
• EXPENSE_AMT — actual expense amount recorded against the line.
• RECOVERABLE_AMT and COMPUTED_RECOVERABLE_AMT — the recoverable portion of the expense and the system-computed equivalent.
• CLS_LINE_SHARE_PCT — share percentage applied to the expense class line.
• CLS_LINE_FEE_BEFORE_CONTR_OVR and CLS_LINE_FEE_AFTER_CONTR_OVR — fees before and after contractual overrides.
• USE_SHARE_PCT_FLAG and USE_FEE_BEFORE_CONTR_FLAG — flags controlling which percentage or fee value the calculation uses.
• RECOVERY_SPACE_STD_CODE and RECOVERY_TYPE_CODE — recovery classification codes determining the recovery method applied.
• ORG_ID — operating unit identifier enforcing multi-org security.
• Standard WHO columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, plus ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 for extensibility.

Common Use Cases and Queries

Typical usage includes recoverable expense reporting, lease-level recovery analysis, and reconciliation of budgeted versus actual expense amounts. A common query pattern joins the line to its detail parent and lease:

• Reporting recoverable expense by lease: join PN_REC_EXPCL_DTLLN_ALL to PN_REC_EXPCL_DTL_ALL on EXPENSE_CLASS_DTL_ID and to PN_LEASES_ALL on LEASE_ID, filtering by ORG_ID.
• Comparing RECOVERABLE_AMT against COMPUTED_RECOVERABLE_AMT to identify variances in the recovery calculation.
• Reviewing recovery classification using RECOVERY_SPACE_STD_CODE and RECOVERY_TYPE_CODE to validate how each line is recovered from tenants.
• Analyzing contractual override impact by comparing CLS_LINE_FEE_BEFORE_CONTR_OVR and CLS_LINE_FEE_AFTER_CONTR_OVR.
• Drilling from a customer space assignment to its expense lines via CUST_SPACE_ASSIGN_ID for tenant billing detail.

Related Objects

• PN_REC_EXPCL_DTL_ALL — parent summary/detail table; joined on EXPENSE_CLASS_DTL_ID.
• PN_REC_EXPCL_DTLACC_ALL — child table referencing this table's EXPENSE_CLASS_LINE_ID, storing related accounting distributions.
• PN_LEASES_ALL — lease master; joined on LEASE_ID.
• PN_SPACE_ASSIGN_CUST_ALL — customer space assignments; joined on CUST_SPACE_ASSIGN_ID.
• GL_CODE_COMBINATIONS — accounting flexfield validation; joined on CUST_ACCOUNT_ID.
• HR_ALL_ORGANIZATION_UNITS — operating unit definition; joined on ORG_ID.

These relationships confirm the table's role as a satellite-style detail store beneath PN_REC_EXPCL_DTL_ALL, with downstream accounting data in PN_REC_EXPCL_DTLACC_ALL.