Module List > Module HR tables AR2BEN40
You are currently viewing the COMPANY database.
Change

COMPANY..AR2BEN40 Table Definition

(COMPANY..Archive_HR_Benefit_Tiers_MSTR_Hist)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
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
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3