BEA11031 - Archive_BEN2_FMLA_Master | Prospr - Dynamics GP Table Reference

BEA11031 - Archive_BEN2_FMLA_Master

Select * from BEA11031

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
EMPID_I	Emp ID	String	16	View
INDEX1	Index	Integer	2	View
CALENDARSTART_I	Calendar Start	Date	4	View
ABSENCESTARTDATE_I	Absence Start Date	Date	4	View
ABSENCEENDDATE_I	Absence End Date	Date	4	View
BNFBEGDT	Benefit Beg Date	Date	4	View
BNFENDDT	Benefit End Date	Date	4	View
ESTRETURNDATE_I	Estimated Return Date	Date	4	View
PHYPROVNOTIFIED_I	Physician/Provider Notified	Date	4	View
LEAVEAPPROVAL_I	Leave Approval	Boolean	2	View
BENEFITEXPIRE_I	Benefit Expire	Date	4	View
IBENEFITFREQUENCY_I	IBenefit Frequency	Integer	2	View
IBENEFITAMOUNT_I	IBenefit Amount	Currency	10	View
IBENEFITYEARMAX_I	IBenefit Year Max	Currency	10	View
CHECK1_I	Check1	Boolean	2	View
HOURSWORKEDPERDAY_I	Hours Worked Per Day	Currency	10	View
TYPEOFDAY_I	Type Of Day	Integer	2	View
CHECK2_I	Check2	Boolean	2	View
IDATE_I	IDate	Date	4	View
OLDCALENDARSTARTFMLA	Old_Calendar_Start_FMLA	Date	4	View
COMMENTS_I	Comments	Text	2	View