HZ_MERGE_DICTIONARY
The HZ_MERGE_DICTIONARY table stores information about the tables affected by a party merge. This table is used by the party merge concurrent program.
Details
-
Schema: FUSION
-
Object owner: ZCH
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
HZ_MERGE_DICTIONARY_PK |
MERGE_DICT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| MERGE_DICT_ID | NUMBER | 18 | Yes | Sequence generated id to uniquely identify a record in the Dictionary | |
| APPLICATION_USAGE | VARCHAR2 | 80 | Yes | This column is to store usage information. Usage is a layer that ties the objects with same business context together. The objects that have the same usage will be processed in the same transaction. To ensure uniqueness, consuming teams need to prefix usage names with <ProductCode>_<LBA> | |
| FETCH_RECORD_FLAG | VARCHAR2 | 1 | Yes | This column is used to indicate if consumer wants TCH PL/SQL runtime to query its table and pass the records to its routine or not. If this flag set to Y, TCH PL/SQL runtime will query the records from consumer's table based on the information specified in the HZ_MERGE_DICTIONARY and pass the record one by one to consumer routine. If this flag set to N, TCH PL/SQL runtime will not query the records from consumer's table. Consuming team's routine has full control of doing merge/transfer/other actions on their entity, including using bulk mode. The default behavior for this column is Y. | |
| RULE_SET_NAME | VARCHAR2 | 30 | Yes | Name of the Rule Set. This will be seeded name for Rel 1. Users cannot alter the rule set value or create a new one. | |
| ENTITY_NAME | VARCHAR2 | 30 | Yes | Name of the entity | |
| PARENT_ENTITY_NAME | VARCHAR2 | 30 | Name of the parent entity | ||
| PK_COLUMN_NAME | VARCHAR2 | 30 | Yes | Name of the Primary Key Column for the entity | |
| FK_COLUMN_NAME | VARCHAR2 | 30 | Name of the Foreign Key Column which links the entity to the parent | ||
| DESC_COLUMN_NAME | VARCHAR2 | 2000 | The name of the columns that will be used in generating a description for the record. Used in generating reports and logs. Eg: PARTY_NAME for HZ_PARTIESCould also be a complex concatenation or decode statement. | ||
| PROCEDURE_TYPE | VARCHAR2 | 30 | Yes | Procedure Type. Values allowed : BC4J, PL/SQL | |
| PROCEDURE_NAME | VARCHAR2 | 60 | Yes | Name of the Merge Procedure | |
| JOIN_CLAUSE | VARCHAR2 | 2000 | Where Clause to related parent and child entity | ||
| DESCRIPTION | VARCHAR2 | 2000 | Short descriptive name for the entity. EG: 'Party' for HZ_PARTIES | ||
| DICT_APPLICATION_ID | NUMBER | 18 | Dictionary application identifier | ||
| 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_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to 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_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| SEQUENCE_NO | NUMBER | Sequence of the entity for merge. | |||
| BULK_FLAG | VARCHAR2 | 1 | Indicates if the records in this table are being handled in bulk by the merge procedure. 'Y' for tables where merge is handled in bulk. 'N' for others. | ||
| FK_DATA_TYPE | VARCHAR2 | 150 | Foreign key data type | ||
| BATCH_MERGE_FLAG | VARCHAR2 | 1 | Indicates whether merge procedure should be executed only once for a batch | ||
| VALIDATE_PURGE_FLAG | VARCHAR2 | 1 | Indicates whether purge validation should be skipped for an entity in the HZ Purge program. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| HZ_MERGE_DICTIONARY_N1 | Non Unique | Default | ENTITY_NAME |
| HZ_MERGE_DICTIONARY_N2 | Non Unique | Default | PARENT_ENTITY_NAME |
| HZ_MERGE_DICTIONARY_N3 | Non Unique | Default | DICT_APPLICATION_ID |
| HZ_MERGE_DICTIONARY_PK | Unique | Default | MERGE_DICT_ID, ORA_SEED_SET1 |
| HZ_MERGE_DICTIONARY_PK1 | Unique | Default | MERGE_DICT_ID, ORA_SEED_SET2 |