HR_Benefit_History_2 (HR2BEN10)

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

Product: Human Resources (414)
Series: 3rd Party

Display Name: HR_Benefit_History_2
Physical Name: HR2BEN10
Technical Name: HR_Benefit_History_2

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1EMPID_I SearchEmp IDSTR15_Employee_ID_IString15
2BNFBEGDT SearchBenefit Beg DateDTDate8
3BENEFIT SearchBenefitSTR6_Payroll_CodeString6
4I1_I Searchi1INT5_NoFormatInteger5
5BENEFITTYPE_I SearchBenefit TypeSTR6_U0String6
6IINDEX_I SearchIIndexIINT2Integer2
7POLICYNUMBER_I SearchPolicy NumberSTR30_I0String30
8GROUPNUMBER_I SearchGroup NumberSTR30_I0String30
9DATE1 SearchDateDT6Date6
10BENEFITSTATUS_I SearchBenefit StatusDDL_Benefit_StatusInteger0
11INACTIVE SearchInactiveCB_InactiveBoolean0
12OVERRIDE_I SearchOverrideCB_IBoolean0
13CHECK1_I SearchCheck1CB_IBoolean0
14CHECK2_I SearchCheck2CB_IBoolean0
15CHECK3_I SearchCheck3CB_IBoolean0
16CHECK4_I SearchCheck4CB_IBoolean0
17CHECK5_I SearchCheck5CB_IBoolean0
18DATEDUE_I SearchDate DueDTDate8
19DSCRIPTN SearchDescriptionSTR30String30
20COMMENTSTR10_I SearchCommentStr10STR10String10
21IBENEFITAMOUNT_I SearchIBenefit AmountDLR11_$U2Currency14
22LIFEAMTEMPL_I SearchLife Amt EmplDLR14_WholeCurrency14
23LIFEAMTSPOUSE_I SearchLife Amt SpouseDLR14_WholeCurrency14
24LIFEAMTCHILDREN_I SearchLife Amt Child(ren)DLR14_WholeCurrency14
25BENELIGIBILEDATE_I SearchBenefit Eligibility DateDTDate8
26BNFENDDT SearchBenefit End DateDTDate8
27VARBENFT SearchVariable BenefitCB_VariableBoolean0
28BNFTFREQ SearchBenefit FrequencyDDL_Ded/Ben FrequencyInteger0
29COSTEMPLOYEE_I SearchCost EmployeeDLR11_$U2Currency14
30COSTEMPLOYER_I SearchCost EmployerDLR11_$U2Currency14
31COSTOTHER1_I SearchCost Other 1DLR11_$S2Currency14
32COSTOTHER2_I SearchCost Other 2DLR11_$S2Currency14
33COSTOTHER3_I SearchCost Other 3DLR11_$S2Currency14
34I2_I Searchi2INT5_NoFormatInteger5
35I3_I Searchi3INT5_NoFormatInteger5
36I4_I Searchi4INT5_NoFormatInteger5
37NUMBEROFCHILDREN_I SearchNumber of childrenINT2Integer2
38COSTTOTAL_I SearchCost TotalDLR11_$S2Currency14
39COSTCOBRA_I SearchCost COBRADLR11_$U2Currency14
40BENEFITDEDUCTIBLE_I SearchBenefit DeductibleDLR11_$U2Currency14
41BNPAYPMX SearchBenefit Pay Period MaxDLR11_$U2Currency14
42BNFYRMAX SearchBenefit Year MaxDLR11_$U2Currency14
43BNFLFMAX SearchBenefit Lifetime MaxDLR11_$U2Currency14
44BENEFICIARYINDEX_I SearchBeneficiary IndexLONGINTLong Integer0
45CHANGEBY_I SearchChange BySTR15_User_IDString15
46CHANGEDATE_I SearchChange DateDTDate8
47NOTESINDEX_I SearchNotes IndexDOLLARCurrency0
48CONTRIBPRETAX_I SearchContrib Pre TaxDLR8_U5%Currency8
49CONTPRETAXDLR_I SearchContrib Pre Tax DollarDLR11_$U2Currency14
50CONTRIBAFTERTAX_I SearchContrib After TaxDLR8_U5%Currency8
51CONTAFTERTAXDLR_I SearchContrib After Tax DollarDLR11_$U2Currency14
52CONTRIBBONUS_I SearchContrib BonusDLR8_U5%Currency8
53CONTRIBBONUSDOLLAR_I SearchContrib Bonus DollarDLR11_$U2Currency14
54HIGHLYCOMPENSATED_I SearchHighly CompensatedCB_IBoolean0
55LOANACTIVE_I SearchLoan ActiveCB_IBoolean0
56Benefit_Fiscal_Max SearchBenefit Fiscal MaxDLR11_$U2Currency14
57Deduction_Fiscal_Yr_Max SearchDeduction Fiscal Year MaxDLR11_$S2Currency14
58DEX_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.

Leave a Reply

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