| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2RB_PENS | Pensioner's data (B) | 35 | INSTN | Registration number institution | nvarchar | 6 | 0 | | |
2 | T521T | Institution Texts - No longer used | 4 | INSTN | Institution key | nvarchar | 5 | 0 | | |
TOPBasic Data |
3 | NC301 | IS-HCM: Order Table Data Transmission for EDI | 7 | INSTN | IS-H: Institute Indicator | nvarchar | 10 | 0 | | |
4 | NC301S | IS-HCM: EDI Status Management | 7 | INSTN | IS-H: Institute Indicator | nvarchar | 10 | 0 | | |
5 | NC301T | IS-H EDI Temporary Storage for Old EDI Msg. Status Records | 7 | INSTN | IS-H: Institute Indicator | nvarchar | 10 | 0 | | |
6 | NGPA | IS-H: Business Partners | 3 | INSTN | IS-H: Institute Indicator | nvarchar | 10 | 0 | | |
TOPBelgium |
7 | PA0504 | Pensioner's Advantage B | 40 | INSTN | Registration number institution | nvarchar | 6 | 0 | | |
TOPBusiness Partners |
8 | NIPR | Addnl HC-Specific Ins. Prov. Relatshp Data for SAP BP | 4 | INSTN | Institution | nvarchar | 4 | 0 | | |
9 | NPNT | Patient Master Data | 3 | INSTN | Institution | nvarchar | 4 | 0 | | |
TOPChile |
10 | T7CLIM | Pension Plan Institutions Mapping | 6 | INSTN | Pension Plan Institution Name | nvarchar | 3 | 0 | | |
TOPClinical System |
11 | NC321 | IS-H: Table for data exchange of §321 | 7 | INSTN | IS-H: Institute Indicator | nvarchar | 10 | 0 | | |
12 | TNCMSCO | IS-H: Scoring - Conversion of the HINR | 3 | INSTN | IS-H: Institute Indicator | nvarchar | 10 | 0 | | |
TOPMessages |
13 | DNOD_NOTIF_S | Notification: SAP Support Data | 5 | INSTN | SAP Installation Number | nvarchar | 10 | 0 | | |
14 | DNOD_UPDATE | Table for Updating Locked Notifications and Time Stamp | 5 | INSTN | SAP Installation Number | nvarchar | 10 | 0 | | |
TOPQuality Notifications |
15 | /SAPSMOSS/UPDATE | Table for Updating Locked Notifications and Time Stamp | 5 | INSTN | Installation number | nvarchar | 10 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
16 | NAKLF | IS-H AT: LKF - Kostenträger zu Landesfond | 3 | INSTN | IS-H AT: LKF - Kostenträger | nvarchar | 2 | 0 | | |
17 | NAPHF | IS-H AT: LKF - Punktehistorie zum Fall | 5 | INSTN | IS-H AT: LKF - Kostenträger | nvarchar | 2 | 0 | | |
18 | TNLMR1 | IS-H NL: LMR-instellingsnummer (WCC-code) | 3 | INSTN | IS-H: Instellingsteken | nvarchar | 10 | 0 | | |
19 | TNWATFCO | IS-H AT: ELDA Fehlercodes | 2 | INSTN | IS-H AT: LKF - Kostenträger | nvarchar | 2 | 0 | | |
20 | TNWATRDNOT | IS-H AT: ELDA Codes für Rückmeldung-Entlassung | 2 | INSTN | IS-H AT: LKF - Kostenträger | nvarchar | 2 | 0 | | |