| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPPersonnel Administration |
1 | T7GR1APD1 | Customizing table for KAD and EMPLOYER DEPARTMENT | 4 | PRSGK | Employee Group-Subgroup Grouping for Gross Payroll | nvarchar | 2 | 0 | | |
2 | T7GR1APD2 | Customizing Table for SPECIALTY IKA | 5 | PRSGK | Employee Group-Subgroup Grouping for Gross Payroll | nvarchar | 2 | 0 | | |
3 | T7GR1APD3 | Customizing Table for ALL_DAYS and FULL_SCHD | 4 | PRSGK | Employee Group-Subgroup Grouping for Gross Payroll | nvarchar | 2 | 0 | | |
4 | T7GR1INS | Social Insurance Fund Agreement | 4 | PRSGK | Employee Group-Subgroup Grouping for Gross Payroll | nvarchar | 2 | 0 | | |
5 | T7GR2AVEH | Increment Collecting Time Period | 5 | PRSGK | Employee Group-Subgroup Grouping for Gross Payroll | nvarchar | 2 | 0 | | |
6 | T7GR2C2 | EE Group-Subgroup grouping for gross payroll | 2 | PRSGK | Employee Group-Subgroup Grouping for Gross Payroll | nvarchar | 2 | 0 | | |
7 | T7GR2C2T | Employee Group-Subgroup Grouping for Gross Payroll | 3 | PRSGK | Employee Group-Subgroup Grouping for Gross Payroll | nvarchar | 2 | 0 | | |
8 | T7GR2OC | Standard Payroll Elements for Off Cycles | 4 | PRSGK | Employee Group-Subgroup Grouping for Gross Payroll | nvarchar | 2 | 0 | | |
9 | T7GR2QUO | Quota Elements | 4 | PRSGK | Employee Group-Subgroup Grouping for Gross Payroll | nvarchar | 2 | 0 | | |
10 | T7GR2STD | Payroll Groupings & Standard Elements | 4 | PRSGK | Employee Group-Subgroup Grouping for Gross Payroll | nvarchar | 2 | 0 | | |
11 | T7GR503 | Grouping for Employee Group-Subgroup | 4 | PRSGK | Employee Group-Subgroup Grouping for Gross Payroll | nvarchar | 2 | 0 | | |