Results for “right_status_code”

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

Overview

PN_RIGHTS_ALL is the base table in the Oracle Property Manager (PN) module that stores rights information for leases. In Oracle EBS 12.1.1 and 12.2.2, a "right" represents a legal or contractual entitlement granted under a lease, such as a right of way, easement, sublease, right of first refusal, or option to purchase. Each row captures a single right tied to a specific lease and, where applicable, to a specific lease change record. The table is owned by the PN schema and is classified as VALID in the ETRM data dictionary.

From a Data Vault modeling perspective, the mined foreign key structure suggests a satellite-leaning classification. The table carries a surrogate primary key (RIGHT_ID) while also holding descriptive and temporal attributes (right type, status, dates, comments) that are subject to change over time. The presence of PN_RIGHTS_HISTORY, which references PN_RIGHTS_ALL by RIGHT_ID, reinforces the satellite interpretation: current-state attributes reside in PN_RIGHTS_ALL, and historical versions are tracked in the companion history table.

Key Information Stored

PN_RIGHTS_ALL contains 32 documented columns. The surrogate primary key is RIGHT_ID, enforced by the PN_RIGHTS_PK constraint and also covered by the unique index PN_RIGHTS_U1, which serves as a business-key candidate. Key columns include:

• RIGHT_ID — Surrogate primary key uniquely identifying each right record.
• LEASE_ID — Foreign key to PN_LEASES_ALL, identifying the parent lease under which the right is granted.
• LEASE_CHANGE_ID — Foreign key to PN_LEASE_CHANGES_ALL, linking the right to a specific lease change or amendment.
• RIGHT_NUM — Business-facing number for the right, used for reference and reporting.
• RIGHT_TYPE_CODE — Classifies the nature of the right (for example, easement, option, or sublease).
• RIGHT_STATUS_CODE — Indicates the lifecycle state of the right (active, expired, terminated).
• RIGHT_REFERENCE — External or legal reference text associated with the right.
• START_DATE and EXPIRATION_DATE — Define the effective period during which the right is valid.
• RIGHT_COMMENTS — Free-form descriptive text.
• ORG_ID — Operating unit identifier supporting multi-org security.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — Descriptive flexfield (DFF) segments for client-specific extensions.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN track record provenance.

Common Use Cases and Queries

Typical reporting scenarios include listing all active rights for a lease, identifying rights approaching expiration, and reconciling rights against lease changes. A representative query follows:

• SELECT r.right_id, r.right_num, r.right_type_code, r.right_status_code, r.start_date, r.expiration_date FROM pn_rights_all r WHERE r.lease_id = :lease_id AND r.org_id = :org_id;
• Expiration monitoring: SELECT right_id, lease_id, expiration_date FROM pn_rights_all WHERE expiration_date BETWEEN SYSDATE AND SYSDATE + 90 AND right_status_code = 'ACTIVE';
• Change reconciliation: join to PN_LEASE_CHANGES_ALL on LEASE_CHANGE_ID to attribute rights to specific amendments.
• Multi-org filtering by ORG_ID is standard practice in any reporting layer.

Related Objects

• PN_LEASES_ALL — Parent lease table; joined via PN_RIGHTS_ALL.LEASE_ID.
• PN_LEASE_CHANGES_ALL — Lease change records; joined via PN_RIGHTS_ALL.LEASE_CHANGE_ID.
• PN_RIGHTS_HISTORY — Historical snapshot table referencing PN_RIGHTS_ALL.RIGHT_ID.
• PN_RIGHTS_PK — Primary key constraint on RIGHT_ID.
• PN_RIGHTS_U1 — Unique index on RIGHT_ID, the business-key candidate.