| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | NNL_ZH308_V9_R02 | ZH308 V09 Record02 Soll Daten | 12 | GSCHL | | nvarchar | 1 | 0 | | |
| 2 | PDPBSZVANM_R | SPI Confirmation: Registration (Record Type 30) | 5 | GSCHL | Gender, ZVE-PBS | nvarchar | 1 | 0 | | |
| 3 | TNNL_CBV_GENDER | CBV Geschlecht | 6 | GSCHL | IS-H: Geschlechtskennzeichen - intern | nvarchar | 1 | 0 | | |
| 4 | TNNL_ICD10GENDER | ICD10 Geschlecht | 6 | GSCHL | IS-H: Geschlechtskennzeichen - intern | nvarchar | 1 | 0 | | |
| TOPBasic Data |
| 5 | NGPA | IS-H: Business Partners | 16 | GSCHL | IS-H: Sex Indicator - Internal | nvarchar | 1 | 0 | | |
| 6 | NKDI | IS-H: Diagnosis Coding Catalogs | 12 | GSCHL | IS-H: Sex Indicator - Internal | nvarchar | 1 | 0 | | |
| 7 | TN11P | IS-H: Planning Characteristics of Building Unit | 6 | GSCHL | Sex Indicator for Building Unit | nvarchar | 1 | 0 | | |
| 8 | TN17G | IS-H: Sex Indicator | 3 | GSCHL | IS-H: Sex Indicator - Internal | nvarchar | 1 | 0 | | |
| 9 | TN17T | IS-H: Texts for Sex Indicators | 3 | GSCHL | IS-H: Sex Indicator - Internal | nvarchar | 1 | 0 | | |
| TOPClinical System |
| 10 | N1PRPAT | IS-H*MED: PATREG: Patientenstammdatentabelle | 3 | GSCHL | IS-H: Cinsiyet göstergesi - dahili | nvarchar | 1 | 0 | | |
| 11 | N1PRTMPPAT | IS-H*MED: PATREG: Temporäre Patientenstammdatentabelle | 4 | GSCHL | IS-H: Cinsiyet göstergesi - dahili | nvarchar | 1 | 0 | | |
| 12 | N1PRTMPPATLOC | IS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal | 4 | GSCHL | IS-H: Cinsiyet göstergesi - dahili | nvarchar | 1 | 0 | | |
| 13 | N2DSDEVICE_ARCH | ISHMED: Archive Transfer Data from Interfaces | 7 | GSCHL | IS-H: Sex Indicator - Internal | nvarchar | 1 | 0 | | |
| 14 | N2DSDEVICE_DATA | ISHMED: Transfer Data from Interface | 7 | GSCHL | IS-H: Sex Indicator - Internal | nvarchar | 1 | 0 | | |
| TOPPatient Accounting |
| 15 | NTPK | IS-H: Header Data of Service Item | 47 | GSCHL | IS-H: Sex Indicator - Internal | nvarchar | 1 | 0 | | |
| TOPPatient Management |
| 16 | NGEB | IS-H: Birth Data of Newborns | 8 | GSCHL | IS-H: Sex Indicator - Internal | nvarchar | 1 | 0 | | |
| 17 | NPAP | IS-H: Provisional Patient Master Data | 10 | GSCHL | IS-H: Sex Indicator - Internal | nvarchar | 1 | 0 | | |
| 18 | NPAT | IS-H: Patient Master Data (General) | 4 | GSCHL | IS-H: Sex Indicator - Internal | nvarchar | 1 | 0 | | |
| 19 | NTMN | IS-H: Patient-Specific Appointments (Header Table for NAPP) | 25 | GSCHL | IS-H: Sex Indicator - Internal | nvarchar | 1 | 0 | | |
| 20 | NWAN | IS-H: Bad Debt Parties | 3 | GSCHL | IS-H: Sex Indicator - Internal | nvarchar | 1 | 0 | | |
| TOPPublic Sector |
| 21 | PDPBSZVANM | Reg. for Compulsory Insurance (Record Type 30), ZVE-PBS | 13 | GSCHL | Gender, ZVE-PBS | nvarchar | 1 | 0 | | |
| TOPSAP Healthcare - Industry-Specific Components for Hospitals |
| 22 | NAKR1 | IS-H AT: LKF - Grunddaten | 7 | GSCHL | IS-H: Geschlechtskennzeichen - intern | nvarchar | 1 | 0 | | |
| 23 | NCH61 | IS-HCO CH: Sammelaufträge | 7 | GSCHL | IS-H: codice sesso - interno | nvarchar | 1 | 0 | | |
| 24 | NLWARTE_003 | NL - Warteliste extra felder fur | 4 | GSCHL | ISH_NL: Teken geslacht | nvarchar | 1 | 0 | | |
| 25 | NNLZP | IS-H NL: LAZR Bewegingsgegevens LAZR-interface | 18 | GSCHL | IS-H NL: LAZR-geslachtscode | nvarchar | 1 | 0 | | |
| 26 | NNL_DDS_QH | Deklaration Query kopf | 9 | GSCHL | IS-H NL: LAZR Geslachtscode | nvarchar | 1 | 0 | | |
| 27 | NNL_DDS_QHL | Deklaration Query kopf log | 10 | GSCHL | IS-H NL: LAZR Geslachtscode | nvarchar | 1 | 0 | | |
| 28 | NPNTCAS | IS-H: Patient Master Data at Case Level (CV IT) | 7 | GSCHL | IS-H: Sex Indicator - Internal | nvarchar | 1 | 0 | | |
| 29 | NPSPAT | IS-H: Pseudonymized Patient Master Data (General) | 3 | GSCHL | IS-H: Sex Indicator - Internal | nvarchar | 1 | 0 | | |
| 30 | TNABETTEN | IS-H AT: Bettenanzahl pro Station | 4 | GSCHL | IS-H: Geschlechtskennzeichen - intern | nvarchar | 1 | 0 | | |
| 31 | TNLGGZ_PAT_GRP | Geisteskrankheit patient gruppe | 7 | GSCHL | IS-H: Geschlechtskennzeichen - intern | nvarchar | 1 | 0 | | |
| 32 | TNWATBETTEN | IS-H AT: Bettenanzahl pro Abteilung und Station | 5 | GSCHL | IS-H: Geschlechtskennzeichen - intern | nvarchar | 1 | 0 | | |
