| EMPID_I |
char(15)
''
|
Employee I...(more) Join Now
|
TATX1030.EMPID_I
|
|
|
| BNFBEGDT |
datetime
'1/1/1900'
|
Benefit Be...(more) Join Now
|
UPR00600.BNFBEGDT
|
|
|
| BENEFIT |
char(7)
''
|
Benefit: ...(more) Join Now
|
UPR00600.BENEFIT
|
|
|
| I1_I |
smallint
0
|
|
|
|
|
| CHECK1_I |
tinyint
0
|
|
|
|
|
| TIERMETHOD_I |
smallint
0
|
|
|
|
|
| BNFTMTHD |
smallint
0
|
Benefit Me...(more) Join Now
|
UPR00600.BNFTMTHD
|
|
|
| BNFPRCNT_1 |
numeric(19,5)
0.00
|
Benefit Pe...(more) Join Now
|
UPR00600.BNFPRCNT_1
|
|
|
| BNFPRCNT_2 |
numeric(19,5)
0.00
|
|
|
|
|
| BNFPRCNT_3 |
numeric(19,5)
0.00
|
|
|
|
|
| BNFPRCNT_4 |
numeric(19,5)
0.00
|
|
|
|
|
| BNFPRCNT_5 |
numeric(19,5)
0.00
|
|
|
|
|
| BNFITAMT_1 |
numeric(19,5)
0.00
|
Benefit Am...(more) Join Now
|
UPR00600.BNFITAMT_1
|
|
|
| BNFITAMT_2 |
numeric(19,5)
0.00
|
|
|
|
|
| BNFITAMT_3 |
numeric(19,5)
0.00
|
|
|
|
|
| BNFITAMT_4 |
numeric(19,5)
0.00
|
|
|
|
|
| BNFITAMT_5 |
numeric(19,5)
0.00
|
|
|
|
|
| BNFTRMAX_1 |
numeric(19,5)
0.00
|
Benefit Ti...(more) Join Now
|
UPR00600.BNFTRMAX_1
|
|
|
| BNFTRMAX_2 |
numeric(19,5)
0.00
|
|
|
|
|
| BNFTRMAX_3 |
numeric(19,5)
0.00
|
|
|
|
|
| BNFTRMAX_4 |
numeric(19,5)
0.00
|
|
|
|
|
| BNFTRMAX_5 |
numeric(19,5)
0.00
|
|
|
|
|
| BNTRMXUN_1 |
int
0
|
Benefit Ti...(more) Join Now
|
UPR00600.BNTRMXUN_1
|
|
|
| BNTRMXUN_2 |
int
0
|
|
|
|
|
| BNTRMXUN_3 |
int
0
|
|
|
|
|
| BNTRMXUN_4 |
int
0
|
|
|
|
|
| BNTRMXUN_5 |
int
0
|
|
|
|
|
| DEDNMTHD |
smallint
0
|
Deduction ...(more) Join Now
|
UPR00500.DEDNMTHD
|
|
|
| DEDNPRCT_1 |
numeric(19,5)
0.00
|
Deduction ...(more) Join Now
|
UPR00500.DEDNPRCT_1
|
|
|
| DEDNPRCT_2 |
numeric(19,5)
0.00
|
|
|
|
|
| DEDNPRCT_3 |
numeric(19,5)
0.00
|
|
|
|
|
| DEDNPRCT_4 |
numeric(19,5)
0.00
|
|
|
|
|
| DEDNPRCT_5 |
numeric(19,5)
0.00
|
|
|
|
|
| DEDCAMNT_1 |
numeric(19,5)
0.00
|
Deduction ...(more) Join Now
|
UPR00500.DEDCAMNT_1
|
|
|
| DEDCAMNT_2 |
numeric(19,5)
0.00
|
|
|
|
|
| DEDCAMNT_3 |
numeric(19,5)
0.00
|
|
|
|
|
| DEDCAMNT_4 |
numeric(19,5)
0.00
|
|
|
|
|
| DEDCAMNT_5 |
numeric(19,5)
0.00
|
|
|
|
|
| DEDTRMAX_1 |
numeric(19,5)
0.00
|
Deduction ...(more) Join Now
|
UPR00500.DEDTRMAX_1
|
|
|
| DEDTRMAX_2 |
numeric(19,5)
0.00
|
|
|
|
|
| DEDTRMAX_3 |
numeric(19,5)
0.00
|
|
|
|
|
| DEDTRMAX_4 |
numeric(19,5)
0.00
|
|
|
|
|
| DEDTRMAX_5 |
numeric(19,5)
0.00
|
|
|
|
|
| DETRMXUN_1 |
int
0
|
Deduction ...(more) Join Now
|
UPR00500.DETRMXUN_1
|
|
|
| DETRMXUN_2 |
int
0
|
|
|
|
|
| DETRMXUN_3 |
int
0
|
|
|
|
|
| DETRMXUN_4 |
int
0
|
|
|
|
|
| DETRMXUN_5 |
int
0
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|