HR24BE17 - HR_Benefit_Life_Hist | Prospr - Dynamics GP Table Reference

HR24BE17 - HR_Benefit_Life_Hist

Query Builder

Select * from HR24BE17

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
BENEFICIARYPRIMARY_I	Beneficiary Primary	String	32	View
BENCONTINGENT_I	Beneficiary Contingent	String	32	View
NAMEA15_I	NameA15	String	16	View
NAMEB15_I	NameB15	String	16	View
NAMEA50_I	NameA50	String	52	View
AGEEMPLOYEE_I	Age Employee	Integer	2	View
AGESPOUSE_I	Age Spouse	Integer	2	View
CHILDREN_I	Children	Integer	2	View
LIFEAMTMAX_I	Life Amt Max	Currency	10	View
LIFEAMTMAXSPOUSE_I	Life Amt Max Spouse	Currency	10	View
LIFEAMTMAXCHILD_I	Life Amt Max Child	Currency	10	View
NEAREST_I	Nearest	Currency	10	View
NEARESTSPOUSE_I	Nearest(Spouse)	Currency	10	View
NEARESTCHILD_I	Nearest(Child)	Currency	10	View
BNFTFREQ	Benefit Frequency	Integer	2	View
SMOKER_I	Smoker	Boolean	2	View
SMOKERSP_I	SmokerSp	Boolean	2	View
GB_I	GB	Integer	2	View
NEARESTEMPLOYER_I	Nearest(Employer)	Currency	10	View
PREMIUMEMPLOYER_I	Premium Employer	Currency	10	View
PREMIUMEMPLOYEE_I	Premium Employee	Currency	10	View
PREMIUMSMOKER_I	Premium Smoker	Currency	10	View
PREMIUMSPOUSE_I	Premium Spouse	Currency	10	View
PREMSMOKESPOUSE_I	Premium Smoking Spouse	Currency	10	View
PREMIUMCHILD_I	Premium Child	Currency	10	View
LIFEINSURTYPE	Life Insurance Type	Integer	2	View