| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | TNPEPP | IS-H: PEPP Billing Parameters for Psychiatry/Psychosomatics | 5 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| TOPBasic Data |
| 2 | NLSU | IS-H: Totals File for Service Statistics | 8 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| TOPClinical System |
| 3 | N1ABWMSG | IS-H*MED: Assignment of service/check/message | 3 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| 4 | N1DWSWL_SUGSURG | i.s.h.med DWS: Active Surgery Proposal Criteria | 6 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| 5 | N1DWSWL_SUGSURG1 | i.s.h.med DWS: Inactive Surgery Proposal Criteria | 6 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| 6 | N1KGTPL | IS-H*MED: Service quota of the performer for the requester | 3 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| 7 | N1LAPP | services without case or movement reference | 8 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| 8 | N1LSTGSPLIT | IS-H*MED: Surgical service split | 3 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| 9 | N1NURSHIFT | IS-H*MED: Nurse shift times | 3 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| 10 | N1OEA | IS-H*MED: Involved org.units dependent on task | 3 | ERBOE | Performing/Documenting Organizational Unit | nvarchar | 8 | 0 | | |
| 11 | N1PREFETCHSPOOL | IS-H*MED: RAD Prefetching Tasks | 6 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| 12 | N1PRLEM | IS-H*MED: PATREG: Leistungen | 10 | ERBOE | IS-H: Hizmeti gerçeklestiren organizasyon brm.taniticisi | nvarchar | 8 | 0 | | |
| 13 | N1ROLZUO | IS-H*MED: Function assignment IS-H -> IS-H*MED | 3 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| 14 | N1STAAL | IS-H*MED: Statuses for cost breakdown | 3 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| 15 | N1URL | IS-H*MED: Addresses of files for browser | 6 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| 16 | NLEM | IS-H*MED: Medical Service | 30 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| 17 | TN1ROUTING | IS-H*MED: Routing Rules | 6 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| 18 | TN2ERFABT | Cardiological Departments with Separate Number Ranges | 2 | ERBOE | Cardiology: Department Which Performs Service | nvarchar | 6 | 0 | | |
| TOPDocuments |
| 19 | N1IM_STUDY | Meta Data of Image Study | 11 | ERBOE | Organizational Unit Which Performs the Service | nvarchar | 8 | 0 | | |
| TOPPatient Accounting |
| 20 | NGLT | IS-H: Intermediate table for service statistics | 18 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| 21 | NLCO | IS-HCO: Transfer information | 13 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| 22 | NLEV | IS-H: Preliminary entered services | 33 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| 23 | NMATP | IS-H: Material planned for case | 14 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| 24 | NMATV | IS-H: Material Entered for Case | 15 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| 25 | NSL2 | IS-H: Online error records of service statistics | 18 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| 26 | NSLF | IS-H: Error records of service statistics | 18 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| 27 | TNVSL | IS-H: Rules for Determining Multiplication Factors | 10 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| TOPPatient Management |
| 28 | NLEI | IS-H: Services Performed | 12 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| 29 | NWPLACE_001 | IS-H / IS-H*MED: Work Environment (Specialization) | 7 | ERBOE | Performing OU in Work Environment | nvarchar | 8 | 0 | | |
| TOPRadiology |
| 30 | N1PREFSPOOL | IS-H*MED: RAD Prefetching Tasks | 9 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| TOPSAP Healthcare - Industry-Specific Components for Hospitals |
| 31 | /ISHFR/TNGAPH | IS-H FR: Supplements (Header Data) | 8 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| 32 | /ISHFR/TNGAPP | IS-H FR: Supplements (Item Data) | 8 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| 33 | NAH01 | IS-H AT: Umschlüsselung Sachkontonummer auf Kreditor | 4 | ERBOE | IS-H: ID der Organisationeinheit, die die Leistung erbringt | nvarchar | 8 | 0 | | |
| 34 | NCH42 | IS-H CH: Service Rules Service Maximum Values | 10 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| 35 | NCH43 | IS-H CH: Leistungsregeln Zuschlagsleistungen | 7 | ERBOE | IS-H: ID unità organizzativa che eroga la prestazione | nvarchar | 8 | 0 | | |
| 36 | NCH43A | IS-H CH: Rollenumschlüsselung für Arztzuordnungen | 7 | ERBOE | IS-H: ID unità organizzativa che eroga la prestazione | nvarchar | 8 | 0 | | |
| 37 | NKLP | IS-H: Individual outpatient srv / ins.providers (AT) | 8 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| 38 | NWATAGBA | IS-H AT: Ambulanzgebühren - Ergebnisse / zu verteilen | 9 | ERBOE | IS-H: ID der Organisationeinheit, die die Leistung erbringt | nvarchar | 8 | 0 | | |
| 39 | NWATALSE | IS-H AT: Amb. Leistungsstatistik - Ergebnisse | 6 | ERBOE | IS-H: ID der Organisationeinheit, die die Leistung erbringt | nvarchar | 8 | 0 | | |
| 40 | NWCHLCOEA | IS-HCO: Überleitungsinformationen | 14 | ERBOE | IS-H: ID unità organizzativa che eroga la prestazione | nvarchar | 8 | 0 | | |
| 41 | NWCHLS_RNLSR | IS-H CH: ALIS-Fehlerhandlung - Leistungen (RNLSR) | 33 | ERBOE | IS-H: ID unità organizzativa che eroga la prestazione | nvarchar | 8 | 0 | | |
| 42 | TN1OEPR | IS-H*MED: Physician-OU Relatshp for Expanding Med.Basic Srvs | 2 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| 43 | TNA40Z | IS-H AT: Zeiten für Zuschlagsleistungen | 6 | ERBOE | IS-H: ID der Organisationeinheit, die die Leistung erbringt | nvarchar | 8 | 0 | | |
| 44 | TNAUMLEI | IS-H AT: Umschlüsselung Leistung | 9 | ERBOE | IS-H: ID der Organisationeinheit, die die Leistung erbringt | nvarchar | 8 | 0 | | |
| 45 | TNCH51 | IS-H CH: Billing Agreement Items | 10 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| 46 | TNCH52 | IS-h CH: Determination of Billing Agreements | 13 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| 47 | TNCH60 | IS-H CH: Times for Surcharge Services | 6 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| 48 | TNEO_BILLTYP_DET | IS-H: External Orders - Billing Type Determination | 4 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| 49 | TNEO_CHARFAC_DET | IS-H: Charge Factor Value Determination for External Orders | 8 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| 50 | TNEO_FEEDIST_DET | IS-H: External Orders - Determine Fee Breakdown Code | 10 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| 51 | TNWAT_LEIKOM_HDR | IS-H AT: Leistungskombinationen umschlüsseln - Header | 7 | ERBOE | IS-H: ID der Organisationeinheit, die die Leistung erbringt | nvarchar | 8 | 0 | | |
| 52 | TNWCH103 | Fees: Determination of Breakdown Code | 12 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| 53 | TNWCH80 | IS-H CH: Charge Factor Value Determination | 7 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| 54 | TNWCH82 | IS-H CH: Punktwertermittlung für TARMED-Leistungen | 7 | ERBOE | IS-H: ID unità organizzativa che eroga la prestazione | nvarchar | 8 | 0 | | |
| 55 | TNWCH83 | Ermittlung der Baserate | 9 | ERBOE | IS-H: ID der Organisationeinheit, die die Leistung erbringt | nvarchar | 8 | 0 | | |
| 56 | TNWCHCO | IS-H: Aufträge bestimmen für Überleitung ins CO | 7 | ERBOE | IS-H: ID unità organizzativa che eroga la prestazione | nvarchar | 8 | 0 | | |
| 57 | TNWCHEA10 | IS-H CH: Abrechnungsartenermittlung für Externe Aufträge | 4 | ERBOE | IS-H: ID unità organizzativa che eroga la prestazione | nvarchar | 8 | 0 | | |
| 58 | TNWCHEA11 | IS-H CH: Punktwertermittlung für Externe Aufträge | 7 | ERBOE | IS-H: ID unità organizzativa che eroga la prestazione | nvarchar | 8 | 0 | | |
| 59 | TNWCHEA12 | Determine Fee Breakdown Code for Transfer of Ext. Order | 10 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| 60 | TNWCHFEEPHYS | Service Rule Fee Physician for Fee-Based Services | 9 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | | |
| 61 | TNWCHTMABRMAT | IS-H CH: TARMED - Leistungsregel Abrechenbarkeit Materialien | 9 | ERBOE | IS-H: ID unità organizzativa che eroga la prestazione | nvarchar | 8 | 0 | | |
| 62 | TNWCH_AL_EXTRA | IS-H CH: ANALYSE - Leistungsregeln Zuschlagsleistungen | 8 | ERBOE | IS-H : ID de l'unité org. réalisant la prestation | nvarchar | 8 | 0 | | |
| 63 | TNWCH_DRG_ACC | Swiss-DRG - Bewertungsrelation für Erlösabgrenzung | 4 | ERBOE | IS-H: ID der Organisationeinheit, die die Leistung erbringt | nvarchar | 8 | 0 | | |
