| 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 | | |
