| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T74_BPS03 | Benefit additional point rule variant | 9 | CRGRP | Benefit Parameter Group for Grouping | nvarchar | 4 | 0 | | |
2 | T74_BPS08 | Benefit request type limit rule variant | 8 | CRGRP | Benefit Parameter Group for Grouping | nvarchar | 4 | 0 | | |
TOPBenefits |
3 | T5UBH | Benefit cost rule variant | 14 | CRGRP | Benefit Parameter Group for Grouping | nvarchar | 4 | 0 | | |
4 | T5UBK | Benefit Salary Group | 3 | CRGRP | Benefit Parameter Group for Grouping | nvarchar | 4 | 0 | | |
5 | T5UBL | Benefit age group | 3 | CRGRP | Benefit Parameter Group for Grouping | nvarchar | 4 | 0 | | |
6 | T5UBM | Benefit seniority group | 3 | CRGRP | Benefit Parameter Group for Grouping | nvarchar | 4 | 0 | | |
7 | T5UBY | Benefits Parameter Group | 3 | CRGRP | Benefit Parameter Group for Grouping | nvarchar | 4 | 0 | | |
8 | T5UCK | Benefit salary group texts | 4 | CRGRP | Benefit Parameter Group for Grouping | nvarchar | 4 | 0 | | |
9 | T5UCL | Benefit age group texts | 4 | CRGRP | Benefit Parameter Group for Grouping | nvarchar | 4 | 0 | | |
10 | T5UCM | Benefit seniority group texts | 4 | CRGRP | Benefit Parameter Group for Grouping | nvarchar | 4 | 0 | | |
11 | T5UCY | Benefit parameter group texts | 4 | CRGRP | Benefit Parameter Group for Grouping | nvarchar | 4 | 0 | | |
12 | T5UDM | To be deleted - no longer used! | 12 | CRGRP | Benefit Parameter Group for Grouping | nvarchar | 4 | 0 | | |
13 | T74FB | Benefits Coverage Rule Variant | 10 | CRGRP | Benefit Parameter Group for Grouping | nvarchar | 4 | 0 | | |
14 | T74FE | Benefit employer contribution rule variant | 10 | CRGRP | Benefit Parameter Group for Grouping | nvarchar | 4 | 0 | | |
15 | T74FG | Benefit employee contribution rule variant | 10 | CRGRP | Benefit Parameter Group for Grouping | nvarchar | 4 | 0 | | |
16 | T74FJ | Benefit credit rule variant | 10 | CRGRP | Benefit Parameter Group for Grouping | nvarchar | 4 | 0 | | |
TOPClaims Processing Asia |
17 | T7XAS3 | Claim variant for Program | 11 | CRGRP | Benefit Parameter Group for Grouping | nvarchar | 4 | 0 | | |
18 | T7XAS6 | Claim variant for Plan | 13 | CRGRP | Benefit Parameter Group for Grouping | nvarchar | 4 | 0 | | |
TOPFinancial Accounting |
19 | /BGLOCS/FIEQCOR | Equity Report: Corresponding Accounts Groups | 5 | CRGRP | Equity Report: Corresponding Accounts Groups->CODE | nvarchar | 3 | 0 | | |
TOPHong Kong |
20 | T7HK2K | Contribution rules for Retirement Plans | 3 | CRGRP | Employee Group Criteria ID for Retirement Plan | nvarchar | 4 | 0 | | |
21 | T7HK2Q | Salary Grouping for Retirement plan | 2 | CRGRP | Employee Group Criteria ID for Retirement Plan | nvarchar | 4 | 0 | | |
22 | T7HK2R | Length of Service Grouping for Retirement plan | 2 | CRGRP | Employee Group Criteria ID for Retirement Plan | nvarchar | 4 | 0 | | |
23 | T7HK2S | Age Grouping for Retirement plan | 2 | CRGRP | Employee Group Criteria ID for Retirement Plan | nvarchar | 4 | 0 | | |
24 | T7HK2U | Salary Grouping Texts for Retirement plan | 3 | CRGRP | Employee Group Criteria ID for Retirement Plan | nvarchar | 4 | 0 | | |
25 | T7HK2V | LOS grouping Texts for Retirement plan | 3 | CRGRP | Employee Group Criteria ID for Retirement Plan | nvarchar | 4 | 0 | | |
26 | T7HK2W | Age Group Texts for Retirement Plan | 3 | CRGRP | Employee Group Criteria ID for Retirement Plan | nvarchar | 4 | 0 | | |
27 | T7HK2X | Employee Group Criteria ID Texts for Retirement Plan | 3 | CRGRP | Employee Group Criteria ID for Retirement Plan | nvarchar | 4 | 0 | | |
28 | T7HK2Y | Employee Group Criteria ID for Retirement Plan | 2 | CRGRP | Employee Group Criteria ID for Retirement Plan | nvarchar | 4 | 0 | | |