HR2BEN10 - HR_Benefit_History_2 | Prospr - Dynamics GP Table Reference

HR2BEN10 - HR_Benefit_History_2

Query Builder

Select * from HR2BEN10

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
EMPID_I	Emp ID	String	16	View
BNFBEGDT	Benefit Beg Date	Date	4	View
BENEFIT	Benefit	String	8	View
I1_I	i1	Integer	2	View
BENEFITTYPE_I	Benefit Type	String	8	View
IINDEX_I	IIndex	Integer	2	View
POLICYNUMBER_I	Policy Number	String	32	View
GROUPNUMBER_I	Group Number	String	32	View
DATE1	Date	Date	4	View
BENEFITSTATUS_I	Benefit Status	Integer	2	View
INACTIVE	Inactive	Boolean	2	View
OVERRIDE_I	Override	Boolean	2	View
CHECK1_I	Check1	Boolean	2	View
CHECK2_I	Check2	Boolean	2	View
CHECK3_I	Check3	Boolean	2	View
CHECK4_I	Check4	Boolean	2	View
CHECK5_I	Check5	Boolean	2	View
DATEDUE_I	Date Due	Date	4	View
DSCRIPTN	Description	String	32	View
COMMENTSTR10_I	CommentStr10	String	12	View
IBENEFITAMOUNT_I	IBenefit Amount	Currency	10	View
LIFEAMTEMPL_I	Life Amt Empl	Currency	10	View
LIFEAMTSPOUSE_I	Life Amt Spouse	Currency	10	View
LIFEAMTCHILDREN_I	Life Amt Child(ren)	Currency	10	View
BENELIGIBILEDATE_I	Benefit Eligibility Date	Date	4	View
BNFENDDT	Benefit End Date	Date	4	View
VARBENFT	Variable Benefit	Boolean	2	View
BNFTFREQ	Benefit Frequency	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
COSTOTHER3_I	Cost Other 3	Currency	10	View
I2_I	i2	Integer	2	View
I3_I	i3	Integer	2	View
I4_I	i4	Integer	2	View
NUMBEROFCHILDREN_I	Number of children	Integer	2	View
COSTTOTAL_I	Cost Total	Currency	10	View
COSTCOBRA_I	Cost COBRA	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
BENEFICIARYINDEX_I	Beneficiary Index	Long Integer	4	View
CHANGEBY_I	Change By	String	16	View
CHANGEDATE_I	Change Date	Date	4	View
NOTESINDEX_I	Notes Index	Currency	10	View
CONTRIBPRETAX_I	Contrib Pre Tax	Currency	10	View
CONTPRETAXDLR_I	Contrib Pre Tax Dollar	Currency	10	View
CONTRIBAFTERTAX_I	Contrib After Tax	Currency	10	View
CONTAFTERTAXDLR_I	Contrib After Tax Dollar	Currency	10	View
CONTRIBBONUS_I	Contrib Bonus	Currency	10	View
CONTRIBBONUSDOLLAR_I	Contrib Bonus Dollar	Currency	10	View
HIGHLYCOMPENSATED_I	Highly Compensated	Boolean	2	View
LOANACTIVE_I	Loan Active	Boolean	2	View
Benefit_Fiscal_Max	Benefit Fiscal Max	Currency	10	View
Deduction_Fiscal_Yr_Max	Deduction Fiscal Year Max	Currency	10	View

HR2BEN10 - HR_Benefit_History_2

Query Builder

Customer Service

Information

My Account

Contact Us