| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TNLBSN_WID | Ausweis type für SBV-z web-service | 3 | PASSTY | IS-H: Typ des Ausweisdokuments | nvarchar | 2 | 0 | | |
TOPClinical System |
2 | N1PRPAT | IS-H*MED: PATREG: Patientenstammdatentabelle | 82 | PASSTY | IS-H: Kimlik belgesinin tipi | nvarchar | 2 | 0 | | |
3 | N1PRTMPPAT | IS-H*MED: PATREG: Temporäre Patientenstammdatentabelle | 83 | PASSTY | IS-H: Kimlik belgesinin tipi | nvarchar | 2 | 0 | | |
4 | N1PRTMPPATLOC | IS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal | 83 | PASSTY | IS-H: Kimlik belgesinin tipi | nvarchar | 2 | 0 | | |
TOPCommunication |
5 | TN17D_SE_MAP | IS-H: Identity document types | 2 | PASSTY | Type of Identification Document | nvarchar | 2 | 0 | | |
TOPPatient Management |
6 | NPAP | IS-H: Provisional Patient Master Data | 17 | PASSTY | Type of Identification Document | nvarchar | 2 | 0 | | |
7 | NPAT | IS-H: Patient Master Data (General) | 95 | PASSTY | Type of Identification Document | nvarchar | 2 | 0 | | |
8 | TN17D | IS-H: Identity Document Types | 2 | PASSTY | Type of Identification Document | nvarchar | 2 | 0 | | |
9 | TN17W | IS-H: Identity document types | 3 | PASSTY | Type of Identification Document | nvarchar | 2 | 0 | | |