HR_Benefit_MDVE_Table (HR2BEN12)

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

Display Name: HR_Benefit_MDVE_Table
Physical Name: HR2BEN12
Technical Name: HR_Benefit_MDVE_Table

Group Display Name: HR Third Party
Group Technical Name: HR_Third_Party

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	SQL DB Length	Keyable Length
1	BENEFIT	Benefit	STR6_Payroll_Code	String	8	6
2	IINDEX_I	IIndex	IINT2	Integer	2	2
3	COSTEMPLOYEE_I	Cost Employee	DLR11_$U2	Currency	10	14
4	COSTEMPLOYER_I	Cost Employer	DLR11_$U2	Currency	10	14
5	COSTOTHER1_I	Cost Other 1	DLR11_$S2	Currency	10	14
6	COSTOTHER2_I	Cost Other 2	DLR11_$S2	Currency	10	14
7	COSTOTHER3_I	Cost Other 3	DLR11_$S2	Currency	10	14
8	COSTTOTAL_I	Cost Total	DLR11_$S2	Currency	10	14
9	COSTCOBRA_I	Cost COBRA	DLR11_$U2	Currency	10	14
10	BENEFITDEDUCTIBLE_I	Benefit Deductible	DLR11_$U2	Currency	10	14
11	BNPAYPMX	Benefit Pay Period Max	DLR11_$U2	Currency	10	14
12	BNFYRMAX	Benefit Year Max	DLR11_$U2	Currency	10	14
13	BNFLFMAX	Benefit Lifetime Max	DLR11_$U2	Currency	10	14
14	DEX_ROW_ID		int	int	10	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.