BEA40100 - Archive_HR_Benefit_COBRA_MSTR | Prospr - Dynamics GP Table Reference

BEA40100 - Archive_HR_Benefit_COBRA_MSTR

Query Builder

Select * from BEA40100

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
EMPID_I	Emp ID	String	16	View
IC_Instance_Number_I	IC Instance Number	Integer	2	View
EFFECTIVEDATE_I	Effective Date0	Date	4	View
LLASTNAME_I	LLast Name	String	22	View
FFIRSTNAME_I	FFirst Name	String	16	View
MI_I	MI	String	2	View
ADDRESS1	Address 1	String	62	View
ADDRESS2	Address 2	String	62	View
CITY	City	String	36	View
STATE	State	String	30	View
ZIPCODE_I	IZip Code	String	12	View
HOMEPHONE	Home Phone	String	22	View
DATEOFBIRTH_I	Date Of Birth	Date	4	View
RELATIONSHIP	Relationship	Integer	2	View
DEPSSN_I	Dep SSN	String	16	View
SSN_I	ISSN	String	16	View
BENEFITEXPIRE_I	Benefit Expire	Date	4	View
BNFBEGDT	Benefit Beg Date	Date	4	View
COBRAQE_I	COBRA QE	Integer	2	View
COMMENTSTR20	CommentStr20	String	22	View
DSCRIPTN	Description	String	32	View
IC_Initial_Balance_I	IC Initial Balance	Currency	10	View
COSTCOBRA_I	Cost COBRA	Currency	10	View
IC_Months_INT_I	IC Months INT	Integer	2	View
IC_Cobra_Month_DDL_I	IC Cobra Month DDL	Integer	2	View
IC_Cobra_Dependent_DDL_I	IC Cobra Dependent DDL	Integer	2	View
IC_Cobra_Employee_DDL_I	IC Cobra Employee DDL	Integer	2	View
IBENEFITFREQUENCY_I	IBenefit Frequency	Integer	2	View
IC_First_Payment_Date_I	IC First Payment Date	Date	4	View
IC_Last_Payment_Date_I	IC Last Payment Date	Date	4	View
IC_Auto_Post_CB_I	IC Auto Post CB	Boolean	2	View
IC_Next_Auto_Post_Date_I	IC Next Auto Post Date	Date	4	View