TASK_ID |
ColumnName | TASK_ID |
Definition | Name: Task ID Description: Unique Identifier for Task. |
CORRECTION_NO |
ColumnName | CORRECTION_NO |
Definition | Name: Correction Number Description: |
S_TASK_OBJECT_CD |
ColumnName | S_TASK_OBJECT_CD |
Definition | Name: Module Description: Indicates object that task is associated with. The valid values are ADVANCE ER EA. |
ADVANCE_ID |
ColumnName | ADVANCE_ID |
Definition | Name: Advance ID Description: The unique identifier for the advance. |
EXP_AUTH_ID |
ColumnName | EXP_AUTH_ID |
Definition | Name: Expense Authorization ID Description: The unique identifier for the expense authorization. |
EXP_RPT_ID |
ColumnName | EXP_RPT_ID |
Definition | Name: Expense Report ID Description: The unique identifier for the expense report. |
EA_EXPENSE_ID |
ColumnName | EA_EXPENSE_ID |
Definition | Name: EA Expense ID Description: The unique identifier for expense on expense authorization. |
ER_EXPENSE_ID |
ColumnName | ER_EXPENSE_ID |
Definition | Name: ER Expense ID Description: The unique identifier for expense on expense authorization. |
EA_ALLOCATION_ID |
ColumnName | EA_ALLOCATION_ID |
Definition | Name: EA Allocation ID Description: Identifies the charge number that is approved during line level approval process. |
ER_ALLOCATION_ID |
ColumnName | ER_ALLOCATION_ID |
Definition | Name: ER_ALLOCATION_ID Description: Identifies the charge number that is approved during line level approval process. |
ATTACHMENT_ID |
ColumnName | ATTACHMENT_ID |
Definition | Name: Attachment ID Description: Indentifies the attachment for the completed task if appropriate. |
FUNCTIONAL_ROLE_CD |
ColumnName | FUNCTIONAL_ROLE_CD |
Definition | Name: FUNCTIONAL_ROLE_CD Description: The functional role that must perform the task. |
BACKUP_FUNCTIONAL_ROLE_CD |
ColumnName | BACKUP_FUNCTIONAL_ROLE_CD |
Definition | Name: Backup Functional Role Description: The functional role that is the backup for this functional role. |
S_TASK_TYPE_CD |
ColumnName | S_TASK_TYPE_CD |
Definition | Name: Task Type Description: Indicates the type of task. The valid values are CREATE SUBMIT REVIEW APPROVE ATTACH. |
S_TASK_SUB_OBJECT_CD |
ColumnName | S_TASK_SUB_OBJECT_CD |
Definition | Name: Task Object Description: Indicates object that task is performed on. The valid values are: OVERALL CHARGE EXPENSE ATTACHMENT. |
ATTACHMENT_TYPE_CD |
ColumnName | ATTACHMENT_TYPE_CD |
Definition | Name: ATTACHMENT_TYPE_CD Description: The attachment type related to task. |
S_TASK_RULE_CD |
ColumnName | S_TASK_RULE_CD |
Definition | Name: S_TASK_RULE_CD Description: The business rule for task attachment. The value vales are: R – Required O - Optional N – None. |
S_TASK_EDIT_CD |
ColumnName | S_TASK_EDIT_CD |
Definition | Name: S_TASK_EDIT_CD Description: Indicates whether user gets error or warning, The valid are: E – Error W – Warning N – None. |
TASK_TEXT |
ColumnName | TASK_TEXT |
Definition | Name: TASK_TEXT Description: User comment when completing task. |
TASK_REJECT_TEXT |
ColumnName | TASK_REJECT_TEXT |
Definition | Name: TASK_REJECT_TEXT Description: User comment when rejecting voiding task. |
TASK_EXPORT_FL |
ColumnName | TASK_EXPORT_FL |
Definition | Name: TASK_EXPORT_FL Description: Y N indicator as to whether task is required for export. Note: Currently not needed for ER but keep for future capability. |
CLEAR_TASK_FL |
ColumnName | CLEAR_TASK_FL |
Definition | Name: CLEAR_TASK_FL Description: Indicator as to whether attachment link should be removed on rejection, revision, or correction. |
TASK_SEQ_NO |
ColumnName | TASK_SEQ_NO |
Definition | Name: TASK_SEQ_NO Description: The sequence of where task falls in object processing. Note: Null means task can be done at any time. |
TASK_COMPLETE_FL |
ColumnName | TASK_COMPLETE_FL |
Definition | Name: TASK_COMPLETE_FL Description: Logical as to task has been completed. |
TASK_REJECTED_FL |
ColumnName | TASK_REJECTED_FL |
Definition | Name: TASK_REJECTED_FL Description: Logical as to task has been rejected. |
TASK_EMPL_ID |
ColumnName | TASK_EMPL_ID |
Definition | Name: TASK_EMPL_ID Description: Employee ID of person performing task. |
TASK_DUE_DTT |
ColumnName | TASK_DUE_DTT |
Definition | Name: Task Due Date Time Description: Date and time the task should be complete. |
TASK_COMPLETE_DTT |
ColumnName | TASK_COMPLETE_DTT |
Definition | Name: TASK_COMPLETE_DTT Description: Date and time the task was complete. |
MED_TASK_DTT |
ColumnName | MED_TASK_DTT |
Definition | Name: Medium Priority Task Date Time Description: Date time the task was upgraded to medium priority. |
HIGH_TASK_DTT |
ColumnName | HIGH_TASK_DTT |
Definition | Name: High Priority Description: Date time the task was upgraded to high priority. |
LOW_NOTIFY_FL |
ColumnName | LOW_NOTIFY_FL |
Definition | Name: Low Priority Notify Flag Description: Logical as to whether role should be sent e-mail for low priority tasks. |
MED_NOTIFY_FL |
ColumnName | MED_NOTIFY_FL |
Definition | Name: Medium Priority Notify Flag Description: Logical as to whether role should be sent e-mail for medium priority tasks. |
HIGH_NOTIFY_FL |
ColumnName | HIGH_NOTIFY_FL |
Definition | Name: High Notify Flag Description: Logical as to whether role should be sent e-mail for medium priority tasks. |
MODIFIED_BY |
ColumnName | MODIFIED_BY |
Definition |
ROWVERSION |
ColumnName | ROWVERSION |
Definition |
TIME_STAMP |
ColumnName | TIME_STAMP |
Definition |
S_TASK_CD |
ColumnName | S_TASK_CD |
Definition |
USER_DIRECTED_FL |
ColumnName | USER_DIRECTED_FL |
Definition | Name: USER DIRECTED FLAG Description: User Directed Task Indicator. |
S_DOCUMENT_MISSING_FL |
ColumnName | S_DOCUMENT_MISSING_FL |
Definition | Name: Document Missing flag Description: Indicates if the document is missing. Valid values include Y for Yes and N for No. |
S_DOCUMENT_STATUS_CD |
ColumnName | S_DOCUMENT_STATUS_CD |
Definition | Name: Document Status Description: P is Pending R is Received and N is Not Applicable. |
TASK_NOTE_TEXT |
ColumnName | TASK_NOTE_TEXT |
Definition | Name: Document Missing Reason Description: Provides a reason for a missing document . |