| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TNNL_ACT_EMPTY | Tabelle Leeren DBC | 5 | TAGRU | IS-H: Typ einer Leistung | nvarchar | 9 | 0 | | |
TOPBasic Data |
2 | NPTW | IS-H: Rules for Charge Factor Value Determ. | 6 | TAGRU | IS-H: Service Category | nvarchar | 9 | 0 | | |
TOPClinical System |
3 | N1DCS_DAUERTHE | IS-H*MED: DCS: Quick Entry Long-Term Therapies | 9 | TAGRU | IS-H: Service Category | nvarchar | 9 | 0 | | |
TOPPatient Accounting |
4 | NTFI | IS-H: Service Catalog Determination Rules | 6 | TAGRU | IS-H: Service Category | nvarchar | 9 | 0 | | |
5 | NTPK | IS-H: Header Data of Service Item | 9 | TAGRU | IS-H: Service Category | nvarchar | 9 | 0 | | |
6 | NVBRP | IS-H: Billing document item data | 75 | TAGRU | IS-H: Service Category | nvarchar | 9 | 0 | | |
7 | TN20 | IS-H: Service Categories | 3 | TAGRU | IS-H: Service Category | nvarchar | 9 | 0 | | |
8 | TN20T | IS-H: Text Table for Service Categories | 4 | TAGRU | IS-H: Service Category | nvarchar | 9 | 0 | | |
9 | TNVSL | IS-H: Rules for Determining Multiplication Factors | 5 | TAGRU | IS-H: Service Category | nvarchar | 9 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
10 | /ISHFR/SERVF04 | IS-H FR: LPP Pricing | 3 | TAGRU | IS-H: Service Category | nvarchar | 9 | 0 | | |
11 | /ISHFR/TNGAPH | IS-H FR: Supplements (Header Data) | 3 | TAGRU | IS-H: Service Category | nvarchar | 9 | 0 | | |
12 | /ISHFR/TNGAPP | IS-H FR: Supplements (Item Data) | 3 | TAGRU | IS-H: Service Category | nvarchar | 9 | 0 | | |
13 | NCH43 | IS-H CH: Leistungsregeln Zuschlagsleistungen | 10 | TAGRU | IS-H: categoria di una prestazione | nvarchar | 9 | 0 | | |
14 | NCH43A | IS-H CH: Rollenumschlüsselung für Arztzuordnungen | 10 | TAGRU | IS-H: categoria di una prestazione | nvarchar | 9 | 0 | | |
15 | NCH44 | IS-H CH: Leistungsregeln OPS | 9 | TAGRU | IS-H: categoria di una prestazione | nvarchar | 9 | 0 | | |
16 | NCH44A | IS-H CH: Rollenumschlüsselung für Arztzuordnungen | 9 | TAGRU | IS-H: categoria di una prestazione | nvarchar | 9 | 0 | | |
17 | NKLP | IS-H: Individual outpatient srv / ins.providers (AT) | 7 | TAGRU | IS-H: Service Category | nvarchar | 9 | 0 | | |
18 | NLDBC_TAGRU | IS-H NL: DBC-spezifische Leistungstypen | 3 | TAGRU | IS-H: Type verrichting | nvarchar | 9 | 0 | | |
19 | NNPW | IS-H NL: Services with charge factors | 5 | TAGRU | IS-H: Service Category | nvarchar | 9 | 0 | | |
20 | NNTF | IS-H NL: Service Catalog Determination | 8 | TAGRU | IS-H: Service Category | nvarchar | 9 | 0 | | |
21 | TN47 | IS-H: Seasonal Fee for Service | 3 | TAGRU | IS-H: Service Category | nvarchar | 9 | 0 | | |
22 | TN48 | IS-H: Fee on Admission and Discharge Day | 5 | TAGRU | IS-H: Service Category | nvarchar | 9 | 0 | | |
23 | TNCH51 | IS-H CH: Billing Agreement Items | 16 | TAGRU | IS-H: Service Category | nvarchar | 9 | 0 | | |
24 | TNCH61 | IS-H CH: Percentage Services | 12 | TAGRU | IS-H: Service Category | nvarchar | 9 | 0 | | |
25 | TNCH62 | IS-H CH: Percentage Reduction | 7 | TAGRU | IS-H: Service Category | nvarchar | 9 | 0 | | |
26 | TNEO_BILLTYP_DET | IS-H: External Orders - Billing Type Determination | 7 | TAGRU | IS-H: Service Category | nvarchar | 9 | 0 | | |
27 | TNEO_CHARFAC_DET | IS-H: Charge Factor Value Determination for External Orders | 12 | TAGRU | IS-H: Service Category | nvarchar | 9 | 0 | | |
28 | TNNA1 | IS-H NL: Billing parties per service (group) | 6 | TAGRU | IS-H: Service Category | nvarchar | 9 | 0 | | |
29 | TNNC1 | IS-H NL: Insurance verification procedures | 6 | TAGRU | IS-H: Service Category | nvarchar | 9 | 0 | | |
30 | TNNC3 | IS-H NL: Kostenübernahme von leistungen | 7 | TAGRU | IS-H: Type verrichting | nvarchar | 9 | 0 | | |
31 | TNSYP | IS-H: System Parameter | 5 | TAGRU | Outpatient Admission Service Category | nvarchar | 9 | 0 | | |
32 | TNWAT_EDI_SERVMP | IS-H AT: EDIVKA Ermittlg Arzt-/Haus-Leist. über Tarifgruppen | 3 | TAGRU | IS-H: Typ einer Leistung | nvarchar | 9 | 0 | | |
33 | TNWCH80 | IS-H CH: Charge Factor Value Determination | 14 | TAGRU | IS-H: Service Category | nvarchar | 9 | 0 | | |
34 | TNWCH81 | IS-H CH: Billing Type Determination | 11 | TAGRU | IS-H: Service Category | nvarchar | 9 | 0 | | |
35 | TNWCH82 | IS-H CH: Punktwertermittlung für TARMED-Leistungen | 12 | TAGRU | IS-H: categoria di una prestazione | nvarchar | 9 | 0 | | |
36 | TNWCH83 | Ermittlung der Baserate | 13 | TAGRU | IS-H: Typ einer Leistung | nvarchar | 9 | 0 | | |
37 | TNWCH84 | Ermittlung des Kostenteilers | 4 | TAGRU | IS-H: Typ einer Leistung | nvarchar | 9 | 0 | | |
38 | TNWCHEA10 | IS-H CH: Abrechnungsartenermittlung für Externe Aufträge | 7 | TAGRU | IS-H: categoria di una prestazione | nvarchar | 9 | 0 | | |
39 | TNWCHEA11 | IS-H CH: Punktwertermittlung für Externe Aufträge | 11 | TAGRU | IS-H: categoria di una prestazione | nvarchar | 9 | 0 | | |
40 | TNWCHFEEPHYS | Service Rule Fee Physician for Fee-Based Services | 10 | TAGRU | IS-H: Service Category | nvarchar | 9 | 0 | | |
41 | TNWCHTMABRMAT | IS-H CH: TARMED - Leistungsregel Abrechenbarkeit Materialien | 12 | TAGRU | IS-H: categoria di una prestazione | nvarchar | 9 | 0 | | |
42 | TNWCH_AL_EXTRA | IS-H CH: ANALYSE - Leistungsregeln Zuschlagsleistungen | 10 | TAGRU | IS-H : catégorie d'une prestation | nvarchar | 9 | 0 | | |