| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /OPT/CT_LG_EXC | Log event history - Exception detail dimension | 5 | EXCEPTION_TYPE | Exception Types | nvarchar | 1 | 0 | | |
| 2 | /OPT/VT_DOC_HEA1 | Document Header - copy of /opt/vt_doc_head | 26 | EXCEPTION_TYPE | Exception Types | nvarchar | 1 | 0 | | |
| 3 | /OPT/VT_DOC_HEAD | Document Header | 26 | EXCEPTION_TYPE | Exception Types | nvarchar | 1 | 0 | | |
| 4 | /OPT/VT_EXCDET | Reporting table: Exception mapping | 3 | EXCEPTION_TYPE | Exception Types | nvarchar | 1 | 0 | | |
| 5 | /OPT/VT_WORKITE1 | Work Item Header Table - Copy of /opt/vt_workitem | 4 | EXCEPTION_TYPE | Exception Types | nvarchar | 1 | 0 | | |
| 6 | /OPT/VT_WORKITEM | Work Item Header Table | 4 | EXCEPTION_TYPE | Exception Types | nvarchar | 1 | 0 | | |
| 7 | /OPT/X133 | Reporting table: Exception mapping | 3 | EXCEPTION_TYPE | Exception Types | nvarchar | 1 | 0 | | |
| 8 | /OPT/Y133 | Reporting table: Exception mapping | 3 | EXCEPTION_TYPE | Exception Types | nvarchar | 1 | 0 | | |
| 9 | /OPT/Z133 | Reporting table: Exception mapping | 3 | EXCEPTION_TYPE | Exception Types | nvarchar | 1 | 0 | | |
| 10 | BBPC_IMS_PROP | IMS Exception Properties | 2 | EXCEPTION_TYPE | Event | nvarchar | 32 | 0 | | |
| TOPFinancial Accounting |
| 11 | /OPT/VT_WORK | Work Item Header Table - Real Time | 4 | EXCEPTION_TYPE | Exception Types | nvarchar | 1 | 0 | | |
| TOPWorkforce Management Application |
| 12 | WFAC_EXCPT_DEF | Schedule Exception Definitions | 2 | EXCEPTION_TYPE | Exception Type | nvarchar | 4 | 0 | | |
| 13 | WFAC_EXCPT_DEF_T | Schedule ExceptionTexts | 2 | EXCEPTION_TYPE | Exception Type | nvarchar | 4 | 0 | | |
| 14 | WFAC_EXCPT_RES | Schedule Exception - Resolution Mapping Table | 2 | EXCEPTION_TYPE | Exception Type | nvarchar | 4 | 0 | | |
| 15 | WFAC_SCHDEXCPN_D | Schedule Exceptions | 4 | EXCEPTION_TYPE | Exception Type | nvarchar | 4 | 0 | | |
| 16 | WFAC_SCHD_EXCPT | Schedule Exceptions (out of use for Retail) | 3 | EXCEPTION_TYPE | Exception Type | nvarchar | 4 | 0 | | |
| TOPWorkforce Management Core |
| 17 | WFMC_EXCPT_DEF | Schedule Exception Definitions | 2 | EXCEPTION_TYPE | Exception Type | nvarchar | 4 | 0 | | |
| 18 | WFMC_EXCPT_DEF_T | Schedule ExceptionTexts | 2 | EXCEPTION_TYPE | Exception Type | nvarchar | 4 | 0 | | |
| 19 | WFMC_EXCPT_RES | Schedule Exception - Resolution Mapping Table | 2 | EXCEPTION_TYPE | Exception Type | nvarchar | 4 | 0 | | |
| 20 | WFMC_SCHDEXCPN_D | Schedule Exceptions | 4 | EXCEPTION_TYPE | Exception Type | nvarchar | 4 | 0 | | |
| 21 | WFMC_SCHD_EXCPT | Schedule Exceptions (out of use for Retail) | 3 | EXCEPTION_TYPE | Exception Type | nvarchar | 4 | 0 | | |
