| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPWorkforce Management Application |
1 | WFACAS_SHIFT_SEG | Shift Segment Table | 7 | SCHDL_EVT_ID | Scheduled Event Id | nvarchar | 32 | 0 | | |
2 | WFATM_SC_SEG_TMP | TM Temp Table: Schedule - Shift Segment | 11 | SCHDL_EVT_ID | Scheduled Event Id | nvarchar | 32 | 0 | | |
3 | WFA_AGTEVT_EL | Agent (Scheduled) Event Eligibility | 3 | SCHDL_EVT_ID | Scheduled Event Id | nvarchar | 32 | 0 | | |
4 | WFA_SCEVT_ORG | Schedule Event - Organization Relationship | 5 | SCHDL_EVT_ID | Scheduled Event Id | nvarchar | 32 | 0 | | |
5 | WFA_SCEVT_QUL | Schedule Event - Qualifications Relationship | 2 | SCHDL_EVT_ID | Scheduled Event Id | nvarchar | 32 | 0 | | |
6 | WFA_SCEVT_WA | Work filter on schedule events | 2 | SCHDL_EVT_ID | Scheduled Event Id | nvarchar | 32 | 0 | | |
7 | WFA_SCHDL_EVT | Scheduled activites(meetings) | 2 | SCHDL_EVT_ID | Scheduled Event Id | nvarchar | 32 | 0 | | |
8 | WFA_SCH_EVT_T | Schedule Event Texts | 2 | SCHDL_EVT_ID | Scheduled Event Id | nvarchar | 32 | 0 | | |
9 | WFA_SHIFT_SG2 | Shifts Segments for WFM Schedule | 10 | SCHDL_EVT_ID | Scheduled Event Id | nvarchar | 32 | 0 | | |
10 | WFA_TEAM_EVT | Teams assigned to a scheduled event | 2 | SCHDL_EVT_ID | Scheduled Event Id | nvarchar | 32 | 0 | | |
TOPWorkforce Management Core |
11 | WFMCAS_AGTEVT_EL | Agent (Scheduled) Event Eligibility | 3 | SCHDL_EVT_ID | Scheduled Event Id | nvarchar | 32 | 0 | | |
12 | WFMCAS_SCEVT_ORG | Schedule Event - Organization Relationship | 5 | SCHDL_EVT_ID | Scheduled Event Id | nvarchar | 32 | 0 | | |
13 | WFMCAS_SCEVT_QUL | Schedule Event - Qualifications Relationship | 2 | SCHDL_EVT_ID | Scheduled Event Id | nvarchar | 32 | 0 | | |
14 | WFMCAS_SCEVT_WA | Work filter on schedule events | 2 | SCHDL_EVT_ID | Scheduled Event Id | nvarchar | 32 | 0 | | |
15 | WFMCAS_SCHDL_EVT | Scheduled activites(meetings) | 2 | SCHDL_EVT_ID | Scheduled Event Id | nvarchar | 32 | 0 | | |
16 | WFMCAS_SCH_EVT_T | Schedule Event Texts | 2 | SCHDL_EVT_ID | Scheduled Event Id | nvarchar | 32 | 0 | | |
17 | WFMCAS_SHIFT_SEG | Shift Segment Table | 7 | SCHDL_EVT_ID | Scheduled Event Id | nvarchar | 32 | 0 | | |
18 | WFMCAS_SHIFT_SG2 | Shifts Integrated with WFD Server | 10 | SCHDL_EVT_ID | Scheduled Event Id | nvarchar | 32 | 0 | | |
19 | WFMCAS_TEAM_EVT | Teams assigned to a scheduled event | 2 | SCHDL_EVT_ID | Scheduled Event Id | nvarchar | 32 | 0 | | |
20 | WFMCAS_WRK_SEG | Actual Work Segment - OBSOLETE | 12 | SCHDL_EVT_ID | Scheduled Event Id | nvarchar | 32 | 0 | | |
21 | WFMTM_SC_SEG_TMP | TM Temp Table: Schedule - Shift Segment | 11 | SCHDL_EVT_ID | Scheduled Event Id | nvarchar | 32 | 0 | | |