| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPPersonnel Administration |
| 1 | T001P | Personnel Area/Subarea | 12 | MOVER | Personnel Subarea Grpg for Substitution/Availability Types | nvarchar | 2 | 0 | | |
| TOPPersonnel Time Management |
| 2 | T556 | Substitution Types | 2 | MOVER | Personnel Subarea Grpg for Substitution/Availability Types | nvarchar | 2 | 0 | | |
| 3 | T556T | Substitution Type Texts | 3 | MOVER | Personnel Subarea Grpg for Substitution/Availability Types | nvarchar | 2 | 0 | | |
| 4 | T557 | Availability Types | 2 | MOVER | Personnel Subarea Grpg for Substitution/Availability Types | nvarchar | 2 | 0 | | |
| 5 | T557T | Availability Types Texts | 3 | MOVER | Personnel Subarea Grpg for Substitution/Availability Types | nvarchar | 2 | 0 | | |
| TOPReuse Services for Country Development |
| 6 | T5F99PHS | Public Holiday Substitutions | 2 | MOVER | Personnel Subarea Grpg for Substitution/Availability Types | nvarchar | 2 | 0 | | |
| TOPShift Planning |
| 7 | PSOLL | Shift Planning: Target Plan | 14 | MOVER | Personnel Subarea Grpg for Substitution/Availability Types | nvarchar | 2 | 0 | | |
| 8 | T77ED | Shift Planning: Definition of Shifts | 17 | MOVER | Personnel Subarea Grpg for Substitution/Availability Types | nvarchar | 2 | 0 | | |
| 9 | T77ER | Substitution Types in Shift Plans | 3 | MOVER | Personnel Subarea Grpg for Substitution/Availability Types | nvarchar | 2 | 0 | | |
| 10 | T7PBS_ADHOC_4 | Proposals for Indicators for Ad Hoc Update | 3 | MOVER | Personnel Subarea Grpg for Substitution/Availability Types | nvarchar | 2 | 0 | | |
| TOPTime Data Recording and Administration |
| 11 | TMW_TDTYPE | Time Data ID | 9 | MOVER | Personnel Subarea Grpg for Substitution/Availability Types | nvarchar | 2 | 0 | | |
