| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | WFA_ABS_REQ_MOB | WFA: Absence Requests for Mobile | 5 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
TOPCross-Application Components |
2 | /PTGWFI/F_PIRAPS | Workflow Runtime Stack for Parked Invoices | 10 | ORG_OBJID | User executing an action on a work item, sy-uname | nvarchar | 12 | 0 | | |
TOPWorkforce Management Application |
3 | ITC_EDIT_AUDIT | iTime Clock Time Event Edit Audit Table | 17 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
4 | ITC_MGR_OVERRIDE | Manager Override Mapping | 2 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
5 | WFACAS_TEAM | Assignment of an Org Unit as a Team for IC WFM | 5 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
6 | WFAC_TRK_ORG_STA | Schedule Track Status | 2 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
7 | WFAFC_CTI_MAP | CTI Mappings | 7 | ORG_OBJID | Organization ID | nvarchar | 8 | 0 | | |
8 | WFAFC_FORECAST | Forecasting master table | 8 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
9 | WFAFC_INDCATOR | Indicator | 7 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
10 | WFAFC_INDTOR_GRP | Indicator Group | 8 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
11 | WFAFC_SAMPLE2 | Forecasting Sample | 8 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
12 | WFAFC_VOLADJ_TMP | Summarization Table for Forecast and Adjustments | 4 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
13 | WFAFC_VOL_ADJ | Summarization Table for Forecast and Adjustments | 4 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
14 | WFAFC_WKLDAD_TMP | Summarized Workload Forecasted and Adjusted Values | 4 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
15 | WFAFC_WKLD_ADJ | Summarized Workload Forecasted and Adjusted Values | 4 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
16 | WFATM_SC_AVA_TMP | TM Temp Table: Schedule - Availability | 3 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
17 | WFATM_SC_LOG | Audit Trail of WFM ESS Schedule Change | 3 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
18 | WFATM_SC_SEG_TMP | TM Temp Table: Schedule - Shift Segment | 3 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
19 | WFATM_SR_AVA_TMP | TM Temp Table: Schedule Rule - Availability | 3 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
20 | WFATM_SR_CTR_TMP | TM Temp Table: Schedule Rule - Contract | 3 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
21 | WFATM_SR_LOG | Audit Trail of WFM ESS Schedule Rule Change | 3 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
22 | WFATM_SR_PRF_TMP | TM Temp Table: Schedule Rule - Preference | 3 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
23 | WFATM_SR_ROT_TMP | TM Temp Table: Schedule Rule - Rotation | 3 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
24 | WFATM_SR_SET_TMP | TM Temp Table: Schedule Rule - Set Shift | 3 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
25 | WFATM_SR_WKR_TMP | TM Temp Table: Schedule Rule - Work Rule | 3 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
26 | WFA_ACT_BENF | Actual imported benefits table | 5 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
27 | WFA_ACT_SHIFT | Actual header table | 5 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
28 | WFA_ACT_SUMM | Actual summary hours, total paid hours and total pay | 4 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
29 | WFA_AGT_CONTR | Agent Contracts | 4 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
30 | WFA_AGT_ORG | Agent Org Attributes | 4 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
31 | WFA_AGT_WRKAR | Agent Work Relationship | 8 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
32 | WFA_CALCST | Calculation Status | 5 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
33 | WFA_ERMS_ORG_MAP | ERMS Mapping - Organizational Assignments | 4 | ORG_OBJID | Organization ID | nvarchar | 8 | 0 | | |
34 | WFA_ORG | Organization Table | 4 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
35 | WFA_SCEVT_ORG | Schedule Event - Organization Relationship | 4 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
36 | WFA_SCHDL_EVT | Scheduled activites(meetings) | 8 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
37 | WFA_SCHEDULE | Schedule Table | 5 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
38 | WFA_SCHED_SUMM | Schedule summary hours, total paid hours and total pay | 4 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
39 | WFA_SCH_CONPAY | Contract employee pay to min hours per week | 2 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
40 | WFA_SHIFT | Shift Table | 6 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
41 | WFA_TEAM_EVT | Teams assigned to a scheduled event | 6 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
42 | WFA_TIMOFFREQ | Time off Requests | 5 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
43 | WFA_VIOLATION | Violations | 5 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
44 | WFA_WRKA_HIST | Work Area Attributes | 22 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
45 | WFA_WRK_RULST | Work Rule Set Master Data | 8 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
TOPWorkforce Management Core |
46 | WFMCAS_ACT_BENF | Actual imported benefits table | 5 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
47 | WFMCAS_ACT_SHIFT | Actual header table | 5 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
48 | WFMCAS_ACT_SUMM | Actual summary hours, total paid hours and total pay | 4 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
49 | WFMCAS_AGT_CONTR | Agent Contracts | 4 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
50 | WFMCAS_AGT_ORG | Agent Org Attributes | 4 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
51 | WFMCAS_AGT_WRKAR | Agent Work Relationship | 8 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
52 | WFMCAS_CALCST | Calculation Status | 5 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
53 | WFMCAS_HOL_HIST | Holiday History table (OBSOLETE) | 4 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
54 | WFMCAS_ORG | Organization Table | 4 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
55 | WFMCAS_SCEVT_ORG | Schedule Event - Organization Relationship | 4 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
56 | WFMCAS_SCHDL_EVT | Scheduled activites(meetings) | 8 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
57 | WFMCAS_SCHEDULE | Schedule Table | 5 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
58 | WFMCAS_SHIFT | Shift Table | 6 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
59 | WFMCAS_STD_ORGHR | Temp Organization Hours -OBSOLETE | 4 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
60 | WFMCAS_TEAM | Assignment of an Org Unit as a Team for IC WFM | 5 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
61 | WFMCAS_TEAM_EVT | Teams assigned to a scheduled event | 6 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
62 | WFMCAS_TIMOFFREQ | Time off Requests | 5 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
63 | WFMCAS_TMP_ORGHR | Temp Organization Hours OBSOLETE | 9 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
64 | WFMCAS_VIOLATION | Violations | 5 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
65 | WFMCAS_WRKA_HIST | Work Area Attributes | 22 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
66 | WFMCAS_WRK_RULST | Work Rule Set Master Data | 8 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
67 | WFMCAS_WRK_SEG | Actual Work Segment - OBSOLETE | 9 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
68 | WFMC_TRK_ORG_STA | Schedule Track Status | 2 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
69 | WFMFC_CTI_MAP | CTI Mappings | 7 | ORG_OBJID | Organization ID | nvarchar | 8 | 0 | | |
70 | WFMFC_FORECAST | Forecasting master table | 8 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
71 | WFMFC_INDCATOR | Indicator | 7 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
72 | WFMFC_INDTOR_GRP | Indicator Group | 8 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
73 | WFMFC_SAMPLE2 | Forecasting Sample | 8 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
74 | WFMTM_SC_AVA_TMP | TM Temp Table: Schedule - Availability | 3 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
75 | WFMTM_SC_LOG | Audit Trail of WFM ESS Schedule Change | 3 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
76 | WFMTM_SC_SEG_TMP | TM Temp Table: Schedule - Shift Segment | 3 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
77 | WFMTM_SR_AVA_TMP | TM Temp Table: Schedule Rule - Availability | 3 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
78 | WFMTM_SR_CTR_TMP | TM Temp Table: Schedule Rule - Contract | 3 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
79 | WFMTM_SR_LOG | Audit Trail of WFM ESS Schedule Rule Change | 3 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
80 | WFMTM_SR_PRF_TMP | TM Temp Table: Schedule Rule - Preference | 3 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
81 | WFMTM_SR_ROT_TMP | TM Temp Table: Schedule Rule - Rotation | 3 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
82 | WFMTM_SR_SET_TMP | TM Temp Table: Schedule Rule - Set Shift | 3 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
83 | WFMTM_SR_WKR_TMP | TM Temp Table: Schedule Rule - Work Rule | 3 | ORG_OBJID | Object ID | nvarchar | 8 | 0 | | |
84 | WFM_ERMS_ORG_MAP | ERMS Mapping - Organizational Assignments | 4 | ORG_OBJID | Organization ID | nvarchar | 8 | 0 | | |