Archive_HR_Benefit_COBRA_MSTR (BEA40100)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/BEA40100

Display Name: Archive_HR_Benefit_COBRA_MSTR
Physical Name: BEA40100
Technical Name: Archive_HR_Benefit_COBRA_MSTR

Group Display Name: HR Third Party
Group Technical Name: HR_Third_Party

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	EMPID_I	Emp ID	String	STR15_Employee_ID_I	15
2	IC_Instance_Number_I	IC Instance Number	Integer	INT4	4
3	EFFECTIVEDATE_I	Effective Date0	Date	DT	8
4	LLASTNAME_I	LLast Name	String	STR20	20
5	FFIRSTNAME_I	FFirst Name	String	STR15_I	15
6	MI_I	MI	String	ISTR1	1
7	ADDRESS1	Address 1	String	STR60	60
8	ADDRESS2	Address 2	String	STR60	60
9	CITY	City	String	STR35	35
10	STATE	State	String	STR30_State	29
11	ZIPCODE_I	IZip Code	String	STR10	10
12	HOMEPHONE	Home Phone	String	STR10_Phone	10
13	DATEOFBIRTH_I	Date Of Birth	Date	DT	8
14	RELATIONSHIP	Relationship	Integer	DDL_Relationship	0
15	DEPSSN_I	Dep SSN	String	STR15_Social_Security_Number	15
16	SSN_I	ISSN	String	STR15_Social_Security_Number	15
17	BENEFITEXPIRE_I	Benefit Expire	Date	DT	8
18	BNFBEGDT	Benefit Beg Date	Date	DT	8
19	COBRAQE_I	COBRA QE	Integer	GB_I	0
20	COMMENTSTR20	CommentStr20	String	STR20	20
21	DSCRIPTN	Description	String	STR30	30
22	IC_Initial_Balance_I	IC Initial Balance	Currency	DLR14_RB2_ST$	14
23	COSTCOBRA_I	Cost COBRA	Currency	DLR11_$U2	14
24	IC_Months_INT_I	IC Months INT	Integer	INT4	4
25	IC_Cobra_Month_DDL_I	IC Cobra Month DDL	Integer	IC Cobra Month DDL	0
26	IC_Cobra_Dependent_DDL_I	IC Cobra Dependent DDL	Integer	IC Cobra Dependent DDL	0
27	IC_Cobra_Employee_DDL_I	IC Cobra Employee DDL	Integer	IC Cobra Employee DDL	0
28	IBENEFITFREQUENCY_I	IBenefit Frequency	Integer	DDL_Benefit_Frequency	0
29	IC_First_Payment_Date_I	IC First Payment Date	Date	DT	8
30	IC_Last_Payment_Date_I	IC Last Payment Date	Date	DT	8
31	IC_Auto_Post_CB_I	IC Auto Post CB	Boolean	IC Auto Post CB	0
32	IC_Next_Auto_Post_Date_I	IC Next Auto Post Date	Date	DT	8