| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | TNSRAT | Service Rules - Maintain Assignment Type | 4 | ZOTYP | IS-H: Type of Service Assignment | nvarchar | 3 | 0 | | |
| TOPBasic Data |
| 2 | NTPZ | IS-H: Service Catalog Line Items: Assignments/Groupings | 3 | ZOTYP | IS-H: Type of Service Assignment | nvarchar | 3 | 0 | | |
| 3 | TNT0 | IS-H: Categories of Service Assignments | 3 | ZOTYP | IS-H: Type of Service Assignment | nvarchar | 3 | 0 | | |
| 4 | TNT0T | IS-H: Texts for Category Table of Service Assignments | 4 | ZOTYP | IS-H: Type of Service Assignment | nvarchar | 3 | 0 | | |
| TOPClinical System |
| 5 | N1APZ | IS-H*MED: Assignment between work station and time marker | 4 | ZOTYP | Assignment Type Work Station - Time Stamp | nvarchar | 3 | 0 | | |
| 6 | N1BEZ | IS-H*MED: Assignment of building units | 4 | ZOTYP | Assignment Type Building Unit | nvarchar | 3 | 0 | | |
| 7 | N1KGTPL | IS-H*MED: Service quota of the performer for the requester | 7 | ZOTYP | Assignment Type for Quota Planning | nvarchar | 1 | 0 | | |
| 8 | N1MEMEZ | IS-H*MED: Medication - Medication Assignment | 7 | ZOTYP | Assignment Type | nvarchar | 3 | 0 | | |
| 9 | N1MLZUO | IS-H*MED: Service-related material proposal | 12 | ZOTYP | Assignment Type | nvarchar | 3 | 0 | | |
| 10 | N1PLZY | IS-H*MED: Cycles with NTPZ reference ->see documentation !!! | 3 | ZOTYP | IS-H: Type of Service Assignment | nvarchar | 3 | 0 | | |
| 11 | N1PRLLZ | IS-H*MED: PATREG: Leistungszuordnung | 5 | ZOTYP | Hizmet tayin tipi | nvarchar | 1 | 0 | | |
| 12 | N1TPGO | IS-H*MED: Day program: Assign OU time segments | 4 | ZOTYP | Assignment Type for Daily Schedule to Org. Unit | nvarchar | 2 | 0 | | |
| 13 | N1TPZ | IS-H*MED: Nursing attr for NTPZ | 3 | ZOTYP | IS-H: Type of Service Assignment | nvarchar | 3 | 0 | | |
| 14 | N1VMK | IS-H*MED: Table for preselections in the service hit list | 5 | ZOTYP | IS-H: Type of Service Assignment | nvarchar | 3 | 0 | | |
| 15 | N1WVIEWZ | IS-H*MED: Structure for Views | 4 | ZOTYP | Assignment Type for Views | nvarchar | 3 | 0 | | |
| 16 | NLLZ | IS-H: Asgmt of Svce to Mat., to Pers. Costs, to Svce | 5 | ZOTYP | Service Assignment Type | nvarchar | 1 | 0 | | |
| TOPCommunication |
| 17 | TNT0_SE_MAP | IS-H: Categories of Service Assignments | 3 | ZOTYP | IS-H: Type of Service Assignment | nvarchar | 3 | 0 | | |
| TOPPatient Accounting |
| 18 | NLGR | IS-H: Dynamic Service Groups | 3 | ZOTYP | IS-H: Type of Service Assignment | nvarchar | 3 | 0 | | |
| 19 | NLICZ | IS-H: Table of Service-to-Surgical Procedures Code Asgmts | 9 | ZOTYP | Service Assignment Type | nvarchar | 1 | 0 | | |
| 20 | NTFI | IS-H: Service Catalog Determination Rules | 12 | ZOTYP | IS-H: Type of Service Assignment | nvarchar | 3 | 0 | | |
| 21 | TNDRG | IS-H: DRG Billing Parameters | 14 | ZOTYP | IS-H: Statistics-Relevant Asgmt Type for Service Remapping | nvarchar | 3 | 0 | | |
| 22 | TNS09 | IS-H: Re-Map Services for Service Statistics | 5 | ZOTYP | IS-H: Type of Service Assignment | nvarchar | 3 | 0 | | |
| TOPPatient Management |
| 23 | NLEI | IS-H: Services Performed | 84 | ZOTYP | IS-H: Type of Service Assignment | nvarchar | 3 | 0 | | |
| TOPSAP Ambulatory Care Management |
| 24 | TNACM | Parameter Maintenance - SAP Ambulatory Care Management | 7 | ZOTYP | Assignment Type for 1:N Remapping | nvarchar | 3 | 0 | | |
| TOPSAP Healthcare - Industry-Specific Components for Hospitals |
| 25 | /ISHFR/SERVF14 | EMI/ETI Margin Service | 8 | ZOTYP | IS-H: Type of Service Assignment | nvarchar | 3 | 0 | | |
| 26 | /ISHFR/TNWFR_F20 | PSC Patient Contribution Inc. Assignment Type | 5 | ZOTYP | Type of Assignment of Service Movement Data | nvarchar | 3 | 0 | | |
| 27 | NNTF | IS-H NL: Service Catalog Determination | 14 | ZOTYP | IS-H: Type of Service Assignment | nvarchar | 3 | 0 | | |
| 28 | NWCHLGZUO | IS-H CH: Zuordnung Leistungen zu Leistungsgruppen | 5 | ZOTYP | IS-H: tipo di attribuzione di prestazioni | nvarchar | 3 | 0 | | |
| 29 | NWCHLS_RNLRZ | IS-H CH: ALIS-Fehlerhandlung - Leistungszuordnungen (RNLRZ) | 14 | ZOTYP | Tipo attribuzione di una prestazione | nvarchar | 1 | 0 | | |
| 30 | NWCHLS_RNLSR | IS-H CH: ALIS-Fehlerhandlung - Leistungen (RNLSR) | 101 | ZOTYP | IS-H: tipo di attribuzione di prestazioni | nvarchar | 3 | 0 | | |
| 31 | TNSBASP | Parameters for Service-Based Appointment Search | 3 | ZOTYP | IS-H: Type of Service Assignment | nvarchar | 3 | 0 | | |
| 32 | TNWAT_EDI_VERTR | IS-H AT: EDIVKA Vereinbarungen Krankenhaus und Versicherung | 8 | ZOTYP | IS-H AT: EDIVKA - Zuordnungstyp für Leistungsumschlüsselung | nvarchar | 3 | 0 | | |
| 33 | TNWCHDRG | IS-H CH: DRG-Abrechnungsparameter | 13 | ZOTYP | IS-H: tipo di attribuzione di prestazioni | nvarchar | 3 | 0 | | |
