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 who was sent the task. |
S_TASK_CD |
|
VARCHAR2(10) |
NO |
Name: Task. Description: The type of task. The valid values are:TSREVIEW - Review Timesheet. TSUPDATE - Update Timesheet. TSSIGN - Sign Timesheet. TSAPPROVE - Approve Timesheet. |
TASK_DTT |
|
DATE |
NO |
Name: Task Date/Time. Description: The date and time the task was created. |
MED_TASK_DTT |
|
DATE |
YES |
Name: Medium Priority Task Date/Time. Description: Date/time the task was upgraded to medium priority. |
HIGH_TASK_DTT |
|
DATE |
YES |
Name: High Priority Task Date/Time. Description: Date/time the task was upgraded to high priority. |
TASK_DESC |
|
VARCHAR2(120) |
NO |
Name: Task Description. Description: The description of the task. |
ORIGINATOR_NAME |
|
VARCHAR2(65) |
NO |
Name: Originator Name. Description: Name of person that originated task. It could be the last name of the employee or "System" if the task was originated by system. |
TASK_TEXT |
|
VARCHAR2(4000) |
YES |
Name: Task 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. |
TASK_EMPL_ID |
|
VARCHAR2(20) |
NO |
Name: Task Employee ID. Description: Employee ID identifier for task. “N/A” if it does not apply. |
TASK_TS_SCHEDULE_CD |
|
VARCHAR2(10) |
NO |
Name: Task Timesheet Schedule. Description: Timesheet frequency for task. “N/A” if it does not apply. |
TASK_YEAR_NO_CD |
|
VARCHAR2(4) |
NO |
Name: Task Timesheet Year. Description: Timesheet frequencys year code for task. N/A if it does not apply. |
TASK_PERIOD_NO_CD |
|
VARCHAR2(3) |
NO |
Name: Task Timesheet Period. Description: Period number for task. N/A if it does not apply. |
TASK_LINE_NO |
|
NUMBER(10, 0) |
NO |
Name: Task Timesheet Line. Description: Line number for task. Zero if it does not apply. |
FUNCTIONAL_ROLE_CD |
|
VARCHAR2(10) |
NO |
Name: Functional Role. Description: The functional role that the task was sent to. |
DELEGATED_FL |
|
VARCHAR2(1) |
NO |
Name: Delegated Flag. Description: Logical as to whether task is delegated. |