| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | WFA_ABS_REQ_MOB | WFA: Absence Requests for Mobile | 3 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
TOPWorkforce Management Application |
2 | WFACAS_TEAM | Assignment of an Org Unit as a Team for IC WFM | 3 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
3 | WFAC_ORGDEPT_MAP | Mapping of org units and department tags | 4 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
4 | WFAFC_CTI_MAP | CTI Mappings | 5 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
5 | WFAFC_FORECAST | Forecasting master table | 6 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
6 | WFAFC_INDCATOR | Indicator | 5 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
7 | WFAFC_INDTOR_GRP | Indicator Group | 6 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
8 | WFAFC_SAMPLE2 | Forecasting Sample | 6 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
9 | WFAFC_VOLADJ_TMP | Summarization Table for Forecast and Adjustments | 2 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
10 | WFAFC_VOL_ADJ | Summarization Table for Forecast and Adjustments | 2 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
11 | WFAFC_WKLDAD_TMP | Summarized Workload Forecasted and Adjusted Values | 2 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
12 | WFAFC_WKLD_ADJ | Summarized Workload Forecasted and Adjusted Values | 2 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
13 | WFA_ACT_BENF | Actual imported benefits table | 3 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
14 | WFA_ACT_SHIFT | Actual header table | 3 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
15 | WFA_ACT_SUMM | Actual summary hours, total paid hours and total pay | 5 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
16 | WFA_AGT_CONTR | Agent Contracts | 2 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
17 | WFA_AGT_ORG | Agent Org Attributes | 2 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
18 | WFA_AGT_WRKAR | Agent Work Relationship | 6 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
19 | WFA_CALCST | Calculation Status | 3 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
20 | WFA_ORG | Organization Table | 2 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
21 | WFA_SCEVT_ORG | Schedule Event - Organization Relationship | 2 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
22 | WFA_SCHDL_EVT | Scheduled activites(meetings) | 6 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
23 | WFA_SCHEDULE | Schedule Table | 3 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
24 | WFA_SCHED_SUMM | Schedule summary hours, total paid hours and total pay | 5 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
25 | WFA_SHIFT | Shift Table | 4 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
26 | WFA_TEAM_EVT | Teams assigned to a scheduled event | 4 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
27 | WFA_TIMOFFREQ | Time off Requests | 3 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
28 | WFA_VIOLATION | Violations | 3 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
29 | WFA_WRKA_HIST | Work Area Attributes | 20 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
30 | WFA_WRK_RULST | Work Rule Set Master Data | 6 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
TOPWorkforce Management Core |
31 | WFMCAS_ACT_BENF | Actual imported benefits table | 3 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
32 | WFMCAS_ACT_SHIFT | Actual header table | 3 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
33 | WFMCAS_ACT_SUMM | Actual summary hours, total paid hours and total pay | 5 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
34 | WFMCAS_AGT_CONTR | Agent Contracts | 2 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
35 | WFMCAS_AGT_ORG | Agent Org Attributes | 2 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
36 | WFMCAS_AGT_WRKAR | Agent Work Relationship | 6 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
37 | WFMCAS_CALCST | Calculation Status | 3 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
38 | WFMCAS_HOL_HIST | Holiday History table (OBSOLETE) | 2 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
39 | WFMCAS_ORG | Organization Table | 2 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
40 | WFMCAS_SCEVT_ORG | Schedule Event - Organization Relationship | 2 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
41 | WFMCAS_SCHDL_EVT | Scheduled activites(meetings) | 6 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
42 | WFMCAS_SCHEDULE | Schedule Table | 3 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
43 | WFMCAS_SHIFT | Shift Table | 4 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
44 | WFMCAS_STD_ORGHR | Temp Organization Hours -OBSOLETE | 2 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
45 | WFMCAS_TEAM | Assignment of an Org Unit as a Team for IC WFM | 3 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
46 | WFMCAS_TEAM_EVT | Teams assigned to a scheduled event | 4 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
47 | WFMCAS_TIMOFFREQ | Time off Requests | 3 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
48 | WFMCAS_TMP_ORGHR | Temp Organization Hours OBSOLETE | 7 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
49 | WFMCAS_VIOLATION | Violations | 3 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
50 | WFMCAS_WRKA_HIST | Work Area Attributes | 20 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
51 | WFMCAS_WRK_RULST | Work Rule Set Master Data | 6 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
52 | WFMCAS_WRK_SEG | Actual Work Segment - OBSOLETE | 7 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
53 | WFMC_ORGDEPT_MAP | Mapping of org units and department tags | 4 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
54 | WFMFC_CTI_MAP | CTI Mappings | 5 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
55 | WFMFC_FORECAST | Forecasting master table | 6 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
56 | WFMFC_INDCATOR | Indicator | 5 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
57 | WFMFC_INDTOR_GRP | Indicator Group | 6 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |
58 | WFMFC_SAMPLE2 | Forecasting Sample | 6 | ORG_PLVAR | Plan Version | nvarchar | 2 | 0 | | |