| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPWorkforce Management Application |
| 1 | WFAC_SETSHFTCN | Set Shifts Config | 3 | ST_SHFT_TMPLT_ID | Set Shift Template ID, Set Shifts Config Table, TimeInterval | nvarchar | 20 | 0 | | |
| 2 | WFAC_SETSHFTCN_T | Set Shift Template Text | 3 | ST_SHFT_TMPLT_ID | Set Shift Template ID, Set Shifts Config Table, TimeInterval | nvarchar | 20 | 0 | | |
| 3 | WFAC_SETSHFT_INT | Set Shift Template Time Interval | 3 | ST_SHFT_TMPLT_ID | Set Shift Template ID, Set Shifts Config Table, TimeInterval | nvarchar | 20 | 0 | | |
| TOPWorkforce Management Core |
| 4 | WFMC_SETSHFTCN | Set Shifts Config | 3 | ST_SHFT_TMPLT_ID | Set Shift Template ID, Set Shifts Config Table, TimeInterval | nvarchar | 20 | 0 | | |
| 5 | WFMC_SETSHFTCN_T | Set Shift Template Text | 3 | ST_SHFT_TMPLT_ID | Set Shift Template ID, Set Shifts Config Table, TimeInterval | nvarchar | 20 | 0 | | |
| 6 | WFMC_SETSHFT_INT | Set Shift Template Time Interval | 3 | ST_SHFT_TMPLT_ID | Set Shift Template ID, Set Shifts Config Table, TimeInterval | nvarchar | 20 | 0 | | |
