| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P01BN_STAT | Status Table for Contribution Statements | 28 | BTRNR | Company Number | nvarchar | 8 | 0 | | |
TOPConstruction Industry |
2 | PA0190 | HR Master Data Record Infotype 0190 (BuildingTradePrevERDat) | 25 | BTRNR | Previous Employer Company Number for Suppl. Pension Fund | nvarchar | 8 | 0 | | |
TOPGermany |
3 | T5D11 | Calculation Procedures and Indicators of Health Ins. Funds | 7 | BTRNR | Company Number | nvarchar | 8 | 0 | | |
4 | T5D1K | Branch Offices | 15 | BTRNR | Company Number | nvarchar | 8 | 0 | | |
5 | T5D3E | Reduced Hours Compensation/Seasonal RHC: Approval Periods | 6 | BTRNR | Company Number for Reduced Hours/Seasonal Reduced Hours | nvarchar | 8 | 0 | | |
6 | T5D3S_EHVE | Additional Data: Reporting Company for Earnings Survey | 6 | BTRNR | Statistics - Company Number for Earnings Survey | nvarchar | 9 | 0 | | |
7 | T5D4T | HIF Receiving Office for the E-Mail Procedure | 3 | BTRNR | Company Number | nvarchar | 8 | 0 | | |
8 | T5D4U | File Numbers for E-Mail Procedure with Health Ins. Funds | 6 | BTRNR | Company Number | nvarchar | 8 | 0 | | |
9 | T5D4V | E-Mail Procedure Contribution Statement: Admin. of Seq. Nos | 10 | BTRNR | Company Number | nvarchar | 8 | 0 | | |
10 | T5D4W | HIF Receiving Office for E-Mail Procedure (Forwarding) | 4 | BTRNR | Company Number | nvarchar | 8 | 0 | | |
11 | T5D4X | Administration CoNo Certificates E-Mail Procedure | 3 | BTRNR | B2A: Company Number of Employer | nvarchar | 8 | 0 | | |
12 | T5D4X_STAT | Status - Admin. Contrib. Statmt Certificates E-Mail Proc. | 3 | BTRNR | B2A: Company Number of Employer | nvarchar | 8 | 0 | | |
13 | T5D4X_ZERTR | Certificate Request - Admin. Contrib. Statmt Certificates | 3 | BTRNR | B2A: Company Number of Employer | nvarchar | 8 | 0 | | |
TOPPayroll |
14 | T5T1J | Health insurance institutions | 13 | BTRNR | Corporation name | nvarchar | 8 | 0 | | |
15 | T5T1K | Health insurance institutions | 15 | BTRNR | Corporation name | nvarchar | 8 | 0 | | |
16 | T7SK1K | Health insurance institutions | 16 | BTRNR | Corporation name | nvarchar | 8 | 0 | | |
TOPSocial Insurance |
17 | P01BD_STAT | Data Module Alternative Correspondence Address | 16 | BTRNR | Company Number | nvarchar | 8 | 0 | | |
18 | P01BM_STAT | Control Records for PPO DEUEV Notifications | 20 | BTRNR | Company Number | nvarchar | 8 | 0 | | |
19 | P01BV_STAT | Status Table for PPO Contribution Collect. Notif. Procedure | 19 | BTRNR | Company Number | nvarchar | 8 | 0 | | |
20 | P01D3_DSAP | DEUEV Confirmation: Control Record for Notifications | 12 | BTRNR | Company Number | nvarchar | 8 | 0 | | |
21 | P01DS_STAT | Control Records for DEUEV Immediate Notifications | 20 | BTRNR | Company Number | nvarchar | 8 | 0 | | |
22 | P01EA_STAT | Status Table for Reimbursement Process | 17 | BTRNR | Company Number | nvarchar | 8 | 0 | | |
23 | P01EE_STAT | Admin. Records for Data Exchange for Compensation Benefits | 18 | BTRNR | Company Number | nvarchar | 8 | 0 | | |
24 | P01EL_PROT | Log Table for the ELENA Procedure | 6 | BTRNR | Company Number | nvarchar | 8 | 0 | | |
25 | P01EL_STAT | Status Table for the ELENA Notification Procedure | 17 | BTRNR | Company Number | nvarchar | 8 | 0 | | |
26 | P01SV_B2ATRNS | Status Table Transfer to Social Insurance Agency | 9 | BTRNR | Company Number | nvarchar | 8 | 0 | | |
27 | P01SV_MLDTRNS | Assignment of Notifications to File Counters | 6 | BTRNR | Company Number | nvarchar | 8 | 0 | | |
28 | P01ZS_STAT | Status Table for Paying Office Procedure | 17 | BTRNR | Company Number | nvarchar | 8 | 0 | | |
29 | T5D31 | Professionals Pension Organization (PPO) | 6 | BTRNR | Company Number of Professional Pension Scheme | nvarchar | 8 | 0 | | |
TOPSouth Africa |
30 | T5W1K | Pension Funds and Medical Aid Schemes (RSA) | 18 | BTRNR | Company number | nvarchar | 8 | 0 | | |
31 | T5W1M | Social insurance companies | 10 | BTRNR | Company number | nvarchar | 8 | 0 | | |