Module List >
Module HR tables
AR2BEN10
You are currently viewing the COMPANY
database.
Change
|
COMPANY..AR2BEN10 Table Definition
(COMPANY..Archive_HR_Benefit_History_2)
Field Definitions:
What is the 'source' column?
| 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
|
|
|
|
|
| BENEFITTYPE_I |
char(7)
''
|
|
|
|
|
| IINDEX_I |
smallint
0
|
|
|
|
|
| POLICYNUMBER_I |
char(31)
''
|
|
|
|
|
| GROUPNUMBER_I |
char(31)
''
|
|
|
|
|
| DATE1 |
datetime
'1/1/1900'
|
Date: Date...(more) Join Now
|
SY03900.DATE1
|
|
|
| BENEFITSTATUS_I |
smallint
0
|
|
|
|
|
| INACTIVE |
tinyint
0
|
Inactive: ...(more) Join Now
|
RM00101.INACTIVE
|
|
|
| OVERRIDE_I |
tinyint
0
|
|
|
|
|
| CHECK1_I |
tinyint
0
|
|
|
|
|
| CHECK2_I |
tinyint
0
|
|
|
|
|
| CHECK3_I |
tinyint
0
|
|
|
|
|
| CHECK4_I |
tinyint
0
|
|
|
|
|
| CHECK5_I |
tinyint
0
|
|
|
|
|
| DATEDUE_I |
datetime
'1/1/1900'
|
|
|
|
|
| DSCRIPTN |
char(31)
''
|
Descriptio...(more) Join Now
|
CM20300.DSCRIPTN
|
|
|
| COMMENTSTR10_I |
char(11)
''
|
|
|
|
|
| IBENEFITAMOUNT_I |
numeric(19,5)
0.00
|
|
|
|
|
| LIFEAMTEMPL_I |
numeric(19,5)
0.00
|
|
|
|
|
| LIFEAMTSPOUSE_I |
numeric(19,5)
0.00
|
|
|
|
|
| LIFEAMTCHILDREN_I |
numeric(19,5)
0.00
|
|
|
|
|
| BENELIGIBILEDATE_I |
datetime
'1/1/1900'
|
|
|
|
|
| BNFENDDT |
datetime
'1/1/1900'
|
Benefit En...(more) Join Now
|
UPR00600.BNFENDDT
|
|
|
| VARBENFT |
tinyint
0
|
Variable B...(more) Join Now
|
UPR00600.VARBENFT
|
|
|
| BNFTFREQ |
smallint
0
|
Benefit Fr...(more) Join Now
|
UPR00600.BNFTFREQ
|
|
|
| COSTEMPLOYEE_I |
numeric(19,5)
0.00
|
|
|
|
|
| COSTEMPLOYER_I |
numeric(19,5)
0.00
|
|
|
|
|
| COSTOTHER1_I |
numeric(19,5)
0.00
|
|
|
|
|
| COSTOTHER2_I |
numeric(19,5)
0.00
|
|
|
|
|
| COSTOTHER3_I |
numeric(19,5)
0.00
|
|
|
|
|
| I2_I |
smallint
0
|
|
|
|
|
| I3_I |
smallint
0
|
|
|
|
|
| I4_I |
smallint
0
|
|
|
|
|
| NUMBEROFCHILDREN_I |
smallint
0
|
|
|
|
|
| COSTTOTAL_I |
numeric(19,5)
0.00
|
|
|
|
|
| COSTCOBRA_I |
numeric(19,5)
0.00
|
|
|
|
|
| BENEFITDEDUCTIBLE_I |
numeric(19,5)
0.00
|
|
|
|
|
| BNPAYPMX |
numeric(19,5)
0.00
|
Benefit Pa...(more) Join Now
|
UPR00600.BNPAYPMX
|
|
|
| BNFYRMAX |
numeric(19,5)
0.00
|
Benefit Ye...(more) Join Now
|
UPR00600.BNFYRMAX
|
|
|
| BNFLFMAX |
numeric(19,5)
0.00
|
Benefit Li...(more) Join Now
|
UPR00600.BNFLFMAX
|
|
|
| BENEFICIARYINDEX_I |
int
0
|
|
|
|
|
| CHANGEBY_I |
char(15)
''
|
*Change By...(more) Join Now
|
UPR00100.CHANGEBY_I
|
|
|
| CHANGEDATE_I |
datetime
'1/1/1900'
|
*Change Da...(more) Join Now
|
UPR00100.CHANGEDATE_I
|
|
|
| NOTESINDEX_I |
numeric(19,5)
0.00
|
|
|
|
|
| CONTRIBPRETAX_I |
numeric(19,5)
0.00
|
|
|
|
|
| CONTPRETAXDLR_I |
numeric(19,5)
0.00
|
|
|
|
|
| CONTRIBAFTERTAX_I |
numeric(19,5)
0.00
|
|
|
|
|
| CONTAFTERTAXDLR_I |
numeric(19,5)
0.00
|
|
|
|
|
| CONTRIBBONUS_I |
numeric(19,5)
0.00
|
|
|
|
|
| CONTRIBBONUSDOLLAR_I |
numeric(19,5)
0.00
|
|
|
|
|
| HIGHLYCOMPENSATED_I |
tinyint
0
|
|
|
|
|
| LOANACTIVE_I |
tinyint
0
|
|
|
|
|
| LIFEINSURTYPE |
smallint
0
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|