HR_Benefit_MDVE_Table (HR2BEN12)

azurecurveProductsHuman Resources (414)3rd PartyHR_Benefit_MDVE_Table (HR2BEN12)

Easily find this page again using the shortlink:

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 TypeLength
1BENEFIT SearchBenefitSTR6_Payroll_CodeString6
2IINDEX_I SearchIIndexIINT2Integer2
3COSTEMPLOYEE_I SearchCost EmployeeDLR11_$U2Currency14
4COSTEMPLOYER_I SearchCost EmployerDLR11_$U2Currency14
5COSTOTHER1_I SearchCost Other 1DLR11_$S2Currency14
6COSTOTHER2_I SearchCost Other 2DLR11_$S2Currency14
7COSTOTHER3_I SearchCost Other 3DLR11_$S2Currency14
8COSTTOTAL_I SearchCost TotalDLR11_$S2Currency14
9COSTCOBRA_I SearchCost COBRADLR11_$U2Currency14
10BENEFITDEDUCTIBLE_I SearchBenefit DeductibleDLR11_$U2Currency14
11BNPAYPMX SearchBenefit Pay Period MaxDLR11_$U2Currency14
12BNFYRMAX SearchBenefit Year MaxDLR11_$U2Currency14
13BNFLFMAX SearchBenefit Lifetime MaxDLR11_$U2Currency14
14DEX_ROW_ID Searchintint10

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 *