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 TypeSQL DB LengthKeyable Length
1EMPID_I SearchEmp IDSTR15_Employee_ID_IString1615
2BNFBEGDT SearchBenefit Beg DateDTDate48
3BENEFIT SearchBenefitSTR6_Payroll_CodeString86
4I1_I Searchi1INT5_NoFormatInteger25
5BENEFITTYPE_I SearchBenefit TypeSTR6_U0String86
6IINDEX_I SearchIIndexIINT2Integer22
7POLICYNUMBER_I SearchPolicy NumberSTR30_I0String3230
8GROUPNUMBER_I SearchGroup NumberSTR30_I0String3230
9DATE1 SearchDateDT6Date46
10BENEFITSTATUS_I SearchBenefit StatusDDL_Benefit_StatusInteger20
11INACTIVE SearchInactiveCB_InactiveBoolean20
12OVERRIDE_I SearchOverrideCB_IBoolean20
13CHECK1_I SearchCheck1CB_IBoolean20
14CHECK2_I SearchCheck2CB_IBoolean20
15CHECK3_I SearchCheck3CB_IBoolean20
16CHECK4_I SearchCheck4CB_IBoolean20
17CHECK5_I SearchCheck5CB_IBoolean20
18DATEDUE_I SearchDate DueDTDate48
19DSCRIPTN SearchDescriptionSTR30String3230
20COMMENTSTR10_I SearchCommentStr10STR10String1210
21IBENEFITAMOUNT_I SearchIBenefit AmountDLR11_$U2Currency1014
22LIFEAMTEMPL_I SearchLife Amt EmplDLR14_WholeCurrency1014
23LIFEAMTSPOUSE_I SearchLife Amt SpouseDLR14_WholeCurrency1014
24LIFEAMTCHILDREN_I SearchLife Amt Child(ren)DLR14_WholeCurrency1014
25BENELIGIBILEDATE_I SearchBenefit Eligibility DateDTDate48
26BNFENDDT SearchBenefit End DateDTDate48
27VARBENFT SearchVariable BenefitCB_VariableBoolean20
28BNFTFREQ SearchBenefit FrequencyDDL_Ded/Ben FrequencyInteger20
29COSTEMPLOYEE_I SearchCost EmployeeDLR11_$U2Currency1014
30COSTEMPLOYER_I SearchCost EmployerDLR11_$U2Currency1014
31COSTOTHER1_I SearchCost Other 1DLR11_$S2Currency1014
32COSTOTHER2_I SearchCost Other 2DLR11_$S2Currency1014
33COSTOTHER3_I SearchCost Other 3DLR11_$S2Currency1014
34I2_I Searchi2INT5_NoFormatInteger25
35I3_I Searchi3INT5_NoFormatInteger25
36I4_I Searchi4INT5_NoFormatInteger25
37NUMBEROFCHILDREN_I SearchNumber of childrenINT2Integer22
38COSTTOTAL_I SearchCost TotalDLR11_$S2Currency1014
39COSTCOBRA_I SearchCost COBRADLR11_$U2Currency1014
40BENEFITDEDUCTIBLE_I SearchBenefit DeductibleDLR11_$U2Currency1014
41BNPAYPMX SearchBenefit Pay Period MaxDLR11_$U2Currency1014
42BNFYRMAX SearchBenefit Year MaxDLR11_$U2Currency1014
43BNFLFMAX SearchBenefit Lifetime MaxDLR11_$U2Currency1014
44BENEFICIARYINDEX_I SearchBeneficiary IndexLONGINTLong Integer40
45CHANGEBY_I SearchChange BySTR15_User_IDString1615
46CHANGEDATE_I SearchChange DateDTDate48
47NOTESINDEX_I SearchNotes IndexDOLLARCurrency100
48CONTRIBPRETAX_I SearchContrib Pre TaxDLR8_U5%Currency108
49CONTPRETAXDLR_I SearchContrib Pre Tax DollarDLR11_$U2Currency1014
50CONTRIBAFTERTAX_I SearchContrib After TaxDLR8_U5%Currency108
51CONTAFTERTAXDLR_I SearchContrib After Tax DollarDLR11_$U2Currency1014
52CONTRIBBONUS_I SearchContrib BonusDLR8_U5%Currency108
53CONTRIBBONUSDOLLAR_I SearchContrib Bonus DollarDLR11_$U2Currency1014
54HIGHLYCOMPENSATED_I SearchHighly CompensatedCB_IBoolean20
55LOANACTIVE_I SearchLoan ActiveCB_IBoolean20
56Benefit_Fiscal_Max SearchBenefit Fiscal MaxDLR11_$U2Currency1014
57Deduction_Fiscal_Yr_Max SearchDeduction Fiscal Year MaxDLR11_$S2Currency1014
58DEX_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.

Leave a Reply

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