| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000285000 | PSA for 0PERSON_ATTR T90CLNT090 Person | 8 | GESCH | | nvarchar | 1 | 0 | | |
2 | P2RB_PERM | Personal Features | 4 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
3 | P2RD_PERM | Payroll Results: Personal Features | 4 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
4 | P2RK_PERM | Personal Characteristics | 4 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
5 | P2RN_NNAM | Personal Data | 15 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
6 | P2RU_PERM | Personal Characteristics | 5 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
7 | PAPBSGB_SWF_STAF | SWF: Staff Details | 15 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
8 | PB0290 | HR Master Record: Infotype 0290 - Identity card CIS | 60 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
9 | T7AEPBS66 | Absence Type Limit Condition | 13 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
10 | T7HK11 | General information of the IR56 forms | 11 | GESCH | Single-Character Indicator | nvarchar | 1 | 0 | | |
11 | T7KW08 | Absence Type Limit Condition | 7 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
12 | T7OM33 | Absence Type Limit Condition | 7 | GESCH | Gender | nvarchar | 1 | 0 | | |
13 | T7QAPBS25 | Absence Type Limit Condition | 7 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
14 | T7RUMATST | OKIN: Marital Status Designators | 5 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
15 | T7RU_MILAGEL | Age Limit for Military Administration (RU) | 5 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
16 | T7SAPBS30 | Absence Quota Generation Refinement | 8 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
17 | T7SAPBS66 | Absence Type Limit Condition | 7 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
18 | T7TRK06 | Retirement account table | 2 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
19 | HRP1702 | DB Table for Infotype 1702 | 37 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
TOPAustria |
20 | T5A1W | SI Age Levels | 2 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
21 | T5A71 | L16 Consolidation File | 41 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
22 | T5A74 | E18 Consolidation File | 41 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
23 | T5A9A | Created Statement of Employment (A) | 21 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
TOPBelgium |
24 | T5BS3 | Employee information except reductions ( level 3 ) | 18 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
TOPBrazil |
25 | T7BRDE | Dependents eligibility for income tax | 2 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
TOPCompany Pension Scheme Germany |
26 | P01CVH | Actuarial CPS Header Records | 28 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
27 | PA0746 | HR Master Record for Infotype 0746 | 51 | GESCH | Gender of Applicant | nvarchar | 1 | 0 | | |
TOPConstruction Industry |
28 | PDBKAN | Construction Industry Social Fund Proced: ANMEL Data Records | 29 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
TOPCross-Application Objects in HR |
29 | HRP5582 | DB Table for Infotype 5582 | 35 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
TOPMaster Data |
30 | JGTGPNR | IS-M: Central Business Partner Table | 24 | GESCH | IS-M: Gender Key | nvarchar | 1 | 0 | | |
31 | TJG43 | IS-M: Form-of-Address Key | 3 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
TOPPayroll |
32 | T5H4O | Reported "closed incapacities to work" | 11 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
TOPPersonnel Administration |
33 | PA0002 | HR Master Record: Infotype 0002 (Personal Data) | 39 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
34 | T522 | Title Keys | 4 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
35 | T522G | Title Keys | 3 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
36 | T528B | Positions | 14 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
TOPPersonnel Time Management |
37 | T554M | Absences for Maternity Protection: Rule Table | 19 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
TOPPublic Sector |
38 | P01ZFA_NN_DATA | ZfA: Notifications Not Assigned | 33 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
39 | PA0619 | HR-AU-PS : Equity and Diversity | 24 | GESCH | Gender for Equity and Diversity | nvarchar | 1 | 0 | | |
40 | PAPBSMXSARC | SAR current result | 27 | GESCH | Gender key | nvarchar | 1 | 0 | | |
41 | PAPBSMXSARP | SAR previous result | 27 | GESCH | Gender key | nvarchar | 1 | 0 | | |
TOPRecruitment |
42 | PB0002 | HR Master Record: Infotype 0002 (Personal Data) | 39 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
TOPReporting |
43 | P05TPRNL_EE_PD | Pension Return: Personal Data - Pers Level | 18 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
TOPRussia |
44 | PA0290 | HR Master Record: Infotype 0290 - Identity card CIS | 60 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
45 | T7RUP2 | Grouping of Employees for Pension Insurance/Accumula | 3 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
TOPSwitzerland |
46 | T5C65 | Derivation of Relationship Between Child and Bonus Recipient | 4 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
47 | T5CR0 | HR-CH: Rules for Determining the Pension Start | 4 | GESCH | Gender Key | nvarchar | 1 | 0 | | |
TOPTax |
48 | P01T_LST | ETStmt: General Employment Tax Data | 15 | GESCH | ETStmt: Gender | nvarchar | 1 | 0 | | |
TOPUnited Kingdom |
49 | PAGB_ASHE | ASHE Return Data | 12 | GESCH | Gender Key | nvarchar | 1 | 0 | | |