BE040100 - HR_Benefit_COBRA_MSTR
Dynamics GP table BE040100 (HR_Benefit_COBRA_MSTR) contains 32 columns including EMPID_I, IC_Instance_Number_I, EFFECTIVEDATE_I....
SQL Query Builder
32 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| EMPID_I | Emp ID | String | 16 | |
| IC_Instance_Number_I | IC Instance Number | Integer | 2 | |
| EFFECTIVEDATE_I | Effective Date0 | Date | 4 | |
| LLASTNAME_I | LLast Name | String | 22 | |
| FFIRSTNAME_I | FFirst Name | String | 16 | |
| MI_I | MI | String | 2 | |
| ADDRESS1 | Address 1 | String | 62 | |
| ADDRESS2 | Address 2 | String | 62 | |
| CITY | City | String | 36 | |
| STATE | State | String | 30 | |
| ZIPCODE_I | IZip Code | String | 12 | |
| HOMEPHONE | Home Phone | String | 22 | |
| DATEOFBIRTH_I | Date Of Birth | Date | 4 | |
| RELATIONSHIP | Relationship | Integer | 2 | |
| DEPSSN_I | Dep SSN | String | 16 | |
| SSN_I | ISSN | String | 16 | |
| BENEFITEXPIRE_I | Benefit Expire | Date | 4 | |
| BNFBEGDT | Benefit Beg Date | Date | 4 | |
| COBRAQE_I | COBRA QE | Integer | 2 | |
| COMMENTSTR20 | CommentStr20 | String | 22 | |
| DSCRIPTN | Description | String | 32 | |
| IC_Initial_Balance_I | IC Initial Balance | Currency | 10 | |
| COSTCOBRA_I | Cost COBRA | Currency | 10 | |
| IC_Months_INT_I | IC Months INT | Integer | 2 | |
| IC_Cobra_Month_DDL_I | IC Cobra Month DDL | Integer | 2 | |
| IC_Cobra_Dependent_DDL_I | IC Cobra Dependent DDL | Integer | 2 | |
| IC_Cobra_Employee_DDL_I | IC Cobra Employee DDL | Integer | 2 | |
| IBENEFITFREQUENCY_I | IBenefit Frequency | Integer | 2 | |
| IC_First_Payment_Date_I | IC First Payment Date | Date | 4 | |
| IC_Last_Payment_Date_I | IC Last Payment Date | Date | 4 | |
| IC_Auto_Post_CB_I | IC Auto Post CB | Boolean | 2 | |
| IC_Next_Auto_Post_Date_I | IC Next Auto Post Date | Date | 4 |
Related Tables
Tables that share columns with BE040100. Click "Join" to add to your query.