| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OPT/VT_USER | User Details | 3 | AGENTID | Agent ID | nvarchar | 35 | 0 | | |
2 | /OPT/VT_USR | Reporting table: Users | 3 | AGENTID | Agent ID | nvarchar | 35 | 0 | | |
3 | /OPT/VT_USR_ORG | Reporting table: Assignment User - OrgUnit | 3 | AGENTID | Agent ID | nvarchar | 35 | 0 | | |
TOPClinical System |
4 | N1AGENTFOA | i.s.h.med: Assignment of Agent to Drugs | 4 | AGENTID | Medication: Agent ID | nvarchar | 32 | 0 | | |
5 | N1BDCCAGENTA | Medication: Assignment of Agents to External Drugs | 3 | AGENTID | Medication: Agent ID | nvarchar | 32 | 0 | | |
6 | N1FOAGENTA | i.s.h.med: Agents - Drug (O B S O L E T E) | 3 | AGENTID | Medication: Agent ID | nvarchar | 32 | 0 | | |
7 | N1ODRUG | IS-H*MED: Medication, Drugs of Order | 27 | AGENTID | Medication: Agent ID | nvarchar | 32 | 0 | | |
8 | N1TPODRUG | IS-H*MED: Medication, Drugs of Templates | 25 | AGENTID | Medication: Agent ID | nvarchar | 32 | 0 | | |
9 | N2AD_ALLERGY | Allergy Documentation - Allergies | 11 | AGENTID | Medication: Agent ID | nvarchar | 32 | 0 | | |
10 | NAGENT | IS-H*MED: Agents of Drugs | 2 | AGENTID | Medication: Agent ID | nvarchar | 32 | 0 | | |
11 | NAGENTEXT | i.s.h.med: Medication; External References for Agents | 3 | AGENTID | Medication: Agent ID | nvarchar | 32 | 0 | | |
12 | NAGENTT | IS-H*MED: Agents of Drugs - Texts | 2 | AGENTID | Medication: Agent ID | nvarchar | 32 | 0 | | |
TOPProcess Monitoring Infrastructure |
13 | SSPIAGD | SPI: Agent Definition | 2 | AGENTID | SPI Global: Agent ID | nvarchar | 22 | 0 | | |
14 | SSPIAGDFLD | Local SPI: Agent Runtime; Field Names | 2 | AGENTID | SPI Global: Agent ID | nvarchar | 22 | 0 | | |
15 | SSPIAGD_T | SPI: Agent Definition Short Texts | 3 | AGENTID | SPI Global: Agent ID | nvarchar | 22 | 0 | | |
16 | SSPIAGFLD | SPI: Descriptions for Agent Payload Attributes | 2 | AGENTID | SPI Global: Agent ID | nvarchar | 22 | 0 | | |
17 | SSPIAGFLD_T | SPI: Payload Attribute Short Texts for Agent | 3 | AGENTID | SPI Global: Agent ID | nvarchar | 22 | 0 | | |
18 | SSPIAGTRC | E2E Trace Configuration | 2 | AGENTID | SPI Global: Agent ID | nvarchar | 22 | 0 | | |
19 | SSPICSTRHEAD | SPI: Central Store Tracking Records Header | 4 | AGENTID | SPI Global: Agent ID | nvarchar | 22 | 0 | | |
20 | SSPIPIFD | SPI: Process Interface | 3 | AGENTID | SPI Global: Agent ID | nvarchar | 22 | 0 | | |
21 | SSPIPIFFLD | SPI: Field Names of Process Interface | 3 | AGENTID | SPI Global: Agent ID | nvarchar | 22 | 0 | | |
22 | SSPISGCON | SPI: Signature Condition Records | 3 | AGENTID | SPI Global: Agent ID | nvarchar | 22 | 0 | | |
23 | SSPISGD | SPI: Signature Definition | 3 | AGENTID | SPI Global: Agent ID | nvarchar | 22 | 0 | | |
24 | SSPISGFLD | SPI: Signature Payload Attributes | 3 | AGENTID | SPI Global: Agent ID | nvarchar | 22 | 0 | | |
25 | SSPISGFLD_T | SPI: Short Texts for Supported Signature Fields | 4 | AGENTID | SPI Global: Agent ID | nvarchar | 22 | 0 | | |
26 | SSPITRCCND | E2E Trace Conditions | 2 | AGENTID | SPI Global: Agent ID | nvarchar | 22 | 0 | | |