FND Design Data [Home] [Help]

Table: PN_CONTACT_ASSIGN_HISTORY

Product: PN - Property Manager
Description: Track changes in contacts linked to the lease
Implementation/DBA Data: TablePN.PN_CONTACT_ASSIGN_HISTORY
Primary Key: PN_CONTACT_ASSIGN_HISTORY_PK
  1. ColumnCONTACT_ASSIGN_HISTORY_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PN_CONTACT_ASSIGN_HISTORY FK Joins to TablePN_COMPANIES_ALL PN_CONTACT_ASSIGN_HISTORY.COMPANY_ID
PN_CONTACT_ASSIGN_HISTORY FK Joins to TablePN_COMPANY_SITES_ALL PN_CONTACT_ASSIGN_HISTORY.COMPANY_SITE_ID
PN_CONTACT_ASSIGN_HISTORY FK Joins to TablePN_CONTACT_ASSIGNMENTS_ALL PN_CONTACT_ASSIGN_HISTORY.CONTACT_ASSIGNMENT_ID
PN_CONTACT_ASSIGN_HISTORY FK Joins to TablePN_LEASES_ALL PN_CONTACT_ASSIGN_HISTORY.LEASE_ID
PN_CONTACT_ASSIGN_HISTORY FK Joins to TablePN_LEASE_CHANGES_ALL PN_CONTACT_ASSIGN_HISTORY.LEASE_CHANGE_ID
PN_CONTACT_ASSIGN_HISTORY FK Joins to TablePN_LOCATIONS_ALL PN_CONTACT_ASSIGN_HISTORY.LOCATION_ID