FND_BOSS_CLST_JOBS

Table that represents a clustering job associated to a clusterization process.

Details

• Schema: BOSS

• Object owner: FND

• Object type: TABLE

• Tablespace: REFERENCE

Primary Key

Name	Columns
FND_BOSS_CLST_JOBS_PK	ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
ID	NUMBER		18	Yes	ID used to identify this clustering job.
CLUSTERIZATION_ID	NUMBER		18	Yes	FK to fnd_boss_clst_erizations that identifies this clustering job to be part of a specific clusterization.
SQL_QUERY	CLOB			Yes	Query in SQL format that will be used to obtain the data to apply the clustering algorithm to.
SAMPLING_PERCENT	NUMBER		3	Yes	Integer from 0 to 100 that reprecents the percentage of the data returned by SQL_QUERY that will be used to apply the algorithm to.
START_DATE	TIMESTAMP				Timestamp that specifies the start date of this clustering job
END_DATE	TIMESTAMP				Timestamp that specifies the end date for this clustering job
STATUS	VARCHAR2	30		Yes	Actual status for this clustering job. Possible values are: CREATED, STARTED, FINISHING, FAILED, CANCELING, CANCELED and FINISHED.
ESTIMATED_COMPLETION_TIME	TIMESTAMP				Estimated completion date and time of the current job. It also can be used as logic to schedule a job execution time
EXECUTION_DETAILS	CLOB				JSON object representing the execution details for this clustering job
TOTAL_DISPERSION	NUMBER				Sum of the dispersions of the clusters produced by this clustering job. Populated when this clustering job is completed.
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.

Indexes

Index	Uniqueness	Tablespace	Columns
FND_BOSS_CLST_JOBS_N1	Non Unique	DEFAULT	ESTIMATED_COMPLETION_TIME
FND_BOSS_CLST_JOBS_U1	Unique	DEFAULT	ID