| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPClinical System |
1 | N1PLZY | IS-H*MED: Cycles with NTPZ reference ->see documentation !!! | 9 | N1ZNR | Cycle Key | nvarchar | 10 | 0 | | |
2 | N1STPLZY | IS-H*MED Nursing: Asgmt. of cycles to nursing plan profile | 8 | N1ZNR | Cycle Key | nvarchar | 10 | 0 | | |
3 | N1STZT | IS-H*MED: Standard cycle text | 3 | N1ZNR | Cycle Key | nvarchar | 10 | 0 | | |
4 | N1STZY | i.s.h.med: Cycles | 3 | N1ZNR | Cycle Key | nvarchar | 10 | 0 | | |
5 | N1ZYINF | IS-H*MED: Cycle information | 3 | N1ZNR | Cycle Key | nvarchar | 10 | 0 | | |
6 | N1ZYINF_EXT | i.s.h.med: Single Time Definition for Cycles (Master Data) | 2 | N1ZNR | Cycle Key | nvarchar | 10 | 0 | | |
7 | N2PSLZ | IS-H*MED: Nursing standard - service catalog assignment | 15 | N1ZNR | Cycle Key | nvarchar | 10 | 0 | | |
TOPNursing |
8 | N1SNPE | Standard Nursing Plan: Entry | 10 | N1ZNR | Cycle Key | nvarchar | 10 | 0 | | |
9 | N1SNPP | OBSOLETE - Std. Nrs. Plan: Std. Nrs. Plan Item | 7 | N1ZNR | Cycle Key | nvarchar | 10 | 0 | | |