| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPWorkforce Management Application |
| 1 | WFAC_OPHOURS | WFM Operating Hours Key | 3 | OPHOURS_ID | WFM operating hours ID | nvarchar | 20 | 0 | | |
| 2 | WFAC_OPHOURS_D | WFM Operating Hours Data | 3 | OPHOURS_ID | WFM operating hours ID | nvarchar | 20 | 0 | | |
| 3 | WFAC_OPHOURS_T | WFM Operating Hours Text Table | 3 | OPHOURS_ID | WFM operating hours ID | nvarchar | 20 | 0 | | |
| 4 | WFAC_SOPHOURS | WFM Special Operating Hours Key | 3 | OPHOURS_ID | WFM special operating hours ID | nvarchar | 20 | 0 | | |
| 5 | WFAC_SOPHOURS_D | WFM Special Operating Hours Data | 3 | OPHOURS_ID | WFM special operating hours ID | nvarchar | 20 | 0 | | |
| 6 | WFAC_SOPHOURS_T | WFM Operating Hours Text Table | 3 | OPHOURS_ID | WFM special operating hours ID | nvarchar | 20 | 0 | | |
| TOPWorkforce Management Core |
| 7 | WFMC_OPHOURS | WFM Operating Hours Key | 3 | OPHOURS_ID | WFM operating hours ID | nvarchar | 20 | 0 | | |
| 8 | WFMC_OPHOURS_D | WFM Operating Hours Data | 3 | OPHOURS_ID | WFM operating hours ID | nvarchar | 20 | 0 | | |
| 9 | WFMC_OPHOURS_T | WFM Operating Hours Text Table | 3 | OPHOURS_ID | WFM operating hours ID | nvarchar | 20 | 0 | | |
| 10 | WFMC_SOPHOURS | WFM Special Operating Hours Key | 3 | OPHOURS_ID | WFM special operating hours ID | nvarchar | 20 | 0 | | |
| 11 | WFMC_SOPHOURS_D | WFM Special Operating Hours Data | 3 | OPHOURS_ID | WFM special operating hours ID | nvarchar | 20 | 0 | | |
| 12 | WFMC_SOPHOURS_T | WFM Operating Hours Text Table | 3 | OPHOURS_ID | WFM special operating hours ID | nvarchar | 20 | 0 | | |
