| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | N1CORDFAVP | CORD: Favorites - Item | 6 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | | |
2 | NNL_FYSIO | Tabelle Physiotherapie | 6 | LEIST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
3 | NNL_ZH308_V9_R04 | ZH308 V09 Record04 Soll Daten | 57 | LEIST | | nvarchar | 10 | 0 | | |
4 | T5D1D | Help View for SI Attribute Combinations | 5 | LEIST | Combination string | nvarchar | 20 | 0 | | |
5 | TNNLLLM | Limitative liste Ermächtigungen | 5 | LEIST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
TOPBasic Data |
6 | NLSU | IS-H: Totals File for Service Statistics | 9 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | | |
TOPClasses |
7 | KLAH | Class Header Data | 32 | LEIST | Characteristics table | nvarchar | 20 | 0 | | |
TOPClinical System |
8 | N1ABWMSG | IS-H*MED: Assignment of service/check/message | 6 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | | |
9 | N1BEZY | IS-H*MED: Cycles with NLEI reference | 5 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | | |
10 | N1CYSRVTPL | CORD: Cyclical Service Template | 3 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | | |
11 | N1DCS_DAUERTHE | IS-H*MED: DCS: Quick Entry Long-Term Therapies | 7 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | | |
12 | N1LAPP | services without case or movement reference | 5 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | | |
13 | N1PRDOC | IS-H*MED: PATREG: Dokumente | 39 | LEIST | Hizmet katalogu içindeki hizmet | nvarchar | 10 | 0 | | |
14 | N1PREFETCHSPOOL | IS-H*MED: RAD Prefetching Tasks | 11 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | | |
15 | N1PRLEM | IS-H*MED: PATREG: Leistungen | 7 | LEIST | Hizmet katalogu içindeki hizmet | nvarchar | 10 | 0 | | |
16 | N1ZSLST | IS-H*Med: Extra services | 6 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | | |
17 | N2DOCBEWLEI | IS-H*MED: Movement and Service Data for Archived Documents | 13 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | | |
18 | N2GL_BASE_REQ_S | IS-H*MED: Services of Request Base Item | 4 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | | |
19 | NDOCA | IS-H*MED: Document Management Data for Archived Documents | 18 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | | |
20 | NDOCSTORNO | IS-H*MED: Canceled Documents | 19 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | | |
TOPEnvironment |
21 | LKLAH | Class Header (Special Objects) | 32 | LEIST | Characteristics table | nvarchar | 20 | 0 | | |
TOPPatient Accounting |
22 | NGLT | IS-H: Intermediate table for service statistics | 12 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | | |
23 | NLEV | IS-H: Preliminary entered services | 5 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | | |
24 | NLH1 | IS-H: Service Maximum Values for Service Groups | 5 | LEIST | IS-H: Service Group for Service Rules | nvarchar | 10 | 0 | | |
25 | NLHO | IS-H: Service Maximum Values | 5 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | | |
26 | NLOP | IS-H:INACTIVE Assignment Table Service - SP Code - Diagnosis | 12 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | | |
27 | NSL2 | IS-H: Online error records of service statistics | 12 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | | |
28 | NSLF | IS-H: Error records of service statistics | 12 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | | |
29 | TN20K | Service-to-Class Assignment | 5 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | | |
30 | TNFPSE | IS-H: Rule Table for FRs Per Case and PSs | 11 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | | |
31 | TNVSL | IS-H: Rules for Determining Multiplication Factors | 6 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | | |
TOPPatient Management |
32 | NDOC | IS-H: Assignment of IS-H Objects to Documents in DMS | 18 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | | |
33 | NLEI | IS-H: Services Performed | 5 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | | |
TOPProduct Safety |
34 | TCGRULPOSMREST | EHS: Easy Expert Set of Rules, Characteristic Restrictions | 36 | LEIST | Characteristics table | nvarchar | 20 | 0 | | |
TOPPublic Sector |
35 | PA0484 | HR Master Record Infotype 0484 (Joint Taxation A) | 27 | LEIST | Benefit Type | nvarchar | 2 | 0 | | |
36 | T5APBS02 | Joint Taxation: Types of Cash Benefits | 2 | LEIST | Benefit Type | nvarchar | 2 | 0 | | |
37 | T5APBS02T | Joint Taxation: Types of Cash Benefits (Texts) | 3 | LEIST | Benefit Type | nvarchar | 2 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
38 | /ISHFR/SERVF04 | IS-H FR: LPP Pricing | 5 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | | |
39 | /ISHFR/SERVF14 | EMI/ETI Margin Service | 7 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | | |
40 | /ISHFR/TNWFR_F00 | IS-H FR: Fixed Patient Contribution | 11 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | | |
41 | /ISHFR/TNWFR_F10 | IS-H FR: Per Diem Fee | 16 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | | |
42 | NAKR2 | IS-H AT: LKF - Scoring Leistungen (MELs) | 5 | LEIST | IS-H AT: LKF - Leistungscode | nvarchar | 7 | 0 | | |
43 | NBQS_ICD | BQS: Assignment of FR/PS to ICD | 4 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | | |
44 | NBQS_OPS | BQS: Assignment of OPS to FR/PS and QA Module | 7 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | | |
45 | NCH42 | IS-H CH: Service Rules Service Maximum Values | 12 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | | |
46 | NLDIS_002 | ISH NL: DIS - Leistungen Spezielle Strecke | 4 | LEIST | Verrichting binnen een verrichtingencatalogus | nvarchar | 10 | 0 | | |
47 | NLDIS_003 | DIS - Leistungen Spezielle Strecke | 3 | LEIST | Verrichting binnen een verrichtingencatalogus | nvarchar | 10 | 0 | | |
48 | NLDIS_004 | DIS - Kostpreis | 4 | LEIST | Verrichting binnen een verrichtingencatalogus | nvarchar | 10 | 0 | | |
49 | NLDIS_005 | DIS - Kostpreis | 5 | LEIST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
50 | NLGGZ_SERVICE | Geisteskrankheit Leistungsgruppe aktuell | 5 | LEIST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
51 | NLGGZ_SERVICE_CP | Geisteskrankheit leistungen Leistungsgruppe kopie | 5 | LEIST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
52 | NLVERP | Rechnungregister-position | 8 | LEIST | Verrichting binnen een verrichtingencatalogus | nvarchar | 10 | 0 | | |
53 | NNL_DDS_QA | Deklaration Query leistung | 9 | LEIST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
54 | NNL_DDS_QAL | Deklaration Query leistung log | 10 | LEIST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
55 | NNVR | IS-H: Subsequent billing (AT) | 6 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | | |
56 | NWATAGBA | IS-H AT: Ambulanzgebühren - Ergebnisse / zu verteilen | 8 | LEIST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
57 | NWATALSE | IS-H AT: Amb. Leistungsstatistik - Ergebnisse | 8 | LEIST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
58 | NWATLH1 | IS-H AT: Leistungshöchstwerte für Leistungsgruppen | 5 | LEIST | IS-H: Leistungsgruppe für Leistungsregeln | nvarchar | 10 | 0 | | |
59 | NWATLHO | IS-H AT: Leistungshöchstwerte | 4 | LEIST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
60 | NWAT_SCO_KAL | LKF - amb. Scoring Leistungen (KALs) | 5 | LEIST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
61 | NWAT_SCO_MEL | LKF - Scoring Leistungen (MELs) | 5 | LEIST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
62 | NWCHLS_RNLSR | IS-H CH: ALIS-Fehlerhandlung - Leistungen (RNLSR) | 10 | LEIST | Prestazione in un catalogo delle prestazioni | nvarchar | 10 | 0 | | |
63 | TN20S | Spaltenermittlung EBM | 4 | LEIST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
64 | TNA21R | IS-H: Flat rate rules (AT) | 7 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | | |
65 | TNA21S | IS-H: Scaled flate rates (VERA) | 8 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | | |
66 | TNAHWFG | IS-H AT: Leistungshöchstwerte pro Fall und Fachgebiet | 5 | LEIST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
67 | TNAUMLEI | IS-H AT: Umschlüsselung Leistung | 4 | LEIST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
68 | TNLDBC_TRDBC1 | IS-H NL: Dummy DBC per Leistung | 3 | LEIST | Verrichting binnen een verrichtingencatalogus | nvarchar | 10 | 0 | | |
69 | TNLGGZ_SERVICE | Geisteskrankheit leistungs gruppe | 4 | LEIST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
70 | TNNA1 | IS-H NL: Billing parties per service (group) | 5 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | | |
71 | TNNC1 | IS-H NL: Insurance verification procedures | 5 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | | |
72 | TNWATKBDIA | IS-H AT: Leistungsgenerierung - Ausschluß über Diagnosen | 12 | LEIST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
73 | TNWATKBGEN | IS-H AT: Leistungsgenerierung | 16 | LEIST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
74 | TNWATLROPLST | IS-H AT: Leistungsregel - Höherreihung OP-Gruppen | 4 | LEIST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
75 | TNWATLRTKLST | IS-H AT: Lregel - Höher. Tageskliniken - spez. TK-Leistung | 4 | LEIST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
76 | TNWAT_DEKADE_P | IS-H AT: Customizingtabelle für Dekaden (Positionsdaten) | 10 | LEIST | Leistung innerhalb eines Leistungskataloges | nvarchar | 10 | 0 | | |
77 | TNWCH30 | IS-H CH: TarMed Leistungsdauer umschlüsseln | 5 | LEIST | Prestazione in un catalogo delle prestazioni | nvarchar | 10 | 0 | | |