| 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 | 6 | ENDTIMEDAY | End Time Day Index | nvarchar | 1 | 0 | | |
2 | WFAC_SETSHFT_INT | Set Shift Template Time Interval | 7 | ENDTIMEDAY | End Time Day Index | nvarchar | 1 | 0 | | |
3 | WFAC_SPECDAYPT_D | Availablility Template Time Interval | 7 | ENDTIMEDAY | End Time Day Index | nvarchar | 1 | 0 | | |
4 | WFAC_SPEC_DAY_DI | Special Day Part Data | 7 | ENDTIMEDAY | End Time Day Index | nvarchar | 1 | 0 | | |
5 | WFAC_WKRLINTVN_D | Work Rule Interval | 7 | ENDTIMEDAY | End Time Day Index | nvarchar | 1 | 0 | | |
6 | WFAC_WKRL_INTV | Work Rule Interval (out of use for Retail) | 6 | ENDTIMEDAY | End Time Day Index | nvarchar | 1 | 0 | | |
7 | WFATM_SC_AVA_TMP | TM Temp Table: Schedule - Availability | 9 | ENDTIMEDAY | End Time Day Index | nvarchar | 1 | 0 | | |
8 | WFATM_SR_AVA_TMP | TM Temp Table: Schedule Rule - Availability | 14 | ENDTIMEDAY | End Time Day Index | nvarchar | 1 | 0 | | |
9 | WFATM_SR_PRF_TMP | TM Temp Table: Schedule Rule - Preference | 14 | ENDTIMEDAY | End Time Day Index | nvarchar | 1 | 0 | | |
10 | WFATM_SR_SET_TMP | TM Temp Table: Schedule Rule - Set Shift | 14 | ENDTIMEDAY | End Time Day Index | nvarchar | 1 | 0 | | |
11 | WFA_TMAP_INTV | Time Map Interval Table | 5 | ENDTIMEDAY | End Time Day Index | nvarchar | 1 | 0 | | |
TOPWorkforce Management Core |
12 | WFMCAS_TMAP_INTV | Time Map Interval Table | 5 | ENDTIMEDAY | End Time Day Index | nvarchar | 1 | 0 | | |
13 | WFMC_AVAIL_INTV | Availablility Template Time Interval | 6 | ENDTIMEDAY | End Time Day Index | nvarchar | 1 | 0 | | |
14 | WFMC_SETSHFT_INT | Set Shift Template Time Interval | 7 | ENDTIMEDAY | End Time Day Index | nvarchar | 1 | 0 | | |
15 | WFMC_WKRLINTVN_D | Work Rule Interval | 7 | ENDTIMEDAY | End Time Day Index | nvarchar | 1 | 0 | | |
16 | WFMC_WKRL_INTV | Work Rule Interval (out of use for Retail) | 6 | ENDTIMEDAY | End Time Day Index | nvarchar | 1 | 0 | | |
17 | WFMTM_SC_AVA_TMP | TM Temp Table: Schedule - Availability | 9 | ENDTIMEDAY | End Time Day Index | nvarchar | 1 | 0 | | |
18 | WFMTM_SR_AVA_TMP | TM Temp Table: Schedule Rule - Availability | 14 | ENDTIMEDAY | End Time Day Index | nvarchar | 1 | 0 | | |
19 | WFMTM_SR_PRF_TMP | TM Temp Table: Schedule Rule - Preference | 14 | ENDTIMEDAY | End Time Day Index | nvarchar | 1 | 0 | | |
20 | WFMTM_SR_SET_TMP | TM Temp Table: Schedule Rule - Set Shift | 14 | ENDTIMEDAY | End Time Day Index | nvarchar | 1 | 0 | | |