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