| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | TC29F | Distribution function for capacity planning | 3 | DAUER | Distribution of cap. requirements acc. to percent. duration | nvarchar | 3 | 0 | | |
| TOPALE Integration Technology |
| 2 | EDADMDEB | Storage of Debugging Settings | 5 | DAUER | | nvarchar | 3 | 0 | | |
| TOPBasic Data |
| 3 | TN40B | IS-H: Scheduling Types | 5 | DAUER | IS-H: Duration for Scheduling Type in Minutes | nvarchar | 4 | 0 | | |
| TOPClinical System |
| 4 | N1PRLEM | IS-H*MED: PATREG: Leistungen | 48 | DAUER | IS-H: Tedavi randevusu için dakika olarak süre | nvarchar | 4 | 0 | | |
| 5 | N1TPM | IS-H*MED: Medical Enhancements for the Service Catalog Items | 6 | DAUER | IS-H*MED: Duration in Minutes | nvarchar | 4 | 0 | | |
| 6 | NLEM | IS-H*MED: Medical Service | 18 | DAUER | IS-H: Duration in Minutes for Treatment Appointment | nvarchar | 4 | 0 | | |
| TOPCompensation Management |
| 7 | T510R | Pay Scale Reclassification | 13 | DAUER | Group membership duration | nvarchar | 4 | 0 | | |
| 8 | T510_PSRCL | Pay scale reclassification | 13 | DAUER | Group Membership Duration | nvarchar | 4 | 0 | | |
| TOPData Collection |
| 9 | CF005 | Personnel Information | 44 | DAUER | Length of time employed | decimal | 15 | 3 | | |
| 10 | CF705 | IDES Personnel Info | 45 | DAUER | Length of time employed | decimal | 15 | 3 | | |
| TOPMaster Data |
| 11 | RSDB | Index of the RESB for the Direct Procurement Element | 15 | DAUER | Time interval between relationships | decimal | 5 | 1 | | |
| TOPNetwork and Activity |
| 12 | AFAB | Network - Relationships | 10 | DAUER | Time interval between relationships | decimal | 5 | 1 | | |
| 13 | PLAB | Relationships | 16 | DAUER | Time interval between relationships | decimal | 5 | 1 | | |
| TOPPatient Management |
| 14 | NAPP | IS-H: Provisional Appointments for Visit Scheduling | 22 | DAUER | IS-H: Duration in Minutes for Treatment Appointment | nvarchar | 4 | 0 | | |
| 15 | NAPP_POB | IS-H: Dummy table for lock object ENAPP_ENQ | 5 | DAUER | IS-H*MED: Duration in Minutes | nvarchar | 4 | 0 | | |
| 16 | NBEW | IS-H: Movements for Case | 36 | DAUER | IS-H: Estimated Length of Stay or Treatment | nvarchar | 5 | 0 | | |
| TOPPersonnel Administration |
| 17 | T510U | Pay Scale Groups | 11 | DAUER | Group membership duration | nvarchar | 4 | 0 | | |
| TOPPlant Maintenance |
| 18 | Z9I_STK_IF_NPV | PM/PS-Schnittstelle: Netzplanvorgänge | 11 | DAUER | Normale Vorgangsdauer | decimal | 5 | 1 | | |
| 19 | Z9I_STK_IF_NPV_W | PM/PS-Schnittstelle: Netzplanvorgänge Werkstattsicht | 12 | DAUER | Normale Vorgangsdauer | decimal | 5 | 1 | | |
| 20 | Z9I_STK_VORGANG | Terminkontrolle Stillstandsplanung: Relevante Vorgänge | 38 | DAUER | Vorgangsdauer Stillstandsplanung | decimal | 6 | 2 | | |
| TOPPublic Sector |
| 21 | PA0265 | HR Master Record Infotype 0265/Special Regulations PSG | 35 | DAUER | Duration of Assessment Period When Overridden | nvarchar | 2 | 0 | | |
| 22 | T5APBS06 | Pay scale reclassification | 12 | DAUER | Group membership duration | nvarchar | 4 | 0 | | |
| TOPQualifications and Requirements |
| 23 | HRPAD44 | PAD44 Additional Data | 4 | DAUER | Duration (numeric value) (years, months, days) | nvarchar | 8 | 0 | | |
| TOPRouting |
| 24 | PLMZ | Allocation of bill of material items to operations | 41 | DAUER | Time interval between relationships | decimal | 5 | 1 | | |
| TOPSAP Healthcare - Industry-Specific Components for Hospitals |
| 25 | NDGB | IS-H: Borrowing authorization | 9 | DAUER | IS-H: Max. no. of Days for which Med.Records can be Borrowed | smallint | 5 | 0 | | |
| 26 | NLWARTE_003 | NL - Warteliste extra felder fur | 9 | DAUER | ISH_NL: Duur | nvarchar | 1 | 0 | | |
| 27 | TND01 | IS-H: Borrowing purposes for documents | 5 | DAUER | IS-H: Max. no. of Days for which Med.Records can be Borrowed | smallint | 5 | 0 | | |
| TOPShift Planning |
| 28 | PSOLL | Shift Planning: Target Plan | 20 | DAUER | Number of hours | decimal | 5 | 2 | | |
| TOPSimulation |
| 29 | VSAFAB_CN | Version: Network relationships | 11 | DAUER | Time interval between relationships | decimal | 5 | 1 | | |
| 30 | VSRSDB_CN | Version: Index of RESB for direct procurement elements | 16 | DAUER | Time interval between relationships | decimal | 5 | 1 | | |
| TOPTraining and Event Management |
| 31 | T770A | Day Segments | 9 | DAUER | Total Duration | nvarchar | 6 | 0 | | |
| TOPTraining Management |
| 32 | HRP1882 | DB Table for Infotype 1882 | 18 | DAUER | Duration of Business Event | nvarchar | 3 | 0 | | |
