| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /NAKISA/HRP9806 | DB Table for Infotype 9806 | 20 | LOCATION_TYPE | Char 1 | nvarchar | 1 | 0 | | |
2 | /NAKISA/HRP9812 | DB Table for Infotype 9812 | 22 | LOCATION_TYPE | Char 1 | nvarchar | 1 | 0 | | |
TOPCross-Application Components |
3 | /MRSS/C_CSG_LOC | Location of Service | 4 | LOCATION_TYPE | Location Type | nvarchar | 2 | 0 | | |
TOPLOGFAS |
4 | /ISDFPS/GEOLOC | Geolocation Database Table | 6 | LOCATION_TYPE | Location Type | nvarchar | 4 | 0 | | |
TOPTalent Management |
5 | HRT7406 | Mobility | 8 | LOCATION_TYPE | Location Type | nvarchar | 1 | 0 | | |
TOPWorkforce Management Application |
6 | ITC_CALCRULE_HOL | Holiday Type Calculation Rule Attributes | 3 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
7 | ITC_CALCRULE_LOC | Calculation Rule Location Specific Attributes | 3 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
8 | ITC_CALCRULE_ML | Meal Penalty Type Calculation Rule Attribubtes | 3 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
9 | ITC_CALCRULE_SFT | Shift Differential Configuration on Shift Interval | 3 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
10 | ITC_CALCRULE_WKA | Calculation Rule Special Work Area Attribubtes | 3 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
11 | ITC_ORG_MAPPING | iTime Clock Installation and Org Mapping | 3 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
12 | WFACAS_TEAM | Assignment of an Org Unit as a Team for IC WFM | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
13 | WFAC_ABSTYPE | Absence Types | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
14 | WFAC_ABSTYPE_T | Absence Type Translation Table | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
15 | WFAC_AVAIL_INTV | Availablility Template Time Interval | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
16 | WFAC_AVAIL_TMP | Availablility Template | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
17 | WFAC_AVAIL_TMP_T | Availablility Template Translation Table | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
18 | WFAC_BRKRUL | Break Rule | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
19 | WFAC_BRKRULSET | BreakRule Set | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
20 | WFAC_BRKRULSET_T | BreakRule Set | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
21 | WFAC_BRKSPRL | Break Space Rule | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
22 | WFAC_BRKTYPES | Break Types | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
23 | WFAC_BRKTYPES_T | Break Types Texts | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
24 | WFAC_COSTN_D | Costs | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
25 | WFAC_DALWDSHFTLN | Disallowed Shift Lengths | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
26 | WFAC_DALWDSHFT_T | Disallowed Shift Lengths | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
27 | WFAC_DAYSHIFTDEF | Day Shift Definition (out of use for Retail) | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
28 | WFAC_DAYSHIFTN | Day Shift Definition | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
29 | WFAC_DFTSETGRP | Default Settings Group | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
30 | WFAC_DFTSETGRP_T | Default Settings Group Text | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
31 | WFAC_EXPORT_RL_T | Schedule export rules | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
32 | WFAC_EXPORT_RULE | Schedule export rules | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
33 | WFAC_HOLASSIGN | Holiday Cost Profile Assigment | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
34 | WFAC_HOLASSIGN_D | Holiday Cost Profile Assigment - Data | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
35 | WFAC_HOLASSIGN_T | Holiday Cost Profile Assigment - Text Table | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
36 | WFAC_HOLPPRF | Holiday Pay Profile Table | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
37 | WFAC_HOLPPRF_T | Holiday Pay Profile Text Table | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
38 | WFAC_HOLPPRM | Holiday Pay Premium | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
39 | WFAC_IMPORT_RL_T | Actual worked segment import rules | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
40 | WFAC_IMPORT_RULE | Actual worked segment import rules | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
41 | WFAC_LGC_MAP | Logical System Mapping for message type | 4 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
42 | WFAC_LOCATION | Location | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
43 | WFAC_LOCATION_T | Location Translation Table | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
44 | WFAC_LOCSETTN | General Location Settings | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
45 | WFAC_NONTRAN | Non transition zones | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
46 | WFAC_NONTRAN_T | text for non transition zones | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
47 | WFAC_OPHOURS | WFM Operating Hours Key | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
48 | WFAC_OPHOURS_D | WFM Operating Hours Data | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
49 | WFAC_OPHOURS_T | WFM Operating Hours Text Table | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
50 | WFAC_ORGDEPT_MAP | Mapping of org units and department tags | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
51 | WFAC_PAYCLASS | Payclass | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
52 | WFAC_PAYCLASS_T | Payclass Translation Table | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
53 | WFAC_PAYCLSPREM | Payclass Premiums | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
54 | WFAC_PRF_MOD_FLG | table stores manager editable and need approval flag for par | 4 | LOCATION_TYPE | Profile Identifier | nvarchar | 20 | 0 | | |
55 | WFAC_SCHDEXCPN_D | Schedule Exceptions | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
56 | WFAC_SCHD_EXCPT | Schedule Exceptions (out of use for Retail) | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
57 | WFAC_SETSHFTCN | Set Shifts Config | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
58 | WFAC_SETSHFTCN_T | Set Shift Template Text | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
59 | WFAC_SETSHFT_INT | Set Shift Template Time Interval | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
60 | WFAC_SNPRFN | Seniority Date Profile | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
61 | WFAC_SN_PRF | Seniority Date Profile (out of use for Retail) | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
62 | WFAC_SOPHOURS | WFM Special Operating Hours Key | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
63 | WFAC_SOPHOURS_D | WFM Special Operating Hours Data | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
64 | WFAC_SOPHOURS_T | WFM Operating Hours Text Table | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
65 | WFAC_SPECDAYPT | WFM Operating Hours Key | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
66 | WFAC_SPECDAYPT_D | Availablility Template Time Interval | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
67 | WFAC_SPECDAYPT_T | WFM Operating Hours Text Table | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
68 | WFAC_WARELUCT | individual work area rank within a reluctance profile | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
69 | WFAC_WARELUCTPRO | work area reluctance profile | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
70 | WFAC_WARELUCT_T | text table for work area reluctance profile | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
71 | WFAC_WKNDDAYSN | Weekend Days | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
72 | WFAC_WKND_DAYS | Weekend Days (out of use for Retail) | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
73 | WFAC_WKRLDFLTN_D | Work Rules Default | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
74 | WFAC_WKRLINTVN_D | Work Rule Interval | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
75 | WFAC_WKRLTEMPN | Work Rule Set Template | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
76 | WFAC_WKRLTEMPN_T | Work Rule Template Set Text | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
77 | WFAC_WKRLTMPPERI | Work Rule Value | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
78 | WFAC_WKRLTMPREST | Work Rule Value | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
79 | WFAC_WKRLVALUE | Work Rule Value | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
80 | WFAC_WKRL_DFLT | Default Work Rules (Out of Use for Retail) | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
81 | WFAC_WKRL_INTV | Work Rule Interval (out of use for Retail) | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
82 | WFAC_WKRL_TEMP | Template for Work Rule Set (Out of Use for Retail) | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
83 | WFAC_WK_WGT_ACT | Week Weight Profile | 4 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
84 | WFAC_WK_WGT_MAP | Week Weight Profile | 5 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
85 | WFAC_WRD_MAXPERI | Period Rule Type | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
86 | WFAC_WRD_RESTPER | Maximum Type for a Period | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
87 | WFAEM_ESG_MAP | Mapping of HCM EmployeeSubgroup to WFM Default Setting Group | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
88 | WFAEM_PAY_MAP | Pay rate mapping table (HCM -> WFM) | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
89 | WFAFC_BUDGET_SET | Budget constraint | 3 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
90 | WFAFC_CALC_BTLOC | Calculation Batch Information | 4 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
91 | WFAFC_FCSTCFGN | Forecasting Configuration Parameters for Location Profile | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
92 | WFAFC_FCST_CFG | Forecasting Configuration Parameters (OBSOLETE) | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
93 | WFAFC_FIXHIST_D | Fixed History- Obsolete as of 5.0 | 3 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
94 | WFAFC_FIX_HIST | Fixed History - Obsolete as of 5.0 | 3 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
95 | WFAFC_GEN_HIST | Templates to identify forecasting dates of interest | 3 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
96 | WFAFC_IGRP_PARAM | Indicator Group | 4 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
97 | WFAFC_IND_ATTRIB | Indicator Attributes | 3 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
98 | WFAFC_IND_TDATA | Time relative data associated with an indicator | 3 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
99 | WFAFC_OBJ_STAT | Object Stat for Configuration | 3 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
100 | WFAFC_STEP_PRM2 | Step Parameters | 3 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
101 | WFAFC_TAGDAY_GLO | Tagged History - Obsolete as of 5.0 | 3 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
102 | WFAFC_TAGDAY_LOC | Tag History - Location specific settings | 3 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
103 | WFATM_ITC_REG | i-Time Clock registration | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
104 | WFA_AGT_WRKAR | Agent Work Relationship | 5 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
105 | WFA_CORE_SCHE | Core Scheduling | 3 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
106 | WFA_ORG | Organization Table | 5 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
107 | WFA_TEAM_EVT | Teams assigned to a scheduled event | 7 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
108 | WFA_WA_LOC | Work Area - Location/Profile Specific Attributes | 3 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
109 | WFA_WRKRLST_V | Work Rule Set Values Master Data | 3 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
110 | WFA_XPRA_PARAMET | XPRA parameters | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
TOPWorkforce Management Core |
111 | WFMCAS_AGT_WRKAR | Agent Work Relationship | 5 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
112 | WFMCAS_CORE_SCHE | Core Scheduling | 3 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
113 | WFMCAS_ORG | Organization Table | 5 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
114 | WFMCAS_TEAM | Assignment of an Org Unit as a Team for IC WFM | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
115 | WFMCAS_TEAM_EVT | Teams assigned to a scheduled event | 7 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
116 | WFMCAS_WA_LOC | Work Area - Location/Profile Specific Attributes | 3 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
117 | WFMCAS_WRKRLST_V | Work Rule Set Values Master Data | 3 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
118 | WFMC_ABSTYPE | Absence Types | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
119 | WFMC_ABSTYPE_T | Absence Type Translation Table | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
120 | WFMC_AVAIL_INTV | Availablility Template Time Interval | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
121 | WFMC_AVAIL_TMP | Availablility Template | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
122 | WFMC_AVAIL_TMP_T | Availablility Template Translation Table | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
123 | WFMC_BRKRUL | Break Rule | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
124 | WFMC_BRKRULSET | BreakRule Set | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
125 | WFMC_BRKRULSET_T | BreakRule Set | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
126 | WFMC_BRKSPRL | Break Space Rule | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
127 | WFMC_BRKTYPES | Break Types | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
128 | WFMC_BRKTYPES_T | Break Types Texts | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
129 | WFMC_COST | Costs (out of use for Retail) | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
130 | WFMC_COSTN_D | Costs | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
131 | WFMC_DALWDSHFTLN | Disallowed Shift Lengths | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
132 | WFMC_DALWDSHFT_T | Disallowed Shift Lengths | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
133 | WFMC_DAYSHIFTDEF | Day Shift Definition (out of use for Retail) | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
134 | WFMC_DAYSHIFTN | Day Shift Definition | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
135 | WFMC_DFTSETGRP | Default Settings Group | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
136 | WFMC_DFTSETGRP_T | Default Settings Group Text | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
137 | WFMC_EXPORT_RL_T | Schedule export rules | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
138 | WFMC_EXPORT_RULE | Schedule export rules | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
139 | WFMC_HOLASSIGN | Holiday Cost Profile Assigment | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
140 | WFMC_HOLASSIGN_D | Holiday Cost Profile Assigment - Data | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
141 | WFMC_HOLASSIGN_T | Holiday Cost Profile Assigment - Text Table | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
142 | WFMC_HOLPPRF | Holiday Pay Profile Table | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
143 | WFMC_HOLPPRF_T | Holiday Pay Profile Text Table | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
144 | WFMC_HOLPPRM | Holiday Pay Premium | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
145 | WFMC_IMPORT_RL_T | Actual worked segment import rules | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
146 | WFMC_IMPORT_RULE | Actual worked segment import rules | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
147 | WFMC_LGC_MAP | Logical System Mapping for message type | 4 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
148 | WFMC_LOCATION | Location | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
149 | WFMC_LOCATION_T | Location Translation Table | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
150 | WFMC_LOCSETTN | General Location Settings | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
151 | WFMC_NONTRAN | Non transition zones | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
152 | WFMC_NONTRAN_T | text for non transition zones | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
153 | WFMC_OPHOURS | WFM Operating Hours Key | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
154 | WFMC_OPHOURS_D | WFM Operating Hours Data | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
155 | WFMC_OPHOURS_T | WFM Operating Hours Text Table | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
156 | WFMC_ORGDEPT_MAP | Mapping of org units and department tags | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
157 | WFMC_PAYCLASS | Payclass | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
158 | WFMC_PAYCLASS_T | Payclass Translation Table | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
159 | WFMC_PAYCLSPREM | Payclass Premiums | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
160 | WFMC_PRF_MOD_FLG | table stores manager editable and need approval flag for par | 4 | LOCATION_TYPE | parameter external key = parameter profile id | nvarchar | 20 | 0 | | |
161 | WFMC_SCHDEXCPN_D | Schedule Exceptions | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
162 | WFMC_SCHD_EXCPT | Schedule Exceptions (out of use for Retail) | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
163 | WFMC_SETSHFTCN | Set Shifts Config | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
164 | WFMC_SETSHFTCN_T | Set Shift Template Text | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
165 | WFMC_SETSHFT_INT | Set Shift Template Time Interval | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
166 | WFMC_SNPRFN | Seniority Date Profile | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
167 | WFMC_SN_PRF | Seniority Date Profile (out of use for Retail) | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
168 | WFMC_SOPHOURS | WFM Special Operating Hours Key | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
169 | WFMC_SOPHOURS_D | WFM Special Operating Hours Data | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
170 | WFMC_SOPHOURS_T | WFM Operating Hours Text Table | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
171 | WFMC_WARELUCT | individual work area rank within a reluctance profile | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
172 | WFMC_WARELUCTPRO | work area reluctance profile | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
173 | WFMC_WARELUCT_T | text table for work area reluctance profile | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
174 | WFMC_WKNDDAYSN | Weekend Days | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
175 | WFMC_WKND_DAYS | Weekend Days (out of use for Retail) | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
176 | WFMC_WKRLDFLTN_D | Work Rules Default | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
177 | WFMC_WKRLINTVN_D | Work Rule Interval | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
178 | WFMC_WKRLTEMPN | Work Rule Set Template | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
179 | WFMC_WKRLTEMPN_T | Work Rule Template Set Text | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
180 | WFMC_WKRLVALUE | Work Rule Value | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
181 | WFMC_WKRL_DFLT | Default Work Rules (Out of Use for Retail) | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
182 | WFMC_WKRL_INTV | Work Rule Interval (out of use for Retail) | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
183 | WFMC_WKRL_TEMP | Template for Work Rule Set (Out of Use for Retail) | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
184 | WFMC_WKRL_TEMP_T | Work Rule Template Set Text (out of use for Retail) | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
185 | WFMC_WKRL_VALUE | Work Rule Value (out of use for Retail) | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
186 | WFMFC_BUDGET_SET | Budget constraint | 3 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
187 | WFMFC_CALC_BTLOC | Calculation Batch Information | 4 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
188 | WFMFC_FCSTCFGN | Forecasting Configuration Parameters for Location Profile | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
189 | WFMFC_FCST_CFG | Forecasting Configuration Parameters (OBSOLETE) | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
190 | WFMFC_FIXHIST_D | Fixed History- Obsolete as of 5.0 | 3 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
191 | WFMFC_FIX_HIST | Fixed History - Obsolete as of 5.0 | 3 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
192 | WFMFC_GEN_HIST | Templates to identify forecasting dates of interest | 3 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
193 | WFMFC_IGRP_PARAM | Indicator Group | 4 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
194 | WFMFC_IND_ATTRIB | Indicator Attributes | 3 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
195 | WFMFC_OBJ_STAT | Object Stat for Configuration | 3 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
196 | WFMFC_STEP_PARAM | Step Parameters - OBSOLETE | 3 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
197 | WFMFC_STEP_PRM2 | Step Parameters | 3 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
198 | WFMFC_TAGDAY_GLO | Tagged History - Obsolete as of 5.0 | 3 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
199 | WFMFC_TAGDAY_LOC | Tag History - Location specific settings | 3 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
200 | WFMTM_ITC_REG | i-Time Clock registration | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |
201 | WFM_XPRA_PARAMET | XPRA parameters | 2 | LOCATION_TYPE | Location Profile | nvarchar | 20 | 0 | | |