FND_BOSS_CLST_ERIZATIONS
Table that contain the main information needed to execute a clusterization process.
Details
-
Schema: BOSS
-
Object owner: FND
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
FND_BOSS_CLST_ERIZATIONS_PK |
ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ID | NUMBER | 18 | Yes | ID that uniquely identifies this clusterization | |
| LIFECYCLE | VARCHAR2 | 10 | Yes | Lifecycle that this clusterization will follow. Possible values are STATIC and DYNAMIC. | |
| SUMMARIZE_USING | VARCHAR2 | 2000 | Yes | JSON list of strings that represent the fields to be used when determining the default description | |
| DESCRIPTION | VARCHAR2 | 512 | Description for this clusterization | ||
| DESCRIPTION_DEFAULTED | VARCHAR2 | 1 | Yes | Value (Y/N) representing a boolean that specifies if the description was generated by default using SUMMARIZE_USING values or not. | |
| ALGORITHM | VARCHAR2 | 20 | Yes | Clustering algorithm used for this clusterization. | |
| ALGORITHM_OPTIONS | VARCHAR2 | 2000 | JSON object specifying options passed to the clustering algorithm. | ||
| MODULE | VARCHAR2 | 255 | Yes | Module name for the business object that will be used for clusterization. | |
| BUSINESS_OBJECT | VARCHAR2 | 255 | Yes | Business Object name used for this clusterization. | |
| NAME | VARCHAR2 | 128 | Yes | Name given to this clusterization. | |
| CLUSTER_ON | VARCHAR2 | 2000 | Yes | JSON list of strings representing the name of the felds of the provided business object that will be used to cluster on. | |
| BQL_FILTER | CLOB | Yes | Passed BQL to filter the business object data that will be used to cluster on. | ||
| TOTAL_DISPERSION | NUMBER | Calculated from the sum of the dispersions of the current clusters in the Clusterization. Returns null if this Clusterization has not been performed. | |||
| 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_ERIZATIONS_U1 | Unique | DEFAULT | ID |
| FND_BOSS_CLST_ERIZATIONS_U2 | Unique | DEFAULT | NAME |