FFS_ROUTE_NOT_ACTIVE_HIST
Contains resources received the "not activated route" messages for the current working day. This table is intended to avoid generation and sending this message to the same resource multiple times for the same day.
Details
-
Schema: FUSION
-
Object owner: FFS
-
Object type: TABLE
-
Tablespace: DATA
Primary Key
| Name | Columns |
|---|---|
|
FFS_ROUTE_NOT_ACTIVE_HIST_PK |
RESOURCE_ID, ROUTE_DATE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RESOURCE_ID | NUMBER | 8 | Yes | Identifier of the resource the 'not activated' trigger was invoked for. | |
| ROUTE_DATE | DATE | Yes | Resource's route date. Date is specified in 'YYYY-MM-DD' format. | ||
| 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_ROUTE_NOT_ACTIVE_HIST_PK | Unique | DATA | RESOURCE_ID, ROUTE_DATE |