| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPWorkforce Management Application |
| 1 | WFAC_SCHDEXCPN_D | Schedule Exceptions | 5 | ENABLED_FLAG | Enabled ('X' = Enabled, ' ' = Disabled) | nvarchar | 1 | 0 | | |
| 2 | WFAC_SCHD_EXCPT | Schedule Exceptions (out of use for Retail) | 4 | ENABLED_FLAG | Enabled ('X' = Enabled, ' ' = Disabled) | nvarchar | 1 | 0 | | |
| 3 | WFAC_WKRLDFLTN_D | Work Rules Default | 11 | ENABLED_FLAG | Enabled ('X' = Enabled, ' ' = Disabled) | nvarchar | 1 | 0 | | |
| 4 | WFAC_WKRL_DFLT | Default Work Rules (Out of Use for Retail) | 10 | ENABLED_FLAG | Enabled ('X' = Enabled, ' ' = Disabled) | nvarchar | 1 | 0 | | |
| 5 | WFATM_SR_WKR_TMP | TM Temp Table: Schedule Rule - Work Rule | 16 | ENABLED_FLAG | Enabled ('X' = Enabled, ' ' = Disabled) | nvarchar | 1 | 0 | | |
| TOPWorkforce Management Core |
| 6 | WFMC_SCHDEXCPN_D | Schedule Exceptions | 5 | ENABLED_FLAG | Enabled ('X' = Enabled, ' ' = Disabled) | nvarchar | 1 | 0 | | |
| 7 | WFMC_SCHD_EXCPT | Schedule Exceptions (out of use for Retail) | 4 | ENABLED_FLAG | Enabled ('X' = Enabled, ' ' = Disabled) | nvarchar | 1 | 0 | | |
| 8 | WFMC_WKRLDFLTN_D | Work Rules Default | 11 | ENABLED_FLAG | Enabled ('X' = Enabled, ' ' = Disabled) | nvarchar | 1 | 0 | | |
| 9 | WFMC_WKRL_DFLT | Default Work Rules (Out of Use for Retail) | 10 | ENABLED_FLAG | Enabled ('X' = Enabled, ' ' = Disabled) | nvarchar | 1 | 0 | | |
| 10 | WFMTM_SR_WKR_TMP | TM Temp Table: Schedule Rule - Work Rule | 16 | ENABLED_FLAG | Enabled ('X' = Enabled, ' ' = Disabled) | nvarchar | 1 | 0 | | |
