| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBalancing |
1 | OIUBL01_ADJ | Balancing Adjustments | 19 | TEMP_FLAG | Balancing - temporary flag for manual adjustments | nvarchar | 1 | 0 | | |
2 | OIUBL01_ADJH | Balancing Adjustments History | 19 | TEMP_FLAG | Balancing - temporary flag for manual adjustments | nvarchar | 1 | 0 | | |
TOPTranslation Tools |
3 | LXE_PC2_HD | Header Data for PC* Objects | 7 | TEMP_FLAG | Single-Character Indicator | nvarchar | 1 | 0 | | |
TOPWorkforce Management Application |
4 | WFACAS_AVAIL | Availabilities | 5 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
5 | WFATM_SR_AVA_TMP | TM Temp Table: Schedule Rule - Availability | 6 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
6 | WFATM_SR_CTR_TMP | TM Temp Table: Schedule Rule - Contract | 6 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
7 | WFATM_SR_LOG | Audit Trail of WFM ESS Schedule Rule Change | 6 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
8 | WFATM_SR_PRF_TMP | TM Temp Table: Schedule Rule - Preference | 6 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
9 | WFATM_SR_ROT_TMP | TM Temp Table: Schedule Rule - Rotation | 6 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
10 | WFATM_SR_SET_TMP | TM Temp Table: Schedule Rule - Set Shift | 6 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
11 | WFATM_SR_WKR_TMP | TM Temp Table: Schedule Rule - Work Rule | 6 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
12 | WFA_AGTEVT_EL | Agent (Scheduled) Event Eligibility | 6 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
13 | WFA_AGT_CONTR | Agent Contracts | 8 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
14 | WFA_AGT_HIST | Agent History | 5 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
15 | WFA_AGT_ORG | Agent Org Attributes | 8 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
16 | WFA_AGT_WRKAR | Agent Work Relationship | 10 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
17 | WFA_PREF | Preferences | 5 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
18 | WFA_SCEVT_ORG | Schedule Event - Organization Relationship | 8 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
19 | WFA_SCEVT_QUL | Schedule Event - Qualifications Relationship | 8 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
20 | WFA_SCEVT_WA | Work filter on schedule events | 6 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
21 | WFA_SCHDL_EVT | Scheduled activites(meetings) | 5 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
22 | WFA_SETSHIFTS | Set Shifts Table, TimeInterval Subject Area | 5 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
23 | WFA_SHFT_INTV | Shift Interval Job and type assignment | 6 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
24 | WFA_TEAM_EVT | Teams assigned to a scheduled event | 9 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
25 | WFA_WA_LOC | Work Area - Location/Profile Specific Attributes | 6 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
26 | WFA_WRKA_HIST | Work Area Attributes | 5 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
27 | WFA_WRK_RULST | Work Rule Set Master Data | 5 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
TOPWorkforce Management Core |
28 | WFMCAS_AGTEVT_EL | Agent (Scheduled) Event Eligibility | 6 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
29 | WFMCAS_AGT_CONTR | Agent Contracts | 8 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
30 | WFMCAS_AGT_HIST | Agent History | 5 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
31 | WFMCAS_AGT_ORG | Agent Org Attributes | 8 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
32 | WFMCAS_AGT_WRKAR | Agent Work Relationship | 10 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
33 | WFMCAS_AVAIL | Availabilities | 5 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
34 | WFMCAS_PREF | Preferences | 5 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
35 | WFMCAS_SCEVT_ORG | Schedule Event - Organization Relationship | 8 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
36 | WFMCAS_SCEVT_QUL | Schedule Event - Qualifications Relationship | 8 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
37 | WFMCAS_SCEVT_WA | Work filter on schedule events | 6 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
38 | WFMCAS_SCHDL_EVT | Scheduled activites(meetings) | 5 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
39 | WFMCAS_SETSHIFTS | Set Shifts Table, TimeInterval Subject Area | 5 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
40 | WFMCAS_SHFT_INTV | Shift Interval Job and type assignment | 6 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
41 | WFMCAS_STD_ORGHR | Temp Organization Hours -OBSOLETE | 7 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
42 | WFMCAS_TEAM_EVT | Teams assigned to a scheduled event | 9 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
43 | WFMCAS_TMP_ORGHR | Temp Organization Hours OBSOLETE | 5 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
44 | WFMCAS_WA_LOC | Work Area - Location/Profile Specific Attributes | 6 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
45 | WFMCAS_WRKA_HIST | Work Area Attributes | 5 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
46 | WFMCAS_WRKA_IMPT | Work Area Importance OBSOLETE | 6 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
47 | WFMCAS_WRK_RULST | Work Rule Set Master Data | 5 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
48 | WFMCAS_WRK_SEG | Actual Work Segment - OBSOLETE | 6 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
49 | WFMTM_SR_AVA_TMP | TM Temp Table: Schedule Rule - Availability | 6 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
50 | WFMTM_SR_CTR_TMP | TM Temp Table: Schedule Rule - Contract | 6 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
51 | WFMTM_SR_LOG | Audit Trail of WFM ESS Schedule Rule Change | 5 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
52 | WFMTM_SR_PRF_TMP | TM Temp Table: Schedule Rule - Preference | 6 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
53 | WFMTM_SR_ROT_TMP | TM Temp Table: Schedule Rule - Rotation | 6 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
54 | WFMTM_SR_SET_TMP | TM Temp Table: Schedule Rule - Set Shift | 6 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |
55 | WFMTM_SR_WKR_TMP | TM Temp Table: Schedule Rule - Work Rule | 6 | TEMP_FLAG | Temporary Flag | nvarchar | 1 | 0 | | |