| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000281000 | PSA for 0EMPLOYEE_ATTR T90CLNT090 Employee | 36 | ANSVH | | nvarchar | 2 | 0 | | |
2 | /BIC/B0000283000 | PSA for 0EMPLOYEE_2_ATTR T90CLNT090 Employee | 21 | ANSVH | | nvarchar | 2 | 0 | | |
3 | CNVLTHCM_APLNO | Application Number Organisational data (Before Conversion) | 15 | ANSVH | Work Contract | nvarchar | 2 | 0 | | |
4 | CNVLTHCM_PERNR | Personnel Number Organisational data (Before Conversion) | 15 | ANSVH | Work Contract | nvarchar | 2 | 0 | | |
5 | P2B2_WPBP | HCM Declustering B2 - Payroll Results Work Center/Basic Pay | 26 | ANSVH | Work Contract | nvarchar | 2 | 0 | | |
6 | P2RX_WPBP | Payroll Results: Work Center/Basic Pay | 24 | ANSVH | Work Contract | nvarchar | 2 | 0 | | |
7 | T5FDSNCT | Temp table for PAYFR_RESULT-CT | 18 | ANSVH | Type de contrat | nvarchar | 2 | 0 | | |
8 | T5REG | Employee Information Log for Destruction of Data | 17 | ANSVH | Work Contract | nvarchar | 2 | 0 | | |
9 | T5RPD | Personnel Data Deletion Log | 27 | ANSVH | Work Contract | nvarchar | 2 | 0 | | |
TOPCanada |
10 | T5KB4 | Account Number Organizational assignment, Canada | 4 | ANSVH | Work Contract | nvarchar | 2 | 0 | | |
TOPCompensation Management |
11 | PA0395 | HR Master Record: Infotype 0395 (External Org.Assignment) | 26 | ANSVH | Work Contract | nvarchar | 2 | 0 | | |
TOPCross-Application Objects in HR |
12 | HRP5581 | DB Table for Infotype 5581 | 32 | ANSVH | Work Contract | nvarchar | 2 | 0 | | |
TOPGermany |
13 | T5D03 | Employee Group/Subgroup | 6 | ANSVH | Work Contract | nvarchar | 2 | 0 | | |
TOPGreat Britain |
14 | T5G0A | Employee Group/Subgroup | 4 | ANSVH | Work Contract | nvarchar | 2 | 0 | | |
TOPJapan |
15 | PA0853 | HR Master Record: Infotype 0853 | 30 | ANSVH | Work Contract | nvarchar | 2 | 0 | | |
TOPNorway |
16 | T5V03 | Employee group/subgrouping for employment contracts (NO) | 4 | ANSVH | Work Contract | nvarchar | 2 | 0 | | |
17 | T5VST | Assignment of granularity to EE status/travel tax key | 2 | ANSVH | Work Contract | nvarchar | 2 | 0 | | |
TOPPayroll General Parts |
18 | HRPY_WPBP | HR-PAY: Transparent Table WPBP | 22 | ANSVH | Work Contract | nvarchar | 2 | 0 | | |
TOPPersonnel Administration |
19 | PA0001 | HR Master Record: Infotype 0001 (Org. Assignment) | 33 | ANSVH | Work Contract | nvarchar | 2 | 0 | | |
20 | PB0395 | HR Master Record: Infotype 0395 (External Org.Assignment) | 26 | ANSVH | Work Contract | nvarchar | 2 | 0 | | |
21 | T542A | Work Contract | 3 | ANSVH | Work Contract | nvarchar | 2 | 0 | | |
22 | T542T | Employment Contracts | 4 | ANSVH | Work Contract | nvarchar | 2 | 0 | | |
23 | T7GR1APD1 | Customizing table for KAD and EMPLOYER DEPARTMENT | 5 | ANSVH | Work Contract | nvarchar | 2 | 0 | | |
24 | T7GR1APD2 | Customizing Table for SPECIALTY IKA | 6 | ANSVH | Work Contract | nvarchar | 2 | 0 | | |
25 | T7GR1APD3 | Customizing Table for ALL_DAYS and FULL_SCHD | 5 | ANSVH | Work Contract | nvarchar | 2 | 0 | | |
26 | T7GR1INS | Social Insurance Fund Agreement | 5 | ANSVH | Work Contract | nvarchar | 2 | 0 | | |
27 | T7GR2AVEH | Increment Collecting Time Period | 6 | ANSVH | Work Contract | nvarchar | 2 | 0 | | |
28 | T7GR2OC | Standard Payroll Elements for Off Cycles | 5 | ANSVH | Work Contract | nvarchar | 2 | 0 | | |
29 | T7GR2QUO | Quota Elements | 5 | ANSVH | Work Contract | nvarchar | 2 | 0 | | |
30 | T7GR2STD | Payroll Groupings & Standard Elements | 5 | ANSVH | Work Contract | nvarchar | 2 | 0 | | |
31 | T7SI42A | Conversion of contract types to M1 values | 2 | ANSVH | Work Contract | nvarchar | 2 | 0 | | |
TOPRecruitment |
32 | PB0001 | HR Master Record: Infotype 0001 (Org. Assignment) | 33 | ANSVH | Work Contract | nvarchar | 2 | 0 | | |
TOPSweden |
33 | T5S03 | Employee Group/Subgroup (SE) | 4 | ANSVH | Work Contract | nvarchar | 2 | 0 | | |