| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000281000 | PSA for 0EMPLOYEE_ATTR T90CLNT090 Employee | 12 | PERSG | | nvarchar | 1 | 0 | | |
2 | /BIC/B0000283000 | PSA for 0EMPLOYEE_2_ATTR T90CLNT090 Employee | 11 | PERSG | | nvarchar | 1 | 0 | | |
3 | CNVLTHCM_APLNO | Application Number Organisational data (Before Conversion) | 8 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
4 | CNVLTHCM_PERNR | Personnel Number Organisational data (Before Conversion) | 8 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
5 | P2B2_WPBP | HCM Declustering B2 - Payroll Results Work Center/Basic Pay | 20 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
6 | P2RA_SP | Payroll Results: Special Payments | 14 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
7 | P2RB_SP | Payroll Results: Special Payments | 14 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
8 | P2RB_ST | Tax payroll Belgium | 14 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
9 | P2RB_SV | Social Insurance payroll Belgium | 14 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
10 | P2RD_SP | Payroll Results: Special Payments | 14 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
11 | P2RE_SP | Payroll Results: Special Payments | 14 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
12 | P2RI_SP | Payroll Results: Special Payments | 14 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
13 | P2RN_SP | Payroll Results: Special Payments | 14 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
14 | P2RQ_QHDA | HR-AU-PS: Payroll structure for Higher Duty Allowance | 22 | PERSG | Employee group of the higher duty position | nvarchar | 1 | 0 | | |
15 | P2RR_SP | Payroll Results: Special Payments | 14 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
16 | P2RV_VAP | VAP Structure Norway | 10 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
17 | P2RX_WPBP | Payroll Results: Work Center/Basic Pay | 18 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
18 | P2UN_QHDA | HR-UN: Payroll structure for Higher Duty Allowance | 22 | PERSG | Employee group of the higher duty position | nvarchar | 1 | 0 | | |
19 | T501_DELIMIT | Validity Period of Employee Group | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
20 | T503_DELIMIT | Validity Period of Employee Subgroup | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
21 | T5B9G | Employee Groups/Subgroups (B) | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
22 | T5F03 | Employee groups/subgroups - special features (France) | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
23 | T5F2M | Sickness compensation period | 3 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
24 | T5F2P | Continued pay in case of sickness | 3 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
25 | T5FPBS03 | Catégorie et statut de personnes: particularité PSF | 2 | PERSG | Catégorie salariés | nvarchar | 1 | 0 | | |
26 | T5M03 | Employee Groups/Subgroups (Denmark) | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
27 | T5REG | Employee Information Log for Destruction of Data | 10 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
28 | T5RPD | Personnel Data Deletion Log | 20 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
29 | T5TL6 | Work schedules to generate leave entitlements | 5 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
30 | T5UEFFR_EMPPARTC | US Effort Rep : Participating Employee | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
31 | T7INPEW6 | P2E: Agent Determination For Team Groups | 5 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
32 | T7NZCT | Employee Categories - NZ | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
33 | T7RU53 | Employee Group/Subgroup Russia attributes | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
34 | T7TRK04 | Account definitions for severance load entegration | 6 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
35 | T7TRK07 | IFRS-TFRS severance provision | 4 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
36 | T7UNCMTC_TRFGB | Customizing table for Personnel SubArea and Employee Group | 4 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
TOPArgentina |
37 | T7AR31 | Social Insurance employee subgroups: Allocations | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
TOPAustria |
38 | T5A03 | Employee Groups/Employee Subgroups | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
TOPBrazil |
39 | T7BRCS | Contract salaries | 3 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
TOPCanada |
40 | T5URB | HR payee derived from wage types via org. assignment | 6 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
TOPCompany Pension Scheme Germany |
41 | P01CVH | Actuarial CPS Header Records | 35 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
TOPCross-Application Objects in HR |
42 | HRP5581 | DB Table for Infotype 5581 | 25 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
TOPFinland |
43 | T7FI503 | HR-FI: Grouping for vacation factor | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
TOPGermany |
44 | T5D03 | Employee Group/Subgroup | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
TOPGreat Britain |
45 | T5G0A | Employee Group/Subgroup | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
TOPHong Kong |
46 | T7HK0P | Extension of T001P | 4 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
TOPItaly |
47 | PA3214 | HR Master Record: Infotype 3214 | 268 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
48 | T5ITME | Current Yr Mun Surch Payment Exc Table (Fin Law 2007) | 3 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
49 | T5ITQ8 | Cont.&coord. services codes for employee status/type | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
TOPJapan |
50 | T5J03 | Person Group/Subgroup JP | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
TOPLean Staffing |
51 | TSAWE_PERSG | Employee Group | 2 | PERSG | Staff Assignment Employee Group | nvarchar | 1 | 0 | | |
TOPMaintenance Processing |
52 | /MRSS/C_PREMK | Dummy table for creating Org. Assgnmnt Search Help (No Data) | 4 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
TOPMalaysia |
53 | T5L03 | Employee Subgroup grouping for Malaysia | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
TOPMexico |
54 | T7MX03 | Assignment tax table to employee group/subgroup | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
TOPNon Profit Organizations |
55 | T7UNPAD03 | Employee Group/Subgroup | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
56 | T7UNPAD_DPDS | Dependency Allowance: Lowest Entry Level Determinatio | 5 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
57 | T7UNPAD_EG03 | NPO: Employee Group/Subgroup Eligibility | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
58 | T7UNPF_CATM | Category Code Mapping | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
TOPNorway |
59 | T5V03 | Employee group/subgrouping for employment contracts (NO) | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
TOPPayroll |
60 | PA0729 | Personál.kmen.záznam Infotyp 0729 | 27 | PERSG | Skupina pracovníku | nvarchar | 1 | 0 | | |
61 | PB0729 | Personál.kmen.záznam Infotyp 0729 | 27 | PERSG | Skupina pracovníku | nvarchar | 1 | 0 | | |
62 | T5H84 | Payroll log | 14 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
63 | T5HPBS79 | Grouping of employee subgroups | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
64 | T5T03 | Personal groups/subgroups - extension | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
65 | T5TA1 | External transfers | 15 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
66 | T5TA2 | Medium for health insurance | 18 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
67 | T5TPSMKIND | Identifikace druhu zamestnaneckého pomeru & resortu | 4 | PERSG | Skupina pracovníku | nvarchar | 1 | 0 | | |
68 | T5TPSTXT01 | Formuláre infotypu 0729 - doplnku opatrení | 6 | PERSG | Skupina pracovníku | nvarchar | 1 | 0 | | |
69 | T5TPSTXT03 | Dynamické texty na formulári T5TPSTXT01 - pro infotyp 0729 | 3 | PERSG | Skupina pracovníku | nvarchar | 1 | 0 | | |
70 | T5TPSTXT05 | Názvy prímých doplnkových textu formuláru infotypu 0729 | 6 | PERSG | Skupina pracovníku | nvarchar | 1 | 0 | | |
71 | T7BG03 | EE Group/subgroup Groupings for Bulgaria | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
72 | T7RO03 | Employee group/subgrou Groupings Romania | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
73 | T7SK03 | Person group/person areas - enhancement | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
74 | T7SK1L | Bank accounts of authorities (tax,insurance) | 8 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
75 | T7SKA1 | External transfers | 15 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
76 | T7SKVDP | Aux table for HSKLVDP0 | 6 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
77 | T7TRG03 | Personel alani ve -altalani bazinda kidem grubu | 2 | PERSG | Çalisan grubu | nvarchar | 1 | 0 | | |
78 | T7TRK03 | Wage and pay increase for higher duty | 4 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
TOPPayroll General Parts |
79 | HRPY_WPBP | HR-PAY: Transparent Table WPBP | 16 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
80 | PYORGSCREEN | PNP900 Selection Screen: Fields for Organizational Selection | 4 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
TOPPension fund Netherlands |
81 | T5NBG | Berekeningsmethode (FAS/ALM interface) | 3 | PERSG | Medewerkersgroep | nvarchar | 1 | 0 | | |
TOPPersonnel Administration |
82 | PA0001 | HR Master Record: Infotype 0001 (Org. Assignment) | 26 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
83 | PA0016 | HR Master Record: Infotype 0016 (Contract Elements) | 41 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
84 | T501 | Employee Group | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
85 | T501T | Employee Group Names | 3 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
86 | T503 | Employee Group/Subgroup | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
87 | T503Z | Country Assignment for Employee Group/Subgroup | 3 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
88 | T529A | Personnel Action Types | 5 | PERSG | Action version | nvarchar | 1 | 0 | | |
89 | T7GR503 | Grouping for Employee Group-Subgroup | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
90 | T7SI03 | Skupina/podskupina zaposlenih SI | 2 | PERSG | Skupina zaposlenih | nvarchar | 1 | 0 | | |
TOPPersonnel Management |
91 | T7HR03 | Employee Group/Subgroup HR | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
TOPPortugal |
92 | T5P03 | HR-PT: Employee Groups / Subgroups - Classification | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
TOPPosition Budgeting and Control |
93 | HRFPM_BPREP_DATA | Preprocesses Data for BPREP Data Extraction | 14 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
TOPPreconfigured Systems |
94 | ZHRBPJPT_SIIID | | 5 | PERSG | ????? | nvarchar | 1 | 0 | | |
TOPProcess Controls -Automated Controls |
95 | GRPCRTA_HRDA0011 | HR Master Record: Infotype 0011 (Ext.Bank Transfers) | 6 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
96 | GRPCRTA_HRDA0045 | PC HR control data for infotype 0045 - Loan | 6 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
97 | GRPCRTA_HRDA0078 | PC HR control data for infotype 0078 - Loan Payments | 6 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
98 | GRPCRTA_HRDA0267 | PC HR control data for infotype 0267 | 6 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
99 | GRPCRTA_HRDAT1 | PC HR control data for infotype 0014 and 0015 | 6 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
100 | GRPCRTA_HRDAT2 | PC HR control data for infotype 0014 and 0015 | 6 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
TOPPublic Sector |
101 | PA0509 | HR-AU-PS: Master Data (Higher Duty Allowance) | 39 | PERSG | Employee group of the higher duty position | nvarchar | 1 | 0 | | |
102 | PDPBSDNEUG_UEB | Carried Over to DNeuG: General HR Master Record | 3 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
103 | PDPBSTVOED_UEB | Transfer to TVoeD: Personnel Master Record Before Transfer | 3 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
104 | T5DPBS3C | Transfer to TVoeD: Assignment EEGrp/Subgrp Old/New | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
105 | T5VPPS_TMA | Temporary Agreement codes | 3 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
TOPRecruitment |
106 | PB0001 | HR Master Record: Infotype 0001 (Org. Assignment) | 26 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
107 | PB0016 | Applicant Master Record Infotype 0016 (Contract Elements) | 41 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
TOPSingapore |
108 | T5R1P | Rate for lump payment and CPF in case of semimonthly payroll | 4 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
109 | T5R2C | Rate for CPF deduction by festival advance payment | 4 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
TOPSouth Africa |
110 | T5WRFN | ZA Tax and UIF reference number table | 4 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
TOPSpain |
111 | T5E51 | Seniority bonuses | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
TOPStaffing |
112 | HRP1013 | Infotype 1013 DB Table | 18 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
113 | T77WS | Person Group/Subgroup per Work Schedule Group | 3 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
114 | T77WT | Employee Group/Subgroup Assignment to Work Schedule Groups | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
TOPSweden |
115 | T5S03 | Employee Group/Subgroup (SE) | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
TOPSwitzerland |
116 | T5C03 | Employee Group/Subgroup | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
TOPTaiwan |
117 | T7TW2I | Reported data of Tax withdrawal report | 9 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
TOPThailand |
118 | T7TH03 | Employee Group/Subgrouping for PF THAILAND | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
TOPWorkforce Management Application |
119 | WFAEM_ESG_MAP | Mapping of HCM EmployeeSubgroup to WFM Default Setting Group | 3 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
120 | WFAEM_PAY_MAP | Pay rate mapping table (HCM -> WFM) | 3 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
121 | WFAEM_V500P_T | Employee group text table | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
122 | WFAEM_VAL500P | Employee Group | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
TOPWorkforce Management Core |
123 | WFMEM_V500P_T | Employee group text table | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |
124 | WFMEM_VAL500P | Employee Group | 2 | PERSG | Employee Group | nvarchar | 1 | 0 | | |