FFS_ACTIVITY

Details

Schema: FUSION
Object owner: FFS
Object type: TABLE
Tablespace: REFERENCE

Primary Key

Name	Columns
FFS_ACTIVITY_TYPE_PK	TYPE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
TYPE_ID	NUMBER		5	Yes	Unique identifier of the activity type.
LABEL	VARCHAR2	128			It is a text label of the type. The activity type labels are unique inside of the same company.
STATUS	VARCHAR2	8			It is a status of the type. The status controls an ability to select this type in GUI for a new object.
NODE_TYPE	VARCHAR2	5			It defines if this type is a group or a particular item.
GROUP_ID	NUMBER		5		It is a reference to a group of types. Please also note that the system also allows to include one group into another one.
FEATURES	NUMBER		10	Yes	It is a bitmask field that defines active features for this activity type.
PENDING_COLOR	VARCHAR2	6			These are values of colors for the 'pending' status of activities and teamworks. Value example: FFDE00.
STARTED_COLOR	VARCHAR2	6			These are values of colors for the 'started' status of activities. Value example: FFDE00.
COMPLETE_COLOR	VARCHAR2	6			These are values of colors for the 'complete' status of activities. Value example: FFDE00.
SUSPENDED_COLOR	VARCHAR2	6			These are values of colors for the 'suspended' status. Value example: FFDE00.
CANCELLED_COLOR	VARCHAR2	6			These are values of colors for the 'cancelled' status of activities. Value example: FFDE00.
NOTDONE_COLOR	VARCHAR2	6			These are values of colors for the 'notdone' status of activities. Value example: FFDE00.
NOT_ORDERED_COLOR	VARCHAR2	6			It is a value of color for a non-ordered 'pending' activity or teamwork. It has a higher priority than 'pending_color'.
WARNING_COLOR	VARCHAR2	6			It is a value of color for an activity or a teamwork with a warning. It has the highest priority.
SEGMENT_MIN_DURATION	NUMBER		5	Yes	Multi-day activities: Minimal duration of a single segment (minutes).
SEGMENT_MAX_DURATION_PER_DAY	NUMBER		5	Yes	Multi-day activities: Maximal total duration of segments created for a particular day (minutes).
SEGMENT_ROUND_TO	NUMBER		5	Yes	Multi-day activities: Rounding of duration values for generated segments (minutes).
SEGMENT_SW_RESERVATION	NUMBER		3	Yes	Multi-day activities: Minimum amount of time available that should be before end of service window (percent of total SW length).
SEGMENT_MAX_DAYS_TO_SKIP	NUMBER		5	Yes	Multi-day activities: Maximum number of consecutive days wo segments that can be skipped because of non-working/overtime/overdue alerts.
DEFAULT_DURATION_AVG	NUMBER		10	Yes	Default average duration for each activity type.
ENROUTE_COLOR	VARCHAR2	6			These are values of colors for the 'enroute' status of activities. Value example: FFDE00.
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.
SEED_DATA_SOURCE	VARCHAR2	512			Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.
ORA_SEED_SET1	VARCHAR2	1		Yes	Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N.
ORA_SEED_SET2	VARCHAR2	1		Yes	Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N.
DELETED_FLAG	VARCHAR2	1			Indicates whether the record is logically deleted (Y - soft deleted, N or NULL - active).

Indexes

Index	Uniqueness	Tablespace	Columns
FFS_ACTIVITY_TYPE_PK	Unique	DATA	TYPE_ID, ORA_SEED_SET1
FFS_ACTIVITY_TYPE_PK1	Unique	DATA	TYPE_ID, ORA_SEED_SET2