HR_Benefit_MDVE_Table (HR2BEN12)

azurecurveProductsHuman Resources (414)3rd PartyHR_Benefit_MDVE_Table (HR2BEN12)

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
Physical Name: HR2BEN12
Technical Name: HR_Benefit_MDVE_Table

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1BENEFIT SearchBenefitSTR6_Payroll_CodeString86
2IINDEX_I SearchIIndexIINT2Integer22
3COSTEMPLOYEE_I SearchCost EmployeeDLR11_$U2Currency1014
4COSTEMPLOYER_I SearchCost EmployerDLR11_$U2Currency1014
5COSTOTHER1_I SearchCost Other 1DLR11_$S2Currency1014
6COSTOTHER2_I SearchCost Other 2DLR11_$S2Currency1014
7COSTOTHER3_I SearchCost Other 3DLR11_$S2Currency1014
8COSTTOTAL_I SearchCost TotalDLR11_$S2Currency1014
9COSTCOBRA_I SearchCost COBRADLR11_$U2Currency1014
10BENEFITDEDUCTIBLE_I SearchBenefit DeductibleDLR11_$U2Currency1014
11BNPAYPMX SearchBenefit Pay Period MaxDLR11_$U2Currency1014
12BNFYRMAX SearchBenefit Year MaxDLR11_$U2Currency1014
13BNFLFMAX SearchBenefit Lifetime MaxDLR11_$U2Currency1014
14DEX_ROW_ID Searchintint1010

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.

azurecurveProductsHuman Resources (414)3rd PartyHR_Benefit_MDVE_Table (HR2BEN12)

Leave a Reply

Your email address will not be published. Required fields are marked *