HR2BEN08 - HR_Benefit_History | Prospr - Dynamics GP Table Reference

HR2BEN08 - HR_Benefit_History

Query Builder

Select * from HR2BEN08

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
EMPID_I	Emp ID	String	16	View
BENEFIT	Benefit	String	8	View
I1_I	i1	Integer	2	View
DATE1	Date	Date	4	View
BENEFITTYPE_I	Benefit Type	String	8	View
BENEFITSTATUS_I	Benefit Status	Integer	2	View
INACTIVE	Inactive	Boolean	2	View
OVERRIDE_I	Override	Boolean	2	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
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
NUMBEROFCHILDREN_I	Number of children	Integer	2	View
COSTTOTAL_I	Cost Total	Currency	10	View
COSTCOBRA_I	Cost COBRA	Currency	10	View