| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000283000 | PSA for 0EMPLOYEE_2_ATTR T90CLNT090 Employee | 47 | ROOM | | nvarchar | 6 | 0 | | |
2 | ZROOMBOOKED | Table with all reservations | 2 | ROOM | Number or name of room | nvarchar | 20 | 0 | | |
3 | ZROOMS | Table stores all rooms that are available | 2 | ROOM | Number or name of room | nvarchar | 20 | 0 | | |
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector |
4 | CRMAHR | Data on Persons | 9 | ROOM | Room or Appartment Number | nvarchar | 10 | 0 | | |
5 | CRMEMTCID | Copy of EMTCID Table | 7 | ROOM | | nvarchar | 7 | 0 | | |
TOPAppointment Calendar |
6 | SCAPPT | User-Specific Appointments | 9 | ROOM | Appointment room | nvarchar | 12 | 0 | | |
7 | SCGENAPPT | generated appointments (regular or group appointments) | 7 | ROOM | Appointment room | nvarchar | 12 | 0 | | |
TOPCross-Application Components |
8 | CACNS_RESERVE_T | Reserve Table in a Room | 3 | ROOM | Telebox number | nvarchar | 15 | 0 | | |
TOPKnowledge Warehouse |
9 | IWBKEPDEST | KEPlicator Data for Logical Destinations | 15 | ROOM | Physical Room Number | nvarchar | 8 | 0 | | |
TOPPatient Management |
10 | NADR | IS-H: Addresses (Central Address Management) | 24 | ROOM | IS-H: Unit Number | nvarchar | 10 | 0 | | |
11 | NTPGP | IS-H: Day program items (possible appointments) | 19 | ROOM | IS-H: Treatment Room of Attending Physician | nvarchar | 8 | 0 | | |