| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T74_BPS05 | Benefit additional point rule | 5 | SALGR | Benefit salary group | nvarchar | 4 | 0 | | |
2 | T74_BPS10 | Benefit request type limit rule | 4 | SALGR | Benefit salary group | nvarchar | 4 | 0 | | |
TOPBenefits |
3 | T5UBI | Benefit cost rule | 5 | SALGR | Benefit salary group | nvarchar | 4 | 0 | | |
4 | T5UBK | Benefit Salary Group | 4 | SALGR | Benefit salary group | nvarchar | 4 | 0 | | |
5 | T5UCK | Benefit salary group texts | 5 | SALGR | Benefit salary group | nvarchar | 4 | 0 | | |
6 | T5UDN | To be deleted - no longer used! | 4 | SALGR | Benefit salary group | nvarchar | 4 | 0 | | |
7 | T74FC | Benefits Insurance Coverage Rule | 5 | SALGR | Benefit salary group | nvarchar | 4 | 0 | | |
8 | T74FF | Benefit employer contribution rule | 5 | SALGR | Benefit salary group | nvarchar | 4 | 0 | | |
9 | T74FH | Benefit employee contribution rule | 5 | SALGR | Benefit salary group | nvarchar | 4 | 0 | | |
10 | T74FK | Benefit credit rule | 5 | SALGR | Benefit salary group | nvarchar | 4 | 0 | | |
TOPClaims Processing Asia |
11 | T7XAS5 | Claim rule for Program | 4 | SALGR | Benefit salary group | nvarchar | 4 | 0 | | |
12 | T7XAS8 | Claim rule for Plan | 5 | SALGR | Benefit salary group | nvarchar | 4 | 0 | | |
TOPGeneral Parts |
13 | T74_FBN_GB05 | Flexible Benefits Employee Pension Contribution Rule (GB) | 5 | SALGR | Benefit salary group | nvarchar | 4 | 0 | | |
TOPHong Kong |
14 | T7HK2Q | Salary Grouping for Retirement plan | 3 | SALGR | Salary grouping for retirement plan | nvarchar | 4 | 0 | | |
15 | T7HK2U | Salary Grouping Texts for Retirement plan | 4 | SALGR | Salary grouping for retirement plan | nvarchar | 4 | 0 | | |
16 | T7HK2Z | Contribution Rule Criteria for Each Contribution Rule | 6 | SALGR | Salary grouping for retirement plan | nvarchar | 4 | 0 | | |
TOPReporting |
17 | T5N2Z | Taxable Allowance for Childcare | 3 | SALGR | Income Theshold for Childcare | decimal | 9 | 2 | | |