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

COMPANY..BE020230 Table Definition

(COMPANY..HR_Benefit_SETP)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
BENEFIT char(7)
''
Benefit: ...(more) Join Now UPR00600.BENEFIT
DSCRIPTN char(31)
''
Descriptio...(more) Join Now CM20300.DSCRIPTN
BENEFITSTATUS_I smallint
0

COMPLETIONSTATUS_I smallint
0

INACTIVE tinyint
0
Inactive: ...(more) Join Now RM00101.INACTIVE
BENEFITKIND_I smallint
0
1 - Health...(more) Join Now
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
CARRIER char(31)
''

GROUPNUMBER_I char(31)
''

PORTABLEBENEFIT_I tinyint
0

PORABLEINDEX_I smallint
0

MAXAGEEMP_I smallint
0

MAXAGEDEP_I smallint
0

MAXAGESP_I smallint
0

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

GB_I smallint
0

COSTTOTAL_I numeric(19,5)
0.00

COSTCOBRA_I numeric(19,5)
0.00

BENAMOUNT_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
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

NEAREST_I numeric(19,5)
0.00

NEARESTCHILD_I numeric(19,5)
0.00

NEARESTSPOUSE_I numeric(19,5)
0.00

NEARESTEMPLOYER_I numeric(19,5)
0.00

PREMMETHOD_I smallint
0

PREMIUMEMPLOYEE_I numeric(19,5)
0.00

PREMIUMSPOUSE_I numeric(19,5)
0.00

PREMIUMCHILD_I numeric(19,5)
0.00

PREMIUMEMPLOYER_I numeric(19,5)
0.00

PREMIUMSMOKER_I numeric(19,5)
0.00

FACTOR_I smallint
0

ROUNDUP_I tinyint
0

PDLIFE_I tinyint
0

CONTEMPMATCH_I numeric(19,5)
0.00

CONTRIBEMPLOYERMAX_I numeric(19,5)
0.00

MINAGE_I smallint
0

BONUSELACTIVE_I tinyint
0

LOANSALLOWED_I tinyint
0

HARDSHPWITHDRAW_I tinyint
0

TYPEOFCODE_I smallint
0

CONTRIBDOLLAR_I numeric(19,5)
0.00

CONTRIBPERCENT_I numeric(19,5)
0.00

MAJMEDCOVERAGE_I smallint
0

MAXOUTOFPOCKET_I numeric(19,5)
0.00

WAITINGPERIOD_I smallint
0

BNFTMTHD smallint
0
Benefit Me...(more) Join Now UPR00600.BNFTMTHD
BNFFRMLA smallint
0
Benefit Formula: 0 is Single, 1 is Tiered. In SBM, this field defaults to the value from the Benefit Formula field of the Payroll Benefit Setup table. The Benefit Formula field is always set to zero (0) in SBM. This field is not exposed in the SBM user interface. APR_BLM42101.BNFFRMLA
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

DEDNMTHD smallint
0
Deduction ...(more) Join Now UPR00500.DEDNMTHD
DEDFRMLA smallint
0
Deduction ...(more) Join Now UPR00500.DEDFRMLA
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

DEPYPRMX numeric(19,5)
0.00
Deduction ...(more) Join Now UPR00500.DEPYPRMX
DEDYRMAX numeric(19,5)
0.00
Deduction ...(more) Join Now UPR00500.DEDYRMAX
DEDLTMAX numeric(19,5)
0.00
Deduction ...(more) Join Now UPR00500.DEDLTMAX
INACTBENEMPLOYEE tinyint
0

INACTBENEMPLR tinyint
0

GARNISHMENT tinyint
0

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Benefit_Fiscal_Max numeric(19,5)
0.00

Deduction_Fiscal_Yr_Max numeric(19,5)
0.00

LIFEINSURTYPE smallint
0

OfferOfCoverageCode smallint
0

SafeHarborCode smallint
0

LowestCostPremium numeric
0.00

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