| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TNWAT_FREQU | Leistungsgenerierung für ambulante Besuche | 11 | TARID | IS-H: Identifikation eines Leistungskataloges | nvarchar | 2 | 0 | | |
2 | TNWCH_ADDCHARGE | Leistungsregel: Altersprüfung bei Zusatzentgelten | 6 | TARID | IS-H: Identifikation eines Leistungskataloges | nvarchar | 2 | 0 | | |
TOPBasic Data |
3 | NKIP | IS-H: Pre-Approved Insurance Verification Information - Item | 10 | TARID | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | | |
4 | TNS23 | IS-H: Assignment of Services to Lines in Statistics | 6 | TARID | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | | |
TOPClinical System |
5 | N2LKGZ | IS-H*MED: Service catalog - classif. area assignment | 4 | TARID | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | | |
6 | TN2K1 | IS-H*MED: Nursing standard catalog categories | 8 | TARID | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | | |
TOPPatient Accounting |
7 | NLGR | IS-H: Dynamic Service Groups | 4 | TARID | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | | |
TOPPatient Management |
8 | NKSP | IS-H: Insurance verification/certificate - item data | 4 | TARID | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | | |
TOPSAP Ambulatory Care Management |
9 | TNACM | Parameter Maintenance - SAP Ambulatory Care Management | 4 | TARID | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
10 | /ISHFR/TNWFR_F00 | IS-H FR: Fixed Patient Contribution | 10 | TARID | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | | |
11 | /ISHFR/TNWFR_F10 | IS-H FR: Per Diem Fee | 15 | TARID | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | | |
12 | NCH41 | IS-H CH: Service Rules Service Breakdown | 9 | TARID | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | | |
13 | NCH43 | IS-H CH: Leistungsregeln Zuschlagsleistungen | 8 | TARID | IS-H: identificatore di un catalogo di prestazioni | nvarchar | 2 | 0 | | |
14 | NCH43A | IS-H CH: Rollenumschlüsselung für Arztzuordnungen | 8 | TARID | IS-H: identificatore di un catalogo di prestazioni | nvarchar | 2 | 0 | | |
15 | NCH44 | IS-H CH: Leistungsregeln OPS | 7 | TARID | IS-H: identificatore di un catalogo di prestazioni | nvarchar | 2 | 0 | | |
16 | NCH44A | IS-H CH: Rollenumschlüsselung für Arztzuordnungen | 7 | TARID | IS-H: identificatore di un catalogo di prestazioni | nvarchar | 2 | 0 | | |
17 | NKLP | IS-H: Individual outpatient srv / ins.providers (AT) | 5 | TARID | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | | |
18 | NWCHLGZUO | IS-H CH: Zuordnung Leistungen zu Leistungsgruppen | 7 | TARID | IS-H: identificatore di un catalogo di prestazioni | nvarchar | 2 | 0 | | |
19 | TNA21R | IS-H: Flat rate rules (AT) | 6 | TARID | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | | |
20 | TNA21S | IS-H: Scaled flate rates (VERA) | 7 | TARID | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | | |
21 | TNEO_FEEDIST_DET | IS-H: External Orders - Determine Fee Breakdown Code | 12 | TARID | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | | |
22 | TNNA1 | IS-H NL: Billing parties per service (group) | 4 | TARID | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | | |
23 | TNNC1 | IS-H NL: Insurance verification procedures | 4 | TARID | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | | |
24 | TNNP1 | IS-H NL: Patient day services | 3 | TARID | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | | |
25 | TNNR6 | IS-H NL: Define in- and exclusion rules | 3 | TARID | IS-H NL: Basiscatalogus om verrichtingen in te voeren | nvarchar | 2 | 0 | | |
26 | TNWAT_EDI_VERTR | IS-H AT: EDIVKA Vereinbarungen Krankenhaus und Versicherung | 7 | TARID | IS-H AT: EDIVKA Leistungskatalog für Leistungsumschlüsselung | nvarchar | 2 | 0 | | |
27 | TNWCH103 | Fees: Determination of Breakdown Code | 14 | TARID | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | | |
28 | TNWCH21 | IS-H CH: Radiologie-Gruppendefinition | 6 | TARID | IS-H: identificatore di un catalogo di prestazioni | nvarchar | 2 | 0 | | |
29 | TNWCHEA12 | Determine Fee Breakdown Code for Transfer of Ext. Order | 12 | TARID | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | | |
30 | TNWCHEA13 | IS-H CH: Bearbeitungsgebühr pflegen für Externe Aufträge | 8 | TARID | IS-H: identificatore di un catalogo di prestazioni | nvarchar | 2 | 0 | | |
31 | TNWCHFEEPHYS | Service Rule Fee Physician for Fee-Based Services | 11 | TARID | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | | |
32 | TNWCHTMADDSRV | IS-H CH: TARMED - (+)%-Zuschlagsleistungen (Bastarde) | 3 | TARID | IS-H: identificatore di un catalogo di prestazioni | nvarchar | 2 | 0 | | |
33 | TNWCH_AL_EXTRA | IS-H CH: ANALYSE - Leistungsregeln Zuschlagsleistungen | 13 | TARID | IS-H : identification d'un catalogue de prestations | nvarchar | 2 | 0 | | |
34 | TNWCH_AL_KUMU | IS-H CH: ANALYSE - Leistungsregeln Kumulation | 7 | TARID | IS-H : identification d'un catalogue de prestations | nvarchar | 2 | 0 | | |
35 | TNWCH_AL_NLHO | IS-H CH: ANALYSE: Leistungsregeln Höchstwerte | 7 | TARID | IS-H: Identifikation eines Leistungskataloges | nvarchar | 2 | 0 | | |