QSC_IMP_PROD_GROUP_REL
Interface table for product group relationships. Used for migrating product group hierarchies. The WHO columns in this table just reflects when the data was loaded into the interface table or when it was processed. These columns are for information purpose only and it will not be used during actual import into fusion.
Details
-
Schema: FUSION
-
Object owner: QSC
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
QSC_IMP_PROD_GROUP_REL_PK |
BATCH_ID, INTERFACE_ROW_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BATCH_ID | NUMBER | 18 | Yes | Primary Key. Batch Identifier. Identifier that groups data into a batch. | |
| INTERFACE_ROW_ID | NUMBER | 18 | Yes | Primary Key. Interface Row Id. Will be used to link this row with rows in the error table. | |
| IMPORT_STATUS_CODE | VARCHAR2 | 30 | Indicates the status of the row to be processed. | ||
| ACTION_CODE | VARCHAR2 | 30 | Indicates the operation to be performed on a row such as Inserts, Updates etc. | ||
| INTERNAL_ACTION_CODE | VARCHAR2 | 30 | For Internal Use. Used to evaluate the operation to be performed on a row such as Insert, Update etc | ||
| PROD_GROUP_ID | NUMBER | 18 | Used for internal processing. Product Group identifier in fusion base table. | ||
| REL_CHILD_PROD_GROUP_ID | NUMBER | 18 | Used for internal processing. Related child product group identifier in fusion. | ||
| PROD_GROUP_REL_ID | NUMBER | 18 | Used for internal processing. Related Product Group Identifier in fusion product group relationship table. | ||
| ADMIN_REVISION_NUM | NUMBER | 18 | Used for internal processing. The revision number of the workspace version. | ||
| RELATION_TYPE_CODE | VARCHAR2 | 30 | Defines the relation type between product groups. For example - PRODUCT_GROUP_HIERARCHY, RELATED_SERVICE_GROUP | ||
| FILE_NAME_SYSTASK_ID | NUMBER | 18 | Individual System Task Id for each input csv file. | ||
| LANGUAGE | VARCHAR2 | 4 | Indicates the code of the language into which the contents of the translatable columns are translated. | ||
| SOURCE_LANG_FLAG | VARCHAR2 | 1 | Flag to indicate whether the specified language is also the source language. | ||
| PROD_GRP_REL_NAME | VARCHAR2 | 250 | Translated Related Product Group Name. | ||
| PG_REF_NUMBER | VARCHAR2 | 50 | Parent product group reference number | ||
| PG_REL_CHILD_REF_NUMBER | VARCHAR2 | 50 | Child product group reference number | ||
| PG_INTERNAL_NAME | VARCHAR2 | 150 | Internal name of the parent product group | ||
| PG_REL_CHILD_INTERNAL_NAME | VARCHAR2 | 150 | Internal name of the child product group. | ||
| ACTIVE_FLAG | VARCHAR2 | 1 | Indicates whether the related product group relationship is active. | ||
| START_DATE | TIMESTAMP | Date from which the related product group relationship is active. | |||
| END_DATE | TIMESTAMP | Date from which the related product group relationship is active | |||
| DISPLAY_ORDER_NUM | NUMBER | 18 | Manually set display order for related product groups in a product group. | ||
| FILE_RECORD_NUM | NUMBER | Used by the file import wizard to relate a row in the interface table to the data file that was uploaded. | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| 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 | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| QSC_IMP_PROD_GROUP_REL_N1 | Non Unique | Default | BATCH_ID, PG_REF_NUMBER, PG_REL_CHILD_REF_NUMBER, RELATION_TYPE_CODE |
| QSC_IMP_PROD_GROUP_REL_N2 | Non Unique | Default | BATCH_ID, PG_INTERNAL_NAME, PG_REL_CHILD_INTERNAL_NAME, RELATION_TYPE_CODE |
| QSC_IMP_PROD_GROUP_REL_N3 | Non Unique | Default | BATCH_ID, INTERNAL_ACTION_CODE, IMPORT_STATUS_CODE |
| QSC_IMP_PROD_GROUP_REL_N4 | Non Unique | Default | BATCH_ID, ACTION_CODE, IMPORT_STATUS_CODE |
| QSC_IMP_PROD_GROUP_REL_PK | Unique | Default | BATCH_ID, INTERFACE_ROW_ID |