HR_Benefit_Life_Hist (HR24BE17)

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

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

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 TypeSQL DB LengthKeyable Length
1EMPID_I SearchEmp IDSTR15_Employee_ID_IString1615
2BNFBEGDT SearchBenefit Beg DateDTDate48
3BENEFIT SearchBenefitSTR6_Payroll_CodeString86
4I1_I Searchi1INT5_NoFormatInteger25
5BENEFICIARYPRIMARY_I SearchBeneficiary PrimarySTR30_I0String3230
6BENCONTINGENT_I SearchBeneficiary ContingentSTR30_I0String3230
7NAMEA15_I SearchNameA15STR15String1615
8NAMEB15_I SearchNameB15STR15String1615
9NAMEA50_I SearchNameA50STR50_IString5250
10AGEEMPLOYEE_I SearchAge EmployeeINT3_NoFormatInteger23
11AGESPOUSE_I SearchAge SpouseINT3_NoFormatInteger23
12CHILDREN_I SearchChildrenIINT2Integer22
13LIFEAMTMAX_I SearchLife Amt MaxDLR14_WholeCurrency1014
14LIFEAMTMAXSPOUSE_I SearchLife Amt Max SpouseDLR14_WholeCurrency1014
15LIFEAMTMAXCHILD_I SearchLife Amt Max ChildDLR14_WholeCurrency1014
16NEAREST_I SearchNearestDLR14_WholeCurrency1014
17NEARESTSPOUSE_I SearchNearest(Spouse)DLR14_WholeCurrency1014
18NEARESTCHILD_I SearchNearest(Child)DLR14_WholeCurrency1014
19BNFTFREQ SearchBenefit FrequencyDDL_Ded/Ben FrequencyInteger20
20SMOKER_I SearchSmokerCB_SmokerBoolean20
21SMOKERSP_I SearchSmokerSpCB_IBoolean20
22GB_I SearchGBGB_IInteger20
23NEARESTEMPLOYER_I SearchNearest(Employer)DLR14_WholeCurrency1014
24PREMIUMEMPLOYER_I SearchPremium EmployerDLR11_$U2Currency1014
25PREMIUMEMPLOYEE_I SearchPremium EmployeeDLR11_$U2Currency1014
26PREMIUMSMOKER_I SearchPremium SmokerDLR11_$U2Currency1014
27PREMIUMSPOUSE_I SearchPremium SpouseDLR11_$U2Currency1014
28PREMSMOKESPOUSE_I SearchPremium Smoking SpouseDLR11_$U2Currency1014
29PREMIUMCHILD_I SearchPremium ChildDLR11_$U2Currency1014
30LIFEINSURTYPE SearchLife Insurance TypeGBInteger20
31DEX_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 *