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