| 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 | | |
