HRC_DL_PARENT_KEYS_GT
Stores logical object information temporarily during data loader import process.
Details
-
Schema: FUSION
-
Object owner: HRC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
HRC_DL_PARENT_KEYS_GT_PK |
KEY_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| KEY_LINE_ID | NUMBER | 18 | Yes | Primary key column generated by the sequence S_ROW_ID_SEQ. | |
| DATA_SET_BUS_OBJ_ID | NUMBER | 18 | Yes | DATA_SET_BUS_OBJ_ID to which the current row belongs to. The value is populated from HRC_DL_FILE_HEADERS.DATA_SET_BUS_OBJ_ID | |
| HEADER_ID | NUMBER | 18 | Yes | HEADER_ID to which the current row belongs to. The value is populated from HRC_DL_FILE_HEADERS.HEADER_ID table. | |
| KEY_GUID | RAW | 16 | The GUID value supplied for the logical object. This value is populated from HRC_DL_FILE_ROWS.KEY_GUID table. | ||
| KEY_SURROGATE_ID | NUMBER | 18 | The Oracle Fusion Surrogate ID supplied for the logical object. This value is populated from HRC_DL_FILE_ROWS.KEY_SURROGATE_ID table. | ||
| KEY_SOURCE_OWNER | VARCHAR2 | 256 | The source owner supplied for the logical. This value is populated from HRC_DL_FILE_ROWS.KEY_SOURCE_OWNER table. | ||
| KEY_SOURCE_ID | VARCHAR2 | 2000 | The source ID supplied for the logical object. This value is populated from HRC_DL_FILE_ROWS.KEY_SOURCE_ID table. | ||
| PARENT_KEY | VARCHAR2 | 2000 | Key information of the parent object. This can be GUID/Surrogate id/Source id. | ||
| PARENT_SRC_OWNER | VARCHAR2 | 256 | Source owner of the parent object. | ||
| ENTERPRISE_ID | NUMBER | 18 | Enterprise_ID, the value is populated from HRC_DL_FILE_HEADERS.ENTERPRISE_ID table. | ||
| IS_SRC_INFO_VALID | VARCHAR2 | 30 | Yes | Y/N flag. Status of Parent source information validation. | |
| PARENT_REFERENCE | NUMBER | 2 | Yes | Status of Parent resolution. -1 = Parent not found 0 = No need to resolve the Parent reference for top level business object 1 = Parent in File 2 = Parent in HRC_DL_INTEGRATION_KEY_MAP table 3 = Parent in Fusion | |
| IS_FOREIGN_KEY_RESOLVED | VARCHAR2 | 30 | Yes | Y/N flag. Status of foreign key resolution. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| HRC_DL_PARENT_KEYS_GT_U1 | Unique | KEY_LINE_ID |