HZ_CONTACT_ROLLUPS
The HZ_CONTACT_ROLLUPS table stores information Rollup Metrics data.
Details
-
Schema: FUSION
-
Object owner: HZ
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PERSON_PROFILE_ID | NUMBER | 18 | Yes | An identifier for the person profiles used as a foreign key to the HZ_PERSON_PROFILES table. | |
| OPEN_OPTY_REVENUE_AMT | NUMBER | The cumulative total of open opportunity revenue amount for a contact. | |||
| NUM_OF_OPEN_OPTY | NUMBER | The count of open opportunities for a contact. | |||
| NUM_OF_OPEN_SR | NUMBER | The number of open service requests for a contact. | |||
| NUM_OF_OPEN_CRITICAL_SR | NUMBER | The number of open service requests for the contact that have a severity equal to one. | |||
| NUM_OF_OPEN_LEAD | NUMBER | Count of leads that are open for a contact. | |||
| NUM_OF_OPEN_HOT_LEAD | NUMBER | Count of leads that are open and are ranked hot for a contact. | |||
| NUM_OF_OPEN_ACTY | NUMBER | Count of open activities for a contact. | |||
| NUM_OF_CALL_MADE | NUMBER | Number of calls made to a contact. | |||
| NUM_OF_EMAIL_SENT | NUMBER | Total number of emails sent to a contact. | |||
| LAST_CALL_MADE | TIMESTAMP | The date when last call was made to a contact. | |||
| LAST_EMAIL_SENT | TIMESTAMP | The date when last email was sent to a contact. | |||
| NUM_OF_TOUCHES | NUMBER | Total number of touches with a contact. Touches refer to outbound communications such as email, phone and so on. | |||
| LAST_TOUCH | TIMESTAMP | The date when the last touch was made with a contact. | |||
| NUM_OF_RESPONSES | NUMBER | The number of inbound calls or email interactions initiated by a contact. | |||
| LAST_RESPONSE | TIMESTAMP | Stores the date and time of the last response received from the contact. Include inbound emails and calls initiated by the contact. | |||
| LAST_COMPLETED_ACTIVITY | TIMESTAMP | The date of last completed activity with a contact. Activity includes task, appointment, and call report. | |||
| NEXT_TASK_DUE | TIMESTAMP | The date when a task is due with a contact. | |||
| TOTAL_NOTES | NUMBER | The total number of public notes associated with a contact. | |||
| 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. | |
| 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_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | The currency code. A list of valid values are defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task. | ||
| CORP_CURRENCY_CODE | VARCHAR2 | 15 | The corporate currency code associated with the contact. A list of accepted values is defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Trading Community Common Lookups task. | ||
| CURCY_CONV_RATE_TYPE | VARCHAR2 | 30 | The currency conversion rate type. This attribute is used by CRM Extensibility framework. A list of valid values are defined in the lookup ZCA_COMMON_RATE_TYPE. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| USER_LAST_UPDATE_DATE | TIMESTAMP | Disconnected Mobile: indicates the date and time of the last update of the row. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database (i.e. a different mobile database or the server). | |||
| EXTN_ATTRIBUTE_TIMESTAMP001 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP001 | |||
| EXTN_ATTRIBUTE_TIMESTAMP002 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP002 | |||
| EXTN_ATTRIBUTE_TIMESTAMP003 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP003 | |||
| EXTN_ATTRIBUTE_NUMBER001 | NUMBER | EXTN_ATTRIBUTE_NUMBER001 | |||
| EXTN_ATTRIBUTE_NUMBER002 | NUMBER | EXTN_ATTRIBUTE_NUMBER002 | |||
| EXTN_ATTRIBUTE_NUMBER003 | NUMBER | EXTN_ATTRIBUTE_NUMBER003 | |||
| EXTN_ATTRIBUTE_NUMBER004 | NUMBER | EXTN_ATTRIBUTE_NUMBER004 | |||
| EXTN_ATTRIBUTE_NUMBER005 | NUMBER | EXTN_ATTRIBUTE_NUMBER005 | |||
| EXTN_ATTRIBUTE_NUMBER006 | NUMBER | EXTN_ATTRIBUTE_NUMBER006 | |||
| EXTN_ATTRIBUTE_NUMBER007 | NUMBER | EXTN_ATTRIBUTE_NUMBER007 | |||
| EXTN_ATTRIBUTE_NUMBER008 | NUMBER | EXTN_ATTRIBUTE_NUMBER008 | |||
| EXTN_ATTRIBUTE_TIMESTAMP004 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP004 | |||
| EXTN_ATTRIBUTE_TIMESTAMP005 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP005 | |||
| EXTN_ATTRIBUTE_TIMESTAMP006 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP006 | |||
| EXTN_ATTRIBUTE_NUMBER009 | NUMBER | EXTN_ATTRIBUTE_NUMBER009 | |||
| EXTN_ATTRIBUTE_NUMBER010 | NUMBER | EXTN_ATTRIBUTE_NUMBER010 | |||
| EXTN_ATTRIBUTE_NUMBER011 | NUMBER | EXTN_ATTRIBUTE_NUMBER011 | |||
| EXTN_ATTRIBUTE_NUMBER012 | NUMBER | EXTN_ATTRIBUTE_NUMBER012 | |||
| EXTN_ATTRIBUTE_NUMBER013 | NUMBER | EXTN_ATTRIBUTE_NUMBER013 | |||
| EXTN_ATTRIBUTE_NUMBER014 | NUMBER | EXTN_ATTRIBUTE_NUMBER014 | |||
| EXTN_ATTRIBUTE_NUMBER015 | NUMBER | EXTN_ATTRIBUTE_NUMBER015 | |||
| EXTN_ATTRIBUTE_NUMBER016 | NUMBER | EXTN_ATTRIBUTE_NUMBER016 | |||
| EXTN_ATTRIBUTE_TIMESTAMP007 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP007 | |||
| EXTN_ATTRIBUTE_TIMESTAMP008 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP008 | |||
| EXTN_ATTRIBUTE_TIMESTAMP009 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP009 | |||
| EXTN_ATTRIBUTE_NUMBER017 | NUMBER | EXTN_ATTRIBUTE_NUMBER017 | |||
| EXTN_ATTRIBUTE_NUMBER018 | NUMBER | EXTN_ATTRIBUTE_NUMBER018 | |||
| EXTN_ATTRIBUTE_NUMBER019 | NUMBER | EXTN_ATTRIBUTE_NUMBER019 | |||
| EXTN_ATTRIBUTE_NUMBER020 | NUMBER | EXTN_ATTRIBUTE_NUMBER020 | |||
| EXTN_ATTRIBUTE_NUMBER021 | NUMBER | EXTN_ATTRIBUTE_NUMBER021 | |||
| EXTN_ATTRIBUTE_NUMBER022 | NUMBER | EXTN_ATTRIBUTE_NUMBER022 | |||
| EXTN_ATTRIBUTE_NUMBER023 | NUMBER | EXTN_ATTRIBUTE_NUMBER023 | |||
| EXTN_ATTRIBUTE_NUMBER024 | NUMBER | EXTN_ATTRIBUTE_NUMBER024 | |||
| EXTN_ATTRIBUTE_TIMESTAMP010 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP010 | |||
| EXTN_ATTRIBUTE_TIMESTAMP011 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP011 | |||
| EXTN_ATTRIBUTE_TIMESTAMP012 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP012 | |||
| EXTN_ATTRIBUTE_NUMBER025 | NUMBER | EXTN_ATTRIBUTE_NUMBER025 | |||
| EXTN_ATTRIBUTE_NUMBER026 | NUMBER | EXTN_ATTRIBUTE_NUMBER026 | |||
| EXTN_ATTRIBUTE_NUMBER027 | NUMBER | EXTN_ATTRIBUTE_NUMBER027 | |||
| EXTN_ATTRIBUTE_NUMBER028 | NUMBER | EXTN_ATTRIBUTE_NUMBER028 | |||
| EXTN_ATTRIBUTE_NUMBER029 | NUMBER | EXTN_ATTRIBUTE_NUMBER029 | |||
| EXTN_ATTRIBUTE_NUMBER030 | NUMBER | EXTN_ATTRIBUTE_NUMBER030 | |||
| EXTN_ATTRIBUTE_NUMBER031 | NUMBER | EXTN_ATTRIBUTE_NUMBER031 | |||
| EXTN_ATTRIBUTE_NUMBER032 | NUMBER | EXTN_ATTRIBUTE_NUMBER032 | |||
| EXTN_ATTRIBUTE_TIMESTAMP013 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP013 | |||
| EXTN_ATTRIBUTE_TIMESTAMP014 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP014 | |||
| EXTN_ATTRIBUTE_TIMESTAMP015 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP015 | |||
| EXTN_ATTRIBUTE_NUMBER033 | NUMBER | EXTN_ATTRIBUTE_NUMBER033 | |||
| EXTN_ATTRIBUTE_NUMBER034 | NUMBER | EXTN_ATTRIBUTE_NUMBER034 | |||
| EXTN_ATTRIBUTE_NUMBER035 | NUMBER | EXTN_ATTRIBUTE_NUMBER035 | |||
| EXTN_ATTRIBUTE_NUMBER036 | NUMBER | EXTN_ATTRIBUTE_NUMBER036 | |||
| EXTN_ATTRIBUTE_NUMBER037 | NUMBER | EXTN_ATTRIBUTE_NUMBER037 | |||
| EXTN_ATTRIBUTE_NUMBER038 | NUMBER | EXTN_ATTRIBUTE_NUMBER038 | |||
| EXTN_ATTRIBUTE_NUMBER039 | NUMBER | EXTN_ATTRIBUTE_NUMBER039 | |||
| EXTN_ATTRIBUTE_NUMBER040 | NUMBER | EXTN_ATTRIBUTE_NUMBER040 | |||
| EXTN_ATTRIBUTE_TIMESTAMP016 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP016 | |||
| EXTN_ATTRIBUTE_TIMESTAMP017 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP017 | |||
| EXTN_ATTRIBUTE_TIMESTAMP018 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP018 | |||
| EXTN_ATTRIBUTE_NUMBER041 | NUMBER | EXTN_ATTRIBUTE_NUMBER041 | |||
| EXTN_ATTRIBUTE_NUMBER042 | NUMBER | EXTN_ATTRIBUTE_NUMBER042 | |||
| EXTN_ATTRIBUTE_NUMBER043 | NUMBER | EXTN_ATTRIBUTE_NUMBER043 | |||
| EXTN_ATTRIBUTE_NUMBER044 | NUMBER | EXTN_ATTRIBUTE_NUMBER044 | |||
| EXTN_ATTRIBUTE_NUMBER045 | NUMBER | EXTN_ATTRIBUTE_NUMBER045 | |||
| EXTN_ATTRIBUTE_NUMBER046 | NUMBER | EXTN_ATTRIBUTE_NUMBER046 | |||
| EXTN_ATTRIBUTE_NUMBER047 | NUMBER | EXTN_ATTRIBUTE_NUMBER047 | |||
| EXTN_ATTRIBUTE_NUMBER048 | NUMBER | EXTN_ATTRIBUTE_NUMBER048 | |||
| EXTN_ATTRIBUTE_TIMESTAMP019 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP019 | |||
| EXTN_ATTRIBUTE_TIMESTAMP020 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP020 | |||
| EXTN_ATTRIBUTE_TIMESTAMP021 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP021 | |||
| EXTN_ATTRIBUTE_NUMBER049 | NUMBER | EXTN_ATTRIBUTE_NUMBER049 | |||
| EXTN_ATTRIBUTE_NUMBER050 | NUMBER | EXTN_ATTRIBUTE_NUMBER050 | |||
| EXTN_ATTRIBUTE_NUMBER051 | NUMBER | EXTN_ATTRIBUTE_NUMBER051 | |||
| EXTN_ATTRIBUTE_NUMBER052 | NUMBER | EXTN_ATTRIBUTE_NUMBER052 | |||
| EXTN_ATTRIBUTE_NUMBER053 | NUMBER | EXTN_ATTRIBUTE_NUMBER053 | |||
| EXTN_ATTRIBUTE_NUMBER054 | NUMBER | EXTN_ATTRIBUTE_NUMBER054 | |||
| EXTN_ATTRIBUTE_NUMBER055 | NUMBER | EXTN_ATTRIBUTE_NUMBER055 | |||
| EXTN_ATTRIBUTE_NUMBER056 | NUMBER | EXTN_ATTRIBUTE_NUMBER056 | |||
| EXTN_ATTRIBUTE_TIMESTAMP022 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP022 | |||
| EXTN_ATTRIBUTE_TIMESTAMP023 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP023 | |||
| EXTN_ATTRIBUTE_TIMESTAMP024 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP024 | |||
| EXTN_ATTRIBUTE_NUMBER057 | NUMBER | EXTN_ATTRIBUTE_NUMBER057 | |||
| EXTN_ATTRIBUTE_NUMBER058 | NUMBER | EXTN_ATTRIBUTE_NUMBER058 | |||
| EXTN_ATTRIBUTE_NUMBER059 | NUMBER | EXTN_ATTRIBUTE_NUMBER059 | |||
| EXTN_ATTRIBUTE_NUMBER060 | NUMBER | EXTN_ATTRIBUTE_NUMBER060 | |||
| EXTN_ATTRIBUTE_NUMBER061 | NUMBER | EXTN_ATTRIBUTE_NUMBER061 | |||
| EXTN_ATTRIBUTE_NUMBER062 | NUMBER | EXTN_ATTRIBUTE_NUMBER062 | |||
| EXTN_ATTRIBUTE_NUMBER063 | NUMBER | EXTN_ATTRIBUTE_NUMBER063 | |||
| EXTN_ATTRIBUTE_NUMBER064 | NUMBER | EXTN_ATTRIBUTE_NUMBER064 | |||
| EXTN_ATTRIBUTE_TIMESTAMP025 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP025 | |||
| EXTN_ATTRIBUTE_TIMESTAMP026 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP026 | |||
| EXTN_ATTRIBUTE_TIMESTAMP027 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP027 | |||
| EXTN_ATTRIBUTE_NUMBER065 | NUMBER | EXTN_ATTRIBUTE_NUMBER065 | |||
| EXTN_ATTRIBUTE_NUMBER066 | NUMBER | EXTN_ATTRIBUTE_NUMBER066 | |||
| EXTN_ATTRIBUTE_NUMBER067 | NUMBER | EXTN_ATTRIBUTE_NUMBER067 | |||
| EXTN_ATTRIBUTE_NUMBER068 | NUMBER | EXTN_ATTRIBUTE_NUMBER068 | |||
| EXTN_ATTRIBUTE_NUMBER069 | NUMBER | EXTN_ATTRIBUTE_NUMBER069 | |||
| EXTN_ATTRIBUTE_NUMBER070 | NUMBER | EXTN_ATTRIBUTE_NUMBER070 | |||
| EXTN_ATTRIBUTE_NUMBER071 | NUMBER | EXTN_ATTRIBUTE_NUMBER071 | |||
| EXTN_ATTRIBUTE_NUMBER072 | NUMBER | EXTN_ATTRIBUTE_NUMBER072 | |||
| EXTN_ATTRIBUTE_TIMESTAMP028 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP028 | |||
| EXTN_ATTRIBUTE_TIMESTAMP029 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP029 | |||
| EXTN_ATTRIBUTE_TIMESTAMP030 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP030 | |||
| EXTN_ATTRIBUTE_NUMBER073 | NUMBER | EXTN_ATTRIBUTE_NUMBER073 | |||
| EXTN_ATTRIBUTE_NUMBER074 | NUMBER | EXTN_ATTRIBUTE_NUMBER074 | |||
| EXTN_ATTRIBUTE_NUMBER075 | NUMBER | EXTN_ATTRIBUTE_NUMBER075 | |||
| EXTN_ATTRIBUTE_NUMBER076 | NUMBER | EXTN_ATTRIBUTE_NUMBER076 | |||
| EXTN_ATTRIBUTE_NUMBER077 | NUMBER | EXTN_ATTRIBUTE_NUMBER077 | |||
| EXTN_ATTRIBUTE_NUMBER078 | NUMBER | EXTN_ATTRIBUTE_NUMBER078 | |||
| EXTN_ATTRIBUTE_NUMBER079 | NUMBER | EXTN_ATTRIBUTE_NUMBER079 | |||
| EXTN_ATTRIBUTE_NUMBER080 | NUMBER | EXTN_ATTRIBUTE_NUMBER080 | |||
| EXTN_ATTRIBUTE_TIMESTAMP031 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP031 | |||
| EXTN_ATTRIBUTE_TIMESTAMP032 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP032 | |||
| EXTN_ATTRIBUTE_TIMESTAMP033 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP033 | |||
| EXTN_ATTRIBUTE_NUMBER081 | NUMBER | EXTN_ATTRIBUTE_NUMBER081 | |||
| EXTN_ATTRIBUTE_NUMBER082 | NUMBER | EXTN_ATTRIBUTE_NUMBER082 | |||
| EXTN_ATTRIBUTE_NUMBER083 | NUMBER | EXTN_ATTRIBUTE_NUMBER083 | |||
| EXTN_ATTRIBUTE_NUMBER084 | NUMBER | EXTN_ATTRIBUTE_NUMBER084 | |||
| EXTN_ATTRIBUTE_NUMBER085 | NUMBER | EXTN_ATTRIBUTE_NUMBER085 | |||
| EXTN_ATTRIBUTE_NUMBER086 | NUMBER | EXTN_ATTRIBUTE_NUMBER086 | |||
| EXTN_ATTRIBUTE_NUMBER087 | NUMBER | EXTN_ATTRIBUTE_NUMBER087 | |||
| EXTN_ATTRIBUTE_NUMBER088 | NUMBER | EXTN_ATTRIBUTE_NUMBER088 | |||
| EXTN_ATTRIBUTE_TIMESTAMP034 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP034 | |||
| EXTN_ATTRIBUTE_TIMESTAMP035 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP035 | |||
| EXTN_ATTRIBUTE_TIMESTAMP036 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP036 | |||
| EXTN_ATTRIBUTE_NUMBER089 | NUMBER | EXTN_ATTRIBUTE_NUMBER089 | |||
| EXTN_ATTRIBUTE_NUMBER090 | NUMBER | EXTN_ATTRIBUTE_NUMBER090 | |||
| EXTN_ATTRIBUTE_NUMBER091 | NUMBER | EXTN_ATTRIBUTE_NUMBER091 | |||
| EXTN_ATTRIBUTE_NUMBER092 | NUMBER | EXTN_ATTRIBUTE_NUMBER092 | |||
| EXTN_ATTRIBUTE_NUMBER093 | NUMBER | EXTN_ATTRIBUTE_NUMBER093 | |||
| EXTN_ATTRIBUTE_NUMBER094 | NUMBER | EXTN_ATTRIBUTE_NUMBER094 | |||
| EXTN_ATTRIBUTE_NUMBER095 | NUMBER | EXTN_ATTRIBUTE_NUMBER095 | |||
| EXTN_ATTRIBUTE_NUMBER096 | NUMBER | EXTN_ATTRIBUTE_NUMBER096 | |||
| EXTN_ATTRIBUTE_TIMESTAMP037 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP037 | |||
| EXTN_ATTRIBUTE_TIMESTAMP038 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP038 | |||
| EXTN_ATTRIBUTE_TIMESTAMP039 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP039 | |||
| EXTN_ATTRIBUTE_NUMBER097 | NUMBER | EXTN_ATTRIBUTE_NUMBER097 | |||
| EXTN_ATTRIBUTE_NUMBER098 | NUMBER | EXTN_ATTRIBUTE_NUMBER098 | |||
| EXTN_ATTRIBUTE_NUMBER099 | NUMBER | EXTN_ATTRIBUTE_NUMBER099 | |||
| EXTN_ATTRIBUTE_NUMBER100 | NUMBER | EXTN_ATTRIBUTE_NUMBER100 | |||
| EXTN_ATTRIBUTE_TIMESTAMP040 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP040 |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| HZ_CONTACT_ROLLUPS | hz_person_profiles | PERSON_PROFILE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| HZ_CONTACT_ROLLUPS_U1 | Unique | FUSION_TS_TX_DATA | PERSON_PROFILE_ID |