FFS_SCHED_ML_VIOLATION
Virtual dispatcher violations storage.
Details
-
Schema: FUSION
-
Object owner: FFS
-
Object type: TABLE
-
Tablespace: ffs_sched_ml_violation
Primary Key
| Name | Columns |
|---|---|
|
FFS_SCHED_ML_VIOLATION_PK |
VIOLATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| VIOLATION_ID | NUMBER | 10 | Yes | Violation ID, auto incremented ID. | |
| ACTION_TIME | TIMESTAMP | The time when violation is occured. | |||
| RESOURCE_ID | NUMBER | 10 | Resource for which violation is linked. | ||
| USER_ID | NUMBER | 18 | The user ID that made violation. | ||
| ACTIVITY_ID | NUMBER | 10 | Activity ID that linked with the violation. | ||
| REQUIRED_WORK_SKILL | VARCHAR2 | 1024 | Work skills required for activity. | ||
| REQUIRED_WORK_ZONE | NUMBER | 10 | Work zone required for activity. | ||
| WORK_SKILL | VARCHAR2 | 1024 | Work skills that has resource.. | ||
| WORK_ZONE | VARCHAR2 | 1024 | Work zones that linked with resource. | ||
| VIOLATIONS_BY | NUMBER | 10 | Violation bit mask, by work skill and by work zone. | ||
| ACTION_TYPE | VARCHAR2 | 16 | Violation type. Can be complete or decline. | ||
| 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 |
|---|---|---|---|
| FFS_SCHED_ML_VIOLATION_N1 | Non Unique | FFS_SCHED_ML_VIOLATION_N1 | RESOURCE_ID, ACTION_TYPE |
| FFS_SCHED_ML_VIOLATION_PK | Unique | FFS_SCHED_ML_VIOLATION_PK | VIOLATION_ID |