Future Effective Payroll Benefit Setup History (APR_BLM32100)

azurecurveProductsHRM Solution Series (1911)PayrollFuture Effective Payroll Benefit Setup History (APR_BLM32100)

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

Product: HRM Solution Series (1911)
Series:

Display Name: Future Effective Payroll Benefit Setup History
Physical Name: APR_BLM32100
Technical Name: APR_BLM_PRBenefit_History

Group Display Name: HRM Solution Series
Group Technical Name: APR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1BENEFIT SearchBenefitStringSTR6_Payroll_Code6
2DSCRIPTN SearchDescriptionStringSTR3030
3INACTIVE SearchInactiveBooleanCB_Inactive0
4BNFBEGDT SearchBenefit Beg DateDateDT8
5BNFENDDT SearchBenefit End DateDateDT8
6VARBENFT SearchVariable BenefitBooleanCB_Variable0
7BNFTFREQ SearchBenefit FrequencyIntegerDDL_Ded/Ben Frequency0
8TAXABLE SearchTaxableBooleanCB_Taxable0
9SBJTFDTX SearchSubject To Federal TaxBooleanCB_Federal0
10SBJTSSEC SearchSubject To Social SecurityBooleanCB_FICA_Social_Security0
11SBJTMCAR SearchSubject To MedicareBooleanCB_FICA_Medicare0
12SBJTSTTX SearchSubject To State TaxBooleanCB_State0
13SBJTLTAX SearchSubject To Local TaxBooleanCB_Local0
14SBJTFUTA SearchSubject To FutaBooleanCB_Futa0
15SBJTSUTA SearchSubject To SutaBooleanCB_Suta0
16FFEDTXRT SearchFlat Federal Tax RateIntegerINT4_%24
17FLSTTXRT SearchFlat State Tax RateIntegerINT4_%24
18BORCDTYP SearchBased On Record TypeIntegerDDL_Based_On_Record_Type0
19BSDORCDS SearchBased On RecordsIntegerGB0
20BNFTMTHD SearchBenefit MethodIntegerDDL_Benefit_Method0
21BNFFRMLA SearchBenefit FormulaIntegerGB0
22BNFPRCNT_1 SearchBenefit Percent[1]CurrencyDLR8_U5%8
23BNFPRCNT_2 SearchBenefit Percent[2]CurrencyDLR8_U5%8
24BNFPRCNT_3 SearchBenefit Percent[3]CurrencyDLR8_U5%8
25BNFPRCNT_4 SearchBenefit Percent[4]CurrencyDLR8_U5%8
26BNFPRCNT_5 SearchBenefit Percent[5]CurrencyDLR8_U5%8
27BNFITAMT_1 SearchBenefit Amount[1]CurrencyDLR11_$U214
28BNFITAMT_2 SearchBenefit Amount[2]CurrencyDLR11_$U214
29BNFITAMT_3 SearchBenefit Amount[3]CurrencyDLR11_$U214
30BNFITAMT_4 SearchBenefit Amount[4]CurrencyDLR11_$U214
31BNFITAMT_5 SearchBenefit Amount[5]CurrencyDLR11_$U214
32BNFTRMAX_1 SearchBenefit Tier Max[1]CurrencyDLR11_$U214
33BNFTRMAX_2 SearchBenefit Tier Max[2]CurrencyDLR11_$U214
34BNFTRMAX_3 SearchBenefit Tier Max[3]CurrencyDLR11_$U214
35BNFTRMAX_4 SearchBenefit Tier Max[4]CurrencyDLR11_$U214
36BNFTRMAX_5 SearchBenefit Tier Max[5]CurrencyDLR11_$U214
37BNTRMXUN_1 SearchBenefit Tier Max Units[1]Long IntegerLI9_U29
38BNTRMXUN_2 SearchBenefit Tier Max Units[2]Long IntegerLI9_U29
39BNTRMXUN_3 SearchBenefit Tier Max Units[3]Long IntegerLI9_U29
40BNTRMXUN_4 SearchBenefit Tier Max Units[4]Long IntegerLI9_U29
41BNTRMXUN_5 SearchBenefit Tier Max Units[5]Long IntegerLI9_U29
42BNPAYPMX SearchBenefit Pay Period MaxCurrencyDLR11_$U214
43BNFYRMAX SearchBenefit Year MaxCurrencyDLR11_$U214
44BNFLFMAX SearchBenefit Lifetime MaxCurrencyDLR11_$U214
45W2BXNMBR SearchW2 Box NumberIntegerINT2_U02
46W2BXLABL SearchW2 Box LabelStringSTR66
47NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Future Effective Payroll Benefit Setup History'].NOTEINDX AS 'Future Effective Payroll Benefit Setup History-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       APR_BLM32100 AS ['Future Effective Payroll Benefit Setup History']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Future Effective Payroll Benefit Setup History'].NOTEINDX = ['Record Notes Master'].NOTEINDX
48DATAENTDFLT SearchData Entry DefaultBooleanCB_DataEntryDefault0
49EMPLRMAXMAT SearchEmployer Maximum MatchCurrencyDLR8_U5%8
50SEQNUMBR SearchSequence NumberLong IntegerLI_Sequence_Number10
51W2BXNMBR2 SearchW2 Box Number 2IntegerINT2_U02
52W2BXLABL2 SearchW2 Box Label 2StringSTR66
53W2BXNMBR3 SearchW2 Box Number 3IntegerINT2_U02
54W2BXLABL3 SearchW2 Box Label 3StringSTR66
55W2BXNMBR4 SearchW2 Box Number 4IntegerINT2_U02
56W2BXLABL4 SearchW2 Box Label 4StringSTR66
57Benefit_Fiscal_Max SearchBenefit Fiscal MaxCurrencyDLR11_$U214
58CHANGEBY_I SearchChange ByStringSTR15_User_ID15
59CHANGEDATE_I SearchChange DateDateDT8
60CHANGEREASON_I SearchChange ReasonStringSTR30_I30
azurecurveProductsHRM Solution Series (1911)PayrollFuture Effective Payroll Benefit Setup History (APR_BLM32100)

Leave a Reply

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