PSC_COM_MIGRATED_SYSDATA_GT

This table contains list of table's parent/child/sibling hierarchy and other related attibutes needed to build the dynamic sql in tge pl/sql package to process bulk delete.

Details

• Schema: FUSION

• Object owner: PSC_CC

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Not-null	Comments
OBJECT_NAME	VARCHAR2	50	Yes	Name of transaction object.
INPUT_ALLOWED_FLAG	VARCHAR2	20		COLUMN1
DEL_ORDER	VARCHAR2	2		Parent/Child hierarchy order.
TABLE_NAME	VARCHAR2	30		Name of the transaction object table.
DEL_KEY_FIELD	VARCHAR2	30		Name of the key field used for the corresponding value field in the input parameter.
PK_FIELD	VARCHAR2	30		Name of the primary key field of the transaction object table.
PUID_FIELD	VARCHAR2	30		Name of PUID field of the transaction object table.
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.

Indexes

Index	Uniqueness	Columns
PSC_COM_MIGRATED_SYSDATA_GT_N1	Non Unique	OBJECT_NAME, DEL_ORDER
PSC_COM_MIGRATED_SYSDATA_N2	Non Unique	PARENT_TABLE_NAME, DEL_ORDER