Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/BE040100
Product: Human Resources (414)
Series:
Display Name: HR_Benefit_COBRA_MSTR Group Display Name: HR Third Party
Physical Name: BE040100
Technical Name: HR_Benefit_COBRA_MSTR
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 |