EXP_RPT_TYPE_CD |
ColumnName | EXP_RPT_TYPE_CD |
Definition | Name: Expense Report Type Description: Unique identifier for this Expense Report Type. |
FUNCTIONAL_ROLE_CD |
ColumnName | FUNCTIONAL_ROLE_CD |
Definition | Name: Functional Role Description: Unique identifier for this functional role. |
S_TASK_OBJECT_CD |
ColumnName | S_TASK_OBJECT_CD |
Definition | Name: Task Object Description: Indicates object that task is associated with. The valid values are: ADVANCE EA ER. |
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 EXPENSE CHARGE ATTACHMENT. |
S_TASK_TYPE_CD |
ColumnName | S_TASK_TYPE_CD |
Definition | Name: Task Type Description: Indicates the type of task. The valid values are SUBMIT REVIEW APPROVE ATTACH. |
ATTACHMENT_TYPE_CD |
ColumnName | ATTACHMENT_TYPE_CD |
Definition | Name: Attachment Type Description: The attachment type related to task. |
TASK_SEQ_NO |
ColumnName | TASK_SEQ_NO |
Definition | Name: Task Sequence Description: The sequence of where task falls in object processing. |
BACKUP_FUNCTIONAL_ROLE_CD |
ColumnName | BACKUP_FUNCTIONAL_ROLE_CD |
Definition | Name: Backup Functional Role Description: The backup functional role that should perform task for primary functional role. |
S_TASK_RULE_CD |
ColumnName | S_TASK_RULE_CD |
Definition | Name: Attachment Type Rule Description: The business rule for task attachment. The valid values are: R – Required O – Optional. |
S_TASK_EDIT_CD |
ColumnName | S_TASK_EDIT_CD |
Definition | 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 |
ColumnName | MIN_EXPENSE_AMT |
Definition | Name: Starting Expense Amount Description: The minimum expense amount that functional role must approve expense reports of this type. |
MAX_EXPENSE_AMT |
ColumnName | MAX_EXPENSE_AMT |
Definition | Name: Ending Expense Amount Description: The maximum expense amount that functional role must approve expense reports of this type. |
MIN_OVER_CEILING_AMT |
ColumnName | MIN_OVER_CEILING_AMT |
Definition | 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 |
ColumnName | MAX_OVER_CEILING_AMT |
Definition | Name: Ending Over Ceiling Amount Description: The maximum over ceiling amount that functional role must approve expense reports of this type. |
MIN_UNALLOWABLE_AMT |
ColumnName | MIN_UNALLOWABLE_AMT |
Definition | Name: Starting Unallowable Amount Description: The minimum unallowable amount that functional role must approve expense reports of this type. |
MAX_UNALLOWABLE_AMT |
ColumnName | MAX_UNALLOWABLE_AMT |
Definition | Name: Ending Unallowable Amount Description: The maximum unallowable amount that functional role must approve expense reports of this type. |
MIN_ADVANCE_AMT |
ColumnName | MIN_ADVANCE_AMT |
Definition | 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 |
ColumnName | MAX_ADVANCE_AMT |
Definition | 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 |
ColumnName | TASK_EXPORT_FL |
Definition | Name: Required For Export Indicator Description: Indicator as to whether task must be complete to allow export of authorization. |
CLEAR_TASK_FL |
ColumnName | CLEAR_TASK_FL |
Definition | 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 |
ColumnName | START_DTT |
Definition | Name: Inactive Date Time Description: Date time that task rule started for expense type. |
END_DTT |
ColumnName | END_DTT |
Definition | Name: Inactive Date Time Description: Date time that task rule ended for expense type. |
MED_PRIORITY_DAYS_NO |
ColumnName | MED_PRIORITY_DAYS_NO |
Definition | Name: Medium Priority Days Description: The number of days that need to expire before task is upgraded to medium priority. |
MED_PRIORITY_HRS_NO |
ColumnName | MED_PRIORITY_HRS_NO |
Definition | Name: Medium Priority Hours Description: The number of hours that need to expire before task is upgraded to medium priority. |
MED_PRIORITY_MINS_NO |
ColumnName | MED_PRIORITY_MINS_NO |
Definition | Name: Medium Priority Minutes Description: The number of minutes that need to expire before task is upgraded to medium priority. |
HIGH_PRIORITY_DAYS_NO |
ColumnName | HIGH_PRIORITY_DAYS_NO |
Definition | Name: High Priority Days Description: The number of days that need to expire before task is upgraded to high priority. |
HIGH_PRIORITY_HRS_NO |
ColumnName | HIGH_PRIORITY_HRS_NO |
Definition | Name: High Priority Hours Description: The number of hours that need to expire before task is upgraded to high priority. |
HIGH_PRIORITY_MINS_NO |
ColumnName | HIGH_PRIORITY_MINS_NO |
Definition | Name: High Priority Description: The number of minutes that need to expire before task is upgraded . |
COMPLETE_TASK_DAYS_NO |
ColumnName | COMPLETE_TASK_DAYS_NO |
Definition | Name: Days Due Description: The number of days that role should complete the task. |
COMPLETE_TASK_HRS_NO |
ColumnName | COMPLETE_TASK_HRS_NO |
Definition | Name: Hours Due Description: The number of hours that role should complete the task. |
COMPLETE_TASK_MINS_NO |
ColumnName | COMPLETE_TASK_MINS_NO |
Definition | Name: Minutes Due Description: The number of minutes that role should complete the task. |
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 high priority tasks. |
S_TASK_INIT_PRIORITY_CD |
ColumnName | S_TASK_INIT_PRIORITY_CD |
Definition | 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 |
ColumnName | USER_DIRECTED_FL |
Definition | Name: User Directed Flag Description: Logical as to this task can be user directed. |
INCLUDE_BACKUP_ROLE_FL |
ColumnName | INCLUDE_BACKUP_ROLE_FL |
Definition | 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 |
ColumnName | MODIFIED_BY |
Definition |
ROWVERSION |
ColumnName | ROWVERSION |
Definition |
TIME_STAMP |
ColumnName | TIME_STAMP |
Definition |