HR_Benefit_History_2 (HR2BEN10)

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

Product: Human Resources (414)
Series:

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 IDStringSTR15_Employee_ID_I15
2BNFBEGDT SearchBenefit Beg DateDateDT8
3BENEFIT SearchBenefitStringSTR6_Payroll_Code6
4I1_I Searchi1IntegerINT5_NoFormat5
5BENEFITTYPE_I SearchBenefit TypeStringSTR6_U06
6IINDEX_I SearchIIndexIntegerIINT22
7POLICYNUMBER_I SearchPolicy NumberStringSTR30_I030
8GROUPNUMBER_I SearchGroup NumberStringSTR30_I030
9DATE1 SearchDateDateDT66
10BENEFITSTATUS_I SearchBenefit StatusIntegerDDL_Benefit_Status0
11INACTIVE SearchInactiveBooleanCB_Inactive0
12OVERRIDE_I SearchOverrideBooleanCB_I0
13CHECK1_I SearchCheck1BooleanCB_I0
14CHECK2_I SearchCheck2BooleanCB_I0
15CHECK3_I SearchCheck3BooleanCB_I0
16CHECK4_I SearchCheck4BooleanCB_I0
17CHECK5_I SearchCheck5BooleanCB_I0
18DATEDUE_I SearchDate DueDateDT8
19DSCRIPTN SearchDescriptionStringSTR3030
20COMMENTSTR10_I SearchCommentStr10StringSTR1010
21IBENEFITAMOUNT_I SearchIBenefit AmountCurrencyDLR11_$U214
22LIFEAMTEMPL_I SearchLife Amt EmplCurrencyDLR14_Whole14
23LIFEAMTSPOUSE_I SearchLife Amt SpouseCurrencyDLR14_Whole14
24LIFEAMTCHILDREN_I SearchLife Amt Child(ren)CurrencyDLR14_Whole14
25BENELIGIBILEDATE_I SearchBenefit Eligibility DateDateDT8
26BNFENDDT SearchBenefit End DateDateDT8
27VARBENFT SearchVariable BenefitBooleanCB_Variable0
28BNFTFREQ SearchBenefit FrequencyIntegerDDL_Ded/Ben Frequency0
29COSTEMPLOYEE_I SearchCost EmployeeCurrencyDLR11_$U214
30COSTEMPLOYER_I SearchCost EmployerCurrencyDLR11_$U214
31COSTOTHER1_I SearchCost Other 1CurrencyDLR11_$S214
32COSTOTHER2_I SearchCost Other 2CurrencyDLR11_$S214
33COSTOTHER3_I SearchCost Other 3CurrencyDLR11_$S214
34I2_I Searchi2IntegerINT5_NoFormat5
35I3_I Searchi3IntegerINT5_NoFormat5
36I4_I Searchi4IntegerINT5_NoFormat5
37NUMBEROFCHILDREN_I SearchNumber of childrenIntegerINT22
38COSTTOTAL_I SearchCost TotalCurrencyDLR11_$S214
39COSTCOBRA_I SearchCost COBRACurrencyDLR11_$U214
40BENEFITDEDUCTIBLE_I SearchBenefit DeductibleCurrencyDLR11_$U214
41BNPAYPMX SearchBenefit Pay Period MaxCurrencyDLR11_$U214
42BNFYRMAX SearchBenefit Year MaxCurrencyDLR11_$U214
43BNFLFMAX SearchBenefit Lifetime MaxCurrencyDLR11_$U214
44BENEFICIARYINDEX_I SearchBeneficiary IndexLong IntegerLONGINT0
45CHANGEBY_I SearchChange ByStringSTR15_User_ID15
46CHANGEDATE_I SearchChange DateDateDT8
47NOTESINDEX_I SearchNotes IndexCurrencyDOLLAR0
48CONTRIBPRETAX_I SearchContrib Pre TaxCurrencyDLR8_U5%8
49CONTPRETAXDLR_I SearchContrib Pre Tax DollarCurrencyDLR11_$U214
50CONTRIBAFTERTAX_I SearchContrib After TaxCurrencyDLR8_U5%8
51CONTAFTERTAXDLR_I SearchContrib After Tax DollarCurrencyDLR11_$U214
52CONTRIBBONUS_I SearchContrib BonusCurrencyDLR8_U5%8
53CONTRIBBONUSDOLLAR_I SearchContrib Bonus DollarCurrencyDLR11_$U214
54HIGHLYCOMPENSATED_I SearchHighly CompensatedBooleanCB_I0
55LOANACTIVE_I SearchLoan ActiveBooleanCB_I0
56Benefit_Fiscal_Max SearchBenefit Fiscal MaxCurrencyDLR11_$U214
57Deduction_Fiscal_Yr_Max SearchDeduction Fiscal Year MaxCurrencyDLR11_$S214

Leave a Reply

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