BE020230 - HR_Benefit_SETP | Prospr - Dynamics GP Table Reference

BE020230 - HR_Benefit_SETP

Query Builder

Select * from BE020230

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
BENEFIT	Benefit	String	8	View
DSCRIPTN	Description	String	32	View
BENEFITSTATUS_I	Benefit Status	Integer	2	View
COMPLETIONSTATUS_I	Completion Status	Integer	2	View
INACTIVE	Inactive	Boolean	2	View
BENEFITKIND_I	Benefit Kind	Integer	2	View
BNFBEGDT	Benefit Beg Date	Date	4	View
BNFENDDT	Benefit End Date	Date	4	View
VARBENFT	Variable Benefit	Boolean	2	View
BNFTFREQ	Benefit Frequency	Integer	2	View
CARRIER	Carrier	String	32	View
GROUPNUMBER_I	Group Number	String	32	View
PORTABLEBENEFIT_I	Portable Benefit	Boolean	2	View
PORABLEINDEX_I	Portable Index	Integer	2	View
MAXAGEEMP_I	Max Age-Emp	Integer	2	View
MAXAGEDEP_I	Max Age-Dep	Integer	2	View
MAXAGESP_I	Max Age-Sp	Integer	2	View
COSTEMPLOYEE_I	Cost Employee	Currency	10	View
COSTEMPLOYER_I	Cost Employer	Currency	10	View
COSTOTHER1_I	Cost Other 1	Currency	10	View
COSTOTHER2_I	Cost Other 2	Currency	10	View
I1_I	i1	Integer	2	View
I2_I	i2	Integer	2	View
I3_I	i3	Integer	2	View
I4_I	i4	Integer	2	View
GB_I	GB	Integer	2	View
COSTTOTAL_I	Cost Total	Currency	10	View
COSTCOBRA_I	Cost COBRA	Currency	10	View
BENAMOUNT_I	Ben Amount	Currency	10	View
BENEFITDEDUCTIBLE_I	Benefit Deductible	Currency	10	View
BNPAYPMX	Benefit Pay Period Max	Currency	10	View
BNFYRMAX	Benefit Year Max	Currency	10	View
BNFLFMAX	Benefit Lifetime Max	Currency	10	View
CHANGEBY_I	Change By	String	16	View
CHANGEDATE_I	Change Date	Date	4	View
NOTESINDEX_I	Notes Index	Currency	10	View
NEAREST_I	Nearest	Currency	10	View
NEARESTCHILD_I	Nearest(Child)	Currency	10	View
NEARESTSPOUSE_I	Nearest(Spouse)	Currency	10	View
NEARESTEMPLOYER_I	Nearest(Employer)	Currency	10	View
PREMMETHOD_I	Prem Method	Integer	2	View
PREMIUMEMPLOYEE_I	Premium Employee	Currency	10	View
PREMIUMSPOUSE_I	Premium Spouse	Currency	10	View
PREMIUMCHILD_I	Premium Child	Currency	10	View
PREMIUMEMPLOYER_I	Premium Employer	Currency	10	View
PREMIUMSMOKER_I	Premium Smoker	Currency	10	View
FACTOR_I	Factor	Integer	2	View
ROUNDUP_I	Round Up	Boolean	2	View
PDLIFE_I	Pd Life	Boolean	2	View
CONTEMPMATCH_I	Contrib Employer Match	Currency	10	View
CONTRIBEMPLOYERMAX_I	Contrib Employer Max	Currency	10	View
MINAGE_I	Min Age	Integer	2	View
BONUSELACTIVE_I	Bonus Election Active	Boolean	2	View
LOANSALLOWED_I	Loans Allowed	Boolean	2	View
HARDSHPWITHDRAW_I	Hardship Withdrawals	Boolean	2	View
TYPEOFCODE_I	Type of Code	Integer	2	View
CONTRIBDOLLAR_I	Contrib Dollar	Currency	10	View
CONTRIBPERCENT_I	Contrib Percent	Currency	10	View
MAJMEDCOVERAGE_I	Major Medical Coverage	Integer	2	View
MAXOUTOFPOCKET_I	Max Out-Of-Pocket	Currency	10	View
WAITINGPERIOD_I	Waiting Period	Integer	2	View
BNFTMTHD	Benefit Method	Integer	2	View
BNFFRMLA	Benefit Formula	Integer	2	View
BNFPRCNT_1	Benefit Percent[1]	Currency	10	View
BNFPRCNT_2	Benefit Percent[2]	Currency	10	View
BNFPRCNT_3	Benefit Percent[3]	Currency	10	View
BNFPRCNT_4	Benefit Percent[4]	Currency	10	View
BNFPRCNT_5	Benefit Percent[5]	Currency	10	View
DEDNMTHD	Deduction Method	Integer	2	View
DEDFRMLA	Deduction Formula	Integer	2	View
DEDNPRCT_1	Deduction Percent[1]	Currency	10	View
DEDNPRCT_2	Deduction Percent[2]	Currency	10	View
DEDNPRCT_3	Deduction Percent[3]	Currency	10	View
DEDNPRCT_4	Deduction Percent[4]	Currency	10	View
DEDNPRCT_5	Deduction Percent[5]	Currency	10	View
DEPYPRMX	Deduction Pay Period Max	Currency	10	View
DEDYRMAX	Deduction Year Max	Currency	10	View
DEDLTMAX	Deduction Lifetime Max	Currency	10	View
INACTBENEMPLOYEE	Inactive Benefit Employee	Boolean	2	View
INACTBENEMPLR	Inactive Benefit Employer	Boolean	2	View
GARNISHMENT	Garnishment	Boolean	2	View
Benefit_Fiscal_Max	Benefit Fiscal Max	Currency	10	View
Deduction_Fiscal_Yr_Max	Deduction Fiscal Year Max	Currency	10	View
LIFEINSURTYPE	Life Insurance Type	Integer	2	View

BE020230 - HR_Benefit_SETP

Query Builder

Customer Service

Information

My Account

Contact Us