CST_PROCESSING_GROUPS_INT

This is an internal table that stores the groups along with the grouping attribute that would be used by child requests to process a subset of data.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: INTERFACE

Primary Key

Name	Columns
CST_PROCESSING_GROUPS_PK	PARENT_REQUEST_ID, PROCESSING_CHUNK_TYPE, ATTR_ID_1

Columns

Name	Datatype	Length	Precision	Not-null	Comments
PARENT_REQUEST_ID	NUMBER		18	Yes	ESS Request ID of the parent process that created these processing groups.
PROCESSING_CHUNK_TYPE	VARCHAR2	30		Yes	Indicates the type of processing group e.g. QPP, DPROC etc.
ATTR_ID_1	NUMBER		18	Yes	Identifier of the attribute that is used to create this processing group e.g. INVENTORY_ITEM_ID or TRANSACTION_ID.
GROUP_ID	NUMBER		18	Yes	Identifier that groups a set of attribute values to be used for processing by a sub-process.
SUB_GROUP_ID	NUMBER		18	Yes	An identifier that determines a subset of attributes which add upto a predefined transaction limit.
STATUS	VARCHAR2	30		Yes	Indicates the processing status of the record.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates 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_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index	Uniqueness	Tablespace	Columns
CST_PROCESSING_GROUPS_INT_N1	Non Unique	DEFAULT	PARENT_REQUEST_ID, GROUP_ID, SUB_GROUP_ID
CST_PROCESSING_GROUPS_INT_U1	Unique	DEFAULT	PARENT_REQUEST_ID, PROCESSING_CHUNK_TYPE, ATTR_ID_1