| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | NBMI_SRV_UPLOAD | Keep the upload status | 2 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
2 | NNLREFER_REF_ACT | Kopplung Verweisungsnummer und Leistung | 4 | LNRLS | IS-H: Laufende Nummer der Leistung | nvarchar | 10 | 0 | | |
3 | NNL_FYSIO | Tabelle Physiotherapie | 5 | LNRLS | IS-H: Laufende Nummer der Leistung | nvarchar | 10 | 0 | | |
4 | NNL_MED_MESS | LBZ medizinische Meldungen | 8 | LNRLS | IS-H: Laufende Nummer der Leistung | nvarchar | 10 | 0 | | |
5 | NNL_ZH308_V9_R04 | ZH308 V09 Record04 Soll Daten | 58 | LNRLS | | nvarchar | 15 | 0 | | |
TOPClinical System |
6 | N1BEZY | IS-H*MED: Cycles with NLEI reference | 6 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
7 | N1DWSWL_WRKSUR | Surgery: Situation - Surgery Assignment | 3 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
8 | N1DYLMZUO | IS-H*MED: Dynamic material proposal | 3 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
9 | N1GENCY_01 | IS-H*MED: Cycle - Nursing Service Assignment | 3 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
10 | N1GENCY_02 | IS-H*MED: Cycle - Medical Service Assignment | 3 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
11 | N1IPBA | IS-H*MED: Asnmt. of Indiv. Nurs. Plan to Basic HospCat.Entry | 2 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
12 | N1IPLE | IS-H*MED:Assignmt of Nursing Anchor Service to the ntpk | 3 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
13 | N1IPST | IS-H*MED: Asgmt of Stnd. Nursing Plans to Ind. Nursing Plans | 2 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
14 | N1LSMAZ | IS-H*MED: Service/employee assign. (delete after 3.03!) | 2 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
15 | N1LSSTZ | ISHMED: Service-Svce Status-Employee Assignment | 3 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
16 | N1LSTEAM | IS-H*MED: Tasks/Employees for a Service | 2 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
17 | N1MEOSRVA | IS-H*MED: Order - Service - Assignment | 3 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
18 | N1NURSPALMPC | IS-H*MED: Log Table for Communication with Palm-PC | 2 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
19 | N1POPAKTE | IS-H*Med: Patient Organizer - Redundant Structure | 15 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
20 | N1PRDOC | IS-H*MED: PATREG: Dokumente | 37 | LNRLS | IS-H: Hizmet sira numarasi | nvarchar | 10 | 0 | | |
21 | N1PREFETCHSPOOL | IS-H*MED: RAD Prefetching Tasks | 3 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
22 | N1PRLEM | IS-H*MED: PATREG: Leistungen | 3 | LNRLS | IS-H: Hizmet sira numarasi | nvarchar | 10 | 0 | | |
23 | N1TMSTPDUR | i.s.h..med: Duration for Time Stamps | 5 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
24 | N2ANKER | IS-H*MED Information for OR Documentation (Anchor Service) | 3 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
25 | N2DGAILEM | ISH*MED : Kontrolltabelle Überleitung med. Leist -> DGAI | 3 | LNRLS | IS-H: Laufende Nummer der Leistung | nvarchar | 10 | 0 | | |
26 | N2DOCBEWLEI | IS-H*MED: Movement and Service Data for Archived Documents | 12 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
27 | N2DOCREFSERV | IS-H*MED: Empty Table for Lock Object Service Ref. Level | 5 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
28 | N2DSDEVICE_ARCH | ISHMED: Archive Transfer Data from Interfaces | 16 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
29 | N2DSDEVICE_DATA | ISHMED: Transfer Data from Interface | 16 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
30 | N2MATREF | IS-H*MED: Reference table for material external data (N2FM) | 6 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
31 | N2OPDIAGNOSEN | IS-H*MED: Diagnoses for Surgeries | 3 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
32 | N2TEAMREF | IS-H*MED: Ref table for team ext. data modules (N2F2) | 6 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
33 | N2TICZ | IS-H*MED: Assignment Table Surgery Team - Surgery Code | 2 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
34 | NDOCA | IS-H*MED: Document Management Data for Archived Documents | 19 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
35 | NDOCSTORNO | IS-H*MED: Canceled Documents | 20 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
36 | NLEM | IS-H*MED: Medical Service | 2 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
TOPDocuments |
37 | N1IM_STUDY | Meta Data of Image Study | 7 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
TOPPatient Accounting |
38 | NGLT | IS-H: Intermediate table for service statistics | 5 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
39 | NLCO | IS-HCO: Transfer information | 2 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
40 | NLICZ | IS-H: Table of Service-to-Surgical Procedures Code Asgmts | 2 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
41 | NLOP | IS-H:INACTIVE Assignment Table Service - SP Code - Diagnosis | 4 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
42 | NMATP | IS-H: Material planned for case | 5 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
43 | NMATV | IS-H: Material Entered for Case | 6 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
44 | NNLZ | IS-H: Service <-> Business Partner Assignment | 2 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
45 | NSL2 | IS-H: Online error records of service statistics | 5 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
46 | NSLF | IS-H: Error records of service statistics | 5 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
47 | NVVQ | IS-H: Individual Payment Distribution (per Service) | 5 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
TOPPatient Management |
48 | NDOC | IS-H: Assignment of IS-H Objects to Documents in DMS | 19 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
49 | NLEI | IS-H: Services Performed | 6 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
50 | NLKZ | IS-H: Assignment table service SC <-> insur. verification BC | 2 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
TOPRadiology |
51 | N1PREFSPOOL | IS-H*MED: RAD Prefetching Tasks | 3 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
52 | /ISHFR/COSTCOV | IS-H FR: Coverage | 2 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
53 | NAKR2 | IS-H AT: LKF - Scoring Leistungen (MELs) | 4 | LNRLS | IS-H: Laufende Nummer der Leistung | nvarchar | 10 | 0 | | |
54 | NLGGZ_SERVICE_CP | Geisteskrankheit leistungen Leistungsgruppe kopie | 6 | LNRLS | IS-H: Laufende Nummer der Leistung | nvarchar | 10 | 0 | | |
55 | NLVERP | Rechnungregister-position | 9 | LNRLS | IS-H: Volgnummer van de verrichting | nvarchar | 10 | 0 | | |
56 | NNLRA | IS-H NL: Auf Leistungen angewendete Regeln | 2 | LNRLS | IS-H: Volgnummer van de verrichting | nvarchar | 10 | 0 | | |
57 | NNRL | IS-H NL: Calculation Rules Log File | 3 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
58 | NWAT_SCO_KAL | LKF - amb. Scoring Leistungen (KALs) | 4 | LNRLS | IS-H: Laufende Nummer der Leistung | nvarchar | 10 | 0 | | |
59 | NWAT_SCO_MEL | LKF - Scoring Leistungen (MELs) | 4 | LNRLS | IS-H: Laufende Nummer der Leistung | nvarchar | 10 | 0 | | |
60 | NWCH150 | IS-H CH: Zeitmarken zur Leistung (ALT => wird gelöscht !) | 4 | LNRLS | IS-H: numero progressivo prestazione | nvarchar | 10 | 0 | | |
61 | NWCH90 | Fee-Based Services | 5 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
62 | NWCH93 | Fees: Transfer Information for Services (NLEI) | 3 | LNRLS | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
63 | NWCHEXTREF | IS-H CH: Referenzschlüssel zur Leistung aus externem System | 4 | LNRLS | IS-H: numero progressivo prestazione | nvarchar | 10 | 0 | | |
64 | NWCHLCOEA | IS-HCO: Überleitungsinformationen | 5 | LNRLS | IS-H: numero progressivo prestazione | nvarchar | 10 | 0 | | |
65 | NWCHLS_RNLRZM | IS-H CH: ALIS-Fehlerhandlung - Zeitmarken (RNLRZM) | 15 | LNRLS | IS-H: numero progressivo prestazione | nvarchar | 10 | 0 | | |
66 | NWCHLS_RNLSR | IS-H CH: ALIS-Fehlerhandlung - Leistungen (RNLSR) | 9 | LNRLS | IS-H: numero progressivo prestazione | nvarchar | 10 | 0 | | |
67 | NWCHPAKLZ | IS-H CH: Patientenabrechnung - LstVerteilung Nachträge | 5 | LNRLS | IS-H: numero progressivo prestazione | nvarchar | 10 | 0 | | |
68 | NWCHZM | IS-H CH: Zeitmarken zur Bewegung/Leistung | 7 | LNRLS | IS-H: numero progressivo prestazione | nvarchar | 10 | 0 | | |
69 | NWCHZME | IS-H CH: Zeit- /Maßangaben zur Bewegung/Leistung | 6 | LNRLS | IS-H: numero progressivo prestazione | nvarchar | 10 | 0 | | |