| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P01BN_BWXX | Data Record: Contribution Statement | 69 | ORT | Location of Employer | nvarchar | 25 | 0 | | |
2 | ZGVB | GVB Schadensdb Data | 9 | ORT | | nvarchar | 60 | 0 | | |
TOPBasic Data |
3 | NC301P | IS-H EDI Data Collection Points | 14 | ORT | IS-H: City of Business Partner | nvarchar | 25 | 0 | | |
4 | NGPA | IS-H: Business Partners | 22 | ORT | IS-H: City of Business Partner | nvarchar | 25 | 0 | | |
5 | NORG | IS-H: Organizational Units | 12 | ORT | City | nvarchar | 25 | 0 | | |
6 | TN01 | IS-H: Institutions | 9 | ORT | City | nvarchar | 25 | 0 | | |
TOPClinical System |
7 | N1DOKEMPF | IS-H*MED: Recipient of the Documents | 20 | ORT | IS-H: City | nvarchar | 40 | 0 | | |
8 | N1PRPAT | IS-H*MED: PATREG: Patientenstammdatentabelle | 39 | ORT | IS-H: Kent | nvarchar | 40 | 0 | | |
9 | N1PRTMPPAT | IS-H*MED: PATREG: Temporäre Patientenstammdatentabelle | 40 | ORT | IS-H: Kent | nvarchar | 40 | 0 | | |
10 | N1PRTMPPATLOC | IS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal | 40 | ORT | IS-H: Kent | nvarchar | 40 | 0 | | |
11 | N2DLV_RECEIVER | i.s.h.med: Dispatch - Recipient | 17 | ORT | IS-H: City of Business Partner | nvarchar | 25 | 0 | | |
12 | N2MV_DISREQ | Dispatch Request Data Table | 23 | ORT | Dispatch Control: City | nvarchar | 40 | 0 | | |
13 | N2MV_VSDAT | Recipient Data Table | 22 | ORT | Dispatch Control: City | nvarchar | 40 | 0 | | |
TOPCompany Pension Scheme Germany |
14 | P01RBM_IM01 | Notification Data IM01 Pension Receipt Notif. Answer Tax ID | 23 | ORT | City | nvarchar | 72 | 0 | | |
15 | P01RBM_MI01 | Notification Data MI01 Pension Receipt Notif. Query Tax ID | 35 | ORT | City | nvarchar | 72 | 0 | | |
16 | P01RBM_MI01R | Confirmation MI01 Pension Receipt Notification Query Tax ID | 35 | ORT | City | nvarchar | 72 | 0 | | |
TOPDenmark |
17 | T5M8T | Danish Postal Codes | 4 | ORT | City | nvarchar | 25 | 0 | | |
TOPFunds Management |
18 | FMFCTR | Funds Center Master Record | 30 | ORT | City | nvarchar | 35 | 0 | | |
TOPGermany |
19 | PD3DBAN | HR-DDU: Address Data Module | 7 | ORT | City | nvarchar | 34 | 0 | | |
20 | T5D4X_ZERTR | Certificate Request - Admin. Contrib. Statmt Certificates | 17 | ORT | City | nvarchar | 40 | 0 | | |
TOPPatient Management |
21 | NADR | IS-H: Addresses (Central Address Management) | 7 | ORT | IS-H: City | nvarchar | 40 | 0 | | |
22 | NPAT | IS-H: Patient Master Data (General) | 30 | ORT | IS-H: City where Patient Resides | nvarchar | 25 | 0 | | |
23 | NWAN | IS-H: Bad Debt Parties | 14 | ORT | IS-H: City where Bad Debt Party Resides | nvarchar | 25 | 0 | | |
TOPPeriodical Sales and Distribution |
24 | JKTWBZIN | IS-M/SD: Clipboard for WBZ Records for Processing | 39 | ORT | IS-M: WBZ, city | nvarchar | 25 | 0 | | |
25 | JKTWBZOUT | IS-M/SD: Clipboard for Processed WBZ Records | 27 | ORT | IS-M: WBZ, city | nvarchar | 25 | 0 | | |
TOPSAP Ambulatory Care Management |
26 | NKTR_KV | IS-H: Ins. Prov. Master acc. to Fed. PPA from PPA Bill.Syst. | 12 | ORT | IS-H: City | nvarchar | 40 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
27 | TNNL3 | IS-H NL: Dutch cities LMR | 3 | ORT | IS-H: City where Patient Resides | nvarchar | 25 | 0 | | |
TOPSAP Media |
28 | J_1SPUPBESTAND | IS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet | 7 | ORT | IS-M: City Number (Unique) | nvarchar | 8 | 0 | | |
TOPSocial Insurance |
29 | P01BD_DBKA | Data Module Different Correspondence Address | 7 | ORT | Company City | nvarchar | 34 | 0 | | |
30 | P01BD_DSBD | Business Data Maintenance Data Record | 19 | ORT | Company City | nvarchar | 34 | 0 | | |
31 | P01BM_DBAN | Address Data Modules for PPO DEUEV Notifications | 5 | ORT | City | nvarchar | 34 | 0 | | |
32 | P01D3_DBAN | DEUEV Confirmation: Address Data Module | 5 | ORT | City | nvarchar | 34 | 0 | | |
33 | P01DS_DBAN | Data Modules Address of DEUEV Immediate Notifications | 5 | ORT | City | nvarchar | 34 | 0 | | |
34 | P01EE_DBAN | Data Module DBAN Address | 5 | ORT | City | nvarchar | 34 | 0 | | |
35 | P01EL_DBAN | Data Module Address of ELENA Notifications | 5 | ORT | City of Residence | nvarchar | 34 | 0 | | |
TOPStatements |
36 | P01W_DBAN | Data Module: Address | 9 | ORT | City | nvarchar | 34 | 0 | | |
TOPTravel Planning |
37 | TA21PH | Customer-Specific Hotel Catalog | 12 | ORT | Hotel location | nvarchar | 30 | 0 | | |