HR_Benefit_MSTR (BE010130)

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

Product: Human Resources (414)
Series:

Display Name: HR_Benefit_MSTR
Physical Name: BE010130
Technical Name: HR_Benefit_MSTR

Group Display Name: HR Third Party
Group Technical Name: HR_Third_Party

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1EMPID_I SearchEmp IDStringSTR15_Employee_ID_I15
2BENEFIT SearchBenefitStringSTR6_Payroll_Code6
3BENEFITTYPE_I SearchBenefit TypeStringSTR6_U06
4IINDEX_I SearchIIndexIntegerIINT22
5BENEFITKIND_I SearchBenefit KindIntegerDDL_Benefit_Kind0
6COMPLETIONSTATUS_I SearchCompletion StatusIntegerDDL_Completion_Status0
7POLICYNUMBER_I SearchPolicy NumberStringSTR30_I030
8BENEFITSTATUS_I SearchBenefit StatusIntegerDDL_Benefit_Status0
9INACTIVE SearchInactiveBooleanCB_Inactive0
10OVERRIDE_I SearchOverrideBooleanCB_I0
11CHECK1_I SearchCheck1BooleanCB_I0
12CHECK2_I SearchCheck2BooleanCB_I0
13CHECK3_I SearchCheck3BooleanCB_I0
14CHECK4_I SearchCheck4BooleanCB_I0
15CHECK5_I SearchCheck5BooleanCB_I0
16DATEDUE_I SearchDate DueDateDT8
17DSCRIPTN SearchDescriptionStringSTR3030
18COMMENTSTR10_I SearchCommentStr10StringSTR1010
19IBENEFITAMOUNT_I SearchIBenefit AmountCurrencyDLR11_$U214
20LIFEAMTEMPL_I SearchLife Amt EmplCurrencyDLR14_Whole14
21LIFEAMTSPOUSE_I SearchLife Amt SpouseCurrencyDLR14_Whole14
22LIFEAMTCHILDREN_I SearchLife Amt Child(ren)CurrencyDLR14_Whole14
23BENELIGIBILEDATE_I SearchBenefit Eligibility DateDateDT8
24BNFBEGDT SearchBenefit Beg DateDateDT8
25BNFENDDT SearchBenefit End DateDateDT8
26VARBENFT SearchVariable BenefitBooleanCB_Variable0
27BNFTFREQ SearchBenefit FrequencyIntegerDDL_Ded/Ben Frequency0
28COSTEMPLOYEE_I SearchCost EmployeeCurrencyDLR11_$U214
29COSTEMPLOYER_I SearchCost EmployerCurrencyDLR11_$U214
30COSTOTHER1_I SearchCost Other 1CurrencyDLR11_$S214
31COSTOTHER2_I SearchCost Other 2CurrencyDLR11_$S214
32I1_I Searchi1IntegerINT5_NoFormat5
33I2_I Searchi2IntegerINT5_NoFormat5
34I3_I Searchi3IntegerINT5_NoFormat5
35I4_I Searchi4IntegerINT5_NoFormat5
36NUMBEROFCHILDREN_I SearchNumber of childrenIntegerINT22
37COSTTOTAL_I SearchCost TotalCurrencyDLR11_$S214
38COSTCOBRA_I SearchCost COBRACurrencyDLR11_$U214
39BENEFITDEDUCTIBLE_I SearchBenefit DeductibleCurrencyDLR11_$U214
40BNPAYPMX SearchBenefit Pay Period MaxCurrencyDLR11_$U214
41BNFYRMAX SearchBenefit Year MaxCurrencyDLR11_$U214
42BNFLFMAX SearchBenefit Lifetime MaxCurrencyDLR11_$U214
43BENEFICIARYINDEX_I SearchBeneficiary IndexLong IntegerLONGINT0
44CHANGEBY_I SearchChange ByStringSTR15_User_ID15
45CHANGEDATE_I SearchChange DateDateDT8
46NOTESINDEX_I SearchNotes IndexCurrencyDOLLAR0
47CONTRIBPRETAX_I SearchContrib Pre TaxCurrencyDLR8_U5%8
48CONTPRETAXDLR_I SearchContrib Pre Tax DollarCurrencyDLR11_$U214
49CONTRIBAFTERTAX_I SearchContrib After TaxCurrencyDLR8_U5%8
50CONTAFTERTAXDLR_I SearchContrib After Tax DollarCurrencyDLR11_$U214
51CONTRIBBONUS_I SearchContrib BonusCurrencyDLR8_U5%8
52CONTRIBBONUSDOLLAR_I SearchContrib Bonus DollarCurrencyDLR11_$U214
53HIGHLYCOMPENSATED_I SearchHighly CompensatedBooleanCB_I0
54LOANACTIVE_I SearchLoan ActiveBooleanCB_I0
55TYPEOFCODE_I SearchType of CodeIntegerDDL_Code_Type0
56TIERSUSED_I SearchTiers UsedBooleanCB_Tiers_Used0
57MAJMEDCOVERAGE_I SearchMajor Medical CoverageIntegerINT5_%25
58MAXOUTOFPOCKET_I SearchMax Out-Of-PocketCurrencyDLR14_RB2_ST$14
59ELIGIBILITYDATE_I SearchEligibility DateDateDT8
60PRIMARYBENEFICIARY_I SearchPrimary BeneficiaryStringSTR30_I030
61SECBENEFICIARY_I SearchSecondary BeneficiaryStringSTR30_I030
62BNFTMTHD SearchBenefit MethodIntegerDDL_Benefit_Method0
63BNFFRMLA SearchBenefit FormulaIntegerGB0
64BNFPRCNT_1 SearchBenefit Percent[1]CurrencyDLR8_U5%8
65BNFPRCNT_2 SearchBenefit Percent[2]CurrencyDLR8_U5%8
66BNFPRCNT_3 SearchBenefit Percent[3]CurrencyDLR8_U5%8
67BNFPRCNT_4 SearchBenefit Percent[4]CurrencyDLR8_U5%8
68BNFPRCNT_5 SearchBenefit Percent[5]CurrencyDLR8_U5%8
69DEDNMTHD SearchDeduction MethodIntegerDDL_Deduction_Method0
70DEDFRMLA SearchDeduction FormulaIntegerGB0
71DEDNPRCT_1 SearchDeduction Percent[1]CurrencyDLR8_U5%8
72DEDNPRCT_2 SearchDeduction Percent[2]CurrencyDLR8_U5%8
73DEDNPRCT_3 SearchDeduction Percent[3]CurrencyDLR8_U5%8
74DEDNPRCT_4 SearchDeduction Percent[4]CurrencyDLR8_U5%8
75DEDNPRCT_5 SearchDeduction Percent[5]CurrencyDLR8_U5%8
76DEPYPRMX SearchDeduction Pay Period MaxCurrencyDLR11_$S214
77DEDYRMAX SearchDeduction Year MaxCurrencyDLR11_$S214
78DEDLTMAX SearchDeduction Lifetime MaxCurrencyDLR11_$S214
79DEDINITBAL SearchDeduction Initial BalanceCurrencyDLR11_$S214
80INACTBENEMPLOYEE SearchInactive Benefit EmployeeBooleanCB_Inactive_Benefit_Employee0
81INACTBENEMPLR SearchInactive Benefit EmployerBooleanCB_Inactive_Benefit_Employer0
82Benefit_Fiscal_Max SearchBenefit Fiscal MaxCurrencyDLR11_$U214
83Deduction_Fiscal_Yr_Max SearchDeduction Fiscal Year MaxCurrencyDLR11_$S214
84LIFEINSURTYPE SearchLife Insurance TypeIntegerGB0
85OfferOfCoverageCode SearchOffer of Coverage CodeIntegerDDL_1095_Line_Code0
86SafeHarborCode SearchSafe Harbor CodeIntegerDDL_1095_Line_Code0
87LowestCostPremium SearchLowest Cost PremiumCurrencyDLR11_$U214

Leave a Reply

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