| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBenefits |
1 | T5UBB | Benefit health option/dependent coverage assignment | 8 | BCOST | Benefit Cost Rule Variant | nvarchar | 4 | 0 | | |
2 | T5UBC | To be deleted - no longer used! | 7 | BCOST | Benefit Cost Rule Variant | nvarchar | 4 | 0 | | |
3 | T5UBH | Benefit cost rule variant | 4 | BCOST | Benefit Cost Rule Variant | nvarchar | 4 | 0 | | |
4 | T5UBI | Benefit cost rule | 4 | BCOST | Benefit Cost Rule Variant | nvarchar | 4 | 0 | | |
5 | T5UCH | Benefit cost rule variant texts | 5 | BCOST | Benefit Cost Rule Variant | nvarchar | 4 | 0 | | |
6 | T74FA | Benefit insurance plan | 7 | BCOST | Benefit Cost Rule Variant | nvarchar | 4 | 0 | | |
7 | T74FL | Benefit miscellaneous plan | 7 | BCOST | Benefit Cost Rule Variant | nvarchar | 4 | 0 | | |
TOPGeneral Parts |
8 | T74_FBN_GB05 | Flexible Benefits Employee Pension Contribution Rule (GB) | 4 | BCOST | Benefit Cost Rule Variant | nvarchar | 4 | 0 | | |