| 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 | | |