CN_RULE_RESULTS_L3_GT

This table uses to store temporary results while performing multi level winning process of real time transactions during classification

Details

• Schema: FUSION

• Object owner: CN

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
TRANS_OBJECT_ID	NUMBER			Yes	Represents Primary Key of the source object row	Active
EVENT_DATE	DATE				Represents the date of the source object	Active
WORKER_ID	NUMBER				Since non batch mode value is 1, column present for batch code compatibility	Active
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.	Active
JOB_DEFINITION_NAME	VARCHAR2	100			Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.	Active
JOB_DEFINITION_PACKAGE	VARCHAR2	900			Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.	Active
WIN_RULE_ID	NUMBER				Column: Represents the winning level rule id	Active
UL_RULE_ID	NUMBER				Column: Represents the upper level from root in multilevel winner process	Active
LL_RULE_ID	NUMBER				Column: Represents the lower level from root in multilevel winner process	Active
LL_NUM_WINNERS	NUMBER				Column: Represents the number of winners	Active