FFS_ACTIVITY_SEGMENT_MODE
Stores method to be used to manage segments of a multi-day activity for a particular day.
Details
-
Schema: FUSION
-
Object owner: FFS
-
Object type: TABLE
-
Tablespace: DATA
Primary Key
| Name | Columns |
|---|---|
|
FFS_ACTIVITY_SEGMENT_MODE_PK |
ACTIVITY_ID, ROUTE_DATE, RESOURCE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ARCH_DATE | DATE | Yes | DB record partitioning date. Set automatically by DB Optimization job. | ||
| ACTIVITY_ID | NUMBER | 10 | Yes | Identifier of the segmentable activity, its segments are assigned to the RESOURCE_ID on the date ROUTE_DATE. It is the foreign key to the table FFS_ACTIVITY. | |
| ROUTE_DATE | DATE | Yes | Date Of The Route Which Segments Of The Segmentable Activity Activity_Id Are Assigned To. | ||
| RESOURCE_ID | NUMBER | 8 | Yes | Identifier Of The Resource Who Segments Of The Segmentable Activity Activity_Id Are Assigned To. It Can Be A Filed Resource As Well As A Bucket. | |
| TOTAL_COUNT | NUMBER | 5 | Yes | Total number of segments of the segmentable activity ACTIVITY_ID that are assigned to the RESOURCE_ID on the day ROUTE_DATE. | |
| TOTAL_DURATION | NUMBER | 5 | Yes | Total duration of all segments of the segmentable activity ACTIVITY_ID that are assigned to the RESOURCE_ID on the date ROUTE_DATE regardless the status of the segments. | |
| STARTED_DURATION | NUMBER | 5 | Yes | Duration of the started segment of the segmentable activity ACTIVITY_ID that is assigned to the RESOURCE_ID on the day ROUTE_DATE. | |
| FINISHED_COUNT | NUMBER | 5 | Yes | Total number of all segments with the final status that belong to the segmentable activity ACTIVITY_ID and are assigned to the RESOURCE_ID on the date ROUTE_DATE. | |
| FINISHED_DURATION | NUMBER | 5 | Yes | Total duration of all segments with the final status that belong to the segmentable activity ACTIVITY_ID. | |
| CANCELLED_COUNT | NUMBER | 5 | Yes | Total number of all cancelled segments that belong to the segmentable activity ACTIVITY_ID and are assigned to the RESOURCE_ID on the date ROUTE_DATE. | |
| OPTIONS | NUMBER | 3 | Yes | Binary representation of the number is the set of boolean flags which are responsible for different assignment options. | |
| 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_ACTIVITY_SEGMENT_MODE_PK | Unique | DATA | ACTIVITY_ID, ROUTE_DATE, RESOURCE_ID |