| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPClinical System |
| 1 | N1CCYGEN | CORD: Cycle Generation Information | 3 | GENCYID | Generic Cycle Key | nvarchar | 10 | 0 | | |
| 2 | N1CYDEF | ISHMED: Cycle Definition | 3 | GENCYID | Generic Cycle Key | nvarchar | 10 | 0 | | |
| 3 | N1GENCY | IS-H*MED: Generic Cycle Use | 2 | GENCYID | Generic Cycle Key | nvarchar | 10 | 0 | | |
| 4 | N1GENCY_01 | IS-H*MED: Cycle - Nursing Service Assignment | 2 | GENCYID | Generic Cycle Key | nvarchar | 10 | 0 | | |
| 5 | N1GENCY_02 | IS-H*MED: Cycle - Medical Service Assignment | 2 | GENCYID | Generic Cycle Key | nvarchar | 10 | 0 | | |
| 6 | N1GENCY_03 | IS-H*MED: Cycle - Drug Order Assignment | 2 | GENCYID | Generic Cycle Key | nvarchar | 10 | 0 | | |
| 7 | N1GENCY_05 | Assignment of Cycles for Planned Measurement | 2 | GENCYID | Generic Cycle Key | nvarchar | 10 | 0 | | |
| 8 | N1GENCY_06 | CORD: Assignment of Cycles to Clinical Order Items | 3 | GENCYID | Generic Cycle Key | nvarchar | 10 | 0 | | |
| 9 | N1SRV | Services: Service Data | 22 | GENCYID | Generic Cycle Key | nvarchar | 10 | 0 | | |
| 10 | N2CLIM_SDLVS | Vital Signs: Measurement Plan for Patient (Cycles) | 13 | GENCYID | Generic Cycle Key | nvarchar | 10 | 0 | | |
| 11 | NLEM | IS-H*MED: Medical Service | 51 | GENCYID | Generic Cycle Key | nvarchar | 10 | 0 | | |
| TOPNursing |
| 12 | N1GENCY_04 | Nursing Plan: Cycle to Nursing Plan Entry Assignment | 2 | GENCYID | Generic Cycle Key | nvarchar | 10 | 0 | | |
| 13 | N1NRSPE | Nursing Plan: Entry | 14 | GENCYID | Generic Cycle Key | nvarchar | 10 | 0 | | |
