| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPPatient Management |
1 | NPAT | IS-H: Patient Master Data (General) | 51 | AGPLZ | IS-H: Employer Postal Code | nvarchar | 10 | 0 | | |
2 | NVVP | IS-H: Patient-related insurance relationship | 30 | AGPLZ | Postal Code of Insured Person's Employer | nvarchar | 10 | 0 | | |
TOPSocial Insurance |
3 | P01EL_DBAG | Data Module Employer Details of ELENA Notifications | 7 | AGPLZ | Postal Code of Employer | nvarchar | 10 | 0 | | |
TOPTax |
4 | P01T_LST | ETStmt: General Employment Tax Data | 43 | AGPLZ | Employment Tax Statement: Employer's Postal Code | nvarchar | 5 | 0 | | |