| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPClinical System |
| 1 | N1STEP_STATE | i.s.h.med: Temporarily Stored Step Process States | 6 | PARENT_UID | i.s.h.med: Unique ID of Higher-Level Step | nvarchar | 32 | 0 | | |
| TOPMonitoring |
| 2 | ALPFCOLLTID | TID List Created from ALPFREORG:Objects to Collect in PerfDB | 11 | PARENT_UID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
| TOPWorkforce Management Core |
| 3 | /SAPAPO/LRPASGLC | Table of Dispatching Details for Assignment | 10 | PARENT_UID | GUID of Parent Node | nvarchar | 22 | 0 | | |
| 4 | /SAPAPO/LRPASSAR | Table of Dispatching Details for Assignment | 11 | PARENT_UID | GUID of Parent Node | nvarchar | 22 | 0 | | |
| 5 | /SAPAPO/LRPASSGN | Obsolete: Table of Dispatching Details for Assignment | 10 | PARENT_UID | GUID of Parent Node | nvarchar | 22 | 0 | | |
| 6 | /SAPAPO/LRPASSIG | Table of Dispatching Details for Assignment | 10 | PARENT_UID | GUID of Parent Node | nvarchar | 22 | 0 | | |
| 7 | /SAPAPO/LRPDEMH | LRP Requirements | 12 | PARENT_UID | GUID of Parent Node | nvarchar | 22 | 0 | | |
| 8 | /SAPAPO/TSTASGLC | Table of Dispatching Details for Assignment | 10 | PARENT_UID | GUID of Parent Node | nvarchar | 22 | 0 | | |
| 9 | /SAPAPO/TSTASSIG | Table of Dispatching Details for Assignment | 10 | PARENT_UID | GUID of Parent Node | nvarchar | 22 | 0 | | |
