| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | N1CORDF | CORD: Order Filler | 4 | ORGPF | CORD: Nursing Organizational Unit (OU) Order Filler | nvarchar | 8 | 0 | | |
2 | N1CORDFAVP | CORD: Favorites - Item | 7 | ORGPF | Identification Key of Organizational Unit | nvarchar | 8 | 0 | | |
3 | N1CORDFT | CORD: Order Fller Texts | 5 | ORGPF | CORD: Nursing Organizational Unit (OU) Order Filler | nvarchar | 8 | 0 | | |
4 | TN2CHART_LOUT_OU | Chart: Customizing Standard Layout per Departmental OU | 3 | ORGPF | Organizational Unit Assigned to Case | nvarchar | 8 | 0 | | |
5 | TNC301L | IS-H: Standortbezogene Übermittlungsmerkmale (§301) | 5 | ORGPF | IS-H: OrgEinheit, die einem Fall zugewiesen wird | nvarchar | 8 | 0 | | |
6 | TNWAT_FREQU | Leistungsgenerierung für ambulante Besuche | 7 | ORGPF | IS-H: OrgEinheit, die einem Fall zugewiesen wird | nvarchar | 8 | 0 | | |
TOPBasic Data |
7 | NOEK | IS-H: Assign Org. Unit to Cost Center | 3 | ORGPF | Requesting Nursing Organizational Unit | nvarchar | 8 | 0 | | |
8 | TN10B | IS-H: Statistical Bed Count of Organizational Units | 3 | ORGPF | Organizational Unit with Nursing Assignment Authority | nvarchar | 8 | 0 | | |
9 | TNCD1 | IS-HCM Dispatch Control for Direct Communication | 6 | ORGPF | IS-HCM: Nursing Organizational Unit Affected by Event | nvarchar | 8 | 0 | | |
TOPClinical System |
10 | N1MEORDER | IS-H*MED: Medication, Medication Order | 10 | ORGPF | Medication: Order - Ordering Organizational Unit | nvarchar | 8 | 0 | | |
11 | N1PRBEW | IS-H*MED: PATREG: Bewegungen | 13 | ORGPF | IS-H: Olguya tayin edilen organizasyon birimi | nvarchar | 8 | 0 | | |
12 | N1SRV | Services: Service Data | 12 | ORGPF | Services: Treatment Organizational Unit | nvarchar | 8 | 0 | | |
13 | N2CLIM_OBSVS | Vital Signs: Examination | 16 | ORGPF | Organizational Unit Assigned to Case | nvarchar | 8 | 0 | | |
14 | N2DWSWL_TASKD | Provisional Task | 34 | ORGPF | Organizational Unit Assigned to Case | nvarchar | 8 | 0 | | |
15 | N2DWSWL_USINGOU | Preset Situation Template for Organizational Units | 7 | ORGPF | Nursing Organizational Unit | nvarchar | 8 | 0 | | |
16 | N2DWSWL_USINGOU1 | Preset Situation Template for Organizational Units | 7 | ORGPF | Nursing Organizational Unit | nvarchar | 8 | 0 | | |
17 | N2GL_BASE_DOC | IS-H*MED: Base Item Document | 7 | ORGPF | Organizational Unit Assigned to Case | nvarchar | 8 | 0 | | |
18 | N2INPA_SUGGEST | Proposal Criteria Ward DWS Assignment | 6 | ORGPF | Organizational Unit Assigned to Case | nvarchar | 8 | 0 | | |
19 | N2INPA_SUGGEST1 | Proposal Criteria Ward DWS Assignment (Processing) | 6 | ORGPF | Organizational Unit Assigned to Case | nvarchar | 8 | 0 | | |
20 | NDOCA | IS-H*MED: Document Management Data for Archived Documents | 13 | ORGPF | Organizational Unit Assigned to Case | nvarchar | 8 | 0 | | |
21 | NDOCSTORNO | IS-H*MED: Canceled Documents | 14 | ORGPF | Organizational Unit Assigned to Case | nvarchar | 8 | 0 | | |
22 | TN1MECCTS | i.s.h.med: Medication Time Spans | 4 | ORGPF | Medication: Order - Ordering Organizational Unit | nvarchar | 8 | 0 | | |
23 | TN2CLIM_COMP_OU | CLIM: Measurement - Entry Element Assignment for OU | 4 | ORGPF | Nursing Organizational Unit | nvarchar | 8 | 0 | | |
24 | TN2CLIM_OUVS | Vital Signs: Customizing per OU | 4 | ORGPF | Nursing Organizational Unit | nvarchar | 8 | 0 | | |
25 | TN2CLIM_SPECIFY | CLIM: Specify Measurement | 4 | ORGPF | Nursing Organizational Unit | nvarchar | 8 | 0 | | |
26 | TN2CLIM_SPEC_POS | CLIM: Specialize Items for Measurement | 4 | ORGPF | Nursing Organizational Unit | nvarchar | 8 | 0 | | |
TOPNursing |
27 | N1NRSPE | Nursing Plan: Entry | 16 | ORGPF | Nursing Plan: Nursing Org. Unit of an Entry | nvarchar | 8 | 0 | | |
28 | N1NRSPH | Nursing Plan: Header Data | 7 | ORGPF | Nursing Plan: Nursing Organizational Unit | nvarchar | 8 | 0 | | |
TOPPatient Accounting |
29 | NICP | IS-H: Surgical Procedure Codes Performed | 30 | ORGPF | IS-H: Date when Surgical Procedure Code Was Completed | nvarchar | 8 | 0 | | |
30 | NICP2 | IS-H: INACTIVE since 4.71 - DO NOT USE ! | 30 | ORGPF | IS-H: Date when Surgical Procedure Code Was Completed | nvarchar | 8 | 0 | | |
31 | TN19D | Proposal of Treatment Certificates | 7 | ORGPF | Organizational Unit Assigned to Case | nvarchar | 8 | 0 | | |
32 | TNIEBILL | IS-H: Internet-Enabled Estimated Invoice - Not Supported Now | 20 | ORGPF | Organizational Unit Assigned to Case | nvarchar | 8 | 0 | | |
TOPPatient Management |
33 | NAPP | IS-H: Provisional Appointments for Visit Scheduling | 12 | ORGPF | Organizational Unit Assigned to Case | nvarchar | 8 | 0 | | |
34 | NBEW | IS-H: Movements for Case | 32 | ORGPF | Organizational Unit Assigned to Case | nvarchar | 8 | 0 | | |
35 | NDOC | IS-H: Assignment of IS-H Objects to Documents in DMS | 13 | ORGPF | Organizational Unit Assigned to Case | nvarchar | 8 | 0 | | |
36 | NLOC | IS-H: Time Slot Substitutions for Visit Scheduling | 2 | ORGPF | Organizational Unit Assigned to Case | nvarchar | 8 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
37 | /ISHFR/TNWFR_F10 | IS-H FR: Per Diem Fee | 9 | ORGPF | Organizational Unit Assigned to Case | nvarchar | 8 | 0 | | |
38 | N1FAPF | Table for dept'l nursing OUS | 4 | ORGPF | OU with Nursing Responsibility for Case | nvarchar | 8 | 0 | | |
39 | N2DWSWL_PATT | Task Template | 27 | ORGPF | Organizational Unit Assigned to Case | nvarchar | 8 | 0 | | |
40 | N2DWSWL_PATT1 | Task Template / Changes | 27 | ORGPF | Organizational Unit Assigned to Case | nvarchar | 8 | 0 | | |
41 | N2DWSWL_TASK | Task | 34 | ORGPF | Organizational Unit Assigned to Case | nvarchar | 8 | 0 | | |
42 | N2PRZ_HIT_HEAD | IS-H*MED: Names of Individual SPC Hit Lists | 6 | ORGPF | Identification Key of Organizational Unit | nvarchar | 8 | 0 | | |
43 | NEAC | IS-H: Estimated Amount for Accommod. in Local Currency | 5 | ORGPF | Organizational Unit Assigned to Case | nvarchar | 8 | 0 | | |
44 | NLWARTE_003 | NL - Warteliste extra felder fur | 10 | ORGPF | ISH_NL: Org. eenheid die aan aan een ZGV wordt toegewezen | nvarchar | 1 | 0 | | |
45 | NWATFAPF | IS-H AT: Tabelle für fachlich pflegerische OEs | 4 | ORGPF | IS-H: OrgEinheit, die einem Fall zugewiesen wird | nvarchar | 8 | 0 | | |
46 | TNABETTEN | IS-H AT: Bettenanzahl pro Station | 3 | ORGPF | IS-H: OrgEinheit, die einem Fall zugewiesen wird | nvarchar | 8 | 0 | | |
47 | TNAFD | IS-H: Outpatient Admission Fee Determination | 6 | ORGPF | Organizational Unit Assigned to Case | nvarchar | 8 | 0 | | |
48 | TNAKRF1 | IS-H: KRARAF Data Carrier, Function Codes/Dept | 2 | ORGPF | Organizational Unit Assigned to Case | nvarchar | 8 | 0 | | |
49 | TNSEL_INTERDEPT | Choice of System Behavior for Interdep. Bed Assignment | 3 | ORGPF | Identification Key of Organizational Unit | nvarchar | 8 | 0 | | |
50 | TNWATBETTEN | IS-H AT: Bettenanzahl pro Abteilung und Station | 4 | ORGPF | IS-H: OrgEinheit, die einem Fall zugewiesen wird | nvarchar | 8 | 0 | | |
51 | TNWATKBGEN | IS-H AT: Leistungsgenerierung | 13 | ORGPF | IS-H: OrgEinheit, die einem Fall zugewiesen wird | nvarchar | 8 | 0 | | |
52 | TNWAT_BETR | IS-H AT: Ermittlung Betreuungsschein | 6 | ORGPF | IS-H: OrgEinheit, die einem Fall zugewiesen wird | nvarchar | 8 | 0 | | |
53 | TNWAT_DEKADE_H | IS-H AT: Customizingtabelle für Dekaden (Kopfdaten) | 4 | ORGPF | IS-H: OrgEinheit, die einem Fall zugewiesen wird | nvarchar | 8 | 0 | | |
54 | TNWAT_DEKADE_P | IS-H AT: Customizingtabelle für Dekaden (Positionsdaten) | 4 | ORGPF | IS-H: OrgEinheit, die einem Fall zugewiesen wird | nvarchar | 8 | 0 | | |
55 | TNWAT_EURS | IS-H AT: Ermittlung Ursache der Behandlung | 6 | ORGPF | IS-H: OrgEinheit, die einem Fall zugewiesen wird | nvarchar | 8 | 0 | | |
56 | TNWAT_OE_ABBEXC | IS-H AT: Ambulanzbehandlungsarten für Ambulanzgebühren | 3 | ORGPF | IS-H: OrgEinheit, die einem Fall zugewiesen wird | nvarchar | 8 | 0 | | |
57 | TNWAT_OE_VPNR | IS-H AT: Vertragspartnernummern für Ambulanzen | 3 | ORGPF | IS-H: behandelnde OrgEinheit | nvarchar | 8 | 0 | | |