Attribute/Logical Rolename |
Domain |
Datatype |
NULL |
Definition |
TASK_ID |
|
VARCHAR(40) |
YES |
Name: Task ID Description: The unique ID for task. |
EMPL_ID |
|
VARCHAR(20) |
YES |
Name: Employee Description: The employees that can be assigned task. |
FUNCTIONAL_ROLE_CD |
|
VARCHAR(10) |
YES |
Name: Functional Role Description: The functional role that assignment is for. |
BACKUP_FL |
|
VARCHAR(1) |
YES |
Name: Backup Assignment Indicator Description: Indicates whether user assignment is backup role assignment or not. |
ASSIGNED_FL |
|
VARCHAR(1) |
YES |
Name: Current Assignment Indicator Description: . |
DELEGATED_FL |
|
VARCHAR(1) |
YES |
Name: Description: Y N indicator as to whether employee task assignment is currently active. |
USER_DIRECTED_FL |
|
VARCHAR(1) |
YES |
Name: User Directed Assignment Indicator Description: Y N indicator as to whether employee task assignment is user directed . |
LOW_NOTIFY_NO |
|
NUMERIC(10, 0) |
YES |
Name: Low priority Notifications Description: The number of times employee has been notified when task was low priority. |
MED_NOTIFY_NO |
|
NUMERIC(10, 0) |
YES |
Name: Medium Priority Notifications Description: The number of times employee has been notified when task was medium priority. |
HIGH_NOTIFY_NO |
|
NUMERIC(10, 0) |
YES |
Name: High Priority Notifications Description: The number of times employee has been notified when task was high priority. |
MODIFIED_BY |
|
VARCHAR(20) |
YES |
|
ROWVERSION |
|
NUMERIC(10, 0) |
YES |
|
TIME_STAMP |
|
DATE |
YES |
|