| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000281000 | PSA for 0EMPLOYEE_ATTR T90CLNT090 Employee | 24 | TRFGR | | nvarchar | 8 | 0 | | |
2 | /BIC/B0000283000 | PSA for 0EMPLOYEE_2_ATTR T90CLNT090 Employee | 25 | TRFGR | | nvarchar | 8 | 0 | | |
3 | P2B2_ALP | HCM Declustering B2 - Alternative Payment Table ALP | 21 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
4 | P2B2_WPBP | HCM Declustering B2 - Payroll Results Work Center/Basic Pay | 42 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
5 | P2RQ_QHDA | HR-AU-PS: Payroll structure for Higher Duty Allowance | 26 | TRFGR | Pay scale group of the higher duty position | nvarchar | 8 | 0 | | |
6 | P2RR_RM | Payroll Results: Table for Master data (SG) | 41 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
7 | P2RV_VAP | VAP Structure Norway | 17 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
8 | P2RX_ALP | Alternative Payment Table ALP | 19 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
9 | P2RX_WPBP | Payroll Results: Work Center/Basic Pay | 40 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
10 | P2UN_QHDA | HR-UN: Payroll structure for Higher Duty Allowance | 26 | TRFGR | Pay scale group of the higher duty position | nvarchar | 8 | 0 | | |
11 | P2UN_RS | UN Rental Subsidy internal structure | 51 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
12 | PA0576 | HR Master Record Infotype 0576 | 27 | TRFGR | | nvarchar | 8 | 0 | | |
13 | PA0648 | HR Master Record: Infotype 0648 | 27 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
14 | T510E | Dynamic Standard Pay Increase II | 6 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
15 | T510N | Pay Scales for Annual Salaries (NA) | 6 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
16 | T5BPBS01 | Description of pay scale rules | 6 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
17 | T5BPBS02 | Description of payscale rule Jumps | 6 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
18 | T5D14 | Features of Earnings Survey for State Statistics Office | 6 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
19 | T5D5F | Case groups | 3 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
20 | T5D5L | Family-Related Bonus Classes and Career Assignment | 6 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
21 | T5FPBS4A | Echelle | 5 | TRFGR | Echelle, groupe hors-échelle. | nvarchar | 8 | 0 | | |
22 | T5FPBS4B | Echelon | 5 | TRFGR | Echelle, groupe hors-échelle. | nvarchar | 8 | 0 | | |
23 | T5FPBS4E | Affectation échelle, grade | 7 | TRFGR | Echelle, groupe hors-échelle. | nvarchar | 8 | 0 | | |
24 | T5GPBSS_PSC | SWF: Pay Scale | 5 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
25 | T5GPBSS_PSC2 | SWF: Pay Scale | 5 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
26 | T5PPBS3D | Functional comp. level/manager level based on pay scale | 5 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
27 | T5PPBS3DT | Text of funct.comp. level/manager level based on pay scale | 6 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
28 | T5PPBS8A | Index Value for Pay Scale Type, Area, Group, and Level | 5 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
29 | T7AEPBS07 | Rental Allocation | 5 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
30 | T7AEPBS51 | Ranking of PS Job Grades | 6 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
31 | T7QAPBS01 | Pay Scale mapping table | 4 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
32 | T7QAPBS07 | Pay Scale Group Sequence | 3 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
33 | T7QAPBS34 | Education qualification for promotion | 2 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
34 | T7SAPBS10 | Representation allowance according to Job & Category | 3 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
35 | T7SAPBS26 | Define Overtime Group Based On Pay Scale | 5 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
36 | T7SAPBS34 | Assign Pay Scale to Job Classification | 11 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
37 | T7SAPBS41 | Refer other Pay Scale for Allowances/Benefits | 4 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
38 | T7SAPBSM1 | Minimum Service Duration for KSA Military Sector | 5 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
39 | T7UNCMT_SACIDM | CMT Map Staff and Salary Assessment Category Code | 9 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
40 | T7UNPF_HR_CATM | Mapping table for Pay scale type to Salary Category | 4 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
41 | ZCATSDB | Records changed with processing status '10' | 41 | TRFGR | | nvarchar | 8 | 0 | | |
42 | ZCATSDB2 | Records changed with processing status '10' | 42 | TRFGR | | nvarchar | 8 | 0 | | |
TOPArgentina |
43 | T7AR65 | Pay scale agreement category identification | 5 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
TOPAttendancesAbsences |
44 | CATSHR | Cross-Application Time Sheet (CATS): Transfer to HR | 47 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
TOPAustralia |
45 | T5QSS | Superannuation Defined Salary Australia | 5 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
TOPBudget Management |
46 | HRP1501 | DB Table for Infotype 1501 | 22 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
47 | HRP1506 | DB Table for Infotype 1506 | 22 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
48 | T7PMF | Special Pay Scale Groups | 8 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
49 | T7PMG | Average Amounts for Collective Agreements (PSG) | 6 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
50 | T7PMU | Default Values for Teaching Hours | 6 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
TOPCompensation Management |
51 | PA0380 | HR Master Data Record Infotype 0380 (Comp. Adjustment) | 32 | TRFGR | Pay grade | nvarchar | 8 | 0 | | |
52 | T510D | Dynamic Standard Pay Increase | 6 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
53 | T510R | Pay Scale Reclassification | 6 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
54 | T510_PSRCL | Pay scale reclassification | 6 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
TOPDenmark |
55 | T5MF6 | Conversion of R/3 Pay Scale Structure to FA PS Structure | 5 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
TOPESS Based on WD ABAP |
56 | HRESS_D_CATS_FAV | CATS Favorites: database table | 48 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
TOPFinland |
57 | T7FI510 | TVR relevant payscale group/level (Finland) | 6 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
TOPGermany |
58 | T5D3M | Assignment of a Valuation of Pay Scales for Statistics | 8 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
TOPIndia |
59 | T7INA3 | Allowance grouping definition table | 6 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
TOPItaly |
60 | PA3214 | HR Master Record: Infotype 3214 | 275 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
61 | T5ITC4 | Lowest rate amounts | 6 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
62 | T5ITEG | Pay Scale Indicator 770 | 3 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
63 | T5ITNV | Assignment table of INPS levels | 2 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
64 | T5ITPM | Check Table for Higher Duties : infotype (3214) subtype 0002 | 7 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
65 | T5ITS1 | Percentage pay scale jumps - percentage ceiling | 5 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
66 | T5ITS2 | Amount-based pay scale jumps - number/amount-based ceiling | 5 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
67 | T5ITS3 | Amount-based pay scale jumps - fractional no. based ceiling | 5 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
68 | T5ITS4 | Percentage pay scale jumps - number-based ceiling | 5 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
69 | T5ITS7 | Insurance pay scale jumps - class change | 5 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
TOPJapan |
70 | T5J59 | HR Job promotion - pay scale level ordering JPN | 6 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
71 | T5J60 | HR Parameters for pay scale recreation JPN | 6 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
TOPKorea |
72 | T7KR32 | Standardized monthly compensation | 6 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
TOPNew Zealand |
73 | PT2001 | HR Time Record: Infotype 2001 (Absences) | 44 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
TOPNon Profit Organizations |
74 | PA0961 | HR Master Record: Infotype 0961 | 31 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
75 | PA0965 | HR Master Record: Infotype 0965 | 61 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
76 | T7UNOM_P_TITLE | Position Title | 7 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
77 | T7UNPAD_CEBGRD | EG CCAQ Staff Grade Mapping table | 3 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
78 | T7UNPAD_DPDS | Dependency Allowance: Lowest Entry Level Determinatio | 8 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
79 | T7UNPAD_EVE_GA | Grade Adjustment for Allowances in EVE | 3 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
80 | T7UNPAD_GA | Grade Adjustment for Mobility Allowances | 2 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
TOPPayroll |
81 | T5HPBS01 | Szorzószámok | 5 | TRFGR | Bérrendszercsoport | nvarchar | 8 | 0 | | |
82 | T5HPBS01X | Szorzószámok | 5 | TRFGR | Bérrendszercsoport | nvarchar | 8 | 0 | | |
83 | T5HPBS02 | Besorolási fokozatok | 3 | TRFGR | Bérrendszercsoport | nvarchar | 8 | 0 | | |
84 | T5HPBS02T | Besorolási fokozatok szövegei | 4 | TRFGR | Bérrendszercsoport | nvarchar | 8 | 0 | | |
85 | T5HPBS02X | Besorolási fokozatok | 3 | TRFGR | Bérrendszercsoport | nvarchar | 8 | 0 | | |
86 | T5HPBS61 | Köztisztviseloi pótszabadság megképzését vezérlo tábla | 3 | TRFGR | Bérrendszercsoport | nvarchar | 8 | 0 | | |
87 | T5HPBS62 | Közalkalmazotti pótszabadság megképzését vezérlo tábla | 3 | TRFGR | Bérrendszercsoport | nvarchar | 8 | 0 | | |
88 | T5HPBS63 | Generating leave quotas | 3 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
89 | T5HPBS96 | Foreign exchange multipliers (for IT3265) | 3 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
90 | T5HPBS98 | FX multipliers for long-term studies abroad | 3 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
91 | T5T10 | Tarif groups - ext.survey | 6 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
92 | T5TPSCODP | Odpocet let podle kategorie dosaženého vzdelání | 2 | TRFGR | Tarifní skupina | nvarchar | 8 | 0 | | |
93 | T5TPSCVYJ | Definice vyjímek a odpocet dle kateg. dosaženého vzdelání | 3 | TRFGR | Tarifní skupina | nvarchar | 8 | 0 | | |
94 | T7SK10 | Tarif groups - ext.survey | 6 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
TOPPayroll General Parts |
95 | HRPY_WPBP | HR-PAY: Transparent Table WPBP | 31 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
TOPPension Administration |
96 | PA0845 | HR Master Record Infotype 0845 (Work Relationships) | 28 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
TOPPersonnel Administration |
97 | PA0008 | HR Master Record: Infotype 0008 (Basic Pay) | 26 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
98 | PA0052 | HR Master Record: Infotype 0052 (Wage Maintenance) | 27 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
99 | T510 | Pay Scale Groups | 6 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
100 | T510M | Valuation of pay scale groups acc. to hiring date | 6 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
101 | T510U | Pay Scale Groups | 6 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
102 | T528B | Positions | 10 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
103 | T5ITS5 | Scatti in categoria tetto massimo in numero - HR Italy | 5 | TRFGR | Gruppo contrattuale | nvarchar | 8 | 0 | | |
104 | T5ITS8 | Scatti assicurativi premio fedelta' | 5 | TRFGR | Gruppo contrattuale | nvarchar | 8 | 0 | | |
TOPPersonnel Time Events |
105 | TPTCOR_APL | Different Payment (Correction Scenario) | 5 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
TOPPersonnel Time Management |
106 | CC1TEV | Temporary Buffer for Time Events from CC1 | 42 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
107 | PA2001 | HR Time Record: Infotype 2001 (Absences) | 44 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
108 | PA2002 | HR Time Record: Infotype 2002 (Attendances) | 37 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
109 | PA2003 | HR Time Record: Infotype 2003 (Substitutions) | 50 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
110 | PA2004 | HR Time Record: Infotype 2004 (Availability) | 37 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
111 | PA2005 | HR Time Record: Infotype 2005 (Overtime) | 47 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
112 | PA2010 | HR Time Record: Infotype 2010 (Employee Remuneration Info.) | 39 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
113 | PTEX2000 | Interface Table for Attendances/Absences Infotype(2001/2002) | 36 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
114 | PTEX2003GEN | Interface Table for IT 2003: General Information | 35 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
115 | PTEX2003SPEC | Interface Table for IT 2003: Interval Information | 11 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
116 | PTEX2010 | Interface Table for EE Remuneration Info. Infotype (2010) | 35 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
117 | TEVEN | Time Events | 32 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
TOPPortugal |
118 | T5PP1 | HR-PT: Professional categories assignment | 5 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
119 | T5PS1 | HR-PT: professional categories assignment (IRC code) | 5 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
TOPPosition Budgeting and Control |
120 | HRFPM_BPREP_DATA | Preprocesses Data for BPREP Data Extraction | 21 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
121 | T77HRFPM_STOV | Maintenance of FTE Limits | 7 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
TOPPublic Sector |
122 | PA0509 | HR-AU-PS: Master Data (Higher Duty Allowance) | 43 | TRFGR | Pay scale group of the higher duty position | nvarchar | 8 | 0 | | |
123 | PDPBSDNEUG_UEB_T | Carried Over to DNeuG: Personnel Pay Scale Information | 6 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
124 | PDPBSTVOED_UEB | Transfer to TVoeD: Personnel Master Record Before Transfer | 7 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
125 | T5APBS06 | Pay scale reclassification | 6 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
126 | T5D5LN | Pay Scale Assign. for Guaranteed Payts: COLA/Fam.-Rel Bonus | 6 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
127 | T5D7K | Parameters for Determining Proposed Pay Seniority | 6 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
128 | T5D7M | Value of Remuneration Groups | 6 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
129 | T5D7MN | Value of Pay Scale Groups | 6 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
130 | T5D7N | Determination of Hiring Level Model 8 | 6 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
131 | T5D7R | Models for Controlling Vacation Bonus | 10 | TRFGR | Limit Pay Scale Group, Lower Half (PSG) | nvarchar | 8 | 0 | | |
132 | T5D82 | Pay Scale Information for Calculation of Minimum Pension | 6 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
133 | T5D8M | Position Table for College Statistics | 9 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
134 | T5D95 | Foreign Service Bonus | 7 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
135 | T5DPBS08 | Spec. and Non-Rec. Payts, Fixed Amts for Each Pay Scale Grp | 8 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
136 | T5DPBS09 | Spec. and Non-Rec. Payts, Cumul. WTs for Each Pay Scale Grp | 8 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
137 | T5DPBS0E | Spec. and Non-Rec. Payments: Pay Scale-Dependent Percentages | 8 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
138 | T5DPBS1C | Basis for Activity with Higher Rate of Pay | 13 | TRFGR | Payment According to Pay Scale Group | nvarchar | 8 | 0 | | |
139 | T5DPBS1G | Validity of Variable Key for Each Pay Scale Group | 6 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
140 | T5DPBS3B | Assignment to Internal Pay Scale Group | 6 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
141 | T5QPBS1E | National Wage Case (NWC) increase for Superannuation | 6 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
142 | T5QPBS1H | Priority Table used in calculating HDA super salary comp. | 4 | TRFGR | Pay scale group of the higher duty position | nvarchar | 8 | 0 | | |
143 | T5QPBS6C | Assignment of APS classification structure | 5 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
144 | T5VPPS_PSRALV | Norway Public Sector: IT 0509 records in ALV of RPIPSP00 | 11 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
TOPRecruitment |
145 | PB0008 | Applicant Master Record Infotype (Basic Pay) | 26 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
TOPSouth Africa |
146 | T5W10 | Link pay scale groups to occupational level. - Equity | 5 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
TOPSpain |
147 | T5E51 | Seniority bonuses | 3 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
148 | T5E53 | Amounts of seniority bonuses | 5 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
TOPTime Sheet |
149 | CATSDB | CATS: Database Table for Time Sheet | 41 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |
150 | CATS_TEMP | CATS: Database Table for Templates | 43 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | | |