| EMPLOYID |
char(15)
''
|
Employee I...(more) Join Now
|
|
|
join ... more text available
|
| BENEFIT |
char(7)
''
|
|
|
|
|
| INACTIVE |
tinyint
0
|
|
|
|
|
| BNFBEGDT |
datetime
'1/1/1900'
|
Benefit Be...(more) Join Now
|
|
|
|
| BNFENDDT |
datetime
'1/1/1900'
|
Benefit En...(more) Join Now
|
|
|
|
| VARBENFT |
tinyint
0
|
Variable B...(more) Join Now
|
|
|
|
| BNFTFREQ |
smallint
0
|
Benefit Fr...(more) Join Now
|
|
|
|
| TAXABLE |
tinyint
0
|
Taxable: ...(more) Join Now
|
|
|
|
| SBJTFDTX |
tinyint
0
|
Subject To...(more) Join Now
|
|
|
|
| SBJTSSEC |
tinyint
0
|
Subject To...(more) Join Now
|
|
|
|
| SBJTMCAR |
tinyint
0
|
Subject To...(more) Join Now
|
|
|
|
| SBJTSTTX |
tinyint
0
|
Subject to...(more) Join Now
|
|
|
|
| SBJTLTAX |
tinyint
0
|
Subject to...(more) Join Now
|
|
|
|
| SBJTFUTA |
tinyint
0
|
|
|
|
|
| SBJTSUTA |
tinyint
0
|
Subject to...(more) Join Now
|
|
|
|
| FFEDTXRT |
smallint
0
|
Flat Feder...(more) Join Now
|
|
|
|
| FLSTTXRT |
smallint
0
|
Flat State...(more) Join Now
|
|
|
|
| BORCDTYP |
smallint
0
|
Based On
...(more) Join Now
|
|
|
|
| BSDORCDS |
smallint
0
|
Based On R...(more) Join Now
|
|
|
|
| BNFTMTHD |
smallint
0
|
Benefit Me...(more) Join Now
|
|
|
|
| BNFFRMLA |
smallint
0
|
Benefit Formula: 0 is Single, 1 is Tiered. In SBM, this field defaults to the value from the Benefit Formula field of the Payroll Benefit Setup table. The Benefit Formula field is always set to zero (0) in SBM. This field is not exposed in the SBM user interface.
|
APR_BLM42101.BNFFRMLA
|
|
|
| BNFPRCNT_1 |
numeric(19,5)
0.00
|
Benefit Pe...(more) Join Now
|
|
|
|
| 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
|
|
|
|
| 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
|
|
|
|
| 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
|
|
|
|
| BNTRMXUN_2 |
int
0
|
|
|
|
|
| BNTRMXUN_3 |
int
0
|
|
|
|
|
| BNTRMXUN_4 |
int
0
|
|
|
|
|
| BNTRMXUN_5 |
int
0
|
|
|
|
|
| BNPAYPMX |
numeric(19,5)
0.00
|
Benefit Pa...(more) Join Now
|
|
|
|
| BNFYRMAX |
numeric(19,5)
0.00
|
Benefit Ye...(more) Join Now
|
|
|
|
| BNFLFMAX |
numeric(19,5)
0.00
|
Benefit Li...(more) Join Now
|
|
|
|
| W2BXNMBR |
smallint
0
|
W2 Box Num...(more) Join Now
|
|
|
|
| W2BXLABL |
char(7)
''
|
W2 Box Lab...(more) Join Now
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| LTDBNFIT |
numeric(19,5)
0.00
|
LTD Benefi...(more) Join Now
|
|
|
|
| DATAENTDFLT |
tinyint
0
|
Data Entry...(more) Join Now
|
|
|
|
| EMPLRMAXMAT |
numeric(19,5)
0.00
|
Employer
...(more) Join Now
|
|
|
|
| W2BXNMBR2 |
smallint
0
|
|
|
|
|
| W2BXLABL2 |
char(7)
''
|
|
|
|
|
| W2BXNMBR3 |
smallint
0
|
|
|
|
|
| W2BXLABL3 |
char(7)
''
|
|
|
|
|
| W2BXNMBR4 |
smallint
0
|
|
|
|
|
| W2BXLABL4 |
char(7)
''
|
|
|
|
|
| Benefit_Fiscal_Max |
numeric(19,5)
0.00
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|