BEN2_FMLA_Master (BE011031)

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

Display Name: BEN2_FMLA_Master
Physical Name: BE011031
Technical Name: BEN2_FMLA_Master

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	STR15_Employee_ID_I	String	15
2	INDEX1	Index	INT1	Integer	1
3	CALENDARSTART_I	Calendar Start	DT	Date	8
4	ABSENCESTARTDATE_I	Absence Start Date	DT	Date	8
5	ABSENCEENDDATE_I	Absence End Date	DT	Date	8
6	BNFBEGDT	Benefit Beg Date	DT	Date	8
7	BNFENDDT	Benefit End Date	DT	Date	8
8	ESTRETURNDATE_I	Estimated Return Date	DT	Date	8
9	PHYPROVNOTIFIED_I	Physician/Provider Notified	DT	Date	8
10	LEAVEAPPROVAL_I	Leave Approval	CB	Boolean	0
11	BENEFITEXPIRE_I	Benefit Expire	DT	Date	8
12	IBENEFITFREQUENCY_I	IBenefit Frequency	DDL_Benefit_Frequency	Integer	0
13	IBENEFITAMOUNT_I	IBenefit Amount	DLR11_$U2	Currency	14
14	IBENEFITYEARMAX_I	IBenefit Year Max	DLR14_RB2_ST$	Currency	14
15	CHECK1_I	Check1	CB_I	Boolean	0
16	HOURSWORKEDPERDAY_I	Hours Worked Per Day	DLR6_S2	Currency	6
17	TYPEOFDAY_I	Type Of Day	GB	Integer	0
18	CHECK2_I	Check2	CB_I	Boolean	0
19	IDATE_I	IDate	DT	Date	8
20	OLDCALENDARSTARTFMLA	Old_Calendar_Start_FMLA	DT	Date	8
21	COMMENTS_I	Comments	TXT1000	Text	1000
22	DEX_ROW_ID		int	int	10
	DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.