| 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 | | |