| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPWorkforce Management Application |
1 | WFAC_EXCPT_DEF | Schedule Exception Definitions | 3 | WORKRULE_TYPE | Work Rule Type | nvarchar | 4 | 0 | | |
2 | WFAC_WKRLDFLTN_D | Work Rules Default | 4 | WORKRULE_TYPE | Work Rule Type | nvarchar | 4 | 0 | | |
3 | WFAC_WKRLINTVN_D | Work Rule Interval | 4 | WORKRULE_TYPE | Work Rule Type | nvarchar | 4 | 0 | | |
4 | WFAC_WKRLVALUE | Work Rule Value | 4 | WORKRULE_TYPE | Work Rule Type | nvarchar | 4 | 0 | | |
5 | WFAC_WKRL_DEF | Default Work Rules Definitions | 2 | WORKRULE_TYPE | Work Rule Type | nvarchar | 4 | 0 | | |
6 | WFAC_WKRL_DEF_T | Default Work Rules Definitions | 2 | WORKRULE_TYPE | Work Rule Type | nvarchar | 4 | 0 | | |
7 | WFAC_WKRL_DFLT | Default Work Rules (Out of Use for Retail) | 3 | WORKRULE_TYPE | Work Rule Type | nvarchar | 4 | 0 | | |
8 | WFAC_WKRL_INTV | Work Rule Interval (out of use for Retail) | 3 | WORKRULE_TYPE | Work Rule Type | nvarchar | 4 | 0 | | |
9 | WFATM_SR_WKR_TMP | TM Temp Table: Schedule Rule - Work Rule | 10 | WORKRULE_TYPE | Work Rule Type | nvarchar | 4 | 0 | | |
10 | WFA_EMP_PD_START | Employee period rule start dates | 3 | WORKRULE_TYPE | Work Rule Type | nvarchar | 4 | 0 | | |
11 | WFA_WRKRLST_V | Work Rule Set Values Master Data | 4 | WORKRULE_TYPE | Work Rule Type | nvarchar | 4 | 0 | | |
TOPWorkforce Management Core |
12 | WFMCAS_WRKRLST_V | Work Rule Set Values Master Data | 4 | WORKRULE_TYPE | Work Rule Type | nvarchar | 4 | 0 | | |
13 | WFMC_EXCPT_DEF | Schedule Exception Definitions | 3 | WORKRULE_TYPE | Work Rule Type | nvarchar | 4 | 0 | | |
14 | WFMC_WKRLDFLTN_D | Work Rules Default | 4 | WORKRULE_TYPE | Work Rule Type | nvarchar | 4 | 0 | | |
15 | WFMC_WKRLINTVN_D | Work Rule Interval | 4 | WORKRULE_TYPE | Work Rule Type | nvarchar | 4 | 0 | | |
16 | WFMC_WKRLVALUE | Work Rule Value | 4 | WORKRULE_TYPE | Work Rule Type | nvarchar | 4 | 0 | | |
17 | WFMC_WKRL_DEF | Default Work Rules Definitions | 2 | WORKRULE_TYPE | Work Rule Type | nvarchar | 4 | 0 | | |
18 | WFMC_WKRL_DEF_T | Default Work Rules Definitions | 2 | WORKRULE_TYPE | Work Rule Type | nvarchar | 4 | 0 | | |
19 | WFMC_WKRL_DFLT | Default Work Rules (Out of Use for Retail) | 3 | WORKRULE_TYPE | Work Rule Type | nvarchar | 4 | 0 | | |
20 | WFMC_WKRL_INTV | Work Rule Interval (out of use for Retail) | 3 | WORKRULE_TYPE | Work Rule Type | nvarchar | 4 | 0 | | |
21 | WFMC_WKRL_VALUE | Work Rule Value (out of use for Retail) | 4 | WORKRULE_TYPE | Work Rule Type | nvarchar | 4 | 0 | | |
22 | WFMTM_SR_WKR_TMP | TM Temp Table: Schedule Rule - Work Rule | 10 | WORKRULE_TYPE | Work Rule Type | nvarchar | 4 | 0 | | |