| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | NTPKDP | IS-H DE: Additional Settings for a PEPP Service | 4 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 2 | NTPKDPREL | IS-H DE: Remuneration Levels of a PEPP Service | 4 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 3 | TN24L_DT | Proposed Services per Treatment Category/Period | 5 | TALST | IS-H: Service to Be Proposed for a Treatment Category | nvarchar | 10 | 0 | | |
| 4 | TNNL_ACT_EMPTY | Tabelle Leeren DBC | 4 | TALST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
| 5 | TNWAT_FREQU | Leistungsgenerierung für ambulante Besuche | 12 | TALST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
| 6 | TNWCHSDRG03 | Swiss-DRG - Leistungsregeln DRG-Zusatzentgelte Medikamente | 13 | TALST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
| 7 | TNWCH_ADDCHARGE | Leistungsregel: Altersprüfung bei Zusatzentgelten | 7 | TALST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
| 8 | TNWCH_LST_CONSVA | Default-Verabreichungsart je Medikament | 4 | TALST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
| TOPBasic Data |
| 9 | NBAU | IS-H: Building Units | 30 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 10 | NORG | IS-H: Organizational Units | 61 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 11 | NPTW | IS-H: Rules for Charge Factor Value Determ. | 5 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 12 | NTPT | IS-H: Service Catalog Item Description | 5 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 13 | NTPZ | IS-H: Service Catalog Line Items: Assignments/Groupings | 5 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 14 | NTSP | IS-H: Columns in Service Catalog | 4 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 15 | TN40B | IS-H: Scheduling Types | 11 | TALST | IS-H: Service Group for Service-Based Appointment Search | nvarchar | 10 | 0 | | |
| 16 | TNC301AS | IS-H: EDI Assign Indicators to Service | 5 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 17 | TNS25 | IS-H: Factors for Determining Std Billing Days | 4 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 18 | TNT1 | IS-H: Specialty-Related Service Catalogs | 6 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| TOPClinical System |
| 19 | N1BCP2NTPK | Basic Cat.: Catalog Item to Service Assignment | 8 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 20 | N1CORDTS | IS-H: Service Hit List Clin.Ord.Type - Order Filler Assgmt | 6 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 21 | N1ELEI | ISHMED: External service range | 4 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 22 | N1IPLE | IS-H*MED:Assignmt of Nursing Anchor Service to the ntpk | 5 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 23 | N1KGTPL | IS-H*MED: Service quota of the performer for the requester | 6 | TALST | Service Code for Quota Check | nvarchar | 10 | 0 | | |
| 24 | N1KPL | IS-H*MED: VBUND: Leistungsangebot Kommunikationspartner | 6 | TALST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
| 25 | N1LAUF | ISHMED: Service Task | 4 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 26 | N1LSTGSPLIT | IS-H*MED: Surgical service split | 5 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 27 | N1PLBA | IS-H*MED: Assignment basic hosp.cat.entry to hour.nurs.plans | 4 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 28 | N1PLZY | IS-H*MED: Cycles with NTPZ reference ->see documentation !!! | 5 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 29 | N1TMSTPDURDEF | i.s.h.med: Duration Definition of Time Stamps | 7 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 30 | N1TPGL | IS-H*MED: Service quotas for daily program | 6 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 31 | N1TPLAB | IS-H*MED: Required Laboratory Parameters | 4 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 32 | N1TPLOK | IS-H*MED: Radiology - Excluded Localization | 4 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 33 | N1TPM | IS-H*MED: Medical Enhancements for the Service Catalog Items | 4 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 34 | N1TPP | IS-H*MED: Resource Profile for Services | 4 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 35 | N1TPTA | IS-H*MED: Excluded Transport Type | 4 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 36 | N1TPZ | IS-H*MED: Nursing attr for NTPZ | 5 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 37 | N1VMK | IS-H*MED: Table for preselections in the service hit list | 7 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 38 | N1XLEI | ISHMED: Service Range | 4 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 39 | N1YLEI | IS-H*MED: Requestable services | 7 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 40 | N1ZPLST | IS-H*MED: Assignment of standards to STD - nursing plans | 4 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 41 | N2ANART | IS-H*MED: Anesthesia types | 4 | TALST | Key for Anesthesia Service | nvarchar | 10 | 0 | | |
| 42 | N2DL | IS-H*MED: Table of doc. category to service assignments | 4 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 43 | N2DL1 | IS-H*MED: Table of doc. category to service assignments | 4 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 44 | N2MATREF | IS-H*MED: Reference table for material external data (N2FM) | 8 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 45 | NASCO | IS-H: LKF Point valuation synchronous | 4 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 46 | TN2KUM02 | IS-H*MED: Asgmt Services->Groups for cumulative findings | 6 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| TOPPatient Accounting |
| 47 | NLAU | IS-H: Service Exclusions | 5 | TALST | IS-H: Service Group for Service Rules | nvarchar | 10 | 0 | | |
| 48 | NLGR | IS-H: Dynamic Service Groups | 5 | TALST | IS-H: Service Group for Service Rules | nvarchar | 10 | 0 | | |
| 49 | NLKO | IS-H: Service Inclusions | 5 | TALST | IS-H: Service Group for Service Rules | nvarchar | 10 | 0 | | |
| 50 | NTFI | IS-H: Service Catalog Determination Rules | 5 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 51 | NTPK | IS-H: Header Data of Service Item | 4 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 52 | NTPKD | IS-H: Add. Fields for Service Master Germany | 4 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 53 | NTPP | IS-H: Planned Values Per Service and Org. Unit | 4 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 54 | NTPV | IS-H: Assign Service to Base Planning Object | 4 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 55 | TN24L | IS-H: Proposed Services By Treatment Category | 5 | TALST | IS-H: Service to Be Proposed for a Treatment Category | nvarchar | 10 | 0 | | |
| 56 | TNLONGTERMSVC | IS-H: Maintain Long-Term Accommodation Services | 4 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 57 | TNMATLEI | Define Default Material Service | 4 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| TOPPatient Management |
| 58 | NPRTL | IS-H*MED: Preregistration Type - Service Hit List | 6 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 59 | TNLOC_SERV | Service to Be Generated for Each Level of Care | 8 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| TOPSAP Healthcare - Industry-Specific Components for Hospitals |
| 60 | /ISHFR/MATSERV | IS-H FR: Assign Service -> Material | 7 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 61 | /ISHFR/NTPKFR | IS-H FR: Additional Fields for Service Master France | 4 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 62 | /ISHFR/NTPKFR_AK | IS-H FR: Asgt Serv. Master France => Activity + Phase | 4 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 63 | /ISHFR/NTPKFR_AS | IS-H FR: Asgt Serv. Master France => Ass. Serv. + Code | 4 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 64 | /ISHFR/NTPKFR_GH | IS-H FR: Additional Fields for Service Master France (DRG) | 4 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 65 | /ISHFR/NTPKFR_LA | IS-H FR: Asgt Service Master France => Service Exclusion | 4 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 66 | /ISHFR/NTPKFR_MC | IS-H FR: Asgt Service Master France => Modif. Codes | 4 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 67 | /ISHFR/TNWFR_CCP | IS-H FR: Coordinated Care Path | 6 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 68 | /ISHFR/TNWFR_F19 | Surcharge for Care Path (CCP) | 9 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 69 | /ISHFR/TNWFR_F20 | PSC Patient Contribution Inc. Assignment Type | 7 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 70 | /ISHFR/TNWFR_F21 | Absence Control | 15 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 71 | NAHGRS | IS-H AT: Höchstgrenzentabelle für Scoring | 4 | TALST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
| 72 | NBQS_ZUSCHL | BQS: Assignment of Module to Surcharge and Discount | 9 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 73 | NCH10 | IS-H CH: Service Breakdown | 4 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 74 | NCH10T | IS-H CH: Service Breakdown Text | 5 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 75 | NLDBC_014 | ISH NL: DBC Ablauf steurung | 8 | TALST | IS-H: Voor te stellen verrichting uit een behandelcategorie | nvarchar | 10 | 0 | | |
| 76 | NLVERZF_005 | Konversion SAP nach neue fall | 3 | TALST | Verrichting binnen een verrichtingencatalogus | nvarchar | 10 | 0 | | |
| 77 | NNPW | IS-H NL: Services with charge factors | 4 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 78 | NNTF | IS-H NL: Service Catalog Determination | 9 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 79 | NTDC | IS-H: Service Default Coverage | 4 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 80 | NTPKAT | IS-H AT: Zusatzfelder Leistungsstamm Österreich | 4 | TALST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
| 81 | NTPKCH | IS-H CH: Zusatzfelder Leistungsstamm Schweiz (TARMED) | 4 | TALST | Prestazione in un catalogo delle prestazioni | nvarchar | 10 | 0 | | |
| 82 | NTPKCH_AGE | IS-H CH: Zuordng Leistungsstamm Schweiz (TARMED) => Alter | 4 | TALST | Prestazione in un catalogo delle prestazioni | nvarchar | 10 | 0 | | |
| 83 | NTPKCH_FACH | IS-H CH: Zuord Lei.Stamm Schweiz (Analyse)=>Fachbereich | 4 | TALST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
| 84 | NTPKCH_KOMB | IS-H CH: Zuo Leiststamm Schweiz (TARMED) => komb. Lei | 4 | TALST | Prestazione in un catalogo delle prestazioni | nvarchar | 10 | 0 | | |
| 85 | NTPKCH_KUMU | IS-H CH: Zuo Leiststamm Schweiz (TARMED) => ausschl. Lei | 4 | TALST | Prestazione in un catalogo delle prestazioni | nvarchar | 10 | 0 | | |
| 86 | NTPKCH_MAX | IS-H CH: Zuordng Leistamm Schweiz (TARMED) => Maximumregel | 4 | TALST | Prestazione in un catalogo delle prestazioni | nvarchar | 10 | 0 | | |
| 87 | NTPKCH_QLDI | IS-H CH: Zuo Leistungsstamm Schweiz (TARMED) => Qualit Dig | 4 | TALST | Prestazione in un catalogo delle prestazioni | nvarchar | 10 | 0 | | |
| 88 | NTPKCH_QTDI | IS-H CH: Zuo Leistungsstamm Schweiz (TARMED) => Quant Dig | 4 | TALST | Prestazione in un catalogo delle prestazioni | nvarchar | 10 | 0 | | |
| 89 | NTPKCH_SPRT | IS-H CH: Zuo Leistungsstamm Schweiz (TARMED) => Sparte | 4 | TALST | Prestazione in un catalogo delle prestazioni | nvarchar | 10 | 0 | | |
| 90 | NTPKIT | CV Italy: Enhancement to Service Master | 4 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 91 | NWCH10 | IS-H CH: Zuordnung Leistung - KÜ-Qualifier | 4 | TALST | Prestazione in un catalogo delle prestazioni | nvarchar | 10 | 0 | | |
| 92 | NWCHLGZUO | IS-H CH: Zuordnung Leistungen zu Leistungsgruppen | 8 | TALST | Prestazione in un catalogo delle prestazioni | nvarchar | 10 | 0 | | |
| 93 | TN22C | IS-H: Zuordnung Leistung zu Befreiungsgrund (amb. Zuz.) | 5 | TALST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
| 94 | TN41 | IS-H: Services for Discharge Days (Singapore Only) | 7 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 95 | TN48 | IS-H: Fee on Admission and Discharge Day | 7 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 96 | TNA30A | IS-H AT: Selektionsschema für Krankenanst.-Statistiken | 10 | TALST | Verrichting binnen een verrichtingencatalogus | nvarchar | 10 | 0 | | |
| 97 | TNA30B | IS-H: Selection procedure - bed classes and services | 9 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 98 | TNAFD | IS-H: Outpatient Admission Fee Determination | 13 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 99 | TNCH51 | IS-H CH: Billing Agreement Items | 6 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 100 | TNEO_BILLTYP_DET | IS-H: External Orders - Billing Type Determination | 6 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 101 | TNEO_CHARFAC_DET | IS-H: Charge Factor Value Determination for External Orders | 11 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 102 | TNNE4 | NL: Scheine und Leistungen | 10 | TALST | Prestación dentro de un catálogo de prestaciones | nvarchar | 10 | 0 | | |
| 103 | TNNLTP | IS-H NL: An zu wenden Regeln auf Leistungen | 4 | TALST | Verrichting binnen een verrichtingencatalogus | nvarchar | 10 | 0 | | |
| 104 | TNNR1 | IS-H NL: Service exclusions (calculation rule) | 6 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 105 | TNNR2 | IS-H NL: Service inclusions (calculation rule) | 6 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 106 | TNNR3 | IS-H NL: Time-related rules | 6 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 107 | TNNR4 | IS-H NL: Time-related rules | 6 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 108 | TNNR5 | IS-H NL: Service Rules At Admission | 7 | TALST | IS-H: Service to Be Proposed for a Treatment Category | nvarchar | 10 | 0 | | |
| 109 | TNNRG | IS-H NL: Zuweisung leistung(sgruppe) zu werte-regel | 3 | TALST | Verrichting binnen een verrichtingencatalogus | nvarchar | 10 | 0 | | |
| 110 | TNWAT_ABB_KBL | IS-H AT: Ambulanzbeitrag KB-Leistungen | 5 | TALST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
| 111 | TNWAT_SCO_HGRS | IS-H AT: Höchstgrenzen für Scoring | 4 | TALST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
| 112 | TNWCH107 | Billing Type Determination for Fee Billing | 8 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 113 | TNWCH108 | Charge Factor Value Determination for Fee Billing | 7 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 114 | TNWCH80 | IS-H CH: Charge Factor Value Determination | 13 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 115 | TNWCH81 | IS-H CH: Billing Type Determination | 10 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | | |
| 116 | TNWCH82 | IS-H CH: Punktwertermittlung für TARMED-Leistungen | 11 | TALST | Prestazione in un catalogo delle prestazioni | nvarchar | 10 | 0 | | |
| 117 | TNWCH83 | Ermittlung der Baserate | 14 | TALST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
| 118 | TNWCH84 | Ermittlung des Kostenteilers | 6 | TALST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
| 119 | TNWCHEA10 | IS-H CH: Abrechnungsartenermittlung für Externe Aufträge | 6 | TALST | Prestazione in un catalogo delle prestazioni | nvarchar | 10 | 0 | | |
| 120 | TNWCHEA11 | IS-H CH: Punktwertermittlung für Externe Aufträge | 10 | TALST | Prestazione in un catalogo delle prestazioni | nvarchar | 10 | 0 | | |
| 121 | TNWCHEA13 | IS-H CH: Bearbeitungsgebühr pflegen für Externe Aufträge | 9 | TALST | Prestazione in un catalogo delle prestazioni | nvarchar | 10 | 0 | | |
| 122 | TNWCHSDRG02 | Swiss-DRG - Leistungsregeln DRG-Zusatzentgelte generieren | 9 | TALST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
| 123 | TNWCHTMABRMAT | IS-H CH: TARMED - Leistungsregel Abrechenbarkeit Materialien | 11 | TALST | Prestazione in un catalogo delle prestazioni | nvarchar | 10 | 0 | | |
| 124 | TNWCHTMDIVIS | IS-H CH: TARMED - Leistungsregel Spartenzuschlag | 8 | TALST | Prestazione in un catalogo delle prestazioni | nvarchar | 10 | 0 | | |
| 125 | TNWCHXMLROLE | IS-H CH: ALIS-XML-Rollenzuordnung | 6 | TALST | Prestazione in un catalogo delle prestazioni | nvarchar | 10 | 0 | | |
| 126 | TNWCH_AL_EXTRA | IS-H CH: ANALYSE - Leistungsregeln Zuschlagsleistungen | 14 | TALST | Prestation dans un catalogue de prestations | nvarchar | 10 | 0 | | |
| 127 | TNWCH_AL_KUMU | IS-H CH: ANALYSE - Leistungsregeln Kumulation | 8 | TALST | Prestation dans un catalogue de prestations | nvarchar | 10 | 0 | | |
| 128 | TNWCH_AL_NLHO | IS-H CH: ANALYSE: Leistungsregeln Höchstwerte | 8 | TALST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
