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

COMPANY..HRPBEN01 Table Definition

(COMPANY..HRP_Benefit_TEMP)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
EMPID_I char(15)
''
Employee I...(more) Join Now
BENEFIT char(7)
''
Benefit: ...(more) Join Now UPR00600.BENEFIT
BENEFITTYPE_I char(7)
''

IINDEX_I smallint
0

BENEFITKIND_I smallint
0

COMPLETIONSTATUS_I smallint
0

POLICYNUMBER_I char(31)
''

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'

BNFBEGDT datetime
'1/1/1900'
Benefit Be...(more) Join Now UPR00600.BNFBEGDT
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

I1_I smallint
0

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
CHANGEDATE_I datetime
'1/1/1900'
*Change Da...(more) Join Now
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

TYPEOFCODE_I smallint
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