| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPWorkforce Management Application |
1 | WFACAS_SHIFT_SEG | Shift Segment Table | 6 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
2 | WFATM_SC_SEG_TMP | TM Temp Table: Schedule - Shift Segment | 9 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
3 | WFATM_SR_SET_TMP | TM Temp Table: Schedule Rule - Set Shift | 21 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
4 | WFA_ACT_SEG | Imported actual segments table | 6 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
5 | WFA_ACT_SUMM | Actual summary hours, total paid hours and total pay | 7 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
6 | WFA_AGT_WRKAR | Agent Work Relationship | 3 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
7 | WFA_CORE_SCHE | Core Scheduling | 2 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
8 | WFA_SCEVT_WA | Work filter on schedule events | 4 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
9 | WFA_SCHED_SUMM | Schedule summary hours, total paid hours and total pay | 7 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
10 | WFA_SCH_AGTST | Schedule Stats - by Workarea and by Agent | 3 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
11 | WFA_SCH_CONPAY | Contract employee pay to min hours per week | 3 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
12 | WFA_SCH_STATS | Schedule Stats - by Workarea | 3 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
13 | WFA_SHFT_INTV | Shift Interval Job and type assignment | 7 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
14 | WFA_SHIFT_SG2 | Shifts Segments for WFM Schedule | 9 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
15 | WFA_VIOLATION | Violations | 8 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
16 | WFA_WAWL_MAP | Work Area - Workload Mapping | 2 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
17 | WFA_WA_DEMAND | Mapping of Work Areas to Demands in WFD Server | 3 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
18 | WFA_WA_LOC | Work Area - Location/Profile Specific Attributes | 2 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
19 | WFA_WORK_LOAD | Workload Attributes | 5 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
20 | WFA_WRKAREA | Work Area | 2 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
21 | WFA_WRKAREA_T | Work Area Texts | 2 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
22 | WFA_WRKA_HIST | Work Area Attributes | 2 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
TOPWorkforce Management Core |
23 | WFMCAS_ACT_SEG | Imported actual segments table | 6 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
24 | WFMCAS_ACT_SUMM | Actual summary hours, total paid hours and total pay | 7 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
25 | WFMCAS_AGT_WRKAR | Agent Work Relationship | 3 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
26 | WFMCAS_CORE_SCHE | Core Scheduling | 2 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
27 | WFMCAS_SCEVT_WA | Work filter on schedule events | 4 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
28 | WFMCAS_SCH_AGTST | Schedule Stats - by Workarea and by Agent | 3 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
29 | WFMCAS_SCH_STATS | Schedule Stats - by Workarea | 3 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
30 | WFMCAS_SHFT_INTV | Shift Interval Job and type assignment | 7 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
31 | WFMCAS_SHIFT_SEG | Shift Segment Table | 6 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
32 | WFMCAS_SHIFT_SG2 | Shifts Integrated with WFD Server | 9 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
33 | WFMCAS_VIOLATION | Violations | 8 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
34 | WFMCAS_WAWL_MAP | Work Area - Workload Mapping | 2 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
35 | WFMCAS_WA_DEMAND | Mapping of Work Areas to Demands in WFD Server | 3 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
36 | WFMCAS_WA_LOC | Work Area - Location/Profile Specific Attributes | 2 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
37 | WFMCAS_WORK_LOAD | Workload Attributes | 5 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
38 | WFMCAS_WRKAREA | Work Area | 2 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
39 | WFMCAS_WRKAREA_T | Work Area Texts | 2 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
40 | WFMCAS_WRKA_HIST | Work Area Attributes | 2 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
41 | WFMCAS_WRKA_IMPT | Work Area Importance OBSOLETE | 2 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
42 | WFMCAS_WRK_COVER | Work Coverage Rule - OBSOLETE | 3 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
43 | WFMTM_SC_SEG_TMP | TM Temp Table: Schedule - Shift Segment | 9 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |
44 | WFMTM_SR_SET_TMP | TM Temp Table: Schedule Rule - Set Shift | 21 | WRKAREA_ID | Work Area Id | nvarchar | 32 | 0 | | |