| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPClinical System |
1 | N1CONNDATA | Connectivity: Handler Data for Object | 3 | VKGID | IS-H: CORD/PREG: ID of an Order Item (Preregistration) | nvarchar | 8 | 0 | | |
2 | N1CONNDEMO | Connectivity: Demo Table for Local Handler | 3 | VKGID | IS-H: CORD/PREG: ID of an Order Item (Preregistration) | nvarchar | 8 | 0 | | |
3 | N1CONNSTATE | Connectivity: Status of Action | 3 | VKGID | IS-H: CORD/PREG: ID of an Order Item (Preregistration) | nvarchar | 8 | 0 | | |
4 | N1GENCY_06 | CORD: Assignment of Cycles to Clinical Order Items | 4 | VKGID | IS-H: CORD/PREG: ID of an Order Item (Preregistration) | nvarchar | 8 | 0 | | |
5 | N1POPAKTE | IS-H*Med: Patient Organizer - Redundant Structure | 33 | VKGID | IS-H: CORD/PREG: ID of an Order Item (Preregistration) | nvarchar | 8 | 0 | | |
6 | N1PRLEM | IS-H*MED: PATREG: Leistungen | 66 | VKGID | IS-H: KlnSprs/ÖnKyt: Siparis kalemi taniticisi(ön kayit) | nvarchar | 8 | 0 | | |
7 | N1PRVKG | IS-H*MED: PATREG: Vormerkungen | 3 | VKGID | IS-H: KlnSprs/ÖnKyt: Siparis kalemi taniticisi(ön kayit) | nvarchar | 8 | 0 | | |
8 | N2RAD_EXAM | IS-H*MED RAD: Radiological Service / Examination | 14 | VKGID | IS-H: CORD/PREG: ID of an Order Item (Preregistration) | nvarchar | 8 | 0 | | |
9 | NLEM | IS-H*MED: Medical Service | 41 | VKGID | IS-H: CORD/PREG: ID of an Order Item (Preregistration) | nvarchar | 8 | 0 | | |
TOPPatient Management |
10 | N1COMPA | IS-H: Order Item to Module Information Assignment | 5 | VKGID | IS-H: CORD/PREG: ID of an Order Item (Preregistration) | nvarchar | 8 | 0 | | |
11 | N1VKG | IS-H: Item of Clinical Order (Preregistration) | 2 | VKGID | IS-H: CORD/PREG: ID of an Order Item (Preregistration) | nvarchar | 8 | 0 | | |
12 | NDIP | IS-H: Diagnoses for Preregistered Patient | 3 | VKGID | IS-H: CORD/PREG: ID of an Order Item (Preregistration) | nvarchar | 8 | 0 | | |
13 | NIPP | IS-H: Provisional Insurance Relationship of Preregistration | 3 | VKGID | IS-H: CORD/PREG: ID of an Order Item (Preregistration) | nvarchar | 8 | 0 | | |
14 | NPCP | IS-H: Procedures for Preregistered Patient | 3 | VKGID | IS-H: CORD/PREG: ID of an Order Item (Preregistration) | nvarchar | 8 | 0 | | |
15 | NTMN | IS-H: Patient-Specific Appointments (Header Table for NAPP) | 74 | VKGID | IS-H: CORD/PREG: ID of an Order Item (Preregistration) | nvarchar | 8 | 0 | | |
16 | NWLM | IS-H: Absences From Waiting List | 4 | VKGID | IS-H: CORD/PREG: ID of an Order Item (Preregistration) | nvarchar | 8 | 0 | | |