CN_ML_CREDITING_HISTORY_ALL

Contains a history of execution times of segments of the Incentive Compensation crediting process.

Details

• Schema: FUSION

• Object owner: CN

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
CN_ML_CREDITING_HISTORY_PK	ML_CREDITING_HISTORY_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
ML_CREDITING_HISTORY_ID	NUMBER		18	Yes	Primary Key
MODEL_NAME	VARCHAR2	26		Yes	Name of the machine learning model in which this record will be used
ORG_ID	NUMBER		18	Yes	Indicates the identifier of the business unit associated to the row.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
ELAPSED_TIME_SEC	NUMBER				The total time in seconds that the job took to complete from the creation of this record
NUM_TRANSACTIONS	NUMBER				The number of transactions in the crediting job
NUM_WORKERS	NUMBER				The number of workers used in the crediting job
NUM_QUALIF_COMBINATIONS	NUMBER				The number of rule qualifier combinations
NUM_CREDITS_TO_PROCESS	NUMBER				The number of credits to process identified in the job
NUM_EXISTING_CREDITS	NUMBER				The number of existing credits which may or may not require to be reversed
TRANS_MUL_QUALIF_DIV_WORKERS	NUMBER				Precalculated value that stores the result of: num_transactions * num_qualif_combinations / num_workers
TRANSACTIONS_DIV_WORKERS	NUMBER				Precalculated value that stores the result of: num_transactions / num_workers
CREDITS_PROCESS_DIV_WORKERS	NUMBER				Precalculated value that stores the result of: num_credits_to_process / num_workers
EXISTING_CREDITS_DIV_WORKERS	NUMBER				Precalculated value that stores the result of: num_existing_credits / num_workers
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of 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
CN_ML_CREDITING_HISTORY_N1	Non Unique	Default	MODEL_NAME, ORG_ID, CREATION_DATE
CN_ML_CREDITING_HISTORY_U1	Unique	Default	ML_CREDITING_HISTORY_ID