| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /ISHCDP/NBDN001 | Erweiterung Todesdaten für Todesanzeige | 3 | PATNR | IS-H: Patientennummer | nvarchar | 10 | 0 | | |
2 | MLAUFKEPHH | History table for summarized MLAUFKEPH data | 12 | PATNR | Partner number for costing | nvarchar | 6 | 0 | | |
3 | N1MCI_MSG | Message Log | 6 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
4 | N1MESORTORDHDR | Medication: Header for Man. Sorting | 3 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
5 | N2CHART_USR_LAYO | SL Chart: User-Specific Chart Layout | 5 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
6 | NHCF_QUEUE_MAP | IS-H: Map SOA Event Sequence ID to IS-H Business Object | 3 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
7 | NNLCAREREQ_IDX | Sorgefrage Index | 3 | PATNR | IS-H: Patientennummer | nvarchar | 10 | 0 | | |
8 | NNL_FYSIO | Tabelle Physiotherapie | 3 | PATNR | IS-H: Patientennummer | nvarchar | 10 | 0 | | |
9 | NNL_MED_MESS | LBZ medizinische Meldungen | 3 | PATNR | IS-H: Patientennummer | nvarchar | 10 | 0 | | |
10 | NNL_ZH308_V9_R02 | ZH308 V09 Record02 Soll Daten | 10 | PATNR | | nvarchar | 11 | 0 | | |
11 | NNL_ZH308_V9_R04 | ZH308 V09 Record04 Soll Daten | 7 | PATNR | IS-H: Patientennummer | nvarchar | 10 | 0 | | |
12 | NNL_ZH308_V9_R06 | ZH308 V09 Record06 Soll Daten | 7 | PATNR | IS-H: Patientennummer | nvarchar | 10 | 0 | | |
13 | NNL_ZH308_V9_R16 | ZH308 V09 Record16 Soll Daten | 7 | PATNR | IS-H: Patientennummer | nvarchar | 10 | 0 | | |
TOPActual CostingMaterial Ledger |
14 | CKMLKEPH | Material Ledger: Cost Component Split (Elements) | 12 | PATNR | Partner number for costing | nvarchar | 6 | 0 | | |
15 | CKMLPRKEPH | Material Ledger: Cost Component Split (Elements) for Prices | 9 | PATNR | Partner number for costing | nvarchar | 6 | 0 | | |
16 | MLAUFKEPH | ML: Cost Component Split (Components) for Order History | 11 | PATNR | Partner number for costing | nvarchar | 6 | 0 | | |
17 | MLBEKEPH | ML: Cost Comp. Split (Elements) for Purchase Order History | 10 | PATNR | Partner number for costing | nvarchar | 6 | 0 | | |
18 | MLKEPH | ML Document: Cost Component Split (Elements) for Values | 10 | PATNR | Partner number for costing | nvarchar | 6 | 0 | | |
19 | MLPRKEPH | ML Document: Cost Component Split (Components)for Prices | 10 | PATNR | Partner number for costing | nvarchar | 6 | 0 | | |
TOPBasic Data |
20 | NC301 | IS-HCM: Order Table Data Transmission for EDI | 29 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
21 | NC301S | IS-HCM: EDI Status Management | 45 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
22 | NC301T | IS-H EDI Temporary Storage for Old EDI Msg. Status Records | 45 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
23 | NFOR | IS-H: Form Log | 2 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
TOPBusiness Partners |
24 | NPNT | Patient Master Data | 51 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
TOPClinical System |
25 | N1DCS_DAUERDIA | IS-H*MEd: DCS: Quick Entry Long-Term Diagnoses | 3 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
26 | N1DCS_DAUERTHE | IS-H*MED: DCS: Quick Entry Long-Term Therapies | 3 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
27 | N1MEORDER | IS-H*MED: Medication, Medication Order | 4 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
28 | N1MEVO | OBSOLETE: Prescription of a Medication | 5 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
29 | N1PATFAL | IS-H*MED: Relationship between patient and case | 4 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
30 | N1PATM | IS-H*MED: Medical Patient Master Record | 2 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
31 | N1POPAKTE | IS-H*Med: Patient Organizer - Redundant Structure | 4 | PATNR | Patient Number | nvarchar | 10 | 0 | | |
32 | N1PRANF | IS-H*MED: PATREG: Anforderungen | 40 | PATNR | IS-H: Hasta numarasi | nvarchar | 10 | 0 | | |
33 | N1PRDOC | IS-H*MED: PATREG: Dokumente | 8 | PATNR | IS-H: Hasta numarasi | nvarchar | 10 | 0 | | |
34 | N1PREFETCHSPOOL | IS-H*MED: RAD Prefetching Tasks | 4 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
35 | N1PRFAL | IS-H*MED: PATREG: Fälle | 5 | PATNR | IS-H: Hasta numarasi | nvarchar | 10 | 0 | | |
36 | N1PRLEM | IS-H*MED: PATREG: Leistungen | 5 | PATNR | IS-H: Hasta numarasi | nvarchar | 10 | 0 | | |
37 | N1PRPATLOG | IS-H*MED: PATREG: Fehlerprotokoll für Patientenstammdaten | 3 | PATNR | IS-H: Hasta numarasi | nvarchar | 10 | 0 | | |
38 | N1PRPATVERGL | IS-H*MED: PATREG: bestimmt ob NPAT Satz an PATREG übertrag | 3 | PATNR | IS-H: Hasta numarasi | nvarchar | 10 | 0 | | |
39 | N1PRPATZUO | IS-H*MED: PATREG: Patientenregisterzuordnungstabelle | 4 | PATNR | IS-H: Hasta numarasi | nvarchar | 10 | 0 | | |
40 | N1PRRSF | IS-H*MED: PATREG: Risikofaktoren | 3 | PATNR | IS-H: Hasta numarasi | nvarchar | 10 | 0 | | |
41 | N1PRTMN | IS-H*MED: PATREG: Termine | 4 | PATNR | IS-H: Hasta numarasi | nvarchar | 10 | 0 | | |
42 | N1PRTMPCPYPAT | IS-H*MED: PATREG: NPAT Kopie des Teilnehmers | 2 | PATNR | IS-H: Hasta numarasi | nvarchar | 10 | 0 | | |
43 | N1PRTMPPAT | IS-H*MED: PATREG: Temporäre Patientenstammdatentabelle | 3 | PATNR | IS-H: Hasta numarasi | nvarchar | 10 | 0 | | |
44 | N1PRTMPPAT2PR | IS-H*MED: PATREG: Zuordnung NPAT -> N1PRPAT Patienten | 3 | PATNR | IS-H: Hasta numarasi | nvarchar | 10 | 0 | | |
45 | N1PRTMPPATLOC | IS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal | 3 | PATNR | PATREG: Hasta taniticisi | nvarchar | 10 | 0 | | |
46 | N1PRVKG | IS-H*MED: PATREG: Vormerkungen | 4 | PATNR | IS-H: Hasta numarasi | nvarchar | 10 | 0 | | |
47 | N1RISMIS | IS-H*MED: Data transfer error (case - patient) | 4 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
48 | N1SIOBUSA | i.s.h.med: Patient Record, Indicator-Object Assignment | 13 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
49 | N1SRV | Services: Service Data | 6 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
50 | N1THERS | IS-H*MED: Therapeutic Scheme | 4 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
51 | N1THS | IS-H*MED: Medication - Order Profile | 5 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
52 | N2AD_ALLERGY | Allergy Documentation - Allergies | 2 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
53 | N2AD_PAT | Allergy Documentation - Overall Allergy Status (OAS) | 2 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
54 | N2AD_REACT | Allergy Documentation - Reactions | 2 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
55 | N2BATMP | IS-H*MED: Temporary treatment order | 2 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
56 | N2CCF_MSGS | CCF: Message Table | 15 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
57 | N2CLIM_OBSVS | Vital Signs: Examination | 13 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
58 | N2CLIM_PATNR | Dummy Table for Lock Object | 3 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
59 | N2CLIM_PLDVS | Vital Signs: Definite Planned Measurement (with Time) | 6 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
60 | N2CLIM_SDLVS | Vital Signs: Measurement Plan for Patient (Cycles) | 6 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
61 | N2DGAILEM | ISH*MED : Kontrolltabelle Überleitung med. Leist -> DGAI | 5 | PATNR | IS-H: Patientennummer | nvarchar | 10 | 0 | | |
62 | N2DOCFAL | IS-H*MED: Case Data for Archived Documents | 5 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
63 | N2DOCREFPAT | IS-H*MED: Empty Table for Lock Object Patient Ref. Level | 5 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
64 | N2DSDEVICE_ARCH | ISHMED: Archive Transfer Data from Interfaces | 5 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
65 | N2DSDEVICE_DATA | ISHMED: Transfer Data from Interface | 5 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
66 | N2DWORKLIST | IS-H*MED RAD: Work list (RIS - PACS work list) | 3 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
67 | N2DWSWL_TASKD | Provisional Task | 4 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
68 | N2DWSWL_WORKD | Provisional Situation | 4 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
69 | N2GL_TM_PROF | IS-H*MED: Occupational Groups for Subsequent Activity | 2 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
70 | N2GL_TM_SCHEDULE | pathways Patient Pathway | 4 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
71 | N2GL_TR_DIA | Treatment Pathway: Proposal for Patient Pathway | 3 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
72 | N2PHYO_ORDER | Physician Order | 4 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
73 | NDOCA | IS-H*MED: Document Management Data for Archived Documents | 9 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
74 | NDOCSTORNO | IS-H*MED: Canceled Documents | 10 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
75 | NLEM | IS-H*MED: Medical Service | 4 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
TOPCommunication |
76 | NHCF_EVENT | IS-H: HCF: Triggered Unprocessed Events | 8 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
TOPDocuments |
77 | N1IM_STUDY | Meta Data of Image Study | 4 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
TOPMedical Patient Data Organization Patient Organizer |
78 | N1STRUCMEDREC | IS-H*MED: Health Problems (Struct. Med. Patient Record) | 3 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
TOPNursing |
79 | N1NRSPH | Nursing Plan: Header Data | 6 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
80 | N1NRSPKMS | Nursing Plan: NCPS Classifications | 4 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
TOPPatient Accounting |
81 | NCIR | IS-H: Insurance Relationships of a Case | 100 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
82 | NEHC | Health Insurance Card EHC | 6 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
83 | NPATVVDEBI | IS-H: Table for RNUVVDEBI | 3 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
84 | NPIR | IS-H: Insurance Relationship Proposal Pool | 2 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
TOPPatient Management |
85 | N1ANF | IS-H*MED: Request | 36 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
86 | N1CORDER | IS-H: Clinical Order | 5 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
87 | N1VKG | IS-H: Item of Clinical Order (Preregistration) | 9 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
88 | NDAT_CHANGE | IS-H: Log Data for Unprotecting Fields | 2 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
89 | NDOC | IS-H: Assignment of IS-H Objects to Documents in DMS | 9 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
90 | NFAL | IS-H: Cases | 5 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
91 | NFALA | IS-H: Archived Cases: Obsolete as of 4.72 (Info via SARI) | 5 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
92 | NKAV | ISH: Intermediate File Creation/Borrowing/Transfer of Recrds | 3 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
93 | NPAE | IS-H: Patient Master Data (Institution-Related) | 3 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
94 | NPAT | IS-H: Patient Master Data (General) | 2 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
95 | NPGZ | IS-H: Assignment of Patient to Business Partner | 2 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
96 | NPIX | IS-H: Patient name index | 3 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
97 | NRSF | IS-H: Patient Risk Factors | 2 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
98 | NTMN | IS-H: Patient-Specific Appointments (Header Table for NAPP) | 4 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
99 | NTRC | IS-H: Trace Log Messages | 16 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
100 | NVVP | IS-H: Patient-related insurance relationship | 2 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
101 | NWAN | IS-H: Bad Debt Parties | 26 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
TOPPatient Transport Service |
102 | N1FAT | IS-H*MED: Transport Orders | 4 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
TOPPersonnel Administration |
103 | T7CO01 | Additional data of the company | 17 | PATNR | Employer registration number | nvarchar | 15 | 0 | | |
TOPProduct Cost Planning |
104 | CKIS | Items Unit Costing/Itemization Product Costing | 100 | PATNR | Partner number for costing | nvarchar | 6 | 0 | | |
105 | KEKO | Product Costing - Header Data | 107 | PATNR | Partner number for costing | nvarchar | 6 | 0 | | |
106 | KEPH | Product Costing: Cost Components for Cost of Goods Mfd | 9 | PATNR | Partner number for costing | nvarchar | 6 | 0 | | |
TOPProfit Center Accounting |
107 | PATN | Partner number/organizational unit | 2 | PATNR | Partner number for costing | nvarchar | 6 | 0 | | |
TOPPublic Sector |
108 | T7MXPBS1P | ISSSTE branch code and paying agent number | 6 | PATNR | ISSSTE paying agent number | nvarchar | 6 | 0 | | |
TOPSAP Ambulatory Care Management |
109 | NREDOMA | IS-H: Table Renewable Documents - Header Data | 2 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
110 | NREDOMA_DIAG | IS-H: Renewable Documents - Diagnoses | 8 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
111 | NWOINC | IS-H: Work Incapacity Certificates | 2 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
112 | ISH_HCF_HEADER | Header for Index Table | 7 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
113 | ISH_IDX_HEADER | Header for Index Table | 8 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
114 | N2DWSWL_TASK | Task | 4 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
115 | N2DWSWL_TASKPROF | Occupational Groups of Tasks in Processing | 3 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
116 | N2DWSWL_TPACK | Profile | 4 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
117 | N2DWSWL_WORK | Situation | 4 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
118 | NLBSN | Burgerservice nummer | 3 | PATNR | IS-H: Patientennummer | nvarchar | 10 | 0 | | |
119 | NLDBC_005 | NL-DBC: DBC Tabelle | 4 | PATNR | IS-H: Patiëntnummer | nvarchar | 10 | 0 | | |
120 | NLDBC_006_TRJ | IS-H: NL-DBC: Sorgestrecke | 5 | PATNR | IS-H: Patiëntnummer | nvarchar | 10 | 0 | | |
121 | NLGGZ_CARE_PRO | Geisteskrankheit DBC Sorgestrecke | 5 | PATNR | IS-H: Patientennummer | nvarchar | 10 | 0 | | |
122 | NLGGZ_CODE | Geisteskrankheit DBC kode | 3 | PATNR | IS-H: Patientennummer | nvarchar | 10 | 0 | | |
123 | NLGGZ_CODE_DIAGN | Geisteskranheit GGZ zusatz diagnose | 3 | PATNR | IS-H: Patientennummer | nvarchar | 10 | 0 | | |
124 | NLGGZ_CODE_LOG | Geisteskrankheit DBC protokoltabelle | 3 | PATNR | IS-H: Patientennummer | nvarchar | 10 | 0 | | |
125 | NLGGZ_DIAG_LOG | Geisteskrankheit DBC zusatz diagnosen protkoltabelle | 3 | PATNR | IS-H: Patientennummer | nvarchar | 10 | 0 | | |
126 | NLGGZ_DIS | Geisteskrankheit DIS protokolle | 7 | PATNR | IS-H: Patientennummer | nvarchar | 10 | 0 | | |
127 | NLGGZ_DIS_LOG | DIS GGZ protokoltabelle | 6 | PATNR | IS-H: Patientennummer | nvarchar | 10 | 0 | | |
128 | NLGGZ_PAT_GRP | Geisteskrankheit patient gruppe aktuell | 5 | PATNR | IS-H: Patientennummer | nvarchar | 10 | 0 | | |
129 | NLGGZ_SERVICE_CP | Geisteskrankheit leistungen Leistungsgruppe kopie | 3 | PATNR | IS-H: Patientennummer | nvarchar | 10 | 0 | | |
130 | NLVERK | Rechnungregister-kopf | 7 | PATNR | IS-H: Patiëntnummer | nvarchar | 10 | 0 | | |
131 | NNAU | IS-H NL: Confirmation of coverage info from ins. provider | 7 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
132 | NNLEK | IS-H NL: Data for treatment certificates | 3 | PATNR | IS-H: Patiëntnummer | nvarchar | 10 | 0 | | |
133 | NNLZP | IS-H NL: LAZR Bewegingsgegevens LAZR-interface | 16 | PATNR | IS-H NL: LAZR-patiëntnummer | nvarchar | 15 | 0 | | |
134 | NPSPAT | IS-H: Pseudonymized Patient Master Data (General) | 2 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
135 | NPSPIX | IS-H: Index of Pseudonymized Patient Names | 3 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
136 | NWAT_GIN_STATIR | IS-H AT: Versicherungsstatus des Patienten | 2 | PATNR | IS-H: Patientennummer | nvarchar | 10 | 0 | | |
137 | NWCHPATREC | IS-H CH: PATREC - erstellte Statistiksätze | 9 | PATNR | IS-H: numero paziente | nvarchar | 10 | 0 | | |
138 | NWCHPATREC_ID | IS-H CH: PATREC - künstl. Patienten-, Fall- und Geburtskeys | 3 | PATNR | IS-H: numero paziente | nvarchar | 10 | 0 | | |
139 | NWCHPSY | IS-H: Tab. für BFS-Statistik um Psychodaten bereitzustelle | 4 | PATNR | IS-H: numero paziente | nvarchar | 10 | 0 | | |
140 | NWCH_BOA_ARCH | Protokoll-Archiv für die Massendeckungsabfrage | 12 | PATNR | IS-H: Patientennummer | nvarchar | 10 | 0 | | |
141 | NWCH_BOA_PROT | Protokoll für die Massendeckungsabfrage | 12 | PATNR | IS-H: Patientennummer | nvarchar | 10 | 0 | | |
142 | TNLGGZ_PAT_GRP | Geisteskrankheit patient gruppe | 4 | PATNR | IS-H: Patientennummer | nvarchar | 10 | 0 | | |
TOPVital Signs |
143 | N1VP | Vital Sign Movement Data | 5 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |
144 | N1VP_PAT | Dummy Table for Vital Signs - Patient Lock | 2 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | |