| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000281000 | PSA for 0EMPLOYEE_ATTR T90CLNT090 Employee | 23 | TRFKZ | | nvarchar | 1 | 0 | | |
2 | T510E | Dynamic Standard Pay Increase II | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
3 | T510N | Pay Scales for Annual Salaries (NA) | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
4 | T546 | Employee Subgroup for PersCalcRule/CollAgreemProvision | 3 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
5 | T5BPBS01 | Description of pay scale rules | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
6 | T5BPBS02 | Description of payscale rule Jumps | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
7 | T5D14 | Features of Earnings Survey for State Statistics Office | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
8 | T5D5L | Family-Related Bonus Classes and Career Assignment | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
9 | T5PPBS3D | Functional comp. level/manager level based on pay scale | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
10 | T5PPBS3DT | Text of funct.comp. level/manager level based on pay scale | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
11 | T5PPBS8A | Index Value for Pay Scale Type, Area, Group, and Level | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
12 | T7AEPBS51 | Ranking of PS Job Grades | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
13 | T7PBS00TRF_BETRG | Amounts for Constants on Pay Scale Basis or Statutory Basis | 7 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
14 | T7UNCMT_PCATM | CMT Payscale Category Mapping | 6 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
15 | T7UNCMT_SACIDM | CMT Map Staff and Salary Assessment Category Code | 8 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
16 | T7UNPAD_UNISOLA | Duty Station Unified SOLA Rates | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
17 | ZA0008 | Importtabelle Fehlerliste Sollbezüge | 22 | TRFKZ | Gruppierung der Mitarbeiterkreise für Tarifregelung | nvarchar | 1 | 0 | | |
TOPArgentina |
18 | T7AR65 | Pay scale agreement category identification | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
TOPBudget Management |
19 | HRP1501 | DB Table for Infotype 1501 | 21 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
20 | HRP1506 | DB Table for Infotype 1506 | 21 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
21 | T7PMF | Special Pay Scale Groups | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
22 | T7PMG | Average Amounts for Collective Agreements (PSG) | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
23 | T7PMU | Default Values for Teaching Hours | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
TOPCompensation Management |
24 | HRP1005 | DB Table for Infotype 1005 (Planned Compensation) | 21 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
25 | T510D | Dynamic Standard Pay Increase | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
26 | T510R | Pay Scale Reclassification | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
27 | T510_PSRCL | Pay scale reclassification | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
28 | T5EMUPROT | Log table for currency translation EMU | 6 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
29 | T71D2 | Pay Scale Group Rule | 7 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
TOPDenmark |
30 | T5MF6 | Conversion of R/3 Pay Scale Structure to FA PS Structure | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
TOPFinland |
31 | T7FI510 | TVR relevant payscale group/level (Finland) | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
TOPGermany |
32 | T5D3M | Assignment of a Valuation of Pay Scales for Statistics | 7 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
TOPIndia |
33 | T7INA3 | Allowance grouping definition table | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
TOPItaly |
34 | T5ITC1 | Contributions | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
35 | T5ITC2 | Negative tax bases | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
36 | T5ITC3 | Lowest rate management | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
37 | T5ITC4 | Lowest rate amounts | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
38 | T5ITC5 | Tax scale rounding | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
39 | T5ITC6 | Contribution table extention for settlement | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
40 | T5ITEG | Pay Scale Indicator 770 | 2 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
41 | T5ITF3 | Provision accrual | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
42 | T5ITF7 | Severance pay | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
43 | T5ITF8 | Accrual settlement | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
44 | T5ITGB | Assign EEF Grouping | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
45 | T5ITI2 | INPS general data table | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
46 | T5ITIA | Nursing table | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
47 | T5ITIC | Marriage leave table | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
48 | T5ITID | Blood donation table | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
49 | T5ITIG | Ordinary days/hours table | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
50 | T5ITII | Sickness handling c/INPS table | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
51 | T5ITIM | Sickness handling c/company | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
52 | T5ITIN | Accident handling table | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
53 | T5ITIP | Maternity table | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
54 | T5ITIS | Sickness handling scale c/company | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
55 | T5ITNG | 01/M data table - section B | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
56 | T5ITNJ | Special remunerations table | 2 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
57 | T5ITQI | Table for ICOMP Indirect Valuation form | 7 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
58 | T5ITQL | Taxation types to be highlighted in the payroll | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
59 | T5ITS1 | Percentage pay scale jumps - percentage ceiling | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
60 | T5ITS2 | Amount-based pay scale jumps - number/amount-based ceiling | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
61 | T5ITS3 | Amount-based pay scale jumps - fractional no. based ceiling | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
62 | T5ITS4 | Percentage pay scale jumps - number-based ceiling | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
63 | T5ITS7 | Insurance pay scale jumps - class change | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
64 | T5ITU1 | Collective Labour Agreement coefficients | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
TOPJapan |
65 | T5J59 | HR Job promotion - pay scale level ordering JPN | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
66 | T5J60 | HR Parameters for pay scale recreation JPN | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
TOPKorea |
67 | T7KR32 | Standardized monthly compensation | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
TOPNon Profit Organizations |
68 | T7UNPAD_DDSA | Duty Station DSA Rates (Daily Subsistence Allowance) | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
69 | T7UNPAD_DMSA | Duty Station MSA Rates (Mission Subsistence Allowance) | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
70 | T7UNPAD_DPDS | Dependency Allowance: Lowest Entry Level Determinatio | 11 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
71 | T7UNPAD_DSDA | Duty Station Dependency Allowance | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
72 | T7UNPAD_DSPA | Duty Station Post Adjustment | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
73 | T7UNPAD_DSPT | Duty Station PTA Personnel Transition Allowance | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
74 | T7UNPAD_DS_T | Duty Station Text Table | 4 | TRFKZ | | nvarchar | 1 | 0 | | |
75 | T7UNPAD_RGST | Repatriation Grant Number Translation | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
TOPPayroll |
76 | T5T10 | Tarif groups - ext.survey | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
77 | T7SK10 | Tarif groups - ext.survey | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
TOPPayroll General Parts |
78 | T510C | Adjust Bases for Calculating Av.Vals.acc.to PScale | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
TOPPension Administration |
79 | T7PBS00TRF_DAT | Payscale Group-Dependent Data | 6 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
80 | T7PBS00TRF_DATES | Payscale Group-Dependent Data | 6 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
TOPPersonnel Administration |
81 | T503 | Employee Group/Subgroup | 7 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
82 | T510 | Pay Scale Groups | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
83 | T510F | Assign Pay Scale --> Currency | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
84 | T510M | Valuation of pay scale groups acc. to hiring date | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
85 | T510U | Pay Scale Groups | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
86 | T510W | Pay Scale > Period Parameter Assignment | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
87 | T528B | Positions | 9 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
88 | T5ITS5 | Scatti in categoria tetto massimo in numero - HR Italy | 4 | TRFKZ | Raggruppamento dei tipi dipendente per condizioni contr. | nvarchar | 1 | 0 | | |
89 | T5ITS8 | Scatti assicurativi premio fedelta' | 4 | TRFKZ | Raggruppamento dei tipi dipendente per condizioni contr. | nvarchar | 1 | 0 | | |
TOPPersonnel Time Management |
90 | T510I | Standard Working Hours | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
TOPPortugal |
91 | T5PP1 | HR-PT: Professional categories assignment | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
92 | T5PS1 | HR-PT: professional categories assignment (IRC code) | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
TOPPosition Budgeting and Control |
93 | HRFPM_BPREP_DATA | Preprocesses Data for BPREP Data Extraction | 19 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
94 | HRP1511 | DB Table for Infotype 1511 | 21 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
95 | T77HRFPM_STOV | Maintenance of FTE Limits | 6 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
TOPPublic Sector |
96 | T5APBS06 | Pay scale reclassification | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
97 | T5D5LN | Pay Scale Assign. for Guaranteed Payts: COLA/Fam.-Rel Bonus | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
98 | T5D7J | Control of BDA and COLA Relevance (Basic Pay) | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
99 | T5D7K | Parameters for Determining Proposed Pay Seniority | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
100 | T5D7L | Auxiliary Table for Higher Grouping and Promotion | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
101 | T5D7LN | Next Pay Scale Group for Higher/Lower Grouping | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
102 | T5D7M | Value of Remuneration Groups | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
103 | T5D7MN | Value of Pay Scale Groups | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
104 | T5D7N | Determination of Hiring Level Model 8 | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
105 | T5D7Q | Models for Control of Contribution | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
106 | T5D7QT | Function Model Texts: Special Payment | 6 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
107 | T5D7R | Models for Controlling Vacation Bonus | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
108 | T5D7RT | Function Model Texts: Vacation Bonus | 6 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
109 | T5D8M | Position Table for College Statistics | 8 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
110 | T5D95 | Foreign Service Bonus | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
111 | T5D97 | Supplement for Child Living Abroad | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
112 | T5DPBS08 | Spec. and Non-Rec. Payts, Fixed Amts for Each Pay Scale Grp | 7 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
113 | T5DPBS09 | Spec. and Non-Rec. Payts, Cumul. WTs for Each Pay Scale Grp | 7 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
114 | T5DPBS0E | Spec. and Non-Rec. Payments: Pay Scale-Dependent Percentages | 7 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
115 | T5DPBS1G | Validity of Variable Key for Each Pay Scale Group | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
116 | T5DPBS3B | Assignment to Internal Pay Scale Group | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
117 | T5DPBS3D | TVoeD: Structural Adjustment | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
118 | T5DPBS3E | TVoeD: COLA Class for Guaranteed Payment (Children) | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
119 | T5PBSR6I | Guideline for Salary Components | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
120 | T5QPBS1E | National Wage Case (NWC) increase for Superannuation | 5 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
TOPSouth Africa |
121 | T5W10 | Link pay scale groups to occupational level. - Equity | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
TOPSpain |
122 | T5E10 | Extension of pay scales | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
123 | T5E53 | Amounts of seniority bonuses | 4 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |
TOPUnited Kingdom |
124 | T5GASHE2 | ASHE Collective Agreement Type | 2 | TRFKZ | ES grouping for collective agreement provision | nvarchar | 1 | 0 | | |