CSO_SCHML_JOB_TRACKER
This table stores the date information related to processing done by the analytics processor job. It also defines the frequencies at which a particular metric needs to be computed.
Details
-
Schema: FUSION
-
Object owner: CSO
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CSO_SCHML_JOB_TRACKER_PK |
METRIC_TYPE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| METRIC_TYPE_ID | NUMBER | 18 | Yes | This is the primary key of the table. | |
| METRIC_TYPE | VARCHAR2 | 32 | Yes | This refers to metric type names to be computed by the analytics job processor. | |
| DESCRIPTION | VARCHAR2 | 255 | This is the description of the metric type. | ||
| HOURLY_ENABLED | NUMBER | 1 | Yes | A flag indicating if this metric is to be calculated at hourly intervals. | |
| DAILY_ENABLED | NUMBER | 1 | Yes | A flag indicating if this metric is to be calculated at daily intervals. | |
| WEEKLY_ENABLED | NUMBER | 1 | Yes | A flag indicating if this metric is to be calculated at weekly intervals. | |
| MONTHLY_ENABLED | NUMBER | 1 | Yes | A flag indicating if this metric is to be calculated at monthly intervals. | |
| YEARLY_ENABLED | NUMBER | 1 | Yes | A flag indicating if this metric is to be calculated at yearly intervals. | |
| LAST_HOURLY_PROC_DATE | TIMESTAMP | This indicates the date and time when the metric was last calculated for the hourly interval. | |||
| LAST_DAILY_PROC_DATE | TIMESTAMP | This indicates the date and time when the metric was last calculated for the daily interval. | |||
| LAST_WEEKLY_PROC_DATE | TIMESTAMP | This indicates the date and time when the metric was last calculated for the weekly interval. | |||
| LAST_MONTHLY_PROC_DATE | TIMESTAMP | This indicates the date and time when the metric was last calculated for the monthly interval. | |||
| LAST_YEARLY_PROC_DATE | TIMESTAMP | This indicates the date and time when the metric was last calculated for the yearly interval. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created 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. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CSO_SCHML_JOB_TRACKER_PK | Unique | Default | METRIC_TYPE_ID |