HZ_ORGANIZATION_PROFILES_CX
The profile index table stores value change information for profile records in the history table. This information is extracted from the history table after it was updated by a batch or real-time process. Later, this information is used to find rows in the history table which contributed attribute values to the current profile record and obtain source information for each value from that row.
Details
-
Schema: FUSION
-
Object owner: HZ
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RECORD_DATE | TIMESTAMP | Yes | Last update of the profile record in the history table. | ||
| RECORD_ID | NUMBER | 18 | Yes | Identifier of the profile record in the history table. | |
| RECORD_VERSION | NUMBER | 9 | Yes | Version of the profile record in the history table. | |
| VALUE_CHANGE_TARGET | NUMBER | 3 | Yes | The attribute of the profile record whose value was changed. The attribute index between 0 and 999 is defined by the column order in FND column metadata for the profile table. | |
| VALUE_CHANGE_TYPE | VARCHAR2 | 1 | Yes | Indicates if the attribute of the profile record was changed to a different value (C), initialized with a value from NULL (I), reset from a value to NULL (R) or updated with the same value (U). |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| HZ_ORGANIZATION_PROFILES_CX_N1 | Non Unique | Default | RECORD_DATE, RECORD_ID |
| HZ_ORGANIZATION_PROFILES_CX_N2 | Non Unique | Default | RECORD_ID, VALUE_CHANGE_TARGET, VALUE_CHANGE_TYPE |