| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPWorkforce Management Application |
| 1 | WFA_ACT_BENF | Actual imported benefits table | 7 | CHARGE_DATE | Benefits charge date | nvarchar | 8 | 0 | | |
| 2 | WFA_ACT_SEG | Imported actual segments table | 12 | CHARGE_DATE | Charge Date | nvarchar | 8 | 0 | | |
| 3 | WFA_ACT_SHIFT | Actual header table | 7 | CHARGE_DATE | Benefits charge date | nvarchar | 8 | 0 | | |
| 4 | WFA_SCHE_BENF | Actual imported benefits table | 5 | CHARGE_DATE | Benefits charge date | nvarchar | 8 | 0 | | |
| 5 | WFA_SCH_AGTST | Schedule Stats - by Workarea and by Agent | 5 | CHARGE_DATE | Date | nvarchar | 8 | 0 | | |
| 6 | WFA_SCH_CONPAY | Contract employee pay to min hours per week | 5 | CHARGE_DATE | Charge Date | nvarchar | 8 | 0 | | |
| 7 | WFA_SCH_STATS | Schedule Stats - by Workarea | 4 | CHARGE_DATE | Date | nvarchar | 8 | 0 | | |
| 8 | WFA_SHIFT | Shift Table | 8 | CHARGE_DATE | Date | nvarchar | 8 | 0 | | |
| 9 | WFA_SHIFT_SG2 | Shifts Segments for WFM Schedule | 6 | CHARGE_DATE | Charge Date | nvarchar | 8 | 0 | | |
| TOPWorkforce Management Core |
| 10 | WFMCAS_ACT_BENF | Actual imported benefits table | 7 | CHARGE_DATE | Benefits charge date | nvarchar | 8 | 0 | | |
| 11 | WFMCAS_ACT_SEG | Imported actual segments table | 12 | CHARGE_DATE | Charge Date | nvarchar | 8 | 0 | | |
| 12 | WFMCAS_ACT_SHIFT | Actual header table | 7 | CHARGE_DATE | Benefits charge date | nvarchar | 8 | 0 | | |
| 13 | WFMCAS_SCHE_BENF | Actual imported benefits table | 5 | CHARGE_DATE | Benefits charge date | nvarchar | 8 | 0 | | |
| 14 | WFMCAS_SCH_AGTST | Schedule Stats - by Workarea and by Agent | 5 | CHARGE_DATE | Date | nvarchar | 8 | 0 | | |
| 15 | WFMCAS_SCH_STATS | Schedule Stats - by Workarea | 4 | CHARGE_DATE | Date | nvarchar | 8 | 0 | | |
| 16 | WFMCAS_SHIFT | Shift Table | 8 | CHARGE_DATE | Date | nvarchar | 8 | 0 | | |
| 17 | WFMCAS_SHIFT_SG2 | Shifts Integrated with WFD Server | 6 | CHARGE_DATE | Charge Date | nvarchar | 8 | 0 | | |
