PC Position Benefit Inheritance (PC40802)

azurecurveProductsHuman Resources (414)PayrollPC Position Benefit Inheritance (PC40802)

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

Product: Human Resources (414)
Series: Payroll

Display Name: PC Position Benefit Inheritance
Physical Name: PC40802
Technical Name: pcPositionBenefitInherit

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1PLANCODE SearchPlanSTR15_LBAUString1615
2JOBTITLE SearchJob TitleSTR6_Payroll_CodeString86
3SEAT SearchSeatINT6Long Integer46
4SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer410
5BENEFIT SearchBenefitSTR6_Payroll_CodeString86
6DEDCAMNT_1 SearchDeduction Amount[1]DLR11_$S2Currency1014
7DEDCAMNT_2 SearchDeduction Amount[2]DLR11_$S2Currency1014
8DEDCAMNT_3 SearchDeduction Amount[3]DLR11_$S2Currency1014
9DEDCAMNT_4 SearchDeduction Amount[4]DLR11_$S2Currency1014
10DEDCAMNT_5 SearchDeduction Amount[5]DLR11_$S2Currency1014
11BNFBEGDT SearchBenefit Beg DateDTDate48
12BENEFITCB SearchBenefit CBCBBoolean20
13DEDNMTHD SearchDeduction MethodDDL_Deduction_MethodInteger20
14DEDNPRCT_1 SearchDeduction Percent[1]DLR8_U5%Currency108
15DEDNPRCT_2 SearchDeduction Percent[2]DLR8_U5%Currency108
16DEDNPRCT_3 SearchDeduction Percent[3]DLR8_U5%Currency108
17DEDNPRCT_4 SearchDeduction Percent[4]DLR8_U5%Currency108
18DEDNPRCT_5 SearchDeduction Percent[5]DLR8_U5%Currency108
19DEDFRMLA SearchDeduction FormulaGBInteger20
20BENEFITSTATUS_I SearchBenefit StatusDDL_Benefit_StatusInteger20
21DEDTRMAX_1 SearchDeduction Tier Max[1]DLR11_$U2Currency1014
22DEDTRMAX_2 SearchDeduction Tier Max[2]DLR11_$U2Currency1014
23DEDTRMAX_3 SearchDeduction Tier Max[3]DLR11_$U2Currency1014
24DEDTRMAX_4 SearchDeduction Tier Max[4]DLR11_$U2Currency1014
25DEDTRMAX_5 SearchDeduction Tier Max[5]DLR11_$U2Currency1014
26DETRMXUN_1 SearchDeduction Tier Max Units[1]LI9_U2Long Integer49
27DETRMXUN_2 SearchDeduction Tier Max Units[2]LI9_U2Long Integer49
28DETRMXUN_3 SearchDeduction Tier Max Units[3]LI9_U2Long Integer49
29DETRMXUN_4 SearchDeduction Tier Max Units[4]LI9_U2Long Integer49
30DETRMXUN_5 SearchDeduction Tier Max Units[5]LI9_U2Long Integer49
31CHILDREN_I SearchChildrenIINT2Integer22
32CONTRIBAFTERTAX_I SearchContrib After TaxDLR8_U5%Currency108
33CONTAFTERTAXDLR_I SearchContrib After Tax DollarDLR11_$U2Currency1014
34CONTRIBBONUS_I SearchContrib BonusDLR8_U5%Currency108
35CONTRIBBONUSDOLLAR_I SearchContrib Bonus DollarDLR11_$U2Currency1014
36CONTRIBPRETAX_I SearchContrib Pre TaxDLR8_U5%Currency108
37CONTPRETAXDLR_I SearchContrib Pre Tax DollarDLR11_$U2Currency1014
38EARNINGSCODE SearchEarnings CodeSTR15_Earnings_CodeString1615
39PREMMETHOD_I SearchPrem MethodGB_PremiumsInteger20
40LIFEAMTCHILDREN_I SearchLife Amt Child(ren)DLR14_WholeCurrency1014
41LIFEAMTEMPL_I SearchLife Amt EmplDLR14_WholeCurrency1014
42LIFEAMTSPOUSE_I SearchLife Amt SpouseDLR14_WholeCurrency1014
43SMOKER_I SearchSmokerCB_SmokerBoolean20
44SMOKERSP_I SearchSmokerSpCB_IBoolean20
45TIERSUSED_I SearchTiers UsedCB_Tiers_UsedBoolean20
46DEX_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.

azurecurveProductsHuman Resources (414)PayrollPC Position Benefit Inheritance (PC40802)

Leave a Reply

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