14.1 sp102_activity_conflicts
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
This table is used to determine how the system should handle an activity when it is first input or when it is modified such that it overlaps (i.e. is concurrent with) another activity for the same employee. The way in which two such "conflicting" activities are resolved depends on the type of the existing activity and of the newly input (or newly modified) activity. The options are either to allow the overlap; or to warn the user of the existing activity and prompt him to confirm the details of the new activity; or to forbid the overlap.
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| current_activity | number(2) |  | |
| new_activity | number(2) | | |
| resolution | number(2) |  |
Keys
unique (current_activity, new_activity)
foreign key (current_activity) references sp105_activity_types (activity_type)
foreign key (new_activity) references sp105_activity_types (activity_type)
Column Descriptions
| Field | Description |
|---|---|
| current_activity | A number identifying the type of the existing activity. A null value in this column is taken to match any activity type. |
| new_activity | A number identifying the type of the new (or newly modified) activity. A null value in this column is taken to match any activity type. |
| resolution | A number indicating how the conflict should be handled - 0 = silently allow the overlap. 20 = prompt the user to confirm before allowing it. 30 = forbid the overlap |