ColumnName |
Domain |
Datatype |
NULL |
Definition |
EXP_RPT_TYPE_CD |
|
VARCHAR2(10) |
NO |
Name: Expense Report Type Description: Unique identifier for this Expense Report Type. |
FUNCTIONAL_ROLE_CD |
|
VARCHAR2(10) |
NO |
Name: Functional Role Description: Unique identifier for this functional role. |
S_TASK_OBJECT_CD |
|
VARCHAR2(10) |
NO |
Name: Task Object Description: Indicates object that task is associated with. The valid values are: ADVANCE EA ER. |
S_TASK_SUB_OBJECT_CD |
|
VARCHAR2(10) |
NO |
Name: Task Object Description: Indicates object that task is performed on. The valid values are: OVERALL EXPENSE CHARGE ATTACHMENT. |
S_TASK_TYPE_CD |
|
VARCHAR2(10) |
NO |
Name: Task Type Description: Indicates the type of task. The valid values are SUBMIT REVIEW APPROVE ATTACH. |
ATTACHMENT_TYPE_CD |
|
VARCHAR2(10) |
NO |
Name: Attachment Type Description: The attachment type related to task. |
TASK_SEQ_NO |
|
NUMBER(10, 0) |
YES |
Name: Task Sequence Description: The sequence of where task falls in object processing. |
BACKUP_FUNCTIONAL_ROLE_CD |
|
VARCHAR2(10) |
NO |
Name: Backup Functional Role Description: The backup functional role that should perform task for primary functional role. |
S_TASK_RULE_CD |
|
VARCHAR2(1) |
NO |
Name: Attachment Type Rule Description: The business rule for task attachment. The valid values are: R – Required O – Optional. |
S_TASK_EDIT_CD |
|
VARCHAR2(1) |
NO |
Name: Attachment Type Edit Description: Indicates whether user gets error or warning, The valid values are: E – Error W – Warning N - None. |
MIN_EXPENSE_AMT |
|
NUMBER(15, 5) |
NO |
Name: Starting Expense Amount Description: The minimum expense amount that functional role must approve expense reports of this type. |
MAX_EXPENSE_AMT |
|
NUMBER(15, 5) |
NO |
Name: Ending Expense Amount Description: The maximum expense amount that functional role must approve expense reports of this type. |
MIN_OVER_CEILING_AMT |
|
NUMBER(15, 5) |
NO |
Name: Starting Over Ceiling Amount Description: The minimum over ceiling amount that functional role must approve expense reports of this type. |
MAX_OVER_CEILING_AMT |
|
NUMBER(15, 5) |
NO |
Name: Ending Over Ceiling Amount Description: The maximum over ceiling amount that functional role must approve expense reports of this type. |
MIN_UNALLOWABLE_AMT |
|
NUMBER(15, 5) |
NO |
Name: Starting Unallowable Amount Description: The minimum unallowable amount that functional role must approve expense reports of this type. |
MAX_UNALLOWABLE_AMT |
|
NUMBER(15, 5) |
NO |
Name: Ending Unallowable Amount Description: The maximum unallowable amount that functional role must approve expense reports of this type. |
MIN_ADVANCE_AMT |
|
NUMBER(15, 5) |
NO |
Name: Starting Cash Advance Amount Description: The minimum advance amount that functional role must approve for advances associated with this expense report type. |
MAX_ADVANCE_AMT |
|
NUMBER(15, 5) |
NO |
Name: Ending Cash Advance Amount Description: The maximum advance amount that functional role must approve for advances associated with this expense report type . |
TASK_EXPORT_FL |
|
VARCHAR2(1) |
NO |
Name: Required For Export Indicator Description: Indicator as to whether task must be complete to allow export of authorization. |
CLEAR_TASK_FL |
|
VARCHAR2(1) |
NO |
Name: Remove Attachment Indicator Description: Indicator as to whether task completion information should be cleared when object\sub object is rejected or revised. |
START_DTT |
|
DATE |
NO |
Name: Inactive Date Time Description: Date time that task rule started for expense type. |
END_DTT |
|
DATE |
YES |
Name: Inactive Date Time Description: Date time that task rule ended for expense type. |
MED_PRIORITY_DAYS_NO |
|
NUMBER(5, 0) |
NO |
Name: Medium Priority Days Description: The number of days that need to expire before task is upgraded to medium priority. |
MED_PRIORITY_HRS_NO |
|
NUMBER(5, 0) |
NO |
Name: Medium Priority Hours Description: The number of hours that need to expire before task is upgraded to medium priority. |
MED_PRIORITY_MINS_NO |
|
NUMBER(5, 0) |
NO |
Name: Medium Priority Minutes Description: The number of minutes that need to expire before task is upgraded to medium priority. |
HIGH_PRIORITY_DAYS_NO |
|
NUMBER(5, 0) |
NO |
Name: High Priority Days Description: The number of days that need to expire before task is upgraded to high priority. |
HIGH_PRIORITY_HRS_NO |
|
NUMBER(5, 0) |
NO |
Name: High Priority Hours Description: The number of hours that need to expire before task is upgraded to high priority. |
HIGH_PRIORITY_MINS_NO |
|
NUMBER(5, 0) |
NO |
Name: High Priority Description: The number of minutes that need to expire before task is upgraded . |
COMPLETE_TASK_DAYS_NO |
|
NUMBER(5, 0) |
NO |
Name: Days Due Description: The number of days that role should complete the task. |
COMPLETE_TASK_HRS_NO |
|
NUMBER(5, 0) |
NO |
Name: Hours Due Description: The number of hours that role should complete the task. |
COMPLETE_TASK_MINS_NO |
|
NUMBER(5, 0) |
NO |
Name: Minutes Due Description: The number of minutes that role should complete the task. |
LOW_NOTIFY_FL |
|
VARCHAR2(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 |
|
VARCHAR2(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 |
|
VARCHAR2(1) |
NO |
Name: High Notify Flag Description: Logical as to whether role should be sent e-mail for high priority tasks. |
S_TASK_INIT_PRIORITY_CD |
|
VARCHAR2(1) |
NO |
Name: S_TASK_INIT_PRIORITY_CD Description: The initial priority for the task. The valid values are L – Low M – Medium H – High. |
USER_DIRECTED_FL |
|
VARCHAR2(1) |
NO |
Name: User Directed Flag Description: Logical as to this task can be user directed. |
INCLUDE_BACKUP_ROLE_FL |
|
VARCHAR2(1) |
NO |
Name: Include Backup Functional Role Flag Description: Logical as whether Backup Functional Role(s) will be included in the list of employees that can perform the task. |
MODIFIED_BY |
|
VARCHAR2(20) |
NO |
|
ROWVERSION |
|
NUMBER(10, 0) |
NO |
|
TIME_STAMP |
|
DATE |
NO |
|