FFS_ACTIVITY_LINK
Stores links created between actual activities.
Details
-
Schema: FUSION
-
Object owner: FFS
-
Object type: TABLE
-
Tablespace: DATA
Primary Key
| Name | Columns |
|---|---|
|
FFS_ACTIVITY_LINK_PK |
FROM_ID, TO_ID, TYPE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| FROM_ID | NUMBER | 10 | Yes | Identifier of the first linked activity. Reference to ffs_activity.aid. | |
| TO_ID | NUMBER | 10 | Yes | Identifier of the second linked activity. Reference to ffs_activity.aid. | |
| TYPE_ID | NUMBER | 5 | Yes | Identifier of activity Link type. | |
| SEQUENCE | VARCHAR2 | 15 | Restriction on activities processing order. | ||
| MIN_INTERVAL | VARCHAR2 | 14 | Defines if the minimum time delay is used for this activity link. | ||
| MIN_INTERVAL_VALUE | NUMBER | 5 | Yes | Minimum time interval (in minutes) between subsequent linked activities, for the links that define the relative order of the activities. This parameter can only be sent if it is configured as 'Adjustable' in the link template configuration. If the parameter is missing in the request, the value from the template wil be used. | |
| MAX_INTERVAL | VARCHAR2 | 14 | Defines if the maximum time delay is used for this activity link. | ||
| MAX_INTERVAL_VALUE | NUMBER | 5 | Yes | Maximum time interval (in minutes) between subsequent linked activities, for the links that define the relative order of the activities. This parameter can only be sent if it is configured as 'Adjustable' in the link template configuration. If the parameter is missing in the request, the value from the template wil be used. | |
| SCHEDULING | VARCHAR2 | 14 | Activity link restriction On Date Selection ('Same day,'different days'). | ||
| ASSIGNMENT | VARCHAR2 | 19 | Actiivty link restriction On Resource Selection ('Same Resource'.'Different Resource'). | ||
| 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_LINK_N1 | Non Unique | DATA | TO_ID |
| FFS_ACTIVITY_LINK_PK | Unique | DATA | FROM_ID, TO_ID, TYPE_ID |