| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBenefits |
1 | PA0167 | HR Master Record: Infotype 0167 (Health Plans) | 32 | BOPTI | Benefit Health Plan Option | nvarchar | 4 | 0 | | |
2 | PA0212 | HR Master Record: Infotpye 0212 (COBRA Health Plan) | 29 | BOPTI | Benefit Health Plan Option | nvarchar | 4 | 0 | | |
3 | T5UB6 | Benefit Standard Health Selection | 7 | BOPTI | Benefit Health Plan Option | nvarchar | 4 | 0 | | |
4 | T5UBB | Benefit health option/dependent coverage assignment | 4 | BOPTI | Benefit Health Plan Option | nvarchar | 4 | 0 | | |
5 | T5UBE | Benefit Health Plan Option | 4 | BOPTI | Benefit Health Plan Option | nvarchar | 4 | 0 | | |
6 | T5UCE | Benefit health plan option texts | 5 | BOPTI | Benefit Health Plan Option | nvarchar | 4 | 0 | | |
7 | T74FS | Benefit evidence of insurability option assignment | 4 | BOPTI | Benefit Health Plan Option | nvarchar | 4 | 0 | | |
TOPGeneral Parts |
8 | T74_FBN_GB11 | Email Data for GB Flexible Benefit | 6 | BOPTI | Benefit Health Plan Option | nvarchar | 4 | 0 | | |
TOPUSA |
9 | T5UPBSPA16 | Federal Health Plan Mapping (PS) | 5 | BOPTI | Benefit Health Plan Option | nvarchar | 4 | 0 | | |