| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T7AEPBS14 | Salary Components | 3 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
2 | T7AEPBS14T | Salary Component Text | 3 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
3 | T7AEPBS16 | Eligibility of Salary Components | 3 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
4 | T7QAW7A | Salary Components | 2 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
5 | T7QAW7AT | Salary Component Text | 3 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
6 | T7QAW7C | Eligibility of Salary Components | 2 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
7 | T7SAPBS14 | Salary Components | 2 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
8 | T7SAPBS14T | Salary Component Text | 3 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
9 | T7SAPBS16 | Eligibility of Salary Components | 2 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
TOPArgentina |
10 | T7ARM2 | (Dependents) additional data | 12 | CAREA | Telephone area code | nvarchar | 4 | 0 | | |
TOPCompensation Administration |
11 | PA0758 | HR Master Record: Infotype 0758 (Compensation Program) | 24 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
12 | PA0759 | HR Master Record: Infotype 0759 (Compensation Process) | 24 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
13 | PA0760 | HR Master Record: Infotype 0760 (Comp. Eligibility Override) | 24 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
14 | T71ADM01 | Compensation Area | 2 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
15 | T71ADM01T | Compensation Area Text | 3 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
16 | T71ADM03 | Compensation Plan Attributes | 2 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
17 | T71ADM04 | Compensation Plan Payroll Data | 2 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
18 | T71ADM05 | First Compensation Program Grouping | 2 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
19 | T71ADM05T | First Compensation Program Grouping Text | 3 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
20 | T71ADM06 | Second Compensation Program Grouping | 2 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
21 | T71ADM06T | Second Compensation Program Grouping Text | 3 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
22 | T71ADM07 | Compensation Program | 2 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
23 | T71ADM10 | Compensation Review Item Attributes | 2 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
24 | T71ADM11 | Compensation Eligibility Rule Variant | 2 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
25 | T71ADM11T | Compensation Eligibility Rule Variant Text | 3 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
26 | T71ADM12 | Compensation Eligibility Grouping | 2 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
27 | T71ADM12T | Compensation Eligibility Grouping Text | 3 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
28 | T71ADM13 | Compensation Eligibility Rule | 2 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
29 | T71ADM14 | Compensation Appraisal Rule | 2 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
30 | T71ADM14T | Compensation Appraisal Rule Text | 3 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
31 | T71ADM15 | Compensation Guideline Variant | 2 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
32 | T71ADM15T | Compensation Guideline Variant Text | 3 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
33 | T71ADM16 | Compensation Guideline Grouping | 2 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
34 | T71ADM16T | Compensation Guideline Grouping Text | 3 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
35 | T71ADM17 | Compensation Guideline | 2 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
36 | T71ADM18 | Compensation Guideline Proration Rule | 2 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
37 | T71ADM18T | Compensation Guideline Proration Rule Text | 3 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
38 | T71ADM19 | Compensation Guideline Matrix | 2 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
39 | T71ADM19T | Compensation Guideline Matrix Text | 3 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
40 | T71ADM20 | Compensation Matrix Dimension | 2 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
41 | T71ADM20T | Compensation Matrix Dimension Text | 3 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
42 | T71ADM22 | Compensation Matrix Dimension Segment | 2 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
43 | T71ADM22T | Compensation Matrix Dimension Segment Text | 3 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
44 | T71ADM23 | Compensation Matrix Values | 2 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
TOPCompensation Management |
45 | PA0380 | HR Master Data Record Infotype 0380 (Comp. Adjustment) | 24 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
46 | PA0381 | HR Master Record Infotype 0381 (Comp. Plan Eligibility) | 25 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
47 | PA0382 | HR Master Data Record Infotype 0382 (Award) | 25 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
48 | PA0383 | HR Master Data Record Infotype 0383 (Compensation Package) | 26 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
49 | PA0384 | HR Master Data Record Infotype 0384 | 25 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
50 | T71C01 | Fixed Compensation Components | 3 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
51 | T71C02 | Variable Compensation Components | 3 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
52 | T71C03 | Stock Components | 3 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
53 | T71C3 | Compensation Area | 2 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
54 | T71C3T | Compensation Area Texts | 3 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
55 | T71C9 | To be deleted - no longer used! | 4 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
56 | T71CB | Compensation Adjustment | 3 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
57 | T71CC | To be deleted - no longer used! | 3 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
58 | T71CD | To be deleted - no longer used! | 3 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
59 | T71E0 | Guidelines | 2 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
60 | T71E0R | Guideline Variants | 2 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
61 | T71E0T | Guideline Variant Texts | 3 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
62 | T71F0 | Wage Types for Compensation Adjustments | 2 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
63 | T71F1 | Wage Type Model for Compensation Adjustments | 2 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
64 | T71G0 | Compensation Matrix | 2 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
65 | T71G0T | Text Table for Compensation Matrices | 3 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
66 | T71GS | Segment Table for Dimensions | 2 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
67 | T71GST | Text Table for Dimension Segments | 3 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
68 | T71GV | Value Table for Compensation Matrix | 2 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
69 | T71LB2 | Country-dependent award attributes | 2 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
70 | T71LV3 | Life event vesting | 2 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
TOPEnterprise Compensation Management |
71 | T71ADM_EE_HIST | Compensation Tracking for Employees | 13 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
72 | T71ADM_PROC_ELIG | Compensation Tracking: Eligibility Information | 5 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
73 | T71ADM_SPENT_AMT | Compensation Planning: Spent Amounts | 6 | CAREA | Compensation Area | nvarchar | 2 | 0 | | |
TOPPayroll |
74 | T7UA1656 | Infotype 1656 Fields: Legal properties (Ukraine) | 14 | CAREA | Area Code | nvarchar | 2 | 0 | | |
TOPPersonnel Administration |
75 | T7GR01P | Grouping for Personnel Area-Subarea | 4 | CAREA | Personnel Area-Subarea Grouping for Gross Payroll | nvarchar | 2 | 0 | | |
76 | T7GR1APD1 | Customizing table for KAD and EMPLOYER DEPARTMENT | 2 | CAREA | Personnel Area-Subarea Grouping for Gross Payroll | nvarchar | 2 | 0 | | |
77 | T7GR1APD2 | Customizing Table for SPECIALTY IKA | 3 | CAREA | Personnel Area-Subarea Grouping for Gross Payroll | nvarchar | 2 | 0 | | |
78 | T7GR1APD3 | Customizing Table for ALL_DAYS and FULL_SCHD | 2 | CAREA | Personnel Area-Subarea Grouping for Gross Payroll | nvarchar | 2 | 0 | | |
79 | T7GR1INS | Social Insurance Fund Agreement | 2 | CAREA | Personnel Area-Subarea Grouping for Gross Payroll | nvarchar | 2 | 0 | | |
80 | T7GR2AVEH | Increment Collecting Time Period | 3 | CAREA | Personnel Area-Subarea Grouping for Gross Payroll | nvarchar | 2 | 0 | | |
81 | T7GR2C1 | Personnel Area-Subarea Grouping for Gross Payroll | 2 | CAREA | Personnel Area-Subarea Grouping for Gross Payroll | nvarchar | 2 | 0 | | |
82 | T7GR2C1T | Personnel Area-Subarea Grouping for Gross Payroll(Texts) | 3 | CAREA | Personnel Area-Subarea Grouping for Gross Payroll | nvarchar | 2 | 0 | | |
83 | T7GR2OC | Standard Payroll Elements for Off Cycles | 2 | CAREA | Personnel Area-Subarea Grouping for Gross Payroll | nvarchar | 2 | 0 | | |
84 | T7GR2QUO | Quota Elements | 2 | CAREA | Personnel Area-Subarea Grouping for Gross Payroll | nvarchar | 2 | 0 | | |
85 | T7GR2STD | Payroll Groupings & Standard Elements | 2 | CAREA | Personnel Area-Subarea Grouping for Gross Payroll | nvarchar | 2 | 0 | | |
86 | T7GR4SUB | Company Subscribers | 2 | CAREA | Personnel Area-Subarea Grouping for Gross Payroll | nvarchar | 2 | 0 | | |
87 | T7GR4SUBT | Company Subscribers (Text) | 3 | CAREA | Personnel Area-Subarea Grouping for Gross Payroll | nvarchar | 2 | 0 | | |
TOPSouth Africa |
88 | T5W7A | Salary components | 2 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
89 | T5W7AT | Salary component text | 3 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
90 | T5W7C | Eligibility of salary components | 2 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
91 | T5W7E | Salary packaging categories | 2 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
92 | T5W7ET | Salary packaging Categories | 2 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
93 | T5W7H | Salary packaging: Categories of salary components | 2 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
94 | T5W7HT | Salary packaging: Text table Categories | 3 | CAREA | Compensation area | nvarchar | 2 | 0 | | |
95 | T5WITA88 | ITA88 Transaction Table | 23 | CAREA | ITA88 Cancellation Reason | nvarchar | 90 | 0 | | |