| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPClinical System |
1 | N1PRPAT | IS-H*MED: PATREG: Patientenstammdatentabelle | 6 | NNAME | IS-H: Hastanin soyadi | nvarchar | 30 | 0 | | |
2 | N1PRPIX | IS-H*MED: PATREG: Tabelle für phonetische Suche | 4 | NNAME | IS-H: Hastanin soyadi | nvarchar | 30 | 0 | | |
3 | N1PRTMPPAT | IS-H*MED: PATREG: Temporäre Patientenstammdatentabelle | 7 | NNAME | IS-H: Hastanin soyadi | nvarchar | 30 | 0 | | |
4 | N1PRTMPPATLOC | IS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal | 7 | NNAME | IS-H: Hastanin soyadi | nvarchar | 30 | 0 | | |
5 | N2DSDEVICE_ARCH | ISHMED: Archive Transfer Data from Interfaces | 8 | NNAME | Patient Last Name | nvarchar | 30 | 0 | | |
6 | N2DSDEVICE_DATA | ISHMED: Transfer Data from Interface | 8 | NNAME | Patient Last Name | nvarchar | 30 | 0 | | |
TOPCompany Pension Scheme Germany |
7 | P01RBM_IM01 | Notification Data IM01 Pension Receipt Notif. Answer Tax ID | 7 | NNAME | Family Name | nvarchar | 45 | 0 | | |
8 | P01RBM_MI01 | Notification Data MI01 Pension Receipt Notif. Query Tax ID | 19 | NNAME | Family Name | nvarchar | 45 | 0 | | |
9 | P01RBM_MI01R | Confirmation MI01 Pension Receipt Notification Query Tax ID | 19 | NNAME | Family Name | nvarchar | 45 | 0 | | |
10 | P01RBM_MZ01 | Reporting Data MZ01 Pension Receipt Notification | 24 | NNAME | Family Name | nvarchar | 45 | 0 | | |
11 | P01RBM_MZ01R | Confirmation MZ01 Pension Receipt Notification | 24 | NNAME | Family Name | nvarchar | 45 | 0 | | |
12 | PA0747 | HR Master Record for Infotype 0747 | 25 | NNAME | Last Name of Child | nvarchar | 35 | 0 | | |
TOPContract Accounts Receivable and Payable |
13 | DFKKCMP2P | Manually Issued Checks Lot: Two Party Checks Data | 5 | NNAME | Name field 1 (name1/last name) | nvarchar | 40 | 0 | | |
14 | DFKKCR2P | Check Repository: Additional Payees | 10 | NNAME | Name field 1 (name1/last name) | nvarchar | 40 | 0 | | |
15 | DFKKCRDEL2P | CR: Deleted Payment Medium / Payee Data | 13 | NNAME | Name field 1 (name1/last name) | nvarchar | 40 | 0 | | |
16 | DFK_NORM_BP | Normalized Data for Duplicate Search for Business Partner | 3 | NNAME | Normalized Name for Duplicate Search | nvarchar | 80 | 0 | | |
TOPPatient Accounting |
17 | NEHC_E111 | IS-H: European Health Insurance Card | 6 | NNAME | IS-H: EHIC - Patient's Last Name | nvarchar | 40 | 0 | | |
TOPPatient Management |
18 | NPAP | IS-H: Provisional Patient Master Data | 3 | NNAME | Patient Last Name | nvarchar | 30 | 0 | | |
19 | NPAPIX | IS-H: Preregistered Patient Name Index | 4 | NNAME | Patient Last Name | nvarchar | 30 | 0 | | |
20 | NPAT | IS-H: Patient Master Data (General) | 5 | NNAME | Patient Last Name | nvarchar | 30 | 0 | | |
21 | NPIX | IS-H: Patient name index | 4 | NNAME | Patient Last Name | nvarchar | 30 | 0 | | |
22 | NTMN | IS-H: Patient-Specific Appointments (Header Table for NAPP) | 15 | NNAME | Patient Last Name | nvarchar | 30 | 0 | | |
23 | NWAN | IS-H: Bad Debt Parties | 4 | NNAME | Last Name of Bad Debt Party | nvarchar | 30 | 0 | | |
TOPProduction Campaign |
24 | PCMO4 | Production campaign pegged reqmt resource network | 10 | NNAME | Resource network name | nvarchar | 10 | 0 | | |
TOPPublic Sector |
25 | P01ZFA_NN_KIDS | ZfA: Notifications Not Assigned - Child Data | 11 | NNAME | Last Name of Child Allowance Beneficiary | nvarchar | 40 | 0 | | |
TOPSAP Ambulatory Care Management |
26 | NREDOMA | IS-H: Table Renewable Documents - Header Data | 29 | NNAME | Patient Last Name | nvarchar | 30 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
27 | NEHIC | IS-H: European Health Insurance Card | 5 | NNAME | IS-H: EHIC - Patient's Last Name | nvarchar | 40 | 0 | | |
28 | NPNTCAS | IS-H: Patient Master Data at Case Level (CV IT) | 4 | NNAME | Patient Last Name | nvarchar | 30 | 0 | | |
29 | NPSPAT | IS-H: Pseudonymized Patient Master Data (General) | 4 | NNAME | Patient Last Name | nvarchar | 30 | 0 | | |
30 | NPSPIX | IS-H: Index of Pseudonymized Patient Names | 4 | NNAME | Patient Last Name | nvarchar | 30 | 0 | | |
31 | NVVN | IS-H: Guarantors | 10 | NNAME | Last Name of Guarantor | nvarchar | 35 | 0 | | |
TOPWithout Description |
32 | RSROLEHIERARCHY | Role hierarchy | 2 | NNAME | Name of the hierarchy node | nvarchar | 32 | 0 | | |