PSC_COM_MIGRATED_STAGE_GT
This table contains list of transactions for deletion based on the input provided.
Details
-
Schema: FUSION
-
Object owner: PSC_CC
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| BATCH_ID | NUMBER | 18 | Yes | This column is used to indicate batch request id | Active | |
| OBJECT_NAME | VARCHAR2 | 50 | Yes | Name of transaction object. | ||
| TABLE_NAME | VARCHAR2 | 30 | Yes | Name of transaction object table. | ||
| INPUT_FIELD | VARCHAR2 | 30 | Name of field used for the input parameter value entered. | |||
| INPUT_VALUE | VARCHAR2 | 480 | Value of field input entered as a parameter. | |||
| DEL_KEY_FIELD | VARCHAR2 | 30 | Name of the key field used in deleting transactions. | |||
| DEL_KEY_VALUE | VARCHAR2 | 50 | Value of the delete key field used in deleting transactions. | |||
| PK_FIELD | VARCHAR2 | 30 | Name of the primary key field of the transaction object table. | |||
| PK_VALUE | VARCHAR2 | 50 | Value of the primary key field. | |||
| PUID_FIELD | VARCHAR2 | 30 | Name of PUID field of the transaction object table. | |||
| PUID_VALUE | VARCHAR2 | 480 | Value for the PUID field. | |||
| PARENT_TABLE_NAME | VARCHAR2 | 30 | Name of parent table for the transaction object table. | |||
| SIBLING_TABLE_NAME | VARCHAR2 | 30 | Name of sibling table. | |||
| SIBLING_PK_FIELD | VARCHAR2 | 30 | Name of primary key field of the sibling table. | |||
| DEL_ORDER | NUMBER | 2 | Parent/Child hierarchy. | |||
| VALID_FLAG | VARCHAR2 | 1 | Flag(N) if transaction is not valid for deletion. | |||
| MESSAGE | VARCHAR2 | 100 | Description of error or validation message. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| PSC_COM_MIGRATED_STAGE_GT_N1 | Non Unique | "DEL_ORDER", TABLE_NAME |