| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /OTEI/OCR_TSTG | Staging table for HDCC download data | 20 | RVNUM | Char 20 | nvarchar | 20 | 0 | | |
| 2 | P2RD_SV | Payroll Result: Social Insurance | 12 | RVNUM | Pension Insurance Number | nvarchar | 12 | 0 | | |
| 3 | P2RT_SV | Structure SV - insurance CZ | 12 | RVNUM | Reserve | nvarchar | 12 | 0 | | |
| 4 | P2SK_SV | Structure of table SV - insurance SK | 12 | RVNUM | Reserve | nvarchar | 12 | 0 | | |
| 5 | PDPBSZVNAM_R | SPI Confirmation: Name (Record Type 80) | 12 | RVNUM | Pension Insurance Number | nvarchar | 12 | 0 | | |
| TOPClinical System |
| 6 | N1PRPAT | IS-H*MED: PATREG: Patientenstammdatentabelle | 57 | RVNUM | IS-H: Sosyal sigorta numarasi | nvarchar | 20 | 0 | | |
| 7 | N1PRTMPPAT | IS-H*MED: PATREG: Temporäre Patientenstammdatentabelle | 58 | RVNUM | IS-H: Sosyal sigorta numarasi | nvarchar | 20 | 0 | | |
| 8 | N1PRTMPPATLOC | IS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal | 58 | RVNUM | IS-H: Sosyal sigorta numarasi | nvarchar | 20 | 0 | | |
| TOPGermany |
| 9 | PA0013 | Infotype Social Insurance - Germany | 27 | RVNUM | Pension Insurance Number | nvarchar | 12 | 0 | | |
| TOPPatient Accounting |
| 10 | NEHC_PAT | IS-H: Health Insurance Card (Patient Data) | 37 | RVNUM | IS-H: Social Insurance Number | nvarchar | 20 | 0 | | |
| TOPPatient Management |
| 11 | NPAP | IS-H: Provisional Patient Master Data | 16 | RVNUM | IS-H: Social Insurance Number | nvarchar | 20 | 0 | | |
| 12 | NPAT | IS-H: Patient Master Data (General) | 55 | RVNUM | IS-H: Social Insurance Number | nvarchar | 20 | 0 | | |
| TOPPension Administration |
| 13 | PA0882 | HR Master Record for Infotype 0882 | 31 | RVNUM | Pension Insurance Number | nvarchar | 12 | 0 | | |
| TOPPersonnel Administration |
| 14 | PA0153 | Infotype 0153 - SI CZ | 27 | RVNUM | Reserve | nvarchar | 12 | 0 | | |
| 15 | PA0253 | Infotype 0253 - Insurance SK | 27 | RVNUM | Health insurance key for compulsory HI fund | nvarchar | 8 | 0 | | |
| TOPPersonnel Management |
| 16 | /BKC/S21_ANON | Sol21: Anonymisierungsfelder für Report /BKC/SOL21_KLON | 11 | RVNUM | Rentenversicherungsnummer | nvarchar | 12 | 0 | | |
| TOPPublic Sector |
| 17 | P01ZFA_NN_DATA | ZfA: Notifications Not Assigned | 16 | RVNUM | ZfA Bonus Number | nvarchar | 12 | 0 | | |
| 18 | PDPBSZVNAM | Name (Record Type 80), ZVE-PBS | 20 | RVNUM | Pension Insurance Number | nvarchar | 12 | 0 | | |
| TOPSAP Healthcare - Industry-Specific Components for Hospitals |
| 19 | NWAT_GIN_ERS | Status der e-Überweisung | 3 | RVNUM | IS-H: Sozialversicherungsnummer | nvarchar | 20 | 0 | | |
| TOPSocial Insurance |
| 20 | P01ZS_INFT | Administration of Master Data Status (Paying Office Proc.) | 22 | RVNUM | Pension Insurance Number | nvarchar | 12 | 0 | | |
