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