| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPCollateral Management System |
| 1 | CMS_TSK | Tasks | 6 | TASK_STATUS | Task Status | nvarchar | 2 | 0 | | |
| 2 | TCMS_TSK_STAT | Task Status | 2 | TASK_STATUS | Task Status | nvarchar | 2 | 0 | | |
| 3 | TCMS_TSK_STAT_T | Task Status Text | 2 | TASK_STATUS | Task Status | nvarchar | 2 | 0 | | |
| TOPIncentive and Commission Management ICM |
| 4 | TCACS_PATCH_U02 | Patch Manager: Job Log | 3 | TASK_STATUS | Patch Manager: Status of Task | nvarchar | 1 | 0 | | |
| TOPInterestCharge Calculation |
| 5 | BKKMDISPTASK | Data on Parallel Tasks | 3 | TASK_STATUS | Status of Parallel Tasks in a Mass Run | nvarchar | 1 | 0 | | |
| TOPNetWeaver Enterprise Search |
| 6 | ESH_PRC_TASK | Process step (task) | 6 | TASK_STATUS | Task Status | nvarchar | 1 | 0 | | |
| TOPSchedule Manager |
| 7 | SCMATREED | Table for Entries that are Dependent on Time and Date | 8 | TASK_STATUS | Schedule Manager: Task status (active, complete, ...) | nvarchar | 4 | 0 | | |
| 8 | SMST | Node Structure and Task Name in the Schedule Manager | 8 | TASK_STATUS | Single-Character Indicator | nvarchar | 1 | 0 | | |
