| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPClinical System |
1 | N1CYDEF | ISHMED: Cycle Definition | 2 | CYDEFID | Unique ID of Cycle Definition | nvarchar | 10 | 0 | | |
2 | N1CYDEF_EXT | i.s.h.med: Single Time Definition for Cycles | 3 | CYDEFID | Unique ID of Cycle Definition | nvarchar | 10 | 0 | | |
3 | N1MEEVENT | IS-H*MED: Medication, Medication Event | 59 | CYDEFID | Unique ID of Cycle Definition | nvarchar | 10 | 0 | | |
4 | N1SRV | Services: Service Data | 25 | CYDEFID | Unique ID of Cycle Definition | nvarchar | 10 | 0 | | |
5 | N2CLIM_PLDVS | Vital Signs: Definite Planned Measurement (with Time) | 11 | CYDEFID | Unique ID of Cycle Definition | nvarchar | 10 | 0 | | |
6 | NLEM | IS-H*MED: Medical Service | 50 | CYDEFID | Unique ID of Cycle Definition | nvarchar | 10 | 0 | | |