| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | PA0614 | HR Master Record: Infotype 0614 | 24 | STAFF | HESA staff ID | nvarchar | 13 | 0 | | |
2 | T5A1C | SI Contributions/Contribution Amounts | 5 | STAFF | Progressive rates | nvarchar | 1 | 0 | | |
3 | T5A2S | Deduction Amounts: Tax (A) | 3 | STAFF | Progressive Rates | nvarchar | 1 | 0 | | |
4 | T5A2S_PP | Commuter Rate (Kilometer Limit) | 2 | STAFF | Progressive Rates | nvarchar | 1 | 0 | | |
5 | T5A2S_PPT | Commuter Rate: Scaling Texts | 2 | STAFF | Progressive Rates | nvarchar | 1 | 0 | | |
6 | T5A4A | General Absence Data | 3 | STAFF | Employee | nvarchar | 1 | 0 | | |
7 | T5A4B | Seniority | 3 | STAFF | Employee | nvarchar | 1 | 0 | | |
8 | T5A4F | Absence Categories for Collective Contract/Company Agreement | 3 | STAFF | Employee | nvarchar | 1 | 0 | | |
9 | T5A4G | Use of Absence Categories | 3 | STAFF | Employee | nvarchar | 1 | 0 | | |
10 | T5A4T | Valuation According to Absence Duration | 3 | STAFF | Employee | nvarchar | 1 | 0 | | |
11 | T5A4V | Entitlements per Absence | 3 | STAFF | Employee | nvarchar | 1 | 0 | | |
TOPAustria |
12 | T5A03 | Employee Groups/Employee Subgroups | 4 | STAFF | Employee | nvarchar | 1 | 0 | | |
TOPForce Element |
13 | /ISDFPS/CSTACHG | Obsolete: New Table /ISDFPS/STA_CHG | 9 | STAFF | General Flag | nvarchar | 1 | 0 | | |
14 | /ISDFPS/CSTACHGC | Obsolete: New Table /ISDFPS/STA_CHGC | 10 | STAFF | General Flag | nvarchar | 1 | 0 | | |
15 | /ISDFPS/CSTASUC | Obsolete: New Table /ISDFPS/STA_SUC | 7 | STAFF | General Flag | nvarchar | 1 | 0 | | |
16 | /ISDFPS/CSTASUCC | Obsolete: New Table /ISDFPS/STA_UCC | 8 | STAFF | General Flag | nvarchar | 1 | 0 | | |
TOPPersonnel Administration |
17 | T5H2P | Tax allowance amount levels | 3 | STAFF | Tax allowance amount levels | nvarchar | 2 | 0 | | |
18 | T5H2R | Tax allowance amounts - texts | 4 | STAFF | Tax allowance amount levels | nvarchar | 2 | 0 | | |
19 | T5H2S | Tax allowance amounts | 3 | STAFF | Tax allowance amount levels | nvarchar | 2 | 0 | | |