| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPWorkforce Management Application |
1 | WFAC_AVAIL_INTV | Availablility Template Time Interval | 4 | INTVINDEX | Time Interval Index | int | 10 | 0 | | |
2 | WFAC_SETSHFT_INT | Set Shift Template Time Interval | 4 | INTVINDEX | Time Interval Index | int | 10 | 0 | | |
3 | WFAC_SPECDAYPT_D | Availablility Template Time Interval | 5 | INTVINDEX | Time Interval Index | int | 10 | 0 | | |
4 | WFAC_SPEC_DAY_DI | Special Day Part Data | 4 | INTVINDEX | Time Interval Index | int | 10 | 0 | | |
5 | WFAC_WKRLINTVN_D | Work Rule Interval | 5 | INTVINDEX | Time Interval Index | int | 10 | 0 | | |
6 | WFAC_WKRL_INTV | Work Rule Interval (out of use for Retail) | 4 | INTVINDEX | Time Interval Index | int | 10 | 0 | | |
7 | WFATM_SC_AVA_TMP | TM Temp Table: Schedule - Availability | 7 | INTVINDEX | Time Interval Index | int | 10 | 0 | | |
8 | WFATM_SR_AVA_TMP | TM Temp Table: Schedule Rule - Availability | 10 | INTVINDEX | Time Interval Index | int | 10 | 0 | | |
9 | WFATM_SR_PRF_TMP | TM Temp Table: Schedule Rule - Preference | 10 | INTVINDEX | Time Interval Index | int | 10 | 0 | | |
10 | WFATM_SR_SET_TMP | TM Temp Table: Schedule Rule - Set Shift | 10 | INTVINDEX | Time Interval Index | int | 10 | 0 | | |
11 | WFA_CORE_SCHE | Core Scheduling | 5 | INTVINDEX | Time Interval Index | int | 10 | 0 | | |
12 | WFA_SHFT_INTV | Shift Interval Job and type assignment | 3 | INTVINDEX | Time Interval Index | int | 10 | 0 | | |
13 | WFA_TMAP_INTV | Time Map Interval Table | 3 | INTVINDEX | Time Interval Index | int | 10 | 0 | | |
TOPWorkforce Management Core |
14 | WFMCAS_CORE_SCHE | Core Scheduling | 5 | INTVINDEX | Time Interval Index | int | 10 | 0 | | |
15 | WFMCAS_SHFT_INTV | Shift Interval Job and type assignment | 3 | INTVINDEX | Time Interval Index | int | 10 | 0 | | |
16 | WFMCAS_TMAP_INTV | Time Map Interval Table | 3 | INTVINDEX | Time Interval Index | int | 10 | 0 | | |
17 | WFMC_AVAIL_INTV | Availablility Template Time Interval | 4 | INTVINDEX | Time Interval Index | int | 10 | 0 | | |
18 | WFMC_SETSHFT_INT | Set Shift Template Time Interval | 4 | INTVINDEX | Time Interval Index | int | 10 | 0 | | |
19 | WFMC_WKRLINTVN_D | Work Rule Interval | 5 | INTVINDEX | Time Interval Index | int | 10 | 0 | | |
20 | WFMC_WKRL_INTV | Work Rule Interval (out of use for Retail) | 4 | INTVINDEX | Time Interval Index | int | 10 | 0 | | |
21 | WFMTM_SC_AVA_TMP | TM Temp Table: Schedule - Availability | 7 | INTVINDEX | Time Interval Index | int | 10 | 0 | | |
22 | WFMTM_SR_AVA_TMP | TM Temp Table: Schedule Rule - Availability | 10 | INTVINDEX | Time Interval Index | int | 10 | 0 | | |
23 | WFMTM_SR_PRF_TMP | TM Temp Table: Schedule Rule - Preference | 10 | INTVINDEX | Time Interval Index | int | 10 | 0 | | |
24 | WFMTM_SR_SET_TMP | TM Temp Table: Schedule Rule - Set Shift | 10 | INTVINDEX | Time Interval Index | int | 10 | 0 | | |