| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /1RA/0SD010MI | Items for Class SD01 - Raw Data | 64 | GEBIE | Area | nvarchar | 4 | 0 | | |
2 | T2538 | Table of Characteristic Values | 2 | GEBIE | Area | nvarchar | 4 | 0 | | |
3 | T25D8 | Text table for characteristic values | 3 | GEBIE | Area | nvarchar | 4 | 0 | | |
TOPBasic Data |
4 | TNREL | IS-H: Insurance Provider Assignments | 9 | GEBIE | IS-H: Geographical Area | nvarchar | 9 | 0 | | |
TOPClinical System |
5 | N1PRPAT | IS-H*MED: PATREG: Patientenstammdatentabelle | 44 | GEBIE | IS-H: Cografi alan | nvarchar | 9 | 0 | | |
6 | N1PRTMPPAT | IS-H*MED: PATREG: Temporäre Patientenstammdatentabelle | 45 | GEBIE | IS-H: Cografi alan | nvarchar | 9 | 0 | | |
7 | N1PRTMPPATLOC | IS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal | 45 | GEBIE | IS-H: Cografi alan | nvarchar | 9 | 0 | | |
TOPData Collection |
8 | CF001 | Profitability Analysis | 8 | GEBIE | Area | nvarchar | 8 | 0 | | |
TOPPatient Management |
9 | NPAT | IS-H: Patient Master Data (General) | 34 | GEBIE | IS-H: Geographical Area | nvarchar | 9 | 0 | | |
10 | NPEZ | IS-H: Assignment of postal code to geographical area | 3 | GEBIE | IS-H: Geographical Area | nvarchar | 9 | 0 | | |
TOPProfitability Analysis |
11 | CE1S001 | Sample operating concern | 54 | GEBIE | Area | nvarchar | 4 | 0 | | |
12 | CE2S001 | Sample operating concern | 42 | GEBIE | Area | nvarchar | 4 | 0 | | |
13 | CE4S001 | Sample operating concern | 29 | GEBIE | Area | nvarchar | 4 | 0 | | |
14 | CE4S001_ACCT | Sample operating con | 37 | GEBIE | Area | nvarchar | 4 | 0 | | |
15 | CE4S001_FLAG | Sample Operating Concern 1 | 33 | GEBIE | Flag: Characteristic Assigned Manually or Using TKEZU | nvarchar | 1 | 0 | | |
16 | CE4S001_KENC | Sample operating con | 34 | GEBIE | Area | nvarchar | 4 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
17 | TNCH11 | IS-H CH: Canton Tariff-to-Geographical Area Assignment | 4 | GEBIE | IS-H: Geographical Area | nvarchar | 9 | 0 | | |