| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | NNK2 | IS-H NL: Zusatz Datei für Kostenträgers - BP Model | 2 | KOSTR | Kostenträgerschlüssel | nvarchar | 10 | 0 | | |
2 | NNL_OHW_DDS_SUB | ISH NL: Kopplung DDS und Subtrajekt | 11 | KOSTR | IS-H: Kostenträger | nvarchar | 10 | 0 | | |
3 | NNL_OHW_VEK_DELV | ISH NL: OHW VEKTIS Anlieferung | 4 | KOSTR | IS-H: Kostenträger | nvarchar | 10 | 0 | | |
4 | NNL_OHW_ZP_DECL | ISH NL: OHW Kopplung Sorgeprodukt und Deklarationskode | 6 | KOSTR | IS-H: Kostenträger | nvarchar | 10 | 0 | | |
5 | TNNL_KOST_GRP | Kostenträger Gruppe | 3 | KOSTR | IS-H: Kostenträger | nvarchar | 10 | 0 | | |
6 | TNWCH_EDI_RETCD | EDI Antwortcodes | 5 | KOSTR | IS-H: Kostenträger | nvarchar | 10 | 0 | | |
7 | TNWCH_EDI_RETCDT | EDI Antwortcodes - Texte | 6 | KOSTR | IS-H: Kostenträger | nvarchar | 10 | 0 | | |
TOPAustria |
8 | PA0131 | HR Master Record: Infotype 0131 (Garnishment/Cession A) | 53 | KOSTR | Correspondence street and house number | nvarchar | 30 | 0 | | |
TOPBasic Data |
9 | NC301 | IS-HCM: Order Table Data Transmission for EDI | 6 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
10 | NC301KTR | IS-H EDI: Data Cllct. Point - Ins. Provider Asgmt | 2 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
11 | NC301S | IS-HCM: EDI Status Management | 6 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
12 | NC301T | IS-H EDI Temporary Storage for Old EDI Msg. Status Records | 6 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
13 | NGPA | IS-H: Business Partners | 42 | KOSTR | IS-H: Text Designating the INSURANCE PROVIDER Function | nvarchar | 1 | 0 | | |
14 | NKIP | IS-H: Pre-Approved Insurance Verification Information - Item | 5 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
15 | NKTR | IS-H: Business Partners/Insurance Providers | 2 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
16 | NPTW | IS-H: Rules for Charge Factor Value Determ. | 7 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
17 | TNC301EX | IS-H EDI: Msg Exclusions for IP - Obsolete => TNC301MX | 4 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
18 | TNC301MX | IS-H EDI: Message Exclusions for Insurance Providers | 4 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
19 | TNCDF4 | IS-H: DRG Coding and Grouping System Payer Determination | 4 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
TOPClinical System |
20 | NC321 | IS-H: Table for data exchange of §321 | 6 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
21 | TNCMSCO | IS-H: Scoring - Conversion of the HINR | 2 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
TOPGermany |
22 | PA0111 | HR Master Record: Infotype 0111 (Garnishment/Cession - D) | 60 | KOSTR | Correspondence street and house number | nvarchar | 30 | 0 | | |
TOPPatient Accounting |
23 | NCIR | IS-H: Insurance Relationships of a Case | 5 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
24 | NEHC_INS | IS-H: Health Insurance Card (Insurance Data) | 72 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
25 | NPIR | IS-H: Insurance Relationship Proposal Pool | 4 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
26 | NTFI | IS-H: Service Catalog Determination Rules | 7 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
27 | NVBRK | IS-H: Billing document header data | 61 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
28 | TN18B | IS-H: Propose Contract Scheme by Ins. Prov. Type | 4 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
29 | TN21A | IS-H: Billing Type Determination | 4 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
30 | TN22K | IS-H: Copayment Amount per Ins. Provider/Ins. Provider Type | 3 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
31 | TNKIV | IS-H: Insurance Provider Attributes - Integrated Care | 3 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
32 | TNVSL | IS-H: Rules for Determining Multiplication Factors | 8 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
TOPPatient Management |
33 | NAMB | IS-H: Request for Medical Grounds | 5 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
34 | NKSK | IS-H: Insurance verification/certificate - Header data | 8 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
35 | NKSP | IS-H: Insurance verification/certificate - item data | 6 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
36 | NMBG | IS-H: Medical grounds | 5 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
37 | NVVF | IS-H: Case-Related Insurance Relationships | 5 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
38 | NVVP | IS-H: Patient-related insurance relationship | 4 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
TOPPayroll General Parts |
39 | PA0611 | HR Master Record: Infotype 0611 | 51 | KOSTR | Lawyer's Street | nvarchar | 30 | 0 | | |
TOPSAP Ambulatory Care Management |
40 | NREDOMA | IS-H: Table Renewable Documents - Header Data | 35 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
41 | TNKTR_KV | IS-H: Settings for Federal PPA Insurance Provider Master | 2 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
42 | /ISHFR/TN21A | IS-H FR: Determine Billing Type | 5 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
43 | /ISHFR/TNWFRPD | IS-H FR: Payment Distribution - Limit by Contract Scheme | 4 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
44 | /ISHFR/TNWFR_B2 | IS-H FR: Control Settings for B2 Dispatch | 6 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
45 | /ISHFR/TNWFR_F00 | IS-H FR: Fixed Patient Contribution | 5 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
46 | ISH_HCF_HEADER | Header for Index Table | 9 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
47 | ISH_IDX_HEADER | Header for Index Table | 10 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
48 | NAKLF | IS-H AT: LKF - Kostenträger zu Landesfond | 4 | KOSTR | IS-H: Kostenträger | nvarchar | 10 | 0 | | |
49 | NAKR1 | IS-H AT: LKF - Grunddaten | 31 | KOSTR | IS-H: Kostenträger | nvarchar | 10 | 0 | | |
50 | NAPHF | IS-H AT: LKF - Punktehistorie zum Fall | 8 | KOSTR | IS-H: Kostenträger | nvarchar | 10 | 0 | | |
51 | NC302KTR | IS-H EDI Annahmestellen Kostenträger Zuordnung für §302 | 2 | KOSTR | IS-H: Kostenträger | nvarchar | 10 | 0 | | |
52 | NKLP | IS-H: Individual outpatient srv / ins.providers (AT) | 4 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
53 | NKSA | IS-H: Insurance verification declaration (Austria) | 5 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
54 | NLREK | Sammelrechnung kopf | 5 | KOSTR | IS-H: Kostendrager | nvarchar | 10 | 0 | | |
55 | NNAU | IS-H NL: Confirmation of coverage info from ins. provider | 6 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
56 | NNK1 | IS-H NL: Additional file for insurance providers | 2 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
57 | NNPER | IS-H NL: Assign Physician -> Ins. Provider | 4 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
58 | NNTF | IS-H NL: Service Catalog Determination | 10 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
59 | NNVR | IS-H: Subsequent billing (AT) | 4 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
60 | NTDC | IS-H: Service Default Coverage | 5 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
61 | NWATLH1 | IS-H AT: Leistungshöchstwerte für Leistungsgruppen | 7 | KOSTR | IS-H: Kostenträger | nvarchar | 10 | 0 | | |
62 | NWATLHO | IS-H AT: Leistungshöchstwerte | 6 | KOSTR | IS-H: Kostenträger | nvarchar | 10 | 0 | | |
63 | NWAT_EDI_KOM | IS-H AT: EDI Kommentar (K12) | 4 | KOSTR | IS-H: Kostenträger | nvarchar | 10 | 0 | | |
64 | NWAT_GIN_STATIR | IS-H AT: Versicherungsstatus des Patienten | 8 | KOSTR | IS-H: Kostenträger | nvarchar | 10 | 0 | | |
65 | NWAT_GIN_STATIR2 | IS-H AT: Versicherungsstatus Familienmitglieder | 14 | KOSTR | IS-H: Kostenträger | nvarchar | 10 | 0 | | |
66 | NWCH70 | IS-H CH: Insurance Verification | 4 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
67 | NWCHKTRGRZUO | IS-H CH: Zuordnung Kostenträger zu Kostenträgergruppen | 5 | KOSTR | IS-H: Kostenträger | nvarchar | 10 | 0 | | |
68 | NWCHPAKLZ | IS-H CH: Patientenabrechnung - LstVerteilung Nachträge | 4 | KOSTR | IS-H: ente pagatore | nvarchar | 10 | 0 | | |
69 | NWCH_BOA_ARCH | Protokoll-Archiv für die Massendeckungsabfrage | 15 | KOSTR | IS-H: Kostenträger | nvarchar | 10 | 0 | | |
70 | NWCH_BOA_PROT | Protokoll für die Massendeckungsabfrage | 15 | KOSTR | IS-H: Kostenträger | nvarchar | 10 | 0 | | |
71 | NWCH_NKTR_PROF | Ausschluss Pro-forma-Rechnungen an Patienten | 3 | KOSTR | IS-H: Kostenträger | nvarchar | 10 | 0 | | |
72 | TN49 | IS-H: Preset Insurance Relationship | 4 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
73 | TNA21A | IS-H: Determining the flat rate type (VERA) | 4 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
74 | TNA30V | IS-H: Insurance statistics (AT) | 4 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
75 | TNAUMLEI | IS-H AT: Umschlüsselung Leistung | 11 | KOSTR | IS-H: Kostenträger | nvarchar | 10 | 0 | | |
76 | TNLDBC_TRDBC3 | IS-H NL: Dummy DBC per Kostenträger | 3 | KOSTR | IS-H: Kostendrager | nvarchar | 10 | 0 | | |
77 | TNLMR4 | IS-H NL: LMR Verzekeringscodes | 3 | KOSTR | IS-H: Kostendrager | nvarchar | 10 | 0 | | |
78 | TNNC3 | IS-H NL: Kostenübernahme von leistungen | 12 | KOSTR | IS-H: Kostendrager | nvarchar | 10 | 0 | | |
79 | TNNL2 | IS-H NL: LMR insurance file | 3 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
80 | TNWATKBDIA | IS-H AT: Leistungsgenerierung - Ausschluß über Diagnosen | 5 | KOSTR | IS-H: Kostenträger | nvarchar | 10 | 0 | | |
81 | TNWATKBGEN | IS-H AT: Leistungsgenerierung | 5 | KOSTR | IS-H: Kostenträger | nvarchar | 10 | 0 | | |
82 | TNWAT_DEK_KOST | IS-H AT: Dekaden (Kostenträgerdaten) | 4 | KOSTR | IS-H: Kostenträger | nvarchar | 10 | 0 | | |
83 | TNWAT_EDI_VERTR | IS-H AT: EDIVKA Vereinbarungen Krankenhaus und Versicherung | 3 | KOSTR | IS-H: Kostenträger | nvarchar | 10 | 0 | | |
84 | TNWAT_LEIKOM_HDR | IS-H AT: Leistungskombinationen umschlüsseln - Header | 9 | KOSTR | IS-H: Kostenträger | nvarchar | 10 | 0 | | |
85 | TNWCH74 | IS-H CH: Vertragstypen Zuordnungstabelle | 6 | KOSTR | IS-H: ente pagatore | nvarchar | 10 | 0 | | |
86 | TNWCH76 | IS-H CH: Zuordnung Kostenübernahme - Rückweisbegründung Code | 4 | KOSTR | IS-H: ente pagatore | nvarchar | 10 | 0 | | |
87 | TNWCH81 | IS-H CH: Billing Type Determination | 5 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
88 | TNWCH83 | Ermittlung der Baserate | 12 | KOSTR | IS-H: Kostenträger | nvarchar | 10 | 0 | | |
89 | TNWCH91 | Items for Fee Relevance | 13 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
90 | TNWCHSDRG01 | Swiss-DRG - Leistungsregeln DRG-Leistung generieren | 6 | KOSTR | IS-H: Kostenträger | nvarchar | 10 | 0 | | |
91 | TNWCH_EDIKTR | IS-H CH: Control Data for EDI Procedure for Ins. Provider | 4 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | | |
92 | TNWCH_EDIKTR_EO | Steuerung EDI-Verfahren für externe Aufträge | 4 | KOSTR | IS-H: Kostenträger | nvarchar | 10 | 0 | | |