| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPConfirmations |
1 | AFRV | Confirmation pool | 61 | DALLF | Single-Character Indicator | nvarchar | 1 | 0 | | |
2 | AFRV_DEL | Backup Copy for Confirmation Pool | 61 | DALLF | Single-Character Indicator | nvarchar | 1 | 0 | | |
TOPPersonnel Time Events |
3 | TPTCOR_CORE | Core Information (Correction Scenario) | 14 | DALLF | Day assignment | nvarchar | 1 | 0 | | |
TOPPersonnel Time Management |
4 | CC1ERP | Incorrect Time Events from CC1, Postings | 14 | DALLF | Day assignment | nvarchar | 1 | 0 | | |
5 | CC1TEV | Temporary Buffer for Time Events from CC1 | 13 | DALLF | Day assignment | nvarchar | 1 | 0 | | |
6 | TEVEN | Time Events | 16 | DALLF | Day assignment | nvarchar | 1 | 0 | | |
7 | TEVEN_MORE | Additional Data for Time Events | 13 | DALLF | Day assignment | nvarchar | 1 | 0 | | |
TOPPlant Data Collection |
8 | RUECK | Temp. storage for subsystem confirmations | 56 | DALLF | Single-Character Indicator | nvarchar | 1 | 0 | | |
TOPTime Tickets |
9 | EVHR | HR Order Confirmations (Times/Time Events) | 13 | DALLF | Day assignment | nvarchar | 1 | 0 | | |
10 | LSHR | HR Order Confirmations (Durations/Time Tickets) | 13 | DALLF | Day assignment | nvarchar | 1 | 0 | | |