| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPClinical System |
| 1 | N1POPAKTE | IS-H*Med: Patient Organizer - Redundant Structure | 67 | SRVID | Technical Key of an Object | nvarchar | 32 | 0 | | |
| 2 | N1SRV | Services: Service Data | 2 | SRVID | Technical Key of an Object | nvarchar | 32 | 0 | | |
| 3 | N1SRVPROP | Nursing Services: Service Properties | 3 | SRVID | Technical Key of an Object | nvarchar | 32 | 0 | | |
| 4 | N1SRVSTAT | Services: Service Statuses | 3 | SRVID | Technical Key of an Object | nvarchar | 32 | 0 | | |
| 5 | N1SRVTEAM | Services: Employee for Service | 3 | SRVID | Technical Key of an Object | nvarchar | 32 | 0 | | |
| TOPCross-Application Components |
| 6 | SPRTL31 | Assignment of Services to Business Objects | 3 | SRVID | Drag&Relate: Service ID | nvarchar | 40 | 0 | | |
| 7 | SPRTL31C | Assignment of Services to Business Objects (Runtime) | 4 | SRVID | Drag&Relate: Service ID | nvarchar | 40 | 0 | | |
| 8 | SPRTL91 | Service Parameter Description | 3 | SRVID | Drag&Relate: Service ID | nvarchar | 40 | 0 | | |
| 9 | SPRTL91C | Service Parameter Description (Runtime) | 4 | SRVID | Drag&Relate: Service ID | nvarchar | 40 | 0 | | |
| TOPNursing |
| 10 | N1NRSSRV | Nursing Services: Nursing Service Data | 2 | SRVID | Technical Key of an Object | nvarchar | 32 | 0 | | |
| 11 | N1NSRVSTAT | OBSOLETE - Nursing Services: Statuses for Service | 3 | SRVID | Technical Key of an Object | nvarchar | 32 | 0 | | |
| 12 | N1NSRVTEAM | OBSOLETE - Nursing Services: Employees for Service | 3 | SRVID | Technical Key of an Object | nvarchar | 32 | 0 | | |
| TOPUser Administration |
| 13 | WP3ROLESRV | Portal Roles: Services | 7 | SRVID | Portal Role Service | nvarchar | 132 | 0 | | |
