Module List >
Module HR tables
AR2BEN08
You are currently viewing the COMPANY
database.
Change
|
COMPANY..AR2BEN08 Table Definition
(COMPANY..Archive_HR_Benefit_History)
Field Definitions:
What is the 'source' column?
| EMPID_I |
char(15)
''
|
Employee I...(more) Join Now
|
TATX1030.EMPID_I
|
|
|
| BENEFIT |
char(7)
''
|
Benefit: ...(more) Join Now
|
UPR00600.BENEFIT
|
|
|
| I1_I |
smallint
0
|
|
|
|
|
| DATE1 |
datetime
'1/1/1900'
|
Date: Date...(more) Join Now
|
SY03900.DATE1
|
|
|
| BENEFITTYPE_I |
char(7)
''
|
|
|
|
|
| BENEFITSTATUS_I |
smallint
0
|
|
|
|
|
| INACTIVE |
tinyint
0
|
Inactive: ...(more) Join Now
|
RM00101.INACTIVE
|
|
|
| OVERRIDE_I |
tinyint
0
|
|
|
|
|
| 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
|
|
|
|
|
| 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
|
|
|
|
|
| NUMBEROFCHILDREN_I |
smallint
0
|
|
|
|
|
| COSTTOTAL_I |
numeric(19,5)
0.00
|
|
|
|
|
| COSTCOBRA_I |
numeric(19,5)
0.00
|
|
|
|
|
| LIFEINSURTYPE |
smallint
0
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|