| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | TMDT_MDS_SCNRIOS | Market Data Set by Scenarios | 7 | SHIFT_ID | Market Data Shift Rule in Risk Management | nvarchar | 10 | 0 | | |
| TOPLine Maintenance |
| 2 | /ISDFPS/LM_SPREL | Database Table for Sites and Person Relation | 4 | SHIFT_ID | ID of a Shift on a Given Day | nvarchar | 1 | 0 | | |
| TOPTransaction Management |
| 3 | THXT_HR_TESTPLAN | Hedging - Effectivity Test Plan | 8 | SHIFT_ID | Market Data Shift Rule in Risk Management | nvarchar | 10 | 0 | | |
| TOPWorkforce Management Application |
| 4 | WFACAS_SHIFT_SEG | Shift Segment Table | 3 | SHIFT_ID | Shift Id | nvarchar | 32 | 0 | | |
| 5 | WFATM_SC_SEG_TMP | TM Temp Table: Schedule - Shift Segment | 8 | SHIFT_ID | Shift Id | nvarchar | 32 | 0 | | |
| 6 | WFA_ACT_SEG | Imported actual segments table | 3 | SHIFT_ID | Shift Id | nvarchar | 32 | 0 | | |
| 7 | WFA_ACT_SHIFT | Actual header table | 2 | SHIFT_ID | Shift Id | nvarchar | 32 | 0 | | |
| 8 | WFA_SHIFT | Shift Table | 2 | SHIFT_ID | Shift Id | nvarchar | 32 | 0 | | |
| 9 | WFA_SHIFT_SG2 | Shifts Segments for WFM Schedule | 8 | SHIFT_ID | Shift Id | nvarchar | 32 | 0 | | |
| TOPWorkforce Management Core |
| 10 | WFMCAS_ACT_SEG | Imported actual segments table | 3 | SHIFT_ID | Shift Id | nvarchar | 32 | 0 | | |
| 11 | WFMCAS_ACT_SHIFT | Actual header table | 2 | SHIFT_ID | Shift Id | nvarchar | 32 | 0 | | |
| 12 | WFMCAS_SHIFT | Shift Table | 2 | SHIFT_ID | Shift Id | nvarchar | 32 | 0 | | |
| 13 | WFMCAS_SHIFT_SEG | Shift Segment Table | 3 | SHIFT_ID | Shift Id | nvarchar | 32 | 0 | | |
| 14 | WFMCAS_SHIFT_SG2 | Shifts Integrated with WFD Server | 8 | SHIFT_ID | Shift Id | nvarchar | 32 | 0 | | |
| 15 | WFMTM_SC_SEG_TMP | TM Temp Table: Schedule - Shift Segment | 8 | SHIFT_ID | Shift Id | nvarchar | 32 | 0 | | |
