| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | NNL_ZH308_V9_R04 | ZH308 V09 Record04 Soll Daten | 19 | EXTNR | | nvarchar | 6 | 0 | | |
2 | NNL_ZH308_V9_R06 | ZH308 V09 Record06 Soll Daten | 18 | EXTNR | | nvarchar | 6 | 0 | | |
3 | NNL_ZH308_V9_R16 | ZH308 V09 Record16 Soll Daten | 18 | EXTNR | | nvarchar | 6 | 0 | | |
4 | TNNL_CBVCARETYPE | CBV Sorgetyp | 3 | EXTNR | IS-H: Alternative Identifikation einer Tarifposition | nvarchar | 12 | 0 | | |
5 | TNNL_CBVCLINDAYS | CBV Pflegetage | 3 | EXTNR | IS-H: Alternative Identifikation einer Tarifposition | nvarchar | 12 | 0 | | |
6 | TNNL_CBV_AGE | CBV Alter | 3 | EXTNR | IS-H: Alternative Identifikation einer Tarifposition | nvarchar | 12 | 0 | | |
7 | TNNL_CBV_CONTACT | CBV Kontakt Typ | 3 | EXTNR | IS-H: Alternative Identifikation einer Tarifposition | nvarchar | 12 | 0 | | |
8 | TNNL_CBV_GENDER | CBV Geschlecht | 3 | EXTNR | IS-H: Alternative Identifikation einer Tarifposition | nvarchar | 12 | 0 | | |
9 | TNNL_CBV_MAINACT | CBV Hauptaktivität | 3 | EXTNR | IS-H: Alternative Identifikation einer Tarifposition | nvarchar | 12 | 0 | | |
10 | TNNL_CBV_SPEM | CBV Spezialgebiet | 3 | EXTNR | IS-H: Alternative Identifikation einer Tarifposition | nvarchar | 12 | 0 | | |
11 | TNNL_CBV_TYP_ACT | CBV Leistungs Typ Gruppe | 3 | EXTNR | IS-H: Alternative Identifikation einer Tarifposition | nvarchar | 12 | 0 | | |
12 | TNRT3 | Test no.ranges:with,w/o subobj.;indep.grp; 2 no.range fields | 3 | EXTNR | Number range number | nvarchar | 2 | 0 | | |
13 | TNRT6 | Test no.ranges:with,w/o subobj.;indep.grp; 2 no.range fields | 3 | EXTNR | Number range number | nvarchar | 2 | 0 | | |
14 | TNRT8 | Test no.ranges:with subobject;dep.group;2 no.range fields | 4 | EXTNR | Number range number | nvarchar | 2 | 0 | | |
15 | TNRT8A | Test no.ranges:with subobject;dep.group;2 no.range fields | 4 | EXTNR | Number range number | nvarchar | 2 | 0 | | |
16 | VIXCESM180DEC | Modelo 180 - Witholding Tax Declarer Line 01 | 18 | EXTNR | External ID Number of Tax Return | nvarchar | 13 | 0 | | |
17 | PIQDBAGM_EXT | Transfer Regulations: External Acad. Achievements | 3 | EXTNR | Sequence Number of External Academic Achievement | nvarchar | 3 | 0 | | |
TOPBasic Data |
18 | NC301 | IS-HCM: Order Table Data Transmission for EDI | 30 | EXTNR | IS-H: External Patient Identification | nvarchar | 20 | 0 | | |
19 | NC301S | IS-HCM: EDI Status Management | 46 | EXTNR | IS-H: External Patient Identification | nvarchar | 20 | 0 | | |
20 | NC301T | IS-H EDI Temporary Storage for Old EDI Msg. Status Records | 46 | EXTNR | IS-H: External Patient Identification | nvarchar | 20 | 0 | | |
TOPClinical System |
21 | N1PRPAT | IS-H*MED: PATREG: Patientenstammdatentabelle | 51 | EXTNR | IS-H: Harici hasta taniticisi | nvarchar | 20 | 0 | | |
22 | N1PRTMPPAT | IS-H*MED: PATREG: Temporäre Patientenstammdatentabelle | 52 | EXTNR | IS-H: Harici hasta taniticisi | nvarchar | 20 | 0 | | |
23 | N1PRTMPPATLOC | IS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal | 52 | EXTNR | IS-H: Harici hasta taniticisi | nvarchar | 20 | 0 | | |
24 | NDOCA | IS-H*MED: Document Management Data for Archived Documents | 49 | EXTNR | IS-H: External Medical Record/Document ID | nvarchar | 15 | 0 | | |
25 | NDOCSTORNO | IS-H*MED: Canceled Documents | 50 | EXTNR | IS-H: External Medical Record/Document ID | nvarchar | 15 | 0 | | |
TOPDefault Risk and Limit System |
26 | KLZUEXTOBJ | Assignment of External Administration Key to Object Number | 4 | EXTNR | External Administration Number | nvarchar | 40 | 0 | | |
TOPDistributor-Reseller-Management |
27 | /SAPHT/DRMCSADRV | DRM: Sales Area derivation | 3 | EXTNR | Additional data, e.g. ILN or D&B no. | nvarchar | 70 | 0 | | |
TOPOverhead Cost Controlling |
28 | CSKR | Resource master record | 11 | EXTNR | Base Planning Object (External Number) | nvarchar | 18 | 0 | | |
TOPOverhead Cost Orders |
29 | COBRB | Distribution Rules Settlement Rule Order Settlement | 56 | EXTNR | Distribution Rule Number | nvarchar | 3 | 0 | | |
TOPPatient Accounting |
30 | NEHC_PAT | IS-H: Health Insurance Card (Patient Data) | 51 | EXTNR | IS-H: External Patient Identification | nvarchar | 20 | 0 | | |
31 | NTPK | IS-H: Header Data of Service Item | 7 | EXTNR | IS-H: Alternative Identification of Service Catalog Item | nvarchar | 12 | 0 | | |
32 | NTPV | IS-H: Assign Service to Base Planning Object | 8 | EXTNR | Base Planning Object (External Number) | nvarchar | 18 | 0 | | |
TOPPatient Management |
33 | NDOC | IS-H: Assignment of IS-H Objects to Documents in DMS | 49 | EXTNR | IS-H: External Medical Record/Document ID | nvarchar | 15 | 0 | | |
34 | NPAP | IS-H: Provisional Patient Master Data | 15 | EXTNR | IS-H: External Patient Identification | nvarchar | 20 | 0 | | |
35 | NPAT | IS-H: Patient Master Data (General) | 42 | EXTNR | IS-H: External Patient Identification | nvarchar | 20 | 0 | | |
36 | NTMN | IS-H: Patient-Specific Appointments (Header Table for NAPP) | 6 | EXTNR | IS-H: External Patient Identification | nvarchar | 20 | 0 | | |
37 | NWAN | IS-H: Bad Debt Parties | 27 | EXTNR | IS-H: External Patient Identification | nvarchar | 20 | 0 | | |
TOPProduct Cost Planning |
38 | CKBS | Base Planning Object - Unit Costing | 3 | EXTNR | Base Planning Object (External Number) | nvarchar | 18 | 0 | | |
39 | CKBT | Texts for CKBS | 3 | EXTNR | Base Planning Object (External Number) | nvarchar | 18 | 0 | | |
40 | CKHS | Header: Unit Costing (Control + Totals) | 61 | EXTNR | Base Planning Object (External Number) | nvarchar | 18 | 0 | | |
41 | CKIS | Items Unit Costing/Itemization Product Costing | 27 | EXTNR | Base Planning Object (External Number) | nvarchar | 18 | 0 | | |
42 | CKPS | Unit Costing Items | 19 | EXTNR | Base Planning Object (External Number) | nvarchar | 18 | 0 | | |
TOPPurchasing |
43 | EREV | Version in Purchasing | 17 | EXTNR | External Change Number of Version | nvarchar | 20 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
44 | ISH_HCF_HEADER | Header for Index Table | 8 | EXTNR | IS-H: External Patient Identification | nvarchar | 20 | 0 | | |
45 | ISH_IDX_HEADER | Header for Index Table | 9 | EXTNR | IS-H: External Patient Identification | nvarchar | 20 | 0 | | |
46 | NLDBC_TRJ_LEIST | IS-H NL: Traject Leistungen | 3 | EXTNR | Verrichting binnen een verrichtingencatalogus | nvarchar | 10 | 0 | | |
47 | NLDBC_ZW_SPEC | IS-H NL: DBC leistungs gewicht kategorie pro fachrichtung | 3 | EXTNR | Verrichting binnen een verrichtingencatalogus | nvarchar | 10 | 0 | | |
48 | NTPKCH | IS-H CH: Zusatzfelder Leistungsstamm Schweiz (TARMED) | 37 | EXTNR | IS-H CH: codice prestazione est. (MEDIDATA) | nvarchar | 20 | 0 | | |
TOPTariffs, Duties and Permits |
49 | OIH30H | Tracking header | 12 | EXTNR | External tracking number | nvarchar | 18 | 0 | | |
TOPWaste Management |
50 | EWA_WA_WEIGHOFFL | Offline Weighing | 4 | EXTNR | External Number for Offline Weighing | nvarchar | 20 | 0 | | |