BEA11031 - Archive_BEN2_FMLA_Master
Dynamics GP table BEA11031 (Archive_BEN2_FMLA_Master) contains 21 columns including EMPID_I, INDEX1, CALENDARSTART_I....
SQL Query Builder
21 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| EMPID_I | Emp ID | String | 16 | |
| INDEX1 | Index | Integer | 2 | |
| CALENDARSTART_I | Calendar Start | Date | 4 | |
| ABSENCESTARTDATE_I | Absence Start Date | Date | 4 | |
| ABSENCEENDDATE_I | Absence End Date | Date | 4 | |
| BNFBEGDT | Benefit Beg Date | Date | 4 | |
| BNFENDDT | Benefit End Date | Date | 4 | |
| ESTRETURNDATE_I | Estimated Return Date | Date | 4 | |
| PHYPROVNOTIFIED_I | Physician/Provider Notified | Date | 4 | |
| LEAVEAPPROVAL_I | Leave Approval | Boolean | 2 | |
| BENEFITEXPIRE_I | Benefit Expire | Date | 4 | |
| IBENEFITFREQUENCY_I | IBenefit Frequency | Integer | 2 | |
| IBENEFITAMOUNT_I | IBenefit Amount | Currency | 10 | |
| IBENEFITYEARMAX_I | IBenefit Year Max | Currency | 10 | |
| CHECK1_I | Check1 | Boolean | 2 | |
| HOURSWORKEDPERDAY_I | Hours Worked Per Day | Currency | 10 | |
| TYPEOFDAY_I | Type Of Day | Integer | 2 | |
| CHECK2_I | Check2 | Boolean | 2 | |
| IDATE_I | IDate | Date | 4 | |
| OLDCALENDARSTARTFMLA | Old_Calendar_Start_FMLA | Date | 4 | |
| COMMENTS_I | Comments | Text | 2 |
Related Tables
Tables that share columns with BEA11031. Click "Join" to add to your query.