HR_Benefit_Life_Hist (HR24BE17)

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

Product: Human Resources (414)
Series:

Display Name: HR_Benefit_Life_Hist
Physical Name: HR24BE17
Technical Name: HR_Benefit_Life_Hist

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
5BENEFICIARYPRIMARY_I SearchBeneficiary PrimaryStringSTR30_I030
6BENCONTINGENT_I SearchBeneficiary ContingentStringSTR30_I030
7NAMEA15_I SearchNameA15StringSTR1515
8NAMEB15_I SearchNameB15StringSTR1515
9NAMEA50_I SearchNameA50StringSTR50_I50
10AGEEMPLOYEE_I SearchAge EmployeeIntegerINT3_NoFormat3
11AGESPOUSE_I SearchAge SpouseIntegerINT3_NoFormat3
12CHILDREN_I SearchChildrenIntegerIINT22
13LIFEAMTMAX_I SearchLife Amt MaxCurrencyDLR14_Whole14
14LIFEAMTMAXSPOUSE_I SearchLife Amt Max SpouseCurrencyDLR14_Whole14
15LIFEAMTMAXCHILD_I SearchLife Amt Max ChildCurrencyDLR14_Whole14
16NEAREST_I SearchNearestCurrencyDLR14_Whole14
17NEARESTSPOUSE_I SearchNearest(Spouse)CurrencyDLR14_Whole14
18NEARESTCHILD_I SearchNearest(Child)CurrencyDLR14_Whole14
19BNFTFREQ SearchBenefit FrequencyIntegerDDL_Ded/Ben Frequency0
20SMOKER_I SearchSmokerBooleanCB_Smoker0
21SMOKERSP_I SearchSmokerSpBooleanCB_I0
22GB_I SearchGBIntegerGB_I0
23NEARESTEMPLOYER_I SearchNearest(Employer)CurrencyDLR14_Whole14
24PREMIUMEMPLOYER_I SearchPremium EmployerCurrencyDLR11_$U214
25PREMIUMEMPLOYEE_I SearchPremium EmployeeCurrencyDLR11_$U214
26PREMIUMSMOKER_I SearchPremium SmokerCurrencyDLR11_$U214
27PREMIUMSPOUSE_I SearchPremium SpouseCurrencyDLR11_$U214
28PREMSMOKESPOUSE_I SearchPremium Smoking SpouseCurrencyDLR11_$U214
29PREMIUMCHILD_I SearchPremium ChildCurrencyDLR11_$U214
30LIFEINSURTYPE SearchLife Insurance TypeIntegerGB0

Leave a Reply

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