| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPConfirmations |
| 1 | AFRV | Confirmation pool | 63 | PDC_PLANS | Position | nvarchar | 8 | 0 | | |
| 2 | AFRV_DEL | Backup Copy for Confirmation Pool | 63 | PDC_PLANS | Position | nvarchar | 8 | 0 | | |
| TOPPersonnel Time Events |
| 3 | TPTCOR_LOGISTIC | Logistics Orders (Correction Scenario) | 4 | PDC_PLANS | Position | nvarchar | 8 | 0 | | |
| TOPPersonnel Time Management |
| 4 | CC1ERP | Incorrect Time Events from CC1, Postings | 16 | PDC_PLANS | Position | nvarchar | 8 | 0 | | |
| 5 | CC1TEV | Temporary Buffer for Time Events from CC1 | 15 | PDC_PLANS | Position | nvarchar | 8 | 0 | | |
| 6 | TEVEN | Time Events | 18 | PDC_PLANS | Position | nvarchar | 8 | 0 | | |
| 7 | TEVEN_MORE | Additional Data for Time Events | 15 | PDC_PLANS | Position | nvarchar | 8 | 0 | | |
| TOPPlant Data Collection |
| 8 | RUECK | Temp. storage for subsystem confirmations | 58 | PDC_PLANS | Position | nvarchar | 8 | 0 | | |
| TOPTime Tickets |
| 9 | EVHR | HR Order Confirmations (Times/Time Events) | 15 | PDC_PLANS | Position | nvarchar | 8 | 0 | | |
| 10 | LSHR | HR Order Confirmations (Durations/Time Tickets) | 15 | PDC_PLANS | Position | nvarchar | 8 | 0 | | |
