Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/HR2BEN12
Product: Human Resources (414)
Series: 3rd Party
Display Name: HR_Benefit_MDVE_Table Group Display Name: HR Third Party
Physical Name: HR2BEN12
Technical Name: HR_Benefit_MDVE_Table
Group Technical Name: HR_Third_Party
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | BENEFIT ![]() | Benefit | STR6_Payroll_Code | String | 6 | |
2 | IINDEX_I ![]() | IIndex | IINT2 | Integer | 2 | |
3 | COSTEMPLOYEE_I ![]() | Cost Employee | DLR11_$U2 | Currency | 14 | |
4 | COSTEMPLOYER_I ![]() | Cost Employer | DLR11_$U2 | Currency | 14 | |
5 | COSTOTHER1_I ![]() | Cost Other 1 | DLR11_$S2 | Currency | 14 | |
6 | COSTOTHER2_I ![]() | Cost Other 2 | DLR11_$S2 | Currency | 14 | |
7 | COSTOTHER3_I ![]() | Cost Other 3 | DLR11_$S2 | Currency | 14 | |
8 | COSTTOTAL_I ![]() | Cost Total | DLR11_$S2 | Currency | 14 | |
9 | COSTCOBRA_I ![]() | Cost COBRA | DLR11_$U2 | Currency | 14 | |
10 | BENEFITDEDUCTIBLE_I ![]() | Benefit Deductible | DLR11_$U2 | Currency | 14 | |
11 | BNPAYPMX ![]() | Benefit Pay Period Max | DLR11_$U2 | Currency | 14 | |
12 | BNFYRMAX ![]() | Benefit Year Max | DLR11_$U2 | Currency | 14 | |
13 | BNFLFMAX ![]() | Benefit Lifetime Max | DLR11_$U2 | Currency | 14 | |
14 | 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. |