Attribute/Logical Rolename |
Domain |
Datatype |
NULL |
Definition |
TASK_ID |
|
VARCHAR(40) |
NO |
Name: Task ID Description: Unique Identifier for Task. |
CORRECTION_NO |
|
NUMERIC(10, 0) |
NO |
Name: Correction Number Description: |
S_TASK_OBJECT_CD |
|
VARCHAR(10) |
NO |
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: ER_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) |
NO |
Name: FUNCTIONAL_ROLE_CD Description: The functional role that must perform the task. |
BACKUP_FUNCTIONAL_ROLE_CD |
|
VARCHAR(10) |
NO |
Name: Backup Functional Role Description: The functional role that is the backup for this functional role. |
S_TASK_TYPE_CD |
|
VARCHAR(10) |
NO |
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) |
NO |
Name: Task Object Description: Indicates object that task is performed on. The valid values are: OVERALL CHARGE EXPENSE ATTACHMENT. |
ATTACHMENT_TYPE_CD |
|
VARCHAR(10) |
NO |
Name: ATTACHMENT_TYPE_CD Description: The attachment type related to task. |
S_TASK_RULE_CD |
|
VARCHAR(1) |
NO |
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 |
|
VARCHAR(1) |
NO |
Name: S_TASK_EDIT_CD Description: Indicates whether user gets error or warning, The valid are: E – Error W – Warning N – None. |
TASK_TEXT |
|
VARCHAR(1000) |
YES |
Name: TASK_TEXT Description: User comment when completing task. |
TASK_REJECT_TEXT |
|
VARCHAR(1000) |
YES |
Name: TASK_REJECT_TEXT Description: User comment when rejecting voiding task. |
TASK_EXPORT_FL |
|
VARCHAR(1) |
NO |
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 |
|
VARCHAR(1) |
NO |
Name: CLEAR_TASK_FL Description: Indicator as to whether attachment link should be removed on rejection, revision, or correction. |
TASK_SEQ_NO |
|
NUMERIC(10, 0) |
YES |
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 |
|
VARCHAR(1) |
NO |
Name: TASK_COMPLETE_FL Description: Logical as to task has been completed. |
TASK_REJECTED_FL |
|
VARCHAR(1) |
NO |
Name: TASK_REJECTED_FL Description: Logical as to task has been rejected. |
TASK_EMPL_ID |
|
VARCHAR(20) |
YES |
Name: TASK_EMPL_ID 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_COMPLETE_DTT 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 Description: Date time the task was upgraded to high priority. |
LOW_NOTIFY_FL |
|
VARCHAR(1) |
NO |
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) |
NO |
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) |
NO |
Name: High Notify Flag Description: Logical as to whether role should be sent e-mail for medium priority tasks. |
MODIFIED_BY |
|
VARCHAR(20) |
NO |
|
ROWVERSION |
|
NUMERIC(10, 0) |
NO |
|
TIME_STAMP |
|
DATE |
NO |
|
S_TASK_CD |
|
VARCHAR(20) |
YES |
|
USER_DIRECTED_FL |
|
VARCHAR(1) |
NO |
Name: USER DIRECTED FLAG Description: User Directed Task Indicator. |
S_DOCUMENT_MISSING_FL |
|
VARCHAR(1) |
NO |
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 |
|
VARCHAR(1) |
NO |
Name: Document Status Description: P is Pending R is Received and N is Not Applicable. |
TASK_NOTE_TEXT |
|
VARCHAR(254) |
YES |
Name: Document Missing Reason Description: Provides a reason for a missing document . |
Entity Name |
Type |
Cardinality |
Business Name |
VerbPhrase |
InversePhrase |
Foreign Keys |
Is Supertype |
FUNCTIONAL_ROLE |
Non-Identifying |
One To Zero or More |
|
|
|
FUNCTIONAL_ROLE_CD |
NO |
FUNCTIONAL_ROLE |
Non-Identifying |
One To Zero or More |
|
|
|
BACKUP_FUNCTIONAL_ROLE_CD |
NO |
GENERAL_CONFIG_ATTACHMENT |
Non-Identifying |
One To Zero or More |
|
|
|
ATTACHMENT_TYPE_CD |
NO |
EMPL |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
TASK_EMPL_ID |
NO |
EXP_ADVANCE |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
ADVANCE_ID |
NO |
EXP_AUTH |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
EXP_AUTH_ID |
NO |
EXP_RPT |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
EXP_RPT_ID |
NO |
EXP_AUTH_EXPENSE |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
EXP_AUTH_ID, EA_EXPENSE_ID |
NO |
EXP_RPT_EXPENSE |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
EXP_RPT_ID, ER_EXPENSE_ID |
NO |
EXP_AUTH_EXPENSE_CHARGE |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
EXP_AUTH_ID, EA_EXPENSE_ID, EA_ALLOCATION_ID |
NO |
EXP_AUTH_CHARGE_ALLOCATIONS |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
EXP_AUTH_ID, EA_ALLOCATION_ID |
NO |
EXP_RPT_CHARGE_ALLOCATIONS |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
EXP_RPT_ID, ER_ALLOCATION_ID |
NO |