Archive_HR_Benefit_Life_Hist (AR24BE17)

azurecurveProductsHuman Resources (414)3rd PartyArchive_HR_Benefit_Life_Hist (AR24BE17)

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

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

Display Name: Archive_HR_Benefit_Life_Hist
Physical Name: AR24BE17
Technical Name: Archive_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 IDSTR15_Employee_ID_IString15
2BNFBEGDT SearchBenefit Beg DateDTDate8
3BENEFIT SearchBenefitSTR6_Payroll_CodeString6
4I1_I Searchi1INT5_NoFormatInteger5
5BENEFICIARYPRIMARY_I SearchBeneficiary PrimarySTR30_I0String30
6BENCONTINGENT_I SearchBeneficiary ContingentSTR30_I0String30
7NAMEA15_I SearchNameA15STR15String15
8NAMEB15_I SearchNameB15STR15String15
9NAMEA50_I SearchNameA50STR50_IString50
10AGEEMPLOYEE_I SearchAge EmployeeINT3_NoFormatInteger3
11AGESPOUSE_I SearchAge SpouseINT3_NoFormatInteger3
12CHILDREN_I SearchChildrenIINT2Integer2
13LIFEAMTMAX_I SearchLife Amt MaxDLR14_WholeCurrency14
14LIFEAMTMAXSPOUSE_I SearchLife Amt Max SpouseDLR14_WholeCurrency14
15LIFEAMTMAXCHILD_I SearchLife Amt Max ChildDLR14_WholeCurrency14
16NEAREST_I SearchNearestDLR14_WholeCurrency14
17NEARESTSPOUSE_I SearchNearest(Spouse)DLR14_WholeCurrency14
18NEARESTCHILD_I SearchNearest(Child)DLR14_WholeCurrency14
19BNFTFREQ SearchBenefit FrequencyDDL_Ded/Ben FrequencyInteger0
20SMOKER_I SearchSmokerCB_SmokerBoolean0
21SMOKERSP_I SearchSmokerSpCB_IBoolean0
22GB_I SearchGBGB_IInteger0
23NEARESTEMPLOYER_I SearchNearest(Employer)DLR14_WholeCurrency14
24PREMIUMEMPLOYER_I SearchPremium EmployerDLR11_$U2Currency14
25PREMIUMEMPLOYEE_I SearchPremium EmployeeDLR11_$U2Currency14
26PREMIUMSMOKER_I SearchPremium SmokerDLR11_$U2Currency14
27PREMIUMSPOUSE_I SearchPremium SpouseDLR11_$U2Currency14
28PREMSMOKESPOUSE_I SearchPremium Smoking SpouseDLR11_$U2Currency14
29PREMIUMCHILD_I SearchPremium ChildDLR11_$U2Currency14
30LIFEINSURTYPE SearchLife Insurance TypeGBInteger0
31DEX_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.

azurecurveProductsHuman Resources (414)3rd PartyArchive_HR_Benefit_Life_Hist (AR24BE17)

Leave a Reply

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