| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBasic Data |
| 1 | NLSU | IS-H: Totals File for Service Statistics | 7 | ANFOE | Departmental Organizational Unit That Requests the Service | nvarchar | 8 | 0 | | |
| 2 | NO2K | IS-H: Assign OU to Cost Center for Revenue Acct Asgmt | 2 | ANFOE | Departmental Organizational Unit That Requests the Service | nvarchar | 8 | 0 | | |
| TOPClinical System |
| 3 | N1PRANF | IS-H*MED: PATREG: Anforderungen | 6 | ANFOE | IS-H: Hizmet talep eden bölüm organizasyon birimi | nvarchar | 8 | 0 | | |
| 4 | N1PREFETCHSPOOL | IS-H*MED: RAD Prefetching Tasks | 7 | ANFOE | Departmental Organizational Unit That Requests the Service | nvarchar | 8 | 0 | | |
| 5 | N1PRLEM | IS-H*MED: PATREG: Leistungen | 8 | ANFOE | IS-H: Hizmet talep eden bölüm organizasyon birimi | nvarchar | 8 | 0 | | |
| 6 | N1URL | IS-H*MED: Addresses of files for browser | 7 | ANFOE | Departmental Organizational Unit That Requests the Service | nvarchar | 8 | 0 | | |
| 7 | N2GL_BASE_REQ | IS-H*MED: Base Item Request | 5 | ANFOE | Departmental Organizational Unit That Requests the Service | nvarchar | 8 | 0 | | |
| 8 | N2OA | IS-H*MED: Evaluations for surgery documentation | 11 | ANFOE | Organizational Unit Assigned to Case | nvarchar | 8 | 0 | | |
| 9 | TN1ROUTING | IS-H*MED: Routing Rules | 5 | ANFOE | Requesting Org. Unit | nvarchar | 8 | 0 | | |
| 10 | TN2KUM01 | IS-H*MED: Group headers for cumulative findings | 4 | ANFOE | IS-H: Nursing Organizational Unit Requesting the Service | nvarchar | 8 | 0 | | |
| 11 | TN2KUM02 | IS-H*MED: Asgmt Services->Groups for cumulative findings | 3 | ANFOE | IS-H: Nursing Organizational Unit Requesting the Service | nvarchar | 8 | 0 | | |
| 12 | TN2KUM03 | IS-H*MED: Customizing for cumulative findings | 3 | ANFOE | IS-H: Nursing Organizational Unit Requesting the Service | nvarchar | 8 | 0 | | |
| 13 | TN2KUM05 | IS-H*MED: Process cumulative finding | 3 | ANFOE | IS-H: Nursing Organizational Unit Requesting the Service | nvarchar | 8 | 0 | | |
| 14 | TN2KUM06 | IS-H*MED: Assignment of cumulative finding to doc. category | 3 | ANFOE | IS-H: Nursing Organizational Unit Requesting the Service | nvarchar | 8 | 0 | | |
| 15 | TN2KUM07 | IS-H*MED: Assignm. of service groups for cumulative findings | 3 | ANFOE | IS-H: Nursing Organizational Unit Requesting the Service | nvarchar | 8 | 0 | | |
| TOPPatient Accounting |
| 16 | NGLT | IS-H: Intermediate table for service statistics | 17 | ANFOE | Departmental Organizational Unit That Requests the Service | nvarchar | 8 | 0 | | |
| 17 | NLCO | IS-HCO: Transfer information | 11 | ANFOE | Departmental Organizational Unit That Requests the Service | nvarchar | 8 | 0 | | |
| 18 | NLEV | IS-H: Preliminary entered services | 35 | ANFOE | Departmental Organizational Unit That Requests the Service | nvarchar | 8 | 0 | | |
| 19 | NMATO | IS-H: Material requisition by nurse station | 10 | ANFOE | IS-H: Departmental Org. Unit Requesting Material | nvarchar | 8 | 0 | | |
| 20 | NMATP | IS-H: Material planned for case | 12 | ANFOE | Departmental Organizational Unit That Requests the Service | nvarchar | 8 | 0 | | |
| 21 | NMATV | IS-H: Material Entered for Case | 13 | ANFOE | Departmental Organizational Unit That Requests the Service | nvarchar | 8 | 0 | | |
| 22 | NMCO | IS-H MM: CO Transfer Information | 4 | ANFOE | Departmental Organizational Unit That Requests the Service | nvarchar | 8 | 0 | | |
| 23 | NSL2 | IS-H: Online error records of service statistics | 17 | ANFOE | Departmental Organizational Unit That Requests the Service | nvarchar | 8 | 0 | | |
| 24 | NSLF | IS-H: Error records of service statistics | 17 | ANFOE | Departmental Organizational Unit That Requests the Service | nvarchar | 8 | 0 | | |
| 25 | NTPP | IS-H: Planned Values Per Service and Org. Unit | 5 | ANFOE | Departmental Organizational Unit That Requests the Service | nvarchar | 8 | 0 | | |
| 26 | NVBRP | IS-H: Billing document item data | 64 | ANFOE | IS-H: OU with Departmental Responsibility for Case | nvarchar | 8 | 0 | | |
| TOPPatient Management |
| 27 | N1ANF | IS-H*MED: Request | 5 | ANFOE | Departmental Organizational Unit That Requests the Service | nvarchar | 8 | 0 | | |
| 28 | NLEI | IS-H: Services Performed | 10 | ANFOE | Departmental Organizational Unit That Requests the Service | nvarchar | 8 | 0 | | |
| TOPSAP Healthcare - Industry-Specific Components for Hospitals |
| 29 | /ISHFR/TNGAPH | IS-H FR: Supplements (Header Data) | 7 | ANFOE | Departmental Organizational Unit That Requests the Service | nvarchar | 8 | 0 | | |
| 30 | /ISHFR/TNGAPP | IS-H FR: Supplements (Item Data) | 7 | ANFOE | Departmental Organizational Unit That Requests the Service | nvarchar | 8 | 0 | | |
| 31 | NCH42 | IS-H CH: Service Rules Service Maximum Values | 9 | ANFOE | Departmental Organizational Unit That Requests the Service | nvarchar | 8 | 0 | | |
| 32 | NCH43 | IS-H CH: Leistungsregeln Zuschlagsleistungen | 6 | ANFOE | IS-H: utà org. medico-specialistica richiedente prestazione | nvarchar | 8 | 0 | | |
| 33 | NCH43A | IS-H CH: Rollenumschlüsselung für Arztzuordnungen | 6 | ANFOE | IS-H: utà org. medico-specialistica richiedente prestazione | nvarchar | 8 | 0 | | |
| 34 | NWCHLCOEA | IS-HCO: Überleitungsinformationen | 12 | ANFOE | IS-H: utà org. medico-specialistica richiedente prestazione | nvarchar | 8 | 0 | | |
| 35 | NWCHLS_RNLSR | IS-H CH: ALIS-Fehlerhandlung - Leistungen (RNLSR) | 17 | ANFOE | IS-H: utà org. medico-specialistica richiedente prestazione | nvarchar | 8 | 0 | | |
| 36 | TNA40Z | IS-H AT: Zeiten für Zuschlagsleistungen | 5 | ANFOE | IS-H: Fachliche Org.einheit, die die Leistung anfordert | nvarchar | 8 | 0 | | |
| 37 | TNCH51 | IS-H CH: Billing Agreement Items | 11 | ANFOE | Departmental Organizational Unit That Requests the Service | nvarchar | 8 | 0 | | |
| 38 | TNCH52 | IS-h CH: Determination of Billing Agreements | 12 | ANFOE | Departmental Organizational Unit That Requests the Service | nvarchar | 8 | 0 | | |
| 39 | TNCH60 | IS-H CH: Times for Surcharge Services | 5 | ANFOE | Departmental Organizational Unit That Requests the Service | nvarchar | 8 | 0 | | |
| 40 | TNEO_CHARFAC_DET | IS-H: Charge Factor Value Determination for External Orders | 9 | ANFOE | Departmental Organizational Unit That Requests the Service | nvarchar | 8 | 0 | | |
| 41 | TNEO_FEEDIST_DET | IS-H: External Orders - Determine Fee Breakdown Code | 11 | ANFOE | Departmental Organizational Unit That Requests the Service | nvarchar | 8 | 0 | | |
| 42 | TNWCH103 | Fees: Determination of Breakdown Code | 13 | ANFOE | Departmental Organizational Unit That Requests the Service | nvarchar | 8 | 0 | | |
| 43 | TNWCH80 | IS-H CH: Charge Factor Value Determination | 8 | ANFOE | Departmental Organizational Unit That Requests the Service | nvarchar | 8 | 0 | | |
| 44 | TNWCH82 | IS-H CH: Punktwertermittlung für TARMED-Leistungen | 8 | ANFOE | IS-H: utà org. medico-specialistica richiedente prestazione | nvarchar | 8 | 0 | | |
| 45 | TNWCH83 | Ermittlung der Baserate | 10 | ANFOE | IS-H: Fachliche Org.einheit, die die Leistung anfordert | nvarchar | 8 | 0 | | |
| 46 | TNWCHCO | IS-H: Aufträge bestimmen für Überleitung ins CO | 5 | ANFOE | IS-H: utà org. medico-specialistica richiedente prestazione | nvarchar | 8 | 0 | | |
| 47 | TNWCHEA11 | IS-H CH: Punktwertermittlung für Externe Aufträge | 8 | ANFOE | IS-H: utà org. medico-specialistica richiedente prestazione | nvarchar | 8 | 0 | | |
| 48 | TNWCHEA12 | Determine Fee Breakdown Code for Transfer of Ext. Order | 11 | ANFOE | Departmental Organizational Unit That Requests the Service | nvarchar | 8 | 0 | | |
| 49 | TNWCHFEEPHYS | Service Rule Fee Physician for Fee-Based Services | 8 | ANFOE | Departmental Organizational Unit That Requests the Service | nvarchar | 8 | 0 | | |
| 50 | TNWCHIVTOE | IS-H CH: Zuordnung Fachl. OE zu Tages- und Fallpauschale | 3 | ANFOE | IS-H: utà org. medico-specialistica richiedente prestazione | nvarchar | 8 | 0 | | |
| 51 | TNWCHTMABRMAT | IS-H CH: TARMED - Leistungsregel Abrechenbarkeit Materialien | 8 | ANFOE | IS-H: utà org. medico-specialistica richiedente prestazione | nvarchar | 8 | 0 | | |
| 52 | TNWCH_AL_EXTRA | IS-H CH: ANALYSE - Leistungsregeln Zuschlagsleistungen | 7 | ANFOE | IS-H : unité org. spécialisée demandant la prestation | nvarchar | 8 | 0 | | |
| 53 | TNWCH_DRG_ACC | Swiss-DRG - Bewertungsrelation für Erlösabgrenzung | 3 | ANFOE | IS-H: Fachliche Org.einheit, die die Leistung anfordert | nvarchar | 8 | 0 | | |
