HZ_ORIG_SYS_REFERENCES
The HZ_ORIG_SYSTEM_REFERENCES table stores the mapping between source system references and the owner tables. The source system reference is an identifier for the record that the data came from the source system and the owner table is the TCA table, which stores that data. A record with an Active status means the cross-reference mapping between TCA and source system is vaild. An Inactive status means the cross-referencing mapping is no longer valid.
Details
-
Schema: FUSION
-
Object owner: HZ
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
HZ_ORIG_SYS_REFERENCES_PK |
ORIG_SYSTEM_REF_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping | Status |
|---|---|---|---|---|---|---|---|
| ORIG_SYSTEM_REF_ID | NUMBER | 18 | Yes | Sequentially generated identifier | |||
| ORIG_SYSTEM | VARCHAR2 | 30 | Yes | Source system name | Active | ||
| ORIG_SYSTEM_REFERENCE | VARCHAR2 | 255 | Yes | Source system id for the source system logical entit | Active | ||
| OWNER_TABLE_NAME | VARCHAR2 | 30 | Yes | TCA tables that have source system reference column | Active | ||
| OWNER_TABLE_ID | NUMBER | 18 | Yes | Unique identifier for a record in the owner table | Active | ||
| STATUS | VARCHAR2 | 1 | Yes | A for Active. Mapping is validI for Inactive. Mapping is invalidThe default is A for Active. | Active | ||
| REASON_CODE | VARCHAR2 | 30 | Reason for setting the record to Inactive | Active | |||
| OLD_ORIG_SYSTEM_REFERENCE | VARCHAR2 | 255 | Old source system reference that is being replaced | Active | |||
| START_DATE_ACTIVE | DATE | Yes | Start date | Active | |||
| END_DATE_ACTIVE | DATE | End date | Active | ||||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | |||
| 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. | Active | ||
| CREATED_BY_MODULE | VARCHAR2 | 30 | TCA Who column | Active | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | Active | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | Active | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | Active | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | Active | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | Active | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | Active | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | Active | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | Active | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | Active | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | Active | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | Active | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | Active | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | Active | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | Active | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | Active | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | Active | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | Active | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | Active | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | Active | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | Active | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | Active | ||
| PARTY_ID | NUMBER | 18 | Denormalized party identifier from HZ_PARTIES table | ||||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | Active | |||
| 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. | ||||
| CONFLICT_ID | NUMBER | 18 | Yes | Disconnected Mobile: this value is used to guarantee the uniqueness of the row when duplicates are created in different databases (i.e. mobile databases or the server). | Active | ||
| 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). | Active | ||||
| ATTRIBUTE21 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | Active | ||
| ATTRIBUTE22 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | Active | ||
| ATTRIBUTE23 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | Active | ||
| ATTRIBUTE24 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | Active | ||
| ATTRIBUTE25 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | Active | ||
| ATTRIBUTE26 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | Active | ||
| ATTRIBUTE27 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | Active | ||
| ATTRIBUTE28 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | Active | ||
| ATTRIBUTE29 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | Active | ||
| ATTRIBUTE30 | VARCHAR2 | 255 | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | Active | ||
| CPDRF_VER_SOR | NUMBER | 9 | Cross Pillar Data Replication Framework (CPDRF) system column for tracking record version in System of Record (SOR) pillar when a record change is replicated to subscribing pillars by the replication flows. | ||||
| CPDRF_VER_PILLAR | NUMBER | 9 | Cross Pillar Data Replication Framework (CPDRF) system column for tracking record version when a record is changed by replication flows | ||||
| CPDRF_LAST_UPD | VARCHAR2 | 15 | Cross Pillar Data Replication Framework (CPDRF) system column for tracking source pillar name when a record is changed by the replication flows. | ||||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | ||||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | ||||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | ||||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | ||||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | ||||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | ||||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | ||||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | ||||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | ||||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | ||||
| ATTRIBUTE_NUMBER11 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | ||||
| ATTRIBUTE_NUMBER12 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | ||||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | ||||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | ||||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | ||||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | ||||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | ||||
| ATTRIBUTE_DATE6 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | ||||
| ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | ||||
| ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | ||||
| ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | ||||
| ATTRIBUTE_DATE10 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | ||||
| ATTRIBUTE_DATE11 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) | ||||
| ATTRIBUTE_DATE12 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Source System Reference (HZ_ORIG_SYS_REFERENCES) |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| HZ_ORIG_SYS_REFERENCES | hz_orig_sys_mapping | ORIG_SYSTEM, OWNER_TABLE_NAME |
| HZ_ORIG_SYS_REFERENCES | hz_parties | PARTY_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| HZ_ORIG_SYS_REFERENCES_N2 | Non Unique | Default | OWNER_TABLE_NAME, OWNER_TABLE_ID |
| HZ_ORIG_SYS_REFERENCES_N3 | Non Unique | Default | LAST_UPDATE_DATE, ORIG_SYSTEM_REF_ID |
| HZ_ORIG_SYS_REFERENCES_N4 | Non Unique | Default | ORIG_SYSTEM, ORIG_SYSTEM_REFERENCE, OWNER_TABLE_NAME |
| HZ_ORIG_SYS_REFERENCES_N5 | Non Unique | Default | ORIG_SYSTEM_REFERENCE, OWNER_TABLE_NAME, OWNER_TABLE_ID |
| HZ_ORIG_SYS_REFERENCES_N6 | Non Unique | Default | REQUEST_ID |
| HZ_ORIG_SYS_REFERENCES_N7 | Non Unique | Default | UPPER("ORIG_SYSTEM_REFERENCE"), UPPER("ORIG_SYSTEM") |
| HZ_ORIG_SYS_REFERENCES_PK | Unique | Default | ORIG_SYSTEM_REF_ID |