| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P01E2_MELD_ST | ELStAM: Status of Notifications for the Administrator | 7 | GTIME | ELStAM: Time of Creation/Change of Data Record | nvarchar | 6 | 0 | | |
2 | P01RBM_TRIN | ZfA: Manage PI Receipt of Notification | 9 | GTIME | Pension Receipt Notification: Time of Status Change | nvarchar | 6 | 0 | | |
3 | P01ZFA_TRIN | ZfA: Manage PI Receipt of Notification | 9 | GTIME | ZfA: Time at Which the Data Record Was Created or Changed | nvarchar | 6 | 0 | | |
4 | P05TPRNL_PR_OUT | Pension Return: PR - Output Data | 13 | GTIME | Creation/Change Hour | nvarchar | 6 | 0 | | |
5 | P05T_WCR_SIMU | WCR Simulation | 41 | GTIME | Creation/Change Hour | nvarchar | 6 | 0 | | |
6 | TGTB | Control table for table converter | 13 | GTIME | Time | nvarchar | 6 | 0 | | |
TOPABAP Authorization and Role Management |
7 | HRP1250 | DB table for infotype 1250 | 18 | GTIME | Generation Time | nvarchar | 6 | 0 | | |
TOPB2A Business to Administration |
8 | PB2ASTAT | HR-B2A: Status Management | 8 | GTIME | Creation/Change Time of Data Record | nvarchar | 6 | 0 | | |
9 | PC01B2A_SVEMSTAT | SI-Specific Storage E-Mails for Procedure for Returning Data | 8 | GTIME | Time | nvarchar | 6 | 0 | | |
TOPCompany Pension Scheme Germany |
10 | P01RBM_HIST | Notification Status: Pension Receipt Notifications | 6 | GTIME | Pension Receipt Notification: Time of Status Change | nvarchar | 6 | 0 | | |
11 | P01RBM_STAT | Notification Status: Pension Receipt Notifications | 12 | GTIME | Pension Receipt Notification: Time of Status Change | nvarchar | 6 | 0 | | |
12 | P01RBM_STAT_R | Status of Confirmations (Pension Receipt Notifications) | 12 | GTIME | Pension Receipt Notification: Time of Status Change | nvarchar | 6 | 0 | | |
13 | P01RBM_TRANS | RBM: Status Table for Transfer | 7 | GTIME | Pension Receipt Notification: Time of Status Change | nvarchar | 6 | 0 | | |
14 | P01VA_STAT | PEP: Status of Pension Equalization Payment | 7 | GTIME | PEP: Time of Status Change | nvarchar | 6 | 0 | | |
TOPConstruction Industry |
15 | PDBKBESUM | Constr. Ind. Social Fund Procedure: BEMEL Records (Total) | 41 | GTIME | Local Time | nvarchar | 6 | 0 | | |
TOPGermany |
16 | T5D4U | File Numbers for E-Mail Procedure with Health Ins. Funds | 9 | GTIME | Time | nvarchar | 6 | 0 | | |
TOPOrganizational Management |
17 | HRP1016 | Infotype 1016 DB Table | 18 | GTIME | Generation Time | nvarchar | 6 | 0 | | |
18 | HRP1220 | DB Table for Infotype 1220 Activity Profile | 18 | GTIME | Generation Time | nvarchar | 6 | 0 | | |
19 | HRP1221 | DB Table for Infotype 1221 Excluded Activities | 18 | GTIME | Generation Time | nvarchar | 6 | 0 | | |
20 | HRPADD3 | Additional Data PADD3 | 6 | GTIME | Generation Time | nvarchar | 6 | 0 | | |
TOPProfile Maintenance |
21 | TPFHS | Prototype: Profile header, administration data for profiles | 11 | GTIME | Time part last profile generation | nvarchar | 6 | 0 | | |
22 | TPFHT | Profile header, administration data for profiles in DB | 11 | GTIME | Time part last profile generation | nvarchar | 6 | 0 | | |
TOPPublic Sector |
23 | P01ZFA_NN_STATUS | ZfA: Status Management for ZKNN Notifications | 7 | GTIME | ZfA: Time at Which the Data Record Was Created or Changed | nvarchar | 6 | 0 | | |
24 | P01ZFA_STATUS | ZfA: Status Management for Notifications | 8 | GTIME | ZfA: Time at Which the Data Record Was Created or Changed | nvarchar | 6 | 0 | | |
25 | P01ZFA_TRANS | ZfA: Status Table for Transfer | 7 | GTIME | ZfA: Time at Which the Data Record Was Created or Changed | nvarchar | 6 | 0 | | |
TOPReporting |
26 | P05TPRNL_EE_ADMS | Pension Return: Admin of Status Income Relationship - Pers L | 16 | GTIME | Creation/Change Hour | nvarchar | 6 | 0 | | |
27 | P05TPRNL_LP_ADMS | Pension Return: Administration of Status - Legal Pers Level | 14 | GTIME | Creation/Change Hour | nvarchar | 6 | 0 | | |
28 | P05T_AE_ADM_STAT | Wage Return: Administrative Unit - Status Table | 12 | GTIME | Creation/Change Hour | nvarchar | 6 | 0 | | |
29 | P05T_A_EXT | Wage Return: Collective Employer Data - Wage Return | 11 | GTIME | Creation/Change Hour | nvarchar | 6 | 0 | | |
30 | P05T_CVZ_UITW | CVZ: Tabel voor uitwisselingsbestand | 9 | GTIME | Creation/Change Hour | nvarchar | 6 | 0 | | |
31 | P05T_IV_ADM_STAT | Wage Return: Income Relationship - Status Table | 14 | GTIME | Creation/Change Hour | nvarchar | 6 | 0 | | |
32 | P05T_JLO_STAT | Annual Wage Return status | 8 | GTIME | Creation/Change Hour | nvarchar | 6 | 0 | | |
33 | P05T_RESPONSE | Wage Return: Table for Response Messages | 9 | GTIME | Creation/Change Hour | nvarchar | 6 | 0 | | |
34 | P05T_WCR_ER_INFO | WCR Info on Employer Level | 19 | GTIME | Creation/Change Hour | nvarchar | 6 | 0 | | |
35 | P05T_WCR_STAT | WCR Status Table | 12 | GTIME | Creation/Change Hour | nvarchar | 6 | 0 | | |
TOPSets |
36 | T800S | FI-SL Set Table (before Release 4.0) | 25 | GTIME | Last changed at | nvarchar | 6 | 0 | | |
TOPSocial Insurance |
37 | P01SV_B2ATRNS | Status Table Transfer to Social Insurance Agency | 16 | GTIME | Creation/Change Time of Data Record | nvarchar | 6 | 0 | | |
TOPStatements |
38 | P01W_ADMIN_01 | HR: Data Module: Administration for Health Insurance Funds | 10 | GTIME | Creation/Change Time of Data Record | nvarchar | 6 | 0 | | |
TOPTax |
39 | P01E2_HIST | ELStAM Procedure: Table for Status History | 7 | GTIME | ELStAM: Time of Creation/Change of Data Record | nvarchar | 6 | 0 | | |
40 | P01E2_LISTMTL_ST | ELStAM: Status Table for Monthly Change Lists | 14 | GTIME | ELStAM: Time of Creation/Change of Data Record | nvarchar | 6 | 0 | | |
41 | P01E2_LIST_ST | Status Table for ELStAM Procedure Change Lists | 8 | GTIME | ELStAM: Time of Creation/Change of Data Record | nvarchar | 6 | 0 | | |
42 | P01E2_STATUS | ELStAM Procedure: Status Table | 9 | GTIME | ELStAM: Time of Creation/Change of Data Record | nvarchar | 6 | 0 | | |
43 | P01E2_TRANS_ST | Status Table Transfer for ELStAM Procedure | 10 | GTIME | ELStAM: Time of Creation/Change of Data Record | nvarchar | 6 | 0 | | |
44 | P01T_ADMIN_STAT | ETStmt: Status Management Employment Tax Statements | 11 | GTIME | Creation/Change Time of Data Record | nvarchar | 6 | 0 | | |
45 | P01T_ADMST | ETStmt: Status Management - Employment Tax Statements (Old) | 11 | GTIME | Creation/Change Time of Data Record | nvarchar | 6 | 0 | | |
46 | P01T_A_ADS | ETNotif.: Status Administration/Employment Tax Notification | 12 | GTIME | Creation/Change Time of Data Record | nvarchar | 6 | 0 | | |
47 | P01T_A_EXT | ETNotif.: External Data | 11 | GTIME | Creation/Change Time of Data Record | nvarchar | 6 | 0 | | |
48 | P01T_TRANS | ETStmt: Administration/Processing Data Tickets | 7 | GTIME | Creation/Change Time of Data Record | nvarchar | 6 | 0 | | |