ColumnName |
Domain |
Datatype |
NULL |
Definition |
EVENT_CD |
|
VARCHAR2(5) |
NO |
Name: Event. Description: The event unique identifier. |
EMPL_ID |
|
VARCHAR2(20) |
NO |
Name: Employee ID. Description: The Employee ID of the employee sent the task. |
ALERT_DTT |
|
DATE |
NO |
Name: Alert Date/Time. Description: Date/time the alert was created. |
ALERT_DESC |
|
VARCHAR2(120) |
NO |
Name: Alert Description. Description: Description of the alert. |
ORIGINATOR_NAME |
|
VARCHAR2(65) |
NO |
Name: Originator Name. Description: Name of person that originated alert. It could be the last name of the employee or "System" if the task was originated by system. |
ALERT_TEXT |
|
VARCHAR2(4000) |
YES |
Name: Alert Text. Description: Notes/comments provided by originator. |
MODIFIED_BY |
|
VARCHAR2(20) |
NO |
Name: Modified By. Description: The User ID of the person who last modified this record. |
ROWVERSION |
|
NUMBER(10, 0) |
NO |
Name: Row Version. Description: The number of times this record has been updated. |
TIME_STAMP |
|
DATE |
NO |
Name: Time Stamp. Description: Date and time the record was last modified. |
FUNCTIONAL_ROLE_CD |
|
VARCHAR2(10) |
NO |
Name: Functional Role. Description: The functional role that the task was sent to. |