CREATE TABLE cn_sim_measure_results_all (
    SIMULATION_ID                NUMBER(18, 0) ,
    SIMULATION_DELETE_FLAG       VARCHAR2(4)       NOT NULL,
    SIMULATION_RESULT_TYPE       VARCHAR2(120) ,
    MEASURE_RESULT_ID            NUMBER(18, 0) ,
    CREDIT_ID                    NUMBER(18, 0) ,
    TRANSACTION_ID               NUMBER(18, 0) ,
    PARTICIPANT_ID               NUMBER(18, 0) ,
    CREDITED_PARTICIPANT_ID      NUMBER(18, 0) ,
    SOURCE_EVENT_DATE            DATE              NOT NULL,
    SOURCE_EVENT_PERIOD_ID       NUMBER(18, 0) ,
    GRP_BY_MEASURE_RESULT_ID     NUMBER(18, 0) ,
    TRANSACTION_AMT_CALC_CURR    NUMBER        ,
    CREDIT_AMT_CALC_CURR         NUMBER        ,
    CALC_CURRENCY_CODE           VARCHAR2(60)  ,
    CREATED_DURING               VARCHAR2(120) ,
    SOURCE_MEASURE_RESULT_ID     NUMBER(18, 0) ,
    EARNING_ID                   NUMBER(18, 0) ,
    REVENUE_TYPE                 VARCHAR2(120) ,
    TRANSACTION_QTY              NUMBER        ,
    MEASURE_TYPE                 VARCHAR2(120) ,
    TRANSACTION_TYPE             VARCHAR2(120)     NOT NULL,
    ELIGIBLE_CAT_ID              NUMBER(18, 0) ,
    OBJECT_STATUS                VARCHAR2(120) ,
    ADJUSTMENT_STATUS            VARCHAR2(120) ,
    ADJUSTMENT_COMMENTS          VARCHAR2(4000),
    REASON_CODE                  VARCHAR2(120) ,
    SOURCE_ORG_ID                NUMBER(18, 0) ,
    ORG_ID                       NUMBER(18, 0)     NOT NULL,
    SOURCE_TRX_NUMBER            VARCHAR2(120) ,
    SPLIT_PCT                    NUMBER        ,
    COMMISSION_VALUE             NUMBER        ,
    PLAN_COMPONENT_ID            NUMBER(18, 0) ,
    FORMULA_ID                   NUMBER(18, 0) ,
    FORMULA_ECAT_ID              NUMBER(18, 0) ,
    TIER_SPLITS                  NUMBER(18, 0) ,
    RATE_TABLE_VALUE_ID          NUMBER(18, 0) ,
    SRP_COMP_PLAN_ID             NUMBER(18, 0) ,
    ROLE_ID                      NUMBER(18, 0) ,
    INPUT_ACHIEVED               NUMBER        ,
    OUTPUT_ACHIEVED              NUMBER        ,
    CREDIT_FACTOR                NUMBER        ,
    EARNING_FACTOR               NUMBER        ,
    EVENT_FACTOR_VALUE           NUMBER        ,
    FORMULA_WEIGHT               NUMBER        ,
    ERROR_REASON                 VARCHAR2(600) ,
    EARNING_TYPE_ID              NUMBER(18, 0) ,
    WORKER_ID                    NUMBER(18, 0) ,
    REQUEST_ID                   NUMBER(18, 0) ,
    JOB_DEFINITION_NAME          VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE       VARCHAR2(3600),
    CREATED_BY                   VARCHAR2(256)     NOT NULL,
    CREATION_DATE                TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY              VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE             TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN            VARCHAR2(128) ,
    TRX_ATTRIBUTE1               VARCHAR2(960) ,
    TRX_ATTRIBUTE2               VARCHAR2(960) ,
    TRX_ATTRIBUTE3               VARCHAR2(960) ,
    TRX_ATTRIBUTE4               VARCHAR2(960) ,
    TRX_ATTRIBUTE5               VARCHAR2(960) ,
    TRX_ATTRIBUTE6               VARCHAR2(960) ,
    TRX_ATTRIBUTE7               VARCHAR2(960) ,
    TRX_ATTRIBUTE8               VARCHAR2(960) ,
    TRX_ATTRIBUTE9               VARCHAR2(960) ,
    TRX_ATTRIBUTE10              VARCHAR2(960) ,
    TRX_ATTRIBUTE11              VARCHAR2(960) ,
    TRX_ATTRIBUTE12              VARCHAR2(960) ,
    TRX_ATTRIBUTE13              VARCHAR2(960) ,
    TRX_ATTRIBUTE14              VARCHAR2(960) ,
    TRX_ATTRIBUTE15              VARCHAR2(960) ,
    TRX_ATTRIBUTE_NUMBER1        NUMBER        ,
    TRX_ATTRIBUTE_NUMBER2        NUMBER        ,
    TRX_ATTRIBUTE_NUMBER3        NUMBER        ,
    TRX_ATTRIBUTE_NUMBER4        NUMBER        ,
    TRX_ATTRIBUTE_NUMBER5        NUMBER        ,
    TRX_ATTRIBUTE_NUMBER6        NUMBER        ,
    TRX_ATTRIBUTE_NUMBER7        NUMBER        ,
    TRX_ATTRIBUTE_NUMBER8        NUMBER        ,
    TRX_ATTRIBUTE_NUMBER9        NUMBER        ,
    TRX_ATTRIBUTE_NUMBER10       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER11       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER12       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER13       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER14       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER15       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER16       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER17       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER18       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER19       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER20       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER21       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER22       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER23       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER24       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER25       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER26       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER27       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER28       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER29       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER30       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER31       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER32       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER33       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER34       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER35       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER36       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER37       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER38       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER39       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER40       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER41       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER42       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER43       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER44       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER45       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER46       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER47       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER48       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER49       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER50       NUMBER        ,
    SIMULATION_ID                NUMBER(18, 0) ,
    SIMULATION_DELETE_FLAG       VARCHAR2(4)       NOT NULL,
    MEASURE_RESULT_ID            NUMBER(18, 0) ,
    CREDIT_ID                    NUMBER(18, 0) ,
    TRANSACTION_ID               NUMBER(18, 0) ,
    PARTICIPANT_ID               NUMBER(18, 0) ,
    CREDITED_PARTICIPANT_ID      NUMBER(18, 0) ,
    SOURCE_EVENT_DATE            DATE              NOT NULL,
    SOURCE_EVENT_PERIOD_ID       NUMBER(18, 0) ,
    GRP_BY_MEASURE_RESULT_ID     NUMBER(18, 0) ,
    TRANSACTION_AMT_CALC_CURR    NUMBER        ,
    CREDIT_AMT_CALC_CURR         NUMBER        ,
    CALC_CURRENCY_CODE           VARCHAR2(60)  ,
    CREATED_DURING               VARCHAR2(120) ,
    SOURCE_MEASURE_RESULT_ID     NUMBER(18, 0) ,
    EARNING_ID                   NUMBER(18, 0) ,
    REVENUE_TYPE                 VARCHAR2(120) ,
    TRANSACTION_QTY              NUMBER        ,
    MEASURE_TYPE                 VARCHAR2(120) ,
    TRANSACTION_TYPE             VARCHAR2(120)     NOT NULL,
    ELIGIBLE_CAT_ID              NUMBER(18, 0) ,
    OBJECT_STATUS                VARCHAR2(120) ,
    ADJUSTMENT_STATUS            VARCHAR2(120) ,
    ADJUSTMENT_COMMENTS          VARCHAR2(4000),
    REASON_CODE                  VARCHAR2(120) ,
    SOURCE_ORG_ID                NUMBER(18, 0) ,
    ORG_ID                       NUMBER(18, 0)     NOT NULL,
    SOURCE_TRX_NUMBER            VARCHAR2(120) ,
    SPLIT_PCT                    NUMBER        ,
    COMMISSION_VALUE             NUMBER        ,
    PLAN_COMPONENT_ID            NUMBER(18, 0) ,
    FORMULA_ID                   NUMBER(18, 0) ,
    FORMULA_ECAT_ID              NUMBER(18, 0) ,
    TIER_SPLITS                  NUMBER(18, 0) ,
    RATE_TABLE_VALUE_ID          NUMBER(18, 0) ,
    SRP_COMP_PLAN_ID             NUMBER(18, 0) ,
    ROLE_ID                      NUMBER(18, 0) ,
    INPUT_ACHIEVED               NUMBER        ,
    OUTPUT_ACHIEVED              NUMBER        ,
    CREDIT_FACTOR                NUMBER        ,
    EARNING_FACTOR               NUMBER        ,
    EVENT_FACTOR_VALUE           NUMBER        ,
    FORMULA_WEIGHT               NUMBER        ,
    ERROR_REASON                 VARCHAR2(600) ,
    EARNING_TYPE_ID              NUMBER(18, 0) ,
    WORKER_ID                    NUMBER(18, 0) ,
    REQUEST_ID                   NUMBER(18, 0) ,
    JOB_DEFINITION_NAME          VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE       VARCHAR2(3600),
    CREATED_BY                   VARCHAR2(256)     NOT NULL,
    CREATION_DATE                TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY              VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE             TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN            VARCHAR2(128) ,
    TRX_ATTRIBUTE1               VARCHAR2(960) ,
    TRX_ATTRIBUTE2               VARCHAR2(960) ,
    TRX_ATTRIBUTE3               VARCHAR2(960) ,
    TRX_ATTRIBUTE4               VARCHAR2(960) ,
    TRX_ATTRIBUTE5               VARCHAR2(960) ,
    TRX_ATTRIBUTE6               VARCHAR2(960) ,
    TRX_ATTRIBUTE7               VARCHAR2(960) ,
    TRX_ATTRIBUTE8               VARCHAR2(960) ,
    TRX_ATTRIBUTE9               VARCHAR2(960) ,
    TRX_ATTRIBUTE10              VARCHAR2(960) ,
    TRX_ATTRIBUTE11              VARCHAR2(960) ,
    TRX_ATTRIBUTE12              VARCHAR2(960) ,
    TRX_ATTRIBUTE13              VARCHAR2(960) ,
    TRX_ATTRIBUTE14              VARCHAR2(960) ,
    TRX_ATTRIBUTE15              VARCHAR2(960) ,
    TRX_ATTRIBUTE_NUMBER1        NUMBER        ,
    TRX_ATTRIBUTE_NUMBER2        NUMBER        ,
    TRX_ATTRIBUTE_NUMBER3        NUMBER        ,
    TRX_ATTRIBUTE_NUMBER4        NUMBER        ,
    TRX_ATTRIBUTE_NUMBER5        NUMBER        ,
    TRX_ATTRIBUTE_NUMBER6        NUMBER        ,
    TRX_ATTRIBUTE_NUMBER7        NUMBER        ,
    TRX_ATTRIBUTE_NUMBER8        NUMBER        ,
    TRX_ATTRIBUTE_NUMBER9        NUMBER        ,
    TRX_ATTRIBUTE_NUMBER10       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER11       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER12       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER13       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER14       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER15       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER16       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER17       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER18       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER19       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER20       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER21       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER22       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER23       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER24       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER25       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER26       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER27       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER28       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER29       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER30       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER31       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER32       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER33       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER34       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER35       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER36       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER37       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER38       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER39       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER40       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER41       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER42       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER43       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER44       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER45       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER46       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER47       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER48       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER49       NUMBER        ,
    TRX_ATTRIBUTE_NUMBER50       NUMBER        ,
    SIMULATION_RESULT_TYPE       VARCHAR2(120) ,
    CONSTRAINT pk_cn_sim_measure_results_all PRIMARY KEY (SIMULATION_ID, MEASURE_RESULT_ID, SIMULATION_ID, MEASURE_RESULT_ID)
);
