1. Tables and Views for Sales, Fusion Service, and Field Service
  2. CN_TP_1002_CLSFN_WINNERS

CN_TP_1002_CLSFN_WINNERS

This table uses to store classification winners for transaction processing

Details

  • Schema: FUSION

  • Object owner: CN

  • Object type: TABLE

  • Tablespace: INTERFACE

Columns

Name Datatype Length Precision Not-null Comments
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row.
TRANS_OBJECT_ID NUMBER Yes PK of the source object row
EVENT_DATE DATE Date of the source object
WORKER_ID NUMBER Worker Number that will process this row
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_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
RULE_ID NUMBER FK to cn_rs_rules_all_b
ABSOLUTE_RANK NUMBER Absolute rank of the rule
TOP_LEVEL_RULE_ID NUMBER FK to cn_rs_rules_all_b
NUM_WINNERS NUMBER Number of winners
RULE_ASSIGNMENT_ID NUMBER FK to cn_rs_rule_assignments_all
ASSIGNED_OBJECT_ID NUMBER FK to winning object (participant/ eligible category)
ASSIGNED_OBJECT_TYPE VARCHAR2 30 Winning Object Type

Foreign Keys

Table Foreign Table Foreign Key Column
CN_TP_1002_CLSFN_WINNERS cn_rs_rules_all_b RULE_ID