| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBenefits |
1 | PA0167 | HR Master Record: Infotype 0167 (Health Plans) | 55 | DTY05 | Benefit dependent type | nvarchar | 4 | 0 | | |
2 | PA0168 | HR Master Record: Infotype 0168 (Insurance Plans) | 63 | DTY05 | Benefit dependent type | nvarchar | 4 | 0 | | |
3 | PA0169 | HR Master Record: Infotype 0169 (Savings Plan) | 72 | DTY05 | Benefit dependent type | nvarchar | 4 | 0 | | |
4 | PA0212 | HR Master Record: Infotpye 0212 (COBRA Health Plan) | 47 | DTY05 | Benefit dependent type | nvarchar | 4 | 0 | | |
5 | PA0377 | HR Master Record: Infotype 0377 (Miscellaneous Plans) | 72 | DTY05 | Benefit dependent type | nvarchar | 4 | 0 | | |
6 | PA0379 | HR Master Record: Infotype 0379 (Stock Purchase Plans) | 68 | DTY05 | Benefit dependent type | nvarchar | 4 | 0 | | |
TOPUSA |
7 | PA0077 | HR Master Record: Infotype 0077 (Additional Personal Data) | 55 | DTY05 | Designated groups for Group types | nvarchar | 2 | 0 | | |
8 | PB0077 | HR Master Record: Infotype 0077 | 55 | DTY05 | Designated groups for Group types | nvarchar | 2 | 0 | | |