Module List >
Module HR tables
AR24BE17
You are currently viewing the COMPANY
database.
Change
|
COMPANY..AR24BE17 Table Definition
(COMPANY..Archive_HR_Benefit_Life_Hist)
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
|
|
|
|
|
| BENEFICIARYPRIMARY_I |
char(31)
''
|
|
|
|
|
| BENCONTINGENT_I |
char(31)
''
|
|
|
|
|
| NAMEA15_I |
char(15)
''
|
|
|
|
|
| NAMEB15_I |
char(15)
''
|
|
|
|
|
| NAMEA50_I |
char(51)
''
|
|
|
|
|
| AGEEMPLOYEE_I |
smallint
0
|
|
|
|
|
| AGESPOUSE_I |
smallint
0
|
|
|
|
|
| CHILDREN_I |
smallint
0
|
|
|
|
|
| LIFEAMTMAX_I |
numeric(19,5)
0.00
|
|
|
|
|
| LIFEAMTMAXSPOUSE_I |
numeric(19,5)
0.00
|
|
|
|
|
| LIFEAMTMAXCHILD_I |
numeric(19,5)
0.00
|
|
|
|
|
| NEAREST_I |
numeric(19,5)
0.00
|
|
|
|
|
| NEARESTSPOUSE_I |
numeric(19,5)
0.00
|
|
|
|
|
| NEARESTCHILD_I |
numeric(19,5)
0.00
|
|
|
|
|
| BNFTFREQ |
smallint
0
|
Benefit Fr...(more) Join Now
|
UPR00600.BNFTFREQ
|
|
|
| SMOKER_I |
tinyint
0
|
*Smoker: ...(more) Join Now
|
UPR00100.SMOKER_I
|
|
|
| SMOKERSP_I |
tinyint
0
|
|
|
|
|
| GB_I |
smallint
0
|
|
|
|
|
| NEARESTEMPLOYER_I |
numeric(19,5)
0.00
|
|
|
|
|
| PREMIUMEMPLOYER_I |
numeric(19,5)
0.00
|
|
|
|
|
| PREMIUMEMPLOYEE_I |
numeric(19,5)
0.00
|
|
|
|
|
| PREMIUMSMOKER_I |
numeric(19,5)
0.00
|
|
|
|
|
| PREMIUMSPOUSE_I |
numeric(19,5)
0.00
|
|
|
|
|
| PREMSMOKESPOUSE_I |
numeric(19,5)
0.00
|
|
|
|
|
| PREMIUMCHILD_I |
numeric(19,5)
0.00
|
|
|
|
|
| LIFEINSURTYPE |
smallint
0
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|