Results for “contact_assignment_id”

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

Overview

PN_CONTACT_ASSIGNMENTS_ALL is a Property Manager (PN) transactional table in Oracle E-Business Suite 12.1.1 and 12.2.2. It links locations or leases to the site of a service provider. In practice, each row represents an assignment of a service provider company or company site to a specific property location, lease, or lease change event. This is the core intersection table that establishes which vendor is responsible for servicing a given property or lease, and is therefore fundamental to the Property Manager operations that track third-party service responsibility.

Structurally, the table carries a surrogate primary key (CONTACT_ASSIGNMENT_ID) enforced through PN_CONTACT_ASSIGNMENTS_PK and a matching unique index PN_CONTACT_ASSIGNMENTS_U1. Its foreign key topology (company, company site, lease, lease change, and location references) causes its heuristic Data Vault classification to lean toward satellite. From a modeling perspective, this suggests the table is best treated as descriptive context attached to the referenced business entities rather than as a standalone hub.

Key Information Stored

The table exposes 29 documented columns. The most operationally significant are listed below.

• CONTACT_ASSIGNMENT_ID — surrogate primary key (PN_CONTACT_ASSIGNMENTS_PK) and the business-key candidate carried by the unique index PN_CONTACT_ASSIGNMENTS_U1.
• COMPANY_ID — the service provider company referenced from PN_COMPANIES_ALL.
• COMPANY_SITE_ID — the specific service provider site referenced from PN_COMPANY_SITES_ALL.
• LOCATION_ID — the property location the provider is assigned to.
• LEASE_ID — the lease against which the assignment is made.
• LEASE_CHANGE_ID — the lease change event (amendment, renewal) associated with the assignment.
• STATUS — current lifecycle state of the assignment.
• ORG_ID — multi-org operating unit discriminator, enabling multi-organization access control.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the standard EBS flexfield descriptor block for client-specific extension.
• Standard 5 WHO columns: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — audit and concurrency tracking.

Common Use Cases and Queries

The table is primarily queried to answer: "Who is the assigned service provider for this location or lease, and at which site?" Reporters frequently join to PN_COMPANIES_ALL, PN_COMPANY_SITES_ALL, and PN_LOCATIONS_ALL to render provider names and addresses.

• Provider by location: filter by LOCATION_ID and join COMPANY_ID to retrieve provider details.
• Active assignments: constrain STATUS and ORG_ID to isolate valid records within an operating unit.
• Lease-level servicing: join on LEASE_ID, optionally restricted by LEASE_CHANGE_ID to track changes across amendments.
• Audit and change tracking: use PN_CONTACT_ASSIGN_HISTORY joined on CONTACT_ASSIGNMENT_ID to reconstruct prior states.

A representative pattern: SELECT a.contact_assignment_id, c.company_name FROM pn_contact_assignments_all a, pn_companies_all c WHERE a.company_id = c.company_id AND a.location_id = :loc_id AND a.org_id = :org_id;

Related Objects

The following objects are most significant to integration and reporting around this table.

• PN_COMPANIES_ALL — referenced via COMPANY_ID; source of provider master data.
• PN_COMPANY_SITES_ALL — referenced via COMPANY_SITE_ID; the provider site assigned.
• PN_LOCATIONS_ALL — referenced via LOCATION_ID; the property serviced.
• PN_LEASES_ALL — referenced via LEASE_ID; the parent lease.
• PN_LEASE_CHANGES_ALL — referenced via LEASE_CHANGE_ID; amendment context.
• PN_CONTACT_ASSIGN_HISTORY — references this table through CONTACT_ASSIGNMENT_ID; the audit trail of assignment changes.

Together these relationships position PN_CONTACT_ASSIGNMENTS_ALL as the connective record between service providers and the properties and leases they service.