Attribute/Logical Rolename |
Domain |
Datatype |
NULL |
Definition |
TASK_ID |
|
VARCHAR(40) |
YES |
Name: Task ID Description: Unique Identifier for Task . |
S_TASK_OBJECT_CD |
|
VARCHAR(10) |
YES |
Name: Module Description: Indicates object that task is associated with. The valid values are: ADVANCE ER EA. |
ADVANCE_ID |
|
VARCHAR(40) |
YES |
Name: Advance ID Description: The unique identifier for the advance. |
EXP_AUTH_ID |
|
VARCHAR(10) |
YES |
Name: Expense Authorization ID Description: The unique identifier for the expense authorization. |
EXP_RPT_ID |
|
VARCHAR(10) |
YES |
Name: Expense Report ID Description: The unique identifier for the expense report. |
EA_EXPENSE_ID |
|
NUMERIC(10, 0) |
YES |
Name: EA Expense ID Description: The unique identifier for expense on expense authorization. |
ER_EXPENSE_ID |
|
NUMERIC(10, 0) |
YES |
Name: ER Expense ID Description: The unique identifier for expense on expense authorization. |
EA_ALLOCATION_ID |
|
NUMERIC(10, 0) |
YES |
Name: EA Allocation ID Description: Identifies the charge number that is approved during line level approval process. |
ER_ALLOCATION_ID |
|
NUMERIC(10, 0) |
YES |
Name: EA Allocation ID Description: Identifies the charge number that is approved during line level approval process. |
ATTACHMENT_ID |
|
VARCHAR(40) |
YES |
Name: Attachment ID Description: Indentifies the attachment for the completed task if appropriate. |
FUNCTIONAL_ROLE_CD |
|
VARCHAR(10) |
YES |
Name: Attachment ID Description: Indentifies the attachment for the completed task if appropriate. |
BACKUP_FUNCTIONAL_ROLE_CD |
|
VARCHAR(10) |
YES |
Name: Backup Functional Role Description: The functional role that is the backup for this functional role. |
S_TASK_TYPE_CD |
|
VARCHAR(10) |
YES |
Name: Task Type Description: Indicates the type of TASK. The valid values are CREATE SUBMIT REVIEW APPROVE ATTACH. |
S_TASK_SUB_OBJECT_CD |
|
VARCHAR(10) |
YES |
Name: Task Object Description: Indicates object that task is performed on. The valid values are: OVERALL CHARGE EXPENSE ATTACHMENT. |
ATTACHMENT_TYPE_CD |
|
VARCHAR(10) |
YES |
Name: Attachment Type Description: The attachment type related to task. |
S_TASK_RULE_CD |
|
VARCHAR(1) |
YES |
Name: Task Edit Description: The business rule for task attachment. The value vales are: R – Required O - Optional. |
S_TASK_EDIT_CD |
|
VARCHAR(1) |
YES |
Name: Task Edit Description: Indicates whether user gets error or warning, The valid are: E – Error W – Warning N – None. |
TASK_TEXT |
|
VARCHAR(1000) |
YES |
|
TASK_REJECT_TEXT |
|
VARCHAR(1000) |
YES |
Name: Comments Description: User comment when rejecting\voiding task. |
TASK_EXPORT_FL |
|
VARCHAR(1) |
YES |
Name: Attachment Export Indicator Description: Y/N indicator as to whether task is required for export. |
CLEAR_TASK_FL |
|
VARCHAR(1) |
YES |
Name: Remove Task Indicator Description: Indicator as to whether attachment link should be removed on rejection, revision, or correction. |
TASK_SEQ_NO |
|
NUMERIC(10, 0) |
YES |
Name: Task Sequence Description: The sequence of where task falls in object processing. |
TASK_COMPLETE_FL |
|
VARCHAR(1) |
YES |
Name: Task Complete Flag Description: Logical as to task has been completed. |
TASK_REJECTED_FL |
|
VARCHAR(1) |
YES |
Name: Task Rejected Flag Description: Logical as to task has been rejected. |
TASK_EMPL_ID |
|
VARCHAR(20) |
YES |
Name: Task Completed By Description: Employee ID of person performing task. |
TASK_DUE_DTT |
|
DATE |
YES |
Name: Task Due Date Time Description: Date and time the task should be complete.. |
TASK_COMPLETE_DTT |
|
DATE |
YES |
Name: Task Completed Date Time Description: Date and time the task was complete. |
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. |
LOW_NOTIFY_FL |
|
VARCHAR(1) |
YES |
Name: Low Priority Notify Flag Description: Logical as to whether role should be sent e-mail for low priority tasks. |
MED_NOTIFY_FL |
|
VARCHAR(1) |
YES |
Name: Medium Priority Notify Flag Description: Logical as to whether role should be sent e-mail for medium priority tasks. |
HIGH_NOTIFY_FL |
|
VARCHAR(1) |
YES |
Name: High Notify Flag Description: Logical as to whether role should be sent e-mail for high priority tasks. |
MODIFIED_BY |
|
VARCHAR(20) |
YES |
|
ROWVERSION |
|
NUMERIC(10, 0) |
YES |
|
TIME_STAMP |
|
DATE |
YES |
|
S_TASK_CD |
|
VARCHAR(20) |
YES |
|