| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPWorkforce Management Application |
1 | ITC_CALCRULE_SFT | Shift Differential Configuration on Shift Interval | 9 | STARTOFFSETTYPE | Start Offset Type | nvarchar | 2 | 0 | | |
2 | WFAC_AVAIL_INTV | Availablility Template Time Interval | 9 | STARTOFFSETTYPE | Start Offset Type | nvarchar | 2 | 0 | | |
3 | WFAC_SETSHFT_INT | Set Shift Template Time Interval | 10 | STARTOFFSETTYPE | Start Offset Type | nvarchar | 2 | 0 | | |
4 | WFAC_SPECDAYPT_D | Availablility Template Time Interval | 10 | STARTOFFSETTYPE | Start Offset Type | nvarchar | 2 | 0 | | |
5 | WFAC_SPEC_DAY_DI | Special Day Part Data | 10 | STARTOFFSETTYPE | Start Offset Type | nvarchar | 2 | 0 | | |
6 | WFAC_WKRLINTVN_D | Work Rule Interval | 10 | STARTOFFSETTYPE | Start Offset Type | nvarchar | 2 | 0 | | |
7 | WFAC_WKRL_INTV | Work Rule Interval (out of use for Retail) | 9 | STARTOFFSETTYPE | Start Offset Type | nvarchar | 2 | 0 | | |
8 | WFAFC_IND_TDATA | Time relative data associated with an indicator | 11 | STARTOFFSETTYPE | Start Offset Type | nvarchar | 2 | 0 | | |
9 | WFATM_SR_AVA_TMP | TM Temp Table: Schedule Rule - Availability | 17 | STARTOFFSETTYPE | Start Offset Type | nvarchar | 2 | 0 | | |
10 | WFATM_SR_PRF_TMP | TM Temp Table: Schedule Rule - Preference | 17 | STARTOFFSETTYPE | Start Offset Type | nvarchar | 2 | 0 | | |
11 | WFATM_SR_SET_TMP | TM Temp Table: Schedule Rule - Set Shift | 17 | STARTOFFSETTYPE | Start Offset Type | nvarchar | 2 | 0 | | |
12 | WFA_CORE_SCHE | Core Scheduling | 15 | STARTOFFSETTYPE | Start Offset Type | nvarchar | 2 | 0 | | |
13 | WFA_TMAP_INTV | Time Map Interval Table | 8 | STARTOFFSETTYPE | Start Offset Type | nvarchar | 2 | 0 | | |
TOPWorkforce Management Core |
14 | WFMCAS_CORE_SCHE | Core Scheduling | 15 | STARTOFFSETTYPE | Start Offset Type | nvarchar | 2 | 0 | | |
15 | WFMCAS_TMAP_INTV | Time Map Interval Table | 8 | STARTOFFSETTYPE | Start Offset Type | nvarchar | 2 | 0 | | |
16 | WFMC_AVAIL_INTV | Availablility Template Time Interval | 9 | STARTOFFSETTYPE | Start Offset Type | nvarchar | 2 | 0 | | |
17 | WFMC_SETSHFT_INT | Set Shift Template Time Interval | 10 | STARTOFFSETTYPE | Start Offset Type | nvarchar | 2 | 0 | | |
18 | WFMC_WKRLINTVN_D | Work Rule Interval | 10 | STARTOFFSETTYPE | Start Offset Type | nvarchar | 2 | 0 | | |
19 | WFMC_WKRL_INTV | Work Rule Interval (out of use for Retail) | 9 | STARTOFFSETTYPE | Start Offset Type | nvarchar | 2 | 0 | | |
20 | WFMTM_SR_AVA_TMP | TM Temp Table: Schedule Rule - Availability | 17 | STARTOFFSETTYPE | Start Offset Type | nvarchar | 2 | 0 | | |
21 | WFMTM_SR_PRF_TMP | TM Temp Table: Schedule Rule - Preference | 17 | STARTOFFSETTYPE | Start Offset Type | nvarchar | 2 | 0 | | |
22 | WFMTM_SR_SET_TMP | TM Temp Table: Schedule Rule - Set Shift | 17 | STARTOFFSETTYPE | Start Offset Type | nvarchar | 2 | 0 | | |