FFS_SP_RUN_LOG_DETAILS

Used to store planned move activity actions that have not actually been performed for some a logged reason.

Details

• Schema: FUSION

• Object owner: FFS

• Object type: TABLE

• Tablespace: DATA

Primary Key

Name	Columns
FFS_SP_RUN_LOG_DETAILS_PK	LOG_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
LOG_ID	NUMBER		19	Yes	Autoincremental unique identifier of the record; the primary key.
ACTION_ID	NUMBER		19	Yes	Who column: identifier of the action that leads to the non-assigment. It is the foreign key to the table FFS_SP_RUN_LOG.
ACTION_TIME	TIMESTAMP			Yes	Who column: timestamp of the action.
ACTIVITY_ID	NUMBER		10	Yes	Identifier of the activity that were not assigned. Also the field contains identifiers of the field resources who were not sent to the scheduling engine. Then the IDs of field resources have the negative sign while activity's IDs are positive.
ROUTE_ID	NUMBER		10	Yes	Identifier of the route where the non-assigned activity was.
NOT_ASSIGNED_REASON_CODE	NUMBER		5	Yes	Numerical code of the activity non-assignment reason or field resource non-use reason.
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_SP_RUN_LOG_DETAILS_N1	Non Unique	DATA	ACTION_ID
FFS_SP_RUN_LOG_DETAILS_PK	Unique	DATA	LOG_ID