| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | N1CORDF | CORD: Order Filler | 5 | ORGFA | CORD: Departmental OU in Preregistration | nvarchar | 8 | 0 | | |
| 2 | N1CORDFAVP | CORD: Favorites - Item | 8 | ORGFA | Identification Key of Organizational Unit | nvarchar | 8 | 0 | | |
| 3 | TN2CHART_LOUT_OU | Chart: Customizing Standard Layout per Departmental OU | 4 | ORGFA | IS-H: OU with Departmental Responsibility for Case | nvarchar | 8 | 0 | | |
| 4 | TNC301L | IS-H: Standortbezogene Übermittlungsmerkmale (§301) | 4 | ORGFA | IS-H: OrgEinheit, die einem Fall fachl. zugewiesen wird | nvarchar | 8 | 0 | | |
| 5 | TNWAT_FREQU | Leistungsgenerierung für ambulante Besuche | 6 | ORGFA | IS-H: OrgEinheit, die einem Fall fachl. zugewiesen wird | nvarchar | 8 | 0 | | |
| TOPBasic Data |
| 6 | NOEK | IS-H: Assign Org. Unit to Cost Center | 2 | ORGFA | Requesting Departmental Organizational Unit | nvarchar | 8 | 0 | | |
| 7 | TN10B | IS-H: Statistical Bed Count of Organizational Units | 2 | ORGFA | IS-H: Org. Unit with Departmental Assignment Authority | nvarchar | 8 | 0 | | |
| 8 | TN11P | IS-H: Planning Characteristics of Building Unit | 16 | ORGFA | IS-H: OU with Departmental Responsibility for Case | nvarchar | 8 | 0 | | |
| 9 | TNCD1 | IS-HCM Dispatch Control for Direct Communication | 5 | ORGFA | IS-HCM: Dept. Orgamizational Unit Affected by Event | nvarchar | 8 | 0 | | |
| 10 | TNFAS | IS-H: Department Status for Basic Medical Documentation | 2 | ORGFA | IS-H: Department for Department Status | nvarchar | 8 | 0 | | |
| TOPClinical System |
| 11 | N1MEORDER | IS-H*MED: Medication, Medication Order | 9 | ORGFA | Medication: Ordering Departmental Org. Unit | nvarchar | 8 | 0 | | |
| 12 | N1PRBEW | IS-H*MED: PATREG: Bewegungen | 11 | ORGFA | IS-H: Olguya bölüm tayini yapilan organizasyon birimi | nvarchar | 8 | 0 | | |
| 13 | N1SRV | Services: Service Data | 11 | ORGFA | Services: Departmental Organizational Unit | nvarchar | 8 | 0 | | |
| 14 | N2CLIM_OBSVS | Vital Signs: Examination | 15 | ORGFA | IS-H: OU with Departmental Responsibility for Case | nvarchar | 8 | 0 | | |
| 15 | N2DWSWL_TASKD | Provisional Task | 33 | ORGFA | IS-H: OU with Departmental Responsibility for Case | nvarchar | 8 | 0 | | |
| 16 | N2DWSWL_USINGOU | Preset Situation Template for Organizational Units | 6 | ORGFA | Departmental Organizational Unit | nvarchar | 8 | 0 | | |
| 17 | N2DWSWL_USINGOU1 | Preset Situation Template for Organizational Units | 6 | ORGFA | Departmental Organizational Unit | nvarchar | 8 | 0 | | |
| 18 | N2GL_BASE_DOC | IS-H*MED: Base Item Document | 6 | ORGFA | IS-H: OU with Departmental Responsibility for Case | nvarchar | 8 | 0 | | |
| 19 | N2INPA_SUGGEST | Proposal Criteria Ward DWS Assignment | 5 | ORGFA | IS-H: OU with Departmental Responsibility for Case | nvarchar | 8 | 0 | | |
| 20 | N2INPA_SUGGEST1 | Proposal Criteria Ward DWS Assignment (Processing) | 5 | ORGFA | IS-H: OU with Departmental Responsibility for Case | nvarchar | 8 | 0 | | |
| 21 | N2TBS_CATEGORY | IS-H*MED: Categories for Text Modules | 5 | ORGFA | IS-H: OU with Departmental Responsibility for Case | nvarchar | 8 | 0 | | |
| 22 | N2TBS_LTE | Text Modules for Long Text Editor | 6 | ORGFA | IS-H: OU with Departmental Responsibility for Case | nvarchar | 8 | 0 | | |
| 23 | N2TBS_SM_TAG | IS-H*MED LTE: Markers Tag Table | 3 | ORGFA | IS-H: OU with Departmental Responsibility for Case | nvarchar | 8 | 0 | | |
| 24 | N2TBS_SM_VALUE | IS-H*MED LTE: Markers | 4 | ORGFA | IS-H: OU with Departmental Responsibility for Case | nvarchar | 8 | 0 | | |
| 25 | N2TBS_USER | OBSOLETE: IS-H*MED: Text Modules | 6 | ORGFA | IS-H: OU with Departmental Responsibility for Case | nvarchar | 8 | 0 | | |
| 26 | NDOCA | IS-H*MED: Document Management Data for Archived Documents | 12 | ORGFA | IS-H: OU with Departmental Responsibility for Case | nvarchar | 8 | 0 | | |
| 27 | NDOCSTORNO | IS-H*MED: Canceled Documents | 13 | ORGFA | IS-H: OU with Departmental Responsibility for Case | nvarchar | 8 | 0 | | |
| 28 | TN2CLIM_COMP_OU | CLIM: Measurement - Entry Element Assignment for OU | 3 | ORGFA | Departmental Organizational Unit | nvarchar | 8 | 0 | | |
| 29 | TN2CLIM_OUVS | Vital Signs: Customizing per OU | 3 | ORGFA | Departmental Organizational Unit | nvarchar | 8 | 0 | | |
| 30 | TN2CLIM_SPECIFY | CLIM: Specify Measurement | 3 | ORGFA | Departmental Organizational Unit | nvarchar | 8 | 0 | | |
| 31 | TN2CLIM_SPEC_POS | CLIM: Specialize Items for Measurement | 3 | ORGFA | Departmental Organizational Unit | nvarchar | 8 | 0 | | |
| TOPNursing |
| 32 | N1NRSPE | Nursing Plan: Entry | 15 | ORGFA | Nursing Plan: Department of an Entry | nvarchar | 8 | 0 | | |
| 33 | N1NRSPH | Nursing Plan: Header Data | 8 | ORGFA | Nursing Plan: Department | nvarchar | 8 | 0 | | |
| TOPPatient Accounting |
| 34 | NICP | IS-H: Surgical Procedure Codes Performed | 29 | ORGFA | IS-H: Departmental Organizational Unit of Procedure | nvarchar | 8 | 0 | | |
| 35 | NICP2 | IS-H: INACTIVE since 4.71 - DO NOT USE ! | 29 | ORGFA | IS-H: Departmental Organizational Unit of Procedure | nvarchar | 8 | 0 | | |
| 36 | TN19D | Proposal of Treatment Certificates | 8 | ORGFA | IS-H: OU with Departmental Responsibility for Case | nvarchar | 8 | 0 | | |
| 37 | TNIEBILL | IS-H: Internet-Enabled Estimated Invoice - Not Supported Now | 19 | ORGFA | IS-H: OU with Departmental Responsibility for Case | nvarchar | 8 | 0 | | |
| TOPPatient Management |
| 38 | N1VKG | IS-H: Item of Clinical Order (Preregistration) | 47 | ORGFA | IS-H: Departmental Org. Unit in Preregistration | nvarchar | 8 | 0 | | |
| 39 | NAPP | IS-H: Provisional Appointments for Visit Scheduling | 11 | ORGFA | IS-H: OU with Departmental Responsibility for Case | nvarchar | 8 | 0 | | |
| 40 | NBEW | IS-H: Movements for Case | 31 | ORGFA | IS-H: OU with Departmental Responsibility for Case | nvarchar | 8 | 0 | | |
| 41 | NDOC | IS-H: Assignment of IS-H Objects to Documents in DMS | 12 | ORGFA | IS-H: OU with Departmental Responsibility for Case | nvarchar | 8 | 0 | | |
| 42 | NFALA | IS-H: Archived Cases: Obsolete as of 4.72 (Info via SARI) | 8 | ORGFA | IS-H: OU with Departmental Responsibility for Case | nvarchar | 8 | 0 | | |
| 43 | NTPGP | IS-H: Day program items (possible appointments) | 15 | ORGFA | IS-H: OU with Departmental Responsibility for Case | nvarchar | 8 | 0 | | |
| TOPSAP Healthcare - Industry-Specific Components for Hospitals |
| 44 | /ISHFR/TNWFR_F10 | IS-H FR: Per Diem Fee | 8 | ORGFA | IS-H: OU with Departmental Responsibility for Case | nvarchar | 8 | 0 | | |
| 45 | N1FAPF | Table for dept'l nursing OUS | 3 | ORGFA | OU with Departmental Responsibility for Case | nvarchar | 8 | 0 | | |
| 46 | N2DWSWL_PATT | Task Template | 26 | ORGFA | IS-H: OU with Departmental Responsibility for Case | nvarchar | 8 | 0 | | |
| 47 | N2DWSWL_PATT1 | Task Template / Changes | 26 | ORGFA | IS-H: OU with Departmental Responsibility for Case | nvarchar | 8 | 0 | | |
| 48 | N2DWSWL_TASK | Task | 33 | ORGFA | IS-H: OU with Departmental Responsibility for Case | nvarchar | 8 | 0 | | |
| 49 | N2PRZ_HIT_HEAD | IS-H*MED: Names of Individual SPC Hit Lists | 5 | ORGFA | Identification Key of Organizational Unit | nvarchar | 8 | 0 | | |
| 50 | NEAC | IS-H: Estimated Amount for Accommod. in Local Currency | 4 | ORGFA | IS-H: OU with Departmental Responsibility for Case | nvarchar | 8 | 0 | | |
| 51 | NEMC | IS-H: Estimated Amount for Med. Cases in Local Currency | 5 | ORGFA | IS-H: OU with Departmental Responsibility for Case | nvarchar | 8 | 0 | | |
| 52 | NEOP | IS-H: Estimated Amnts for Table of Operation in Local Crrncy | 6 | ORGFA | IS-H: OU with Departmental Responsibility for Case | nvarchar | 8 | 0 | | |
| 53 | NWATFAPF | IS-H AT: Tabelle für fachlich pflegerische OEs | 3 | ORGFA | IS-H: OrgEinheit, die einem Fall fachl. zugewiesen wird | nvarchar | 8 | 0 | | |
| 54 | TNAFD | IS-H: Outpatient Admission Fee Determination | 5 | ORGFA | IS-H: OU with Departmental Responsibility for Case | nvarchar | 8 | 0 | | |
| 55 | TNAKRF1 | IS-H: KRARAF Data Carrier, Function Codes/Dept | 3 | ORGFA | IS-H: OU with Departmental Responsibility for Case | nvarchar | 8 | 0 | | |
| 56 | TNWATBETTEN | IS-H AT: Bettenanzahl pro Abteilung und Station | 3 | ORGFA | IS-H: OrgEinheit, die einem Fall fachl. zugewiesen wird | nvarchar | 8 | 0 | | |
| 57 | TNWAT_BETR | IS-H AT: Ermittlung Betreuungsschein | 5 | ORGFA | IS-H: OrgEinheit, die einem Fall fachl. zugewiesen wird | nvarchar | 8 | 0 | | |
| 58 | TNWAT_DEKADE_H | IS-H AT: Customizingtabelle für Dekaden (Kopfdaten) | 5 | ORGFA | IS-H: OrgEinheit, die einem Fall fachl. zugewiesen wird | nvarchar | 8 | 0 | | |
| 59 | TNWAT_DEKADE_P | IS-H AT: Customizingtabelle für Dekaden (Positionsdaten) | 5 | ORGFA | IS-H: OrgEinheit, die einem Fall fachl. zugewiesen wird | nvarchar | 8 | 0 | | |
| 60 | TNWAT_EURS | IS-H AT: Ermittlung Ursache der Behandlung | 5 | ORGFA | IS-H: OrgEinheit, die einem Fall fachl. zugewiesen wird | nvarchar | 8 | 0 | | |
| 61 | TNWAT_OE_ABBEXC | IS-H AT: Ambulanzbehandlungsarten für Ambulanzgebühren | 2 | ORGFA | IS-H: OrgEinheit, die einem Fall fachl. zugewiesen wird | nvarchar | 8 | 0 | | |
| 62 | TNWAT_OE_VPNR | IS-H AT: Vertragspartnernummern für Ambulanzen | 2 | ORGFA | IS-H: Aktuelle fachliche Organisationseinheit des Patienten | nvarchar | 8 | 0 | | |
