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 TypeLength
1PLANCODE SearchPlanSTR15_LBAUString15
2JOBTITLE SearchJob TitleSTR6_Payroll_CodeString6
3SEAT SearchSeatINT6Long Integer6
4SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer10
5BENEFIT SearchBenefitSTR6_Payroll_CodeString6
6DEDCAMNT_1 SearchDeduction Amount[1]DLR11_$S2Currency14
7DEDCAMNT_2 SearchDeduction Amount[2]DLR11_$S2Currency14
8DEDCAMNT_3 SearchDeduction Amount[3]DLR11_$S2Currency14
9DEDCAMNT_4 SearchDeduction Amount[4]DLR11_$S2Currency14
10DEDCAMNT_5 SearchDeduction Amount[5]DLR11_$S2Currency14
11BNFBEGDT SearchBenefit Beg DateDTDate8
12BENEFITCB SearchBenefit CBCBBoolean0
13DEDNMTHD SearchDeduction MethodDDL_Deduction_MethodInteger0
14DEDNPRCT_1 SearchDeduction Percent[1]DLR8_U5%Currency8
15DEDNPRCT_2 SearchDeduction Percent[2]DLR8_U5%Currency8
16DEDNPRCT_3 SearchDeduction Percent[3]DLR8_U5%Currency8
17DEDNPRCT_4 SearchDeduction Percent[4]DLR8_U5%Currency8
18DEDNPRCT_5 SearchDeduction Percent[5]DLR8_U5%Currency8
19DEDFRMLA SearchDeduction FormulaGBInteger0
20BENEFITSTATUS_I SearchBenefit StatusDDL_Benefit_StatusInteger0
21DEDTRMAX_1 SearchDeduction Tier Max[1]DLR11_$U2Currency14
22DEDTRMAX_2 SearchDeduction Tier Max[2]DLR11_$U2Currency14
23DEDTRMAX_3 SearchDeduction Tier Max[3]DLR11_$U2Currency14
24DEDTRMAX_4 SearchDeduction Tier Max[4]DLR11_$U2Currency14
25DEDTRMAX_5 SearchDeduction Tier Max[5]DLR11_$U2Currency14
26DETRMXUN_1 SearchDeduction Tier Max Units[1]LI9_U2Long Integer9
27DETRMXUN_2 SearchDeduction Tier Max Units[2]LI9_U2Long Integer9
28DETRMXUN_3 SearchDeduction Tier Max Units[3]LI9_U2Long Integer9
29DETRMXUN_4 SearchDeduction Tier Max Units[4]LI9_U2Long Integer9
30DETRMXUN_5 SearchDeduction Tier Max Units[5]LI9_U2Long Integer9
31CHILDREN_I SearchChildrenIINT2Integer2
32CONTRIBAFTERTAX_I SearchContrib After TaxDLR8_U5%Currency8
33CONTAFTERTAXDLR_I SearchContrib After Tax DollarDLR11_$U2Currency14
34CONTRIBBONUS_I SearchContrib BonusDLR8_U5%Currency8
35CONTRIBBONUSDOLLAR_I SearchContrib Bonus DollarDLR11_$U2Currency14
36CONTRIBPRETAX_I SearchContrib Pre TaxDLR8_U5%Currency8
37CONTPRETAXDLR_I SearchContrib Pre Tax DollarDLR11_$U2Currency14
38EARNINGSCODE SearchEarnings CodeSTR15_Earnings_CodeString15
39PREMMETHOD_I SearchPrem MethodGB_PremiumsInteger0
40LIFEAMTCHILDREN_I SearchLife Amt Child(ren)DLR14_WholeCurrency14
41LIFEAMTEMPL_I SearchLife Amt EmplDLR14_WholeCurrency14
42LIFEAMTSPOUSE_I SearchLife Amt SpouseDLR14_WholeCurrency14
43SMOKER_I SearchSmokerCB_SmokerBoolean0
44SMOKERSP_I SearchSmokerSpCB_IBoolean0
45TIERSUSED_I SearchTiers UsedCB_Tiers_UsedBoolean0
46DEX_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)PayrollPC Position Benefit Inheritance (PC40802)

Leave a Reply

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