| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | PDPBSZVANM_R | SPI Confirmation: Registration (Record Type 30) | 4 | SATZA | Record Type, DATUEV-ZVE | nvarchar | 2 | 0 | | |
2 | PDPBSZVNAM_R | SPI Confirmation: Name (Record Type 80) | 4 | SATZA | Record Type, DATUEV-ZVE | nvarchar | 2 | 0 | | |
TOPConfirmations |
3 | AFRP0 | Table of planned changes for confirmation (PDC) | 46 | SATZA | Record type for confirmation | nvarchar | 3 | 0 | | |
4 | AFRU | Order Confirmations | 111 | SATZA | Record type for confirmation | nvarchar | 3 | 0 | | |
5 | AFRV | Confirmation pool | 53 | SATZA | Time Event Type | nvarchar | 3 | 0 | | |
6 | AFRV_DEL | Backup Copy for Confirmation Pool | 53 | SATZA | Time Event Type | nvarchar | 3 | 0 | | |
TOPPersonnel Time Events |
7 | TPTCOR_CORE | Core Information (Correction Scenario) | 10 | SATZA | Time Event Type | nvarchar | 3 | 0 | | |
TOPPersonnel Time Management |
8 | CC1ERP | Incorrect Time Events from CC1, Postings | 10 | SATZA | Time Event Type | nvarchar | 3 | 0 | | |
9 | CC1TEV | Temporary Buffer for Time Events from CC1 | 9 | SATZA | Time Event Type | nvarchar | 3 | 0 | | |
10 | T705P | Work Time Event Type Groups | 3 | SATZA | Time Event Type | nvarchar | 3 | 0 | | |
11 | TEVEN | Time Events | 8 | SATZA | Time Event Type | nvarchar | 3 | 0 | | |
12 | TEVEN_MORE | Additional Data for Time Events | 9 | SATZA | Time Event Type | nvarchar | 3 | 0 | | |
13 | TOPRK | Log Messages | 5 | SATZA | Record Type | nvarchar | 3 | 0 | | |
TOPPlant Data Collection |
14 | RUECK | Temp. storage for subsystem confirmations | 48 | SATZA | Time Event Type | nvarchar | 3 | 0 | | |
TOPPublic Sector |
15 | PDPBSZVABM | Dereg. from Compulsory Insurance (Record Type 40), ZVE-PBS | 12 | SATZA | Record Type, DATUEV-ZVE | nvarchar | 2 | 0 | | |
16 | PDPBSZVABS | Periods (Record Type 60), ZVE-PBS | 12 | SATZA | Record Type, DATUEV-ZVE | nvarchar | 2 | 0 | | |
17 | PDPBSZVADR | Address (Record Type 81), ZVE-PBS | 12 | SATZA | Record Type, DATUEV-ZVE | nvarchar | 2 | 0 | | |
18 | PDPBSZVANM | Reg. for Compulsory Insurance (Record Type 30), ZVE-PBS | 12 | SATZA | Record Type, DATUEV-ZVE | nvarchar | 2 | 0 | | |
19 | PDPBSZVDIF | Difference (Record Type 70), ZVE-PBS | 12 | SATZA | Record Type, DATUEV-ZVE | nvarchar | 2 | 0 | | |
20 | PDPBSZVLOG | Log Table for ZVE-PBS Notification Procedure | 15 | SATZA | Record Type, DATUEV-ZVE | nvarchar | 2 | 0 | | |
21 | PDPBSZVNAM | Name (Record Type 80), ZVE-PBS | 12 | SATZA | Record Type, DATUEV-ZVE | nvarchar | 2 | 0 | | |
22 | PDPBSZVSUM | Totals Record (Record Type 90), SPI | 11 | SATZA | Record Type, DATUEV-ZVE | nvarchar | 2 | 0 | | |
TOPTime Data Recording and Administration |
23 | TMW_TDTYPE | Time Data ID | 27 | SATZA | Time Event Type | nvarchar | 3 | 0 | | |
TOPTime Tickets |
24 | EVHR | HR Order Confirmations (Times/Time Events) | 9 | SATZA | Time Event Type | nvarchar | 3 | 0 | | |
25 | LSHR | HR Order Confirmations (Durations/Time Tickets) | 9 | SATZA | Time Event Type | nvarchar | 3 | 0 | | |