| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNV_20551_APLNO | Identific. applicant number and relevance for deletion | 6 | PERSA | Personnel Area | nvarchar | 4 | 0 | | |
2 | CNV_20551_PERNR | Identific. personnel areas and relevance for deletion | 6 | PERSA | Personnel Area | nvarchar | 4 | 0 | | |
3 | CNV_20551_PERSA | Personnel areas (DEL_FLAG=X => relevant for deletion) | 3 | PERSA | Personnel Area | nvarchar | 4 | 0 | | |
4 | P2RV_SCRT | SCRT Norway | 5 | PERSA | Personnel Area | nvarchar | 4 | 0 | | |
5 | T500P_DELIMIT | Validity Period of Personnel Area | 2 | PERSA | Personnel Area | nvarchar | 4 | 0 | | |
6 | T5PPBS3B | Assignment/competency for Jobs objects | 2 | PERSA | Personnel Area | nvarchar | 4 | 0 | | |
7 | T5PPBS3BT | Assignment/competency for Jobs objects text table | 3 | PERSA | Personnel Area | nvarchar | 4 | 0 | | |
TOPCanada |
8 | T5KB3 | Registration Number Organizational assignment, Canada | 3 | PERSA | Personnel Area | nvarchar | 4 | 0 | | |
TOPCompany Pension Scheme Germany |
9 | T5D0W | Assignment of Pension Organization to Personnel Area | 2 | PERSA | Personnel Area | nvarchar | 4 | 0 | | |
TOPCross-Application Objects in HR |
10 | HRP1008 | Infotype 1008 DB Table | 21 | PERSA | Personnel Area | nvarchar | 4 | 0 | | |
TOPFinland |
11 | T7FI0P | Addtional information on personnel area/subarea (Finland) | 2 | PERSA | Personnel Area | nvarchar | 4 | 0 | | |
TOPGermany |
12 | T5D15 | EDI Funds | 3 | PERSA | Personnel Area | nvarchar | 4 | 0 | | |
TOPPersonnel Administration |
13 | T500P | Personnel Areas | 2 | PERSA | Personnel Area | nvarchar | 4 | 0 | | |
14 | T5ITI1 | Standard period table | 4 | PERSA | Personnel Area | nvarchar | 4 | 0 | | |
TOPSouth Africa |
15 | T5W4A | Leave parameter table - Southern Africa | 2 | PERSA | Personnel Area | nvarchar | 4 | 0 | | |
16 | T5W4B | Leave entitlement (IT0005) parameter table - Southern Africa | 2 | PERSA | Personnel Area | nvarchar | 4 | 0 | | |
TOPSwitzerland |
17 | T5C2I | WhT Accounting Number | 2 | PERSA | Personnel Area | nvarchar | 4 | 0 | | |
TOPTax |
18 | T5D2I | StADUEV Notifications: Transfer Numbers | 2 | PERSA | Personnel Area | nvarchar | 4 | 0 | | |
TOPWaste Management |
19 | EWA_EL_WDPLANT | Waste Disposal Facility | 10 | PERSA | Personnel Area | nvarchar | 4 | 0 | | |