HZ_USER_CONTACTS
This table is store the association between Resources and Contacts. The table supports the feature that allows sales reps to associate contacts to themselves. Once the association is made, it is leveraged for productivity improvements when selecting contacts.
Details
-
Schema: FUSION
-
Object owner: HZ
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
HZ_USER_CONTACTS_PK |
USER_CONTACT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| USER_CONTACT_ID | NUMBER | 18 | Yes | This is the Primary key. Auto-generated. | |
| USER_PARTY_ID | NUMBER | 18 | Yes | FK To HZ_PARTIES. Identifier of the user who stores the contact in this record. | |
| CONTACT_PARTY_ID | NUMBER | 18 | Yes | FK To HZ_PARTIES. Identifier of the contact who was selected as My Contact by the user. | |
| CONTACT_ORG_PARTY_ID | NUMBER | 18 | Trading Community Organization Party Identifier to which Contact is related to. This is a FK to HZ_PARTIES. | ||
| RELATIONSHIP_ID | NUMBER | 18 | This is the relationship identifier that identifies relationship between Trading Community Organization and Contact. | ||
| CONTACT_ADDITION_DATE | DATE | Yes | Date when contact was added to MyContacts list. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| HZ_USER_CONTACTS | hz_parties | CONTACT_PARTY_ID |
| HZ_USER_CONTACTS | hz_parties | CONTACT_ORG_PARTY_ID |
| HZ_USER_CONTACTS | hz_parties | USER_PARTY_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| HZ_USER_CONTACTS_N1 | Non Unique | Default | USER_PARTY_ID, CONTACT_ORG_PARTY_ID |
| HZ_USER_CONTACTS_N2 | Non Unique | Default | RELATIONSHIP_ID |
| HZ_USER_CONTACTS_U1 | Unique | Default | USER_PARTY_ID, CONTACT_PARTY_ID |
| HZ_USER_CONTACTS_U2 | Unique | Default | USER_CONTACT_ID |