| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPWorkforce Management Application |
1 | WFACAS_SHIFT_SEG | Shift Segment Table | 13 | REGULAR_HRS | Regular Hours Worked/Scheduled | decimal | 16 | 2 | | |
2 | WFA_ACT_SEG | Imported actual segments table | 16 | REGULAR_HRS | Regular Hours Worked/Scheduled | decimal | 16 | 2 | | |
3 | WFA_SHIFT_SG2 | Shifts Segments for WFM Schedule | 12 | REGULAR_HRS | Regular Hours Worked/Scheduled | decimal | 16 | 2 | | |
TOPWorkforce Management Core |
4 | WFMCAS_ACT_SEG | Imported actual segments table | 16 | REGULAR_HRS | Regular Hours Worked/Scheduled | decimal | 16 | 2 | | |
5 | WFMCAS_SHIFT_SEG | Shift Segment Table | 13 | REGULAR_HRS | Regular Hours Worked/Scheduled | decimal | 16 | 2 | | |
6 | WFMCAS_SHIFT_SG2 | Shifts Integrated with WFD Server | 12 | REGULAR_HRS | Regular Hours Worked/Scheduled | decimal | 16 | 2 | | |