| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPShift Planning |
1 | HRP1039 | Database Table for Infotype 1039 | 18 | DIENSTGR | Shift group for organizational units | nvarchar | 10 | 0 | | |
2 | PSHIFT_PBS | Shift Planning: Shift Abbreviation for Persons | 4 | DIENSTGR | Shift group for organizational units | nvarchar | 10 | 0 | | |
3 | PSOLL | Shift Planning: Target Plan | 8 | DIENSTGR | Shift group for organizational units | nvarchar | 10 | 0 | | |
4 | T77DB | Shift Groups for Organizational Units | 2 | DIENSTGR | Shift group for organizational units | nvarchar | 10 | 0 | | |
5 | T77DT | Texts for Shift Groups | 3 | DIENSTGR | Shift group for organizational units | nvarchar | 10 | 0 | | |
6 | T77ED | Shift Planning: Definition of Shifts | 2 | DIENSTGR | Shift group for organizational units | nvarchar | 10 | 0 | | |
7 | T77ES | Selection ID for Shift Planning Profile | 4 | DIENSTGR | Shift group for organizational units | nvarchar | 10 | 0 | | |
8 | T77ET | Shift Planning: Descriptions of Shift Abbreviations | 3 | DIENSTGR | Shift group for organizational units | nvarchar | 10 | 0 | | |
9 | T77EVOPT_DEF | Default Assignment Strategy for Shift Group | 2 | DIENSTGR | Shift group for organizational units | nvarchar | 10 | 0 | | |
10 | T77RB | Requirement Types per Shift Group of Organizational Unit | 2 | DIENSTGR | Shift group for organizational units | nvarchar | 10 | 0 | | |
11 | T77SP_CD | Shift Planning: Rules for Abbreviation Sequence | 2 | DIENSTGR | Shift group for organizational units | nvarchar | 10 | 0 | | |
12 | T77SP_CDT | Shift Planning: Names for Abbreviation Sequence Rules | 3 | DIENSTGR | Shift group for organizational units | nvarchar | 10 | 0 | | |
13 | T77SP_CE | Shift Planning: Rules for Abbreviation Sequences | 2 | DIENSTGR | Shift group for organizational units | nvarchar | 10 | 0 | | |
14 | T7PBS_ADHOC_1 | Shift Abbreviations Without Working Time Check | 2 | DIENSTGR | Shift group for organizational units | nvarchar | 10 | 0 | | |
15 | T7PBS_ADHOC_3 | Specifications for Abbreviations Relating to ADHOC Update | 2 | DIENSTGR | Shift group for organizational units | nvarchar | 10 | 0 | | |
16 | T7PBS_ADHOC_4 | Proposals for Indicators for Ad Hoc Update | 2 | DIENSTGR | Shift group for organizational units | nvarchar | 10 | 0 | | |
TOPShift Planning for Public Sector |
17 | T7PBS_ADHOC_2 | Info Columns with ADHOC Update | 2 | DIENSTGR | Shift group for organizational units | nvarchar | 10 | 0 | | |