Filing dates | 6/1/2022 to: 9/20/2022 |
Comp dates | 7/1/2022 to: 12/31/2022 |
Splits |
BaseSalary,BaseSalary,Number
EquitableComp,EquitableComp,Number
NewChurchComp,NewChurchComp,Number
OtherComp,OtherComp,Number
HousingAllowance,HousingAllowance,Number
ParsonageValue,ParsonageValue,Number
PensionAmt,PensionAmt,Number
AccountableReimbursement,AccountableReimbursement,Number
MovingExpenses,MovingExpenses,Number
ContinuingEducationExpense,ContinuingEducationExpense,Number
UtilityAllowance,UtilityAllowance,Number
HealthCareSupp,HealthCareSupp,Number
HealthCareSuppOther,HealthCareSuppOther,Number
|
Approval stages |
Submitter,District
|
Report fields |
People.FirstName,People.LastName,PubDate,AppointmentChargeConferences,DateOfChargeConference,ClergyStatusAtTimeOfFiling,MultiPointCharge,LeadChurch,ExtensionMinistry,GSSReport,BaseSalary,EquitableComp,NewChurchComp,OtherComp,TotalSalaryValue,CompensationTags,HousingAllowance,ParsonageValue,UtilityExclusion,AccountableReimbursement,MovingExpenses,ContinuingEducationExpense,Utility,UtilityAllowance,HealthInsuranceOption,HealthSupplement,HealthCareSupp,ReceivePension,GrandTotal,PensionAmt,TotalBenefitPackage,TotalCompensation,Notes,SalaryBreakdown.Church.Name,SalaryBreakdown.ExtensionMinistryList.Name,SalaryBreakdown.BaseSalary,SalaryBreakdown.EquitableComp,SalaryBreakdown.NewChurchComp,SalaryBreakdown.OtherComp,SalaryBreakdown.HousingAllowance,SalaryBreakdown.ParsonageValue,SalaryBreakdown.PensionAmt,SalaryBreakdown.AccountableReimbursement,SalaryBreakdown.MovingExpenses,SalaryBreakdown.ContinuingEducationExpense,SalaryBreakdown.UtilityAllowance,SalaryBreakdown.HealthCareSupp,SalaryBreakdown.HealthCareSuppOther
|
<View Id="Comp2022" TableId="Content" Inherits="ClergyCompForm" Name="2022 Comp Form Records" Plural="2022 Comp Records" Singular="2022 Comp Record" Invisible="true" Menu="UMC (comp)"><Fields><FieldSet Id="FilingInfo" Important="true" Invisible="false"><Info Id="dropdown" Cmd="Before:PubDate"> You must use the drop-down selections where applicable. </Info><Category Id="ServiceTimeAtTimeOfFiling" Cmd="Remove" /><!--<Relationship Id="Church" Name="Currently appointed to church for which this form applies" />--><Column Id="PubDate" Name="Compensation will be effective on" Type="DateTime" Invisible="false" ReadOnlyOnAdd="false" /><Category Id="AppointmentChargeConferences" Name="And was approved at a:" /><Relationship Id="DistrictOfChurch" TableId="Contacts" ViewId="Districts" Name="Church District"><Filters><Filter Id="OnlyOpenDisricts" Type="Search,Link"><Or><IsNull FieldId="MakeInactive" /><Eq Id="MakeInactive" Value="false" /></Or></Filter></Filters></Relationship><File Id="CompiledCompensationFiles" Invisible="true" /><CustomField Id="DateOfChargeConference" Cmd="After:AppointmentChargeConferences" Name="Date of that Charge Conference" Invisible="false" /><Category Id="ClergyStatusAtTimeOfFiling" Name="Your clergy status" Multiple="false" Cmd="After:DateOfChargeConference" /></FieldSet><FieldSet Id="SalaryInfo"><Info Id="SalaryText" Cmd="Before:BaseSalary"><b> 2022 Minimum Salary (full time) </b><br /><ul><li> Full Connection - $46,500 </li><li> Provisional Member - $44,100 </li><li> Associate Member - $42,700 </li><li> Local Pastor w M.Div. or 5 years COS - $41,400 </li><li> Local Pastor with less than 5 years COS - $40,400 </li></ul> Clergy who are appointed AND receive at least 50% of minimum salary <b><i> are eligible and will be enrolled in the Wespath pension plan. </i></b><br /><br /> Retired Clergy are <b> NOT </b> eligible for pension. <br /><br /> Lay Supply Pastors and Certified Lay Ministers <b> are NOT ELIGIBLE FOR CLERGY PENSION NOR CLERGY TAX EXEMPTIONS. </b><br /><br /> Pension to be paid to FLUMC (below) is calculated as follows: <br /><ul><li> With a housing allowance: (Base Annual Salary + Housing Allowance) X 15% = Pension Billing; </li><li> With a parsonage*: Base Annual Salary X 1.25 X 15% = Pension Billing </li></ul> *Parsonage value is used for Pension purposes only; not to be used for income tax. </Info><CustomField Id="BaseSalary" Name="Salary: Church/Ext. Min." /><CustomField Id="EquitableComp" Name="Salary: Conf Equitable Salary Support" Format="C" /><CustomField Id="NewChurchComp" Name="Salary: NCD Conf Salary Support" Format="C" /><CustomField Id="OtherComp" Name="Salary: Other Support" Cmd="After:NewChurchComp" Invisible="false" Type="Float" Format="C" /><CustomField Id="TotalSalaryValue" Name="Total Approved Annual Base Salary" Format="C" Cmd="After:OtherComp" /><Category Id="CompensationTags" Description="Must be chosen for every clergy. Either Parsonage, Housing Allowance or None" Name="Housing Code" Cmd="After:TotalSalaryValue" /><Relationship Id="ParsonageProviderChurch" Name="Church that provides the parsonage" Cmd="After:CompensationTags" /><CustomField Id="HousingAllowance" Name="Housing Allowance" Format="C" /><CustomField Id="ParsonageValue" Name="Parsonage Value" Format="C" /><CustomField Id="AccountableReimbursement" Name="Reimbursable Account" Description="This amount is not included in any compensation totals" Invisible="false" /><CustomField Id="UtilityExclusion" Name="Housing Exclusion" Invisible="false" /><CustomField Id="MovingExpenses" Name="Moving Expense Reimbursement (not in RA Above)" Description="This amount is included in compensation totals and is pension eligible" Invisible="false" /><CustomField Id="Utility" Name="Utilities - Checking yes means all utilities are paid" Invisible="false" /><CustomField Id="UtilityAllowance" Name="Utilities Allowance" Description="Enter dollar amount ONLY if church does not pay ALL or puts a cap on utilities expense. (If YES is checked on line above no amount can be entered here. It is one or the other.)" Invisible="false" Format="C" /><Category Id="HealthInsuranceOption" Name="Health Insurance Options" CatType="Health Insurance Options" Multiple="false" Cmd="After:UtilityAllowance" /><Info Id="SupplementInfo" Cmd="After:HealthInsuranceOption"> A Health Supplement is taxable earnings. Lay Supply, CLM and Retired Clergy are not eligible for Health Supplement. </Info><Category Id="HealthSupplement" Name="Health Supplements" CatType="Health Supplements" Multiple="false" Invisible="false" Cmd="Before:HealthCareSupp" /><CustomField Id="HealthCareSupp" Name="Health Supplement Amount" Description="Amount Paid to Clergy based on Health Supplement Type Chosen" Invisible="false" /><CustomField Id="HealthCareSuppOther" Name="Health Care Supplement Amount - Special case if standard Supplement Amount not used (DS approval required)" Format="C" /><CustomField Id="HealthInsurance" Invisible="true" /><CustomField Id="HealthInsAmt" Invisible="true" /><CustomField Id="ChurchProvidedPlan" Name="Church Provided Plan" Invisible="true" /><CustomField Id="ReceivePension" Name="Participates in Conference Pension Plan" Invisible="false" Cmd="After:HealthCareSuppOther" /><CustomField Id="PensionAmt" Name="Pension to be paid to FLUMC" Format="C" Cmd="Before:TotalBenefitPackage" /><CustomField Id="TotalBenefitPackage" Name="Total Benefit Package Cost" Description="Total of Health Supplement and Pension Amount" Invisible="false" /><CustomField Id="TotalComp" Invisible="true" /><CustomField Id="Notes" Name="Notes" Invisible="false" Cmd="Last" /><CustomField Id="GrandTotal" Name="Total Salary + Housing Value + Moving Expense = Pension Base" Description="If parsonage is chosen above, the housing value is 25% of Total Approved Annual Base Salary" Cmd="Before:PensionAmt" Invisible="false" /><CustomField Id="TotalCompensation" Name="Total Cost to Church" Description="Includes any or all of the following: Salary, Housing Allowance, Moving Expenses, Health Supplement and Pension. Does not include Parsonage Value as it is not paid out to the person as a direct cost." Cmd="After:PensionAmt" Format="C" /><CustomField Id="AppdByDistrict" Invisible="true" /><CustomField Id="LastEditedDate" Invisible="true" /><CustomField Id="LastEditedBy" Invisible="true" /><CustomField Id="EditNotes" Invisible="true" /><Column Id="EndDate" Invisible="false" /><CustomField Id="ContinuingEducationExpense" Name="Continuing Education (not in RA Above)" Description="This amount is not included in any compensation totals" Invisible="false" /><CustomField Id="AnnualConferenceExpense" Invisible="true" /><CustomField Id="OtherReimbursedExpense" Invisible="true" /><CustomField Id="DistrictComp" Invisible="true" /><CustomField Id="ContinuingEducation" Invisible="true" /><CustomField Id="TotalSalary" Invisible="true" /></FieldSet><FieldSet Id="Insurance" Invisible="true" /><FieldSet Id="SignatureFields" Invisible="true"><CustomField Id="SignaturePastor" Cmd="Before:PastorDate" /><CustomField Id="SignatureDistrict" Cmd="Before:DSDate" /></FieldSet><FieldSet Id="SalarySource" Name="Salary Source" Invisible="false"><Info Id="SalaryInfo" /><Relationship Id="Church" Name="Church(s)" /><Filters><Filter Id="OnlyOpenChurches" Type="Search,Link"><Or><IsNull FieldId="MakeInactive" /><Eq Id="MakeInactive" Value="false" /></Or></Filter></Filters><CustomField Id="MultiPointCharge" Name="Is this church part of a multi-point charge?" Type="Bit" Cmd="After:Church" /><CustomField Id="LeadChurch" Name="Is this the lead church in the charge?" Invisible="true" /><Relationship Id="ExtensionMinistryList" Name="Choose your extension ministry" /><Relationship Id="District" TableId="Contacts" ViewId="Districts" Name="District (choose only if income comes from the district)" Invisible="false" Cmd="After:ExtensionMinistryList"><Filters><Filter Id="OnlyOpenDisricts" Type="Search,Link"><Or><IsNull FieldId="MakeInactive" /><Eq Id="MakeInactive" Value="false" /></Or></Filter></Filters></Relationship><CustomField Id="GSSReport" Name="Include this Extension Ministry in the GSS Report?" /><Relationship Id="SalaryBreakdown" Invisible="true" /><Relationship Id="LeadChurchName" Name="If yes, which is the lead church in the charge?" /></FieldSet><Category Id="ClergyStatusAtTimeOfFiling" Cmd="Remove" /><CustomField Id="DateOfChargeConference" Cmd="Remove" /><Category Id="AppointmentChargeConferences" Cmd="Remove" /></Fields></View>
<script src="https://www.flumc.org/peopleportal/compcalc.js"></script> <style type="text/css"> body { background-color:#eee; } .container { max-width:800px; } fieldset.engine-fieldset legend { font-size:20px; border-bottom:none; padding:10px; background-color:#eee; margin-bottom:16px; } label { font-size:15px; } legend .icon-caret-down, #brandedtop { display:none; } </style> <script> $(document).ready(function() { if ( window.location !== window.parent.location ) { $(".btn-large").hide(); } }); </script>
Formula
Visible |
GrandTotal
|
CompensationTags==19939 ? TotalSalaryValue*1.25+MovingExpenses : TotalSalaryValue+HousingAllowance+MovingExpenses |
||||||||||||||||||
Constant
Visible |
HCSClergyCouple
|
7705 |
||||||||||||||||||
Constant
Visible |
HCSClergyCoupleFamilyCoverage
|
9484 |
||||||||||||||||||
Constant
Visible |
HCSClergyFamily
|
18967 |
||||||||||||||||||
Constant
Visible |
HCSClergyOne
|
15410 |
||||||||||||||||||
Constant
Visible |
HCSSingleClergy
|
11854 |
||||||||||||||||||
Formula
Visible |
HealthCareSupp
|
if (HealthSupplement==49768){ HCSSingleClergy } else if (HealthSupplement==49769){ HCSClergyOne } else if (HealthSupplement==49770){ HCSClergyCouple } else if (HealthSupplement==49771){ HCSClergyFamily } else if (HealthSupplement==49772){ HCSClergyCoupleFamilyCoverage } else { 0 }
HealthSupplement==49768 ? HCS-SingleClergy : HealthSupplement==49769 ? HCS-Clergy+One : HealthSupplement==49770 ? HCS-ClergyCouple : HealthSupplement==49771 ? HCS-ClergyFamily : HealthSupplement==49772 ? HCS-ClergyCoupleFamilyCoverage : 0
|
||||||||||||||||||
Constant
Visible |
MinimumSalary
|
20000
Anyone with Pensionable Status and a Total Compensation of $20,000 or higher receives a pension
|
||||||||||||||||||
Show/Hide
Visible |
ParsonageProviderChurch
|
CompensationTags==19939 |
||||||||||||||||||
Formula
Visible |
ParsonageValue
|
if (CompensationTags==19939){ TotalSalaryValue*.25 } |
||||||||||||||||||
Constant
Visible |
PensionAbleStatuses
|
[4920,4921,4927,4928,4929,4932,4933,4934,4935,4936,4938,4939,4940]
An array of clergy statuses that allow them to have a pension
|
||||||||||||||||||
Formula
Visible |
PensionAmt
|
PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling) && TotalSalaryValue>=MinimumSalary ? GrandTotal*.15 : 0
Pension paid to FLUMC
The constant: IsPensionable= Yes, then the Pensionable amount is TotalCompensation * .15
Pension paid to FLUMC The clergy statuses are:
SCRATCH PAD PensionAbleStatuses.includes(ClergyStatus) && TotalComp*1 >= 20000 ? (CompensationTags==19939 ? (TotalSalary*1.25)*.15 : TotalSalary*.15) : 0 TotalSalary*.15 NO: if(ClergyStatusAtTimeOfFiling in PensionAbleStatuses && ServiceTimeAtTimeOfFiling in PensionAbleServiceTimes){ if(CompensationTags==19939){ (TotalSalary*1.25)*.15 } else{ TotalSalary*.15 } } |
||||||||||||||||||
Formula
Visible |
TotalBenefitPackage
|
HealthCareSupp+PensionAmt |
||||||||||||||||||
Formula
Visible |
TotalCompensation
|
TotalSalaryValue+HousingAllowance+MovingExpenses+HealthCareSupp+PensionAmt |
||||||||||||||||||
Formula
Visible |
TotalSalaryValue
|
BaseSalary+EquitableComp+NewChurchComp+OtherComp |
Filing dates | 10/21/2021 to: 5/20/2022 |
Comp dates | 1/1/2022 to: 12/31/2022 |
Splits |
BaseSalary,BaseSalary,Number
EquitableComp,EquitableComp,Number
NewChurchComp,NewChurchComp,Number
OtherComp,OtherComp,Number
HousingAllowance,HousingAllowance,Number
ParsonageValue,ParsonageValue,Number
PensionAmt,PensionAmt,Number
AccountableReimbursement,AccountableReimbursement,Number
MovingExpenses,MovingExpenses,Number
ContinuingEducationExpense,ContinuingEducationExpense,Number
UtilityAllowance,UtilityAllowance,Number
HealthCareSupp,HealthCareSupp,Number
HealthCareSuppOther,HealthCareSuppOther,Number
|
Approval stages |
Submitter,District
|
Report fields |
People.FirstName,People.LastName,PubDate,AppointmentChargeConferences,DateOfChargeConference,ClergyStatusAtTimeOfFiling,MultiPointCharge,LeadChurch,ExtensionMinistry,GSSReport,BaseSalary,EquitableComp,NewChurchComp,OtherComp,TotalSalaryValue,CompensationTags,HousingAllowance,ParsonageValue,UtilityExclusion,AccountableReimbursement,MovingExpenses,ContinuingEducationExpense,Utility,UtilityAllowance,HealthInsuranceOption,HealthSupplement,HealthCareSupp,ReceivePension,GrandTotal,PensionAmt,TotalBenefitPackage,TotalCompensation,Notes,SalaryBreakdown.Church.Name,SalaryBreakdown.ExtensionMinistryList.Name,SalaryBreakdown.BaseSalary,SalaryBreakdown.EquitableComp,SalaryBreakdown.NewChurchComp,SalaryBreakdown.OtherComp,SalaryBreakdown.HousingAllowance,SalaryBreakdown.ParsonageValue,SalaryBreakdown.PensionAmt,SalaryBreakdown.AccountableReimbursement,SalaryBreakdown.MovingExpenses,SalaryBreakdown.ContinuingEducationExpense,SalaryBreakdown.UtilityAllowance,SalaryBreakdown.HealthCareSupp,SalaryBreakdown.HealthCareSuppOther
|
<View Id="Comp2022" TableId="Content" Inherits="ClergyCompForm" Name="2022 Comp Form Records" Plural="2022 Comp Records" Singular="2022 Comp Record" Invisible="true" Menu="UMC (comp)"><Fields><FieldSet Id="FilingInfo" Important="true" Invisible="false"><Info Id="dropdown" Cmd="Before:PubDate"> You must use the drop-down selections where applicable. </Info><Category Id="ServiceTimeAtTimeOfFiling" Cmd="Remove" /><!--<Relationship Id="Church" Name="Currently appointed to church for which this form applies" />--><Column Id="PubDate" Name="Compensation will be effective on" Type="DateTime" Invisible="false" ReadOnlyOnAdd="false" /><Category Id="AppointmentChargeConferences" Name="And was approved at a:" /><Relationship Id="DistrictOfChurch" TableId="Contacts" ViewId="Districts" Name="Church District"><Filters><Filter Id="OnlyOpenDisricts" Type="Search,Link"><Or><IsNull FieldId="MakeInactive" /><Eq Id="MakeInactive" Value="false" /></Or></Filter></Filters></Relationship><File Id="CompiledCompensationFiles" Invisible="true" /><CustomField Id="DateOfChargeConference" Cmd="After:AppointmentChargeConferences" Name="Date of that Charge Conference" Invisible="false" /><Category Id="ClergyStatusAtTimeOfFiling" Name="Your clergy status" Multiple="false" Cmd="After:DateOfChargeConference" /></FieldSet><FieldSet Id="SalaryInfo"><Info Id="SalaryText" Cmd="Before:BaseSalary"><b> 2022 Minimum Salary (full time) </b><br /><ul><li> Full Connection - $46,500 </li><li> Provisional Member - $44,100 </li><li> Associate Member - $42,700 </li><li> Local Pastor w M.Div. or 5 years COS - $41,400 </li><li> Local Pastor with less than 5 years COS - $40,400 </li></ul> Clergy who are appointed AND receive at least 50% of minimum salary <b><i> are eligible and will be enrolled in the Wespath pension plan. </i></b><br /><br /> Retired Clergy are <b> NOT </b> eligible for pension. <br /><br /> Lay Supply Pastors and Certified Lay Ministers <b> are NOT ELIGIBLE FOR CLERGY PENSION NOR CLERGY TAX EXEMPTIONS. </b><br /><br /> Pension to be paid to FLUMC (below) is calculated as follows: <br /><ul><li> With a housing allowance: (Base Annual Salary + Housing Allowance) X 15% = Pension Billing; </li><li> With a parsonage*: Base Annual Salary X 1.25 X 15% = Pension Billing </li></ul> *Parsonage value is used for Pension purposes only; not to be used for income tax. </Info><CustomField Id="BaseSalary" Name="Salary: Church/Ext. Min." /><CustomField Id="EquitableComp" Name="Salary: Conf Equitable Salary Support" Format="C" /><CustomField Id="NewChurchComp" Name="Salary: NCD Conf Salary Support" Format="C" /><CustomField Id="OtherComp" Name="Salary: Other Support" Cmd="After:NewChurchComp" Invisible="false" Type="Float" Format="C" /><CustomField Id="TotalSalaryValue" Name="Total Approved Annual Base Salary" Format="C" Cmd="After:OtherComp" /><Category Id="CompensationTags" Description="Must be chosen for every clergy. Either Parsonage, Housing Allowance or None" Name="Housing Code" Cmd="After:TotalSalaryValue" /><Relationship Id="ParsonageProviderChurch" Name="Church that provides the parsonage" Cmd="After:CompensationTags" /><CustomField Id="HousingAllowance" Name="Housing Allowance" Format="C" /><CustomField Id="ParsonageValue" Name="Parsonage Value" Format="C" /><CustomField Id="AccountableReimbursement" Name="Reimbursable Account" Description="This amount is not included in any compensation totals" Invisible="false" /><CustomField Id="UtilityExclusion" Name="Housing Exclusion" Invisible="false" /><CustomField Id="MovingExpenses" Name="Moving Expense Reimbursement (not in RA Above)" Description="This amount is included in compensation totals and is pension eligible" Invisible="false" /><CustomField Id="Utility" Name="Utilities - Checking yes means all utilities are paid" Invisible="false" /><CustomField Id="UtilityAllowance" Name="Utilities Allowance" Description="Enter dollar amount ONLY if church does not pay ALL or puts a cap on utilities expense. (If YES is checked on line above no amount can be entered here. It is one or the other.)" Invisible="false" Format="C" /><Category Id="HealthInsuranceOption" Name="Health Insurance Options" CatType="Health Insurance Options" Multiple="false" Cmd="After:UtilityAllowance" /><Info Id="SupplementInfo" Cmd="After:HealthInsuranceOption"> A Health Supplement is taxable earnings. Lay Supply, CLM and Retired Clergy are not eligible for Health Supplement. </Info><Category Id="HealthSupplement" Name="Health Supplements" CatType="Health Supplements" Multiple="false" Invisible="false" Cmd="Before:HealthCareSupp" /><CustomField Id="HealthCareSupp" Name="Health Supplement Amount" Description="Amount Paid to Clergy based on Health Supplement Type Chosen" Invisible="false" /><CustomField Id="HealthCareSuppOther" Name="Health Care Supplement Amount - Special case if standard Supplement Amount not used (DS approval required)" Format="C" /><CustomField Id="HealthInsurance" Invisible="true" /><CustomField Id="HealthInsAmt" Invisible="true" /><CustomField Id="ChurchProvidedPlan" Name="Church Provided Plan" Invisible="true" /><CustomField Id="ReceivePension" Name="Participates in Conference Pension Plan" Invisible="false" Cmd="After:HealthCareSuppOther" /><CustomField Id="PensionAmt" Name="Pension to be paid to FLUMC" Format="C" Cmd="Before:TotalBenefitPackage" /><CustomField Id="TotalBenefitPackage" Name="Total Benefit Package Cost" Description="Total of Health Supplement and Pension Amount" Invisible="false" /><CustomField Id="TotalComp" Invisible="true" /><CustomField Id="Notes" Name="Notes" Invisible="false" Cmd="Last" /><CustomField Id="GrandTotal" Name="Total Salary + Housing Value + Moving Expense = Pension Base" Description="If parsonage is chosen above, the housing value is 25% of Total Approved Annual Base Salary" Cmd="Before:PensionAmt" Invisible="false" /><CustomField Id="TotalCompensation" Name="Total Cost to Church" Description="Includes any or all of the following: Salary, Housing Allowance, Moving Expenses, Health Supplement and Pension. Does not include Parsonage Value as it is not paid out to the person as a direct cost." Cmd="After:PensionAmt" Format="C" /><CustomField Id="AppdByDistrict" Invisible="true" /><CustomField Id="LastEditedDate" Invisible="true" /><CustomField Id="LastEditedBy" Invisible="true" /><CustomField Id="EditNotes" Invisible="true" /><Column Id="EndDate" Invisible="false" /><CustomField Id="ContinuingEducationExpense" Name="Continuing Education (not in RA Above)" Description="This amount is not included in any compensation totals" Invisible="false" /><CustomField Id="AnnualConferenceExpense" Invisible="true" /><CustomField Id="OtherReimbursedExpense" Invisible="true" /><CustomField Id="DistrictComp" Invisible="true" /><CustomField Id="ContinuingEducation" Invisible="true" /><CustomField Id="TotalSalary" Invisible="true" /></FieldSet><FieldSet Id="Insurance" Invisible="true" /><FieldSet Id="SignatureFields" Invisible="true"><CustomField Id="SignaturePastor" Cmd="Before:PastorDate" /><CustomField Id="SignatureDistrict" Cmd="Before:DSDate" /></FieldSet><FieldSet Id="SalarySource" Name="Salary Source" Invisible="false"><Info Id="SalaryInfo" /><Relationship Id="Church" Name="Church(s)" /><Filters><Filter Id="OnlyOpenChurches" Type="Search,Link"><Or><IsNull FieldId="MakeInactive" /><Eq Id="MakeInactive" Value="false" /></Or></Filter></Filters><CustomField Id="MultiPointCharge" Name="Is this church part of a multi-point charge?" Type="Bit" Cmd="After:Church" /><CustomField Id="LeadChurch" Name="Is this the lead church in the charge?" Invisible="true" /><Relationship Id="ExtensionMinistryList" Name="Choose your extension ministry" /><Relationship Id="District" TableId="Contacts" ViewId="Districts" Name="District (choose only if income comes from the district)" Invisible="false" Cmd="After:ExtensionMinistryList"><Filters><Filter Id="OnlyOpenDisricts" Type="Search,Link"><Or><IsNull FieldId="MakeInactive" /><Eq Id="MakeInactive" Value="false" /></Or></Filter></Filters></Relationship><CustomField Id="GSSReport" Name="Include this Extension Ministry in the GSS Report?" /><Relationship Id="SalaryBreakdown" Invisible="true" /><Relationship Id="LeadChurchName" Name="If yes, which is the lead church in the charge?" /></FieldSet><Category Id="ClergyStatusAtTimeOfFiling" Cmd="Remove" /><CustomField Id="DateOfChargeConference" Cmd="Remove" /><Category Id="AppointmentChargeConferences" Cmd="Remove" /></Fields></View>
<script src="https://www.flumc.org/peopleportal/compcalc.js"></script> <style type="text/css"> body { background-color:#eee; } .container { max-width:800px; } fieldset.engine-fieldset legend { font-size:20px; border-bottom:none; padding:10px; background-color:#eee; margin-bottom:16px; } label { font-size:15px; } legend .icon-caret-down, #brandedtop { display:none; } </style> <script> $(document).ready(function() { if ( window.location !== window.parent.location ) { $(".btn-large").hide(); } }); </script>
Formula
Visible |
GrandTotal
|
CompensationTags==19939 ? TotalSalaryValue*1.25+MovingExpenses : TotalSalaryValue+HousingAllowance+MovingExpenses |
||||||||||||||||||
Constant
Visible |
HCSClergyCouple
|
7705 |
||||||||||||||||||
Constant
Visible |
HCSClergyCoupleFamilyCoverage
|
9484 |
||||||||||||||||||
Constant
Visible |
HCSClergyFamily
|
18967 |
||||||||||||||||||
Constant
Visible |
HCSClergyOne
|
15410 |
||||||||||||||||||
Constant
Visible |
HCSSingleClergy
|
11854 |
||||||||||||||||||
Formula
Visible |
HealthCareSupp
|
if (HealthSupplement==49768){ HCSSingleClergy } else if (HealthSupplement==49769){ HCSClergyOne } else if (HealthSupplement==49770){ HCSClergyCouple } else if (HealthSupplement==49771){ HCSClergyFamily } else if (HealthSupplement==49772){ HCSClergyCoupleFamilyCoverage } else { 0 }
HealthSupplement==49768 ? HCS-SingleClergy : HealthSupplement==49769 ? HCS-Clergy+One : HealthSupplement==49770 ? HCS-ClergyCouple : HealthSupplement==49771 ? HCS-ClergyFamily : HealthSupplement==49772 ? HCS-ClergyCoupleFamilyCoverage : 0
|
||||||||||||||||||
Constant
Visible |
MinimumSalary
|
20000
Anyone with Pensionable Status and a Total Compensation of $20,000 or higher receives a pension
|
||||||||||||||||||
Show/Hide
Visible |
ParsonageProviderChurch
|
CompensationTags==19939 |
||||||||||||||||||
Formula
Visible |
ParsonageValue
|
if (CompensationTags==19939){ TotalSalaryValue*.25 } |
||||||||||||||||||
Constant
Visible |
PensionAbleStatuses
|
[4920,4921,4927,4928,4929,4932,4933,4934,4935,4936,4938,4939,4940]
An array of clergy statuses that allow them to have a pension
|
||||||||||||||||||
Formula
Visible |
PensionAmt
|
PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling) && TotalSalaryValue>=MinimumSalary ? GrandTotal*.15 : 0
Pension paid to FLUMC
The constant: IsPensionable= Yes, then the Pensionable amount is TotalCompensation * .15
Pension paid to FLUMC The clergy statuses are:
SCRATCH PAD PensionAbleStatuses.includes(ClergyStatus) && TotalComp*1 >= 20000 ? (CompensationTags==19939 ? (TotalSalary*1.25)*.15 : TotalSalary*.15) : 0 TotalSalary*.15 NO: if(ClergyStatusAtTimeOfFiling in PensionAbleStatuses && ServiceTimeAtTimeOfFiling in PensionAbleServiceTimes){ if(CompensationTags==19939){ (TotalSalary*1.25)*.15 } else{ TotalSalary*.15 } } |
||||||||||||||||||
Formula
Visible |
TotalBenefitPackage
|
HealthCareSupp+PensionAmt |
||||||||||||||||||
Formula
Visible |
TotalCompensation
|
TotalSalaryValue+HousingAllowance+MovingExpenses+HealthCareSupp+PensionAmt |
||||||||||||||||||
Formula
Visible |
TotalSalaryValue
|
BaseSalary+EquitableComp+NewChurchComp+OtherComp |
Filing dates | 9/20/2022 to: 6/1/2023 |
Comp dates | 1/1/2023 to: 12/31/2023 |
Splits |
BaseSalary,BaseSalary,Number
EquitableComp,EquitableComp,Number
NewChurchComp,NewChurchComp,Number
OtherComp,OtherComp,Number
HousingAllowance,HousingAllowance,Number
ParsonageValue,ParsonageValue,Number
PensionAmt,PensionAmt,Number
AccountableReimbursement,AccountableReimbursement,Number
MovingExpenses,MovingExpenses,Number
ContinuingEducationExpense,ContinuingEducationExpense,Number
UtilityAllowance,UtilityAllowance,Number
HealthCareSupp,HealthCareSupp,Number
HealthCareSuppOther,HealthCareSuppOther,Number
|
Approval stages |
Submitter,District
|
Report fields |
People.FirstName,People.LastName,PubDate,AppointmentChargeConferences,DateOfChargeConference,ClergyStatusAtTimeOfFiling,MultiPointCharge,LeadChurch,ExtensionMinistry,GSSReport,BaseSalary,EquitableComp,NewChurchComp,OtherComp,TotalSalaryValue,CompensationTags,HousingAllowance,ParsonageValue,UtilityExclusion,AccountableReimbursement,MovingExpenses,ContinuingEducationExpense,Utility,UtilityAllowance,HealthInsuranceOption,HealthSupplement,HealthCareSupp,ReceivePension,GrandTotal,PensionAmt,TotalBenefitPackage,TotalCompensation,Notes,SalaryBreakdown.Church.Name,SalaryBreakdown.ExtensionMinistryList.Name,SalaryBreakdown.BaseSalary,SalaryBreakdown.EquitableComp,SalaryBreakdown.NewChurchComp,SalaryBreakdown.OtherComp,SalaryBreakdown.HousingAllowance,SalaryBreakdown.ParsonageValue,SalaryBreakdown.PensionAmt,SalaryBreakdown.AccountableReimbursement,SalaryBreakdown.MovingExpenses,SalaryBreakdown.ContinuingEducationExpense,SalaryBreakdown.UtilityAllowance,SalaryBreakdown.HealthCareSupp,SalaryBreakdown.HealthCareSuppOther
|
<View Id="Comp2023" TableId="Content" Inherits="ClergyCompForm" Name="2023 Comp Form Records" Plural="2023 Comp Records" Singular="2023 Comp Record" Invisible="true" Menu="UMC (comp)"><Fields><FieldSet Id="FilingInfo" Important="true" Invisible="false"><Info Id="dropdown" Cmd="Before:PubDate"> You must use the drop-down selections where applicable. </Info><Category Id="ServiceTimeAtTimeOfFiling" Cmd="Remove" /><!--<Relationship Id="Church" Name="Currently appointed to church for which this form applies" />--><Column Id="PubDate" Name="Compensation will be effective on" Type="DateTime" Invisible="false" ReadOnlyOnAdd="false" /><Category Id="AppointmentChargeConferences" Name="And was approved at a:" /><Relationship Id="DistrictOfChurch" TableId="Contacts" ViewId="Districts" Name="Church District"><Filters><Filter Id="OnlyOpenDisricts" Type="Search,Link"><Or><IsNull FieldId="MakeInactive" /><Eq Id="MakeInactive" Value="false" /></Or></Filter></Filters></Relationship><File Id="CompiledCompensationFiles" Invisible="true" /><CustomField Id="DateOfChargeConference" Cmd="After:AppointmentChargeConferences" Name="Date of that Charge Conference" Invisible="false" /><Category Id="ClergyStatusAtTimeOfFiling" Name="Your clergy status" Multiple="false" Cmd="After:DateOfChargeConference" /></FieldSet><FieldSet Id="SalaryInfo"><Info Id="SalaryText" Cmd="Before:BaseSalary"><b> 2023 Minimum Salary (full time) </b><br /><ul><li> Full Connection - $47,400 </li><li> Provisional Member - $44,950 </li><li> Associate Member - $43,500 </li><li> Local Pastor w M.Div. or 5 years COS - $42,200 </li><li> Local Pastor with less than 5 years COS - $41,200 </li></ul> Clergy who are appointed AND receive at least 50% of minimum salary <b><i> are eligible and will be enrolled in the Wespath pension plan. </i></b><br /><br /> Retired Clergy are <b> NOT </b> eligible for pension. <br /><br /> Lay Supply Pastors and Certified Lay Ministers <b> are NOT ELIGIBLE FOR CLERGY PENSION NOR CLERGY TAX EXEMPTIONS. </b><br /><br /> Pension to be paid to FLUMC (below) is calculated as follows: <br /><ul><li> With a housing allowance: (Base Annual Salary + Housing Allowance) X 15% = Pension Billing; </li><li> With a parsonage*: Base Annual Salary X 1.25 X 15% = Pension Billing </li></ul> *Parsonage value is used for Pension purposes only; not to be used for income tax. </Info><CustomField Id="BaseSalary" Name="Salary: Church/Ext. Min." /><CustomField Id="EquitableComp" Name="Salary: Conf Equitable Salary Support" Format="C" /><CustomField Id="NewChurchComp" Name="Salary: NCD Conf Salary Support" Format="C" /><CustomField Id="OtherComp" Name="Salary: Other Support" Cmd="After:NewChurchComp" Invisible="false" Type="Float" Format="C" /><CustomField Id="TotalSalaryValue" Name="Total Approved Annual Base Salary" Format="C" Cmd="After:OtherComp" /><Category Id="CompensationTags" Description="Must be chosen for every clergy. Either Parsonage, Housing Allowance or None" Name="Housing Code" Cmd="After:TotalSalaryValue" /><Relationship Id="ParsonageProviderChurch" Name="Church that provides the parsonage" Cmd="After:CompensationTags" /><CustomField Id="HousingAllowance" Name="Housing Allowance" Format="C" /><CustomField Id="ParsonageValue" Name="Parsonage Value" Format="C" /><CustomField Id="AccountableReimbursement" Name="Reimbursable Account" Description="This amount is not included in any compensation totals" Invisible="false" /><CustomField Id="UtilityExclusion" Name="Housing Exclusion" Invisible="false" /><CustomField Id="MovingExpenses" Name="Moving Expense Reimbursement (not in RA Above)" Description="This amount is included in compensation totals and is pension eligible" Invisible="false" /><CustomField Id="Utility" Name="Utilities - Checking yes means all utilities are paid" Invisible="false" /><CustomField Id="UtilityAllowance" Name="Utilities Allowance" Description="Enter dollar amount ONLY if church does not pay ALL or puts a cap on utilities expense. (If YES is checked on line above no amount can be entered here. It is one or the other.)" Invisible="false" Format="C" /><Category Id="HealthInsuranceOption" Name="Health Insurance Options" CatType="Health Insurance Options" Multiple="false" Cmd="After:UtilityAllowance" /><Info Id="SupplementInfo" Cmd="After:HealthInsuranceOption"> A Health Supplement is taxable earnings. Lay Supply, CLM and Retired Clergy are not eligible for Health Supplement. </Info><Category Id="HealthSupplement" Name="Health Supplements" CatType="Health Supplements" Multiple="false" Invisible="false" Cmd="Before:HealthCareSupp" /><CustomField Id="HealthCareSupp" Name="Health Supplement Amount" Description="Amount Paid to Clergy based on Health Supplement Type Chosen" Invisible="false" /><CustomField Id="HealthCareSuppOther" Name="Health Care Supplement Amount - Special case if standard Supplement Amount not used (DS approval required)" Format="C" /><CustomField Id="HealthInsurance" Invisible="true" /><CustomField Id="HealthInsAmt" Invisible="true" /><CustomField Id="ChurchProvidedPlan" Name="Church Provided Plan" Invisible="true" /><CustomField Id="ReceivePension" Name="Participates in Conference Pension Plan" Invisible="false" Cmd="After:HealthCareSuppOther" /><CustomField Id="PensionAmt" Name="Pension to be paid to FLUMC" Format="C" Cmd="Before:TotalBenefitPackage" /><CustomField Id="TotalBenefitPackage" Name="Total Benefit Package Cost" Description="Total of Health Supplement and Pension Amount" Invisible="false" /><CustomField Id="TotalComp" Invisible="true" /><CustomField Id="Notes" Name="Notes" Invisible="false" Cmd="Last" /><CustomField Id="GrandTotal" Name="Total Salary + Housing Value + Moving Expense = Pension Base" Description="If parsonage is chosen above, the housing value is 25% of Total Approved Annual Base Salary" Cmd="Before:PensionAmt" Invisible="false" /><CustomField Id="TotalCompensation" Name="Total Cost to Church" Description="Includes any or all of the following: Salary, Housing Allowance, Moving Expenses, Health Supplement and Pension. Does not include Parsonage Value as it is not paid out to the person as a direct cost." Cmd="After:PensionAmt" Format="C" /><CustomField Id="AppdByDistrict" Invisible="true" /><CustomField Id="LastEditedDate" Invisible="true" /><CustomField Id="LastEditedBy" Invisible="true" /><CustomField Id="EditNotes" Invisible="true" /><Column Id="EndDate" Invisible="false" /><CustomField Id="ContinuingEducationExpense" Name="Continuing Education (not in RA Above)" Description="This amount is not included in any compensation totals" Invisible="false" /><CustomField Id="AnnualConferenceExpense" Invisible="true" /><CustomField Id="OtherReimbursedExpense" Invisible="true" /><CustomField Id="DistrictComp" Invisible="true" /><CustomField Id="ContinuingEducation" Invisible="true" /><CustomField Id="TotalSalary" Invisible="true" /></FieldSet><FieldSet Id="Insurance" Invisible="true" /><FieldSet Id="SignatureFields" Invisible="true"><CustomField Id="SignaturePastor" Cmd="Before:PastorDate" /><CustomField Id="SignatureDistrict" Cmd="Before:DSDate" /></FieldSet><FieldSet Id="SalarySource" Name="Salary Source" Invisible="false"><Info Id="SalaryInfo" /><Relationship Id="Church" Name="Church(s)" /><Filters><Filter Id="OnlyOpenChurches" Type="Search,Link"><Or><IsNull FieldId="MakeInactive" /><Eq Id="MakeInactive" Value="false" /></Or></Filter></Filters><CustomField Id="MultiPointCharge" Name="Is this church part of a multi-point charge?" Type="Bit" Cmd="After:Church" /><CustomField Id="LeadChurch" Name="Is this the lead church in the charge?" Invisible="true" /><Relationship Id="ExtensionMinistryList" Name="Choose your extension ministry" /><Relationship Id="District" TableId="Contacts" ViewId="Districts" Name="District (choose only if income comes from the district)" Invisible="false" Cmd="After:ExtensionMinistryList"><Filters><Filter Id="OnlyOpenDisricts" Type="Search,Link"><Or><IsNull FieldId="MakeInactive" /><Eq Id="MakeInactive" Value="false" /></Or></Filter></Filters></Relationship><CustomField Id="GSSReport" Name="Include this Extension Ministry in the GSS Report?" /><Relationship Id="SalaryBreakdown" Invisible="true" /><Relationship Id="LeadChurchName" Name="If yes, which is the lead church in the charge?" /></FieldSet><Category Id="ClergyStatusAtTimeOfFiling" Cmd="Remove" /><CustomField Id="DateOfChargeConference" Cmd="Remove" /><Category Id="AppointmentChargeConferences" Cmd="Remove" /></Fields></View>
<script src="https://www.flumc.org/peopleportal/compcalc.js"></script> <style type="text/css"> body { background-color:#eee; } .container { max-width:800px; } fieldset.engine-fieldset legend { font-size:20px; border-bottom:none; padding:10px; background-color:#eee; margin-bottom:16px; } label { font-size:15px; } legend .icon-caret-down, #brandedtop { display:none; } </style> <script> $(document).ready(function() { if ( window.location !== window.parent.location ) { $(".btn-large").hide(); } }); </script>
Formula
Visible |
GrandTotal
|
CompensationTags==19939 ? TotalSalaryValue*1.25+MovingExpenses : TotalSalaryValue+HousingAllowance+MovingExpenses |
||||||||||||||||||
Constant
Visible |
HCSClergyCouple
|
8091 |
||||||||||||||||||
Constant
Visible |
HCSClergyCoupleFamilyCoverage
|
9958 |
||||||||||||||||||
Constant
Visible |
HCSClergyFamily
|
19915 |
||||||||||||||||||
Constant
Visible |
HCSClergyOne
|
16181 |
||||||||||||||||||
Constant
Visible |
HCSSingleClergy
|
12446 |
||||||||||||||||||
Constant
Visible |
HCSSingleClergyTwoPoint
|
6223 |
||||||||||||||||||
Formula
Visible |
HealthCareSupp
|
if (HealthSupplement==49768){ HCSSingleClergy } else if (HealthSupplement==49769){ HCSClergyOne } else if (HealthSupplement==49770){ HCSClergyCouple } else if (HealthSupplement==49771){ HCSClergyFamily } else if (HealthSupplement==49772){ HCSClergyCoupleFamilyCoverage } else if (HealthSupplement==51902){ HCSSingleClergyTwoPoint } else { 0 }
HealthSupplement==49768 ? HCS-SingleClergy : HealthSupplement==49769 ? HCS-Clergy+One : HealthSupplement==49770 ? HCS-ClergyCouple : HealthSupplement==49771 ? HCS-ClergyFamily : HealthSupplement==49772 ? HCS-ClergyCoupleFamilyCoverage : 0
|
||||||||||||||||||
Constant
Visible |
MinimumSalary
|
20600
Anyone with Pensionable Status and a Total Compensation of $20,600 or higher receives a pension
|
||||||||||||||||||
Show/Hide
Visible |
ParsonageProviderChurch
|
CompensationTags==19939 |
||||||||||||||||||
Formula
Visible |
ParsonageValue
|
if (CompensationTags==19939){ TotalSalaryValue*.25 } |
||||||||||||||||||
Constant
Visible |
PensionAbleStatuses
|
[4920,4921,4927,4928,4929,4932,4933,4934,4935,4936,4938,4939,4940]
An array of clergy statuses that allow them to have a pension
|
||||||||||||||||||
Formula
Visible |
PensionAmt
|
PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling) && TotalSalaryValue>=MinimumSalary ? GrandTotal*.15 : 0
Pension paid to FLUMC
The constant: IsPensionable= Yes, then the Pensionable amount is TotalCompensation * .15
Pension paid to FLUMC The clergy statuses are:
SCRATCH PAD PensionAbleStatuses.includes(ClergyStatus) && TotalComp*1 >= 20000 ? (CompensationTags==19939 ? (TotalSalary*1.25)*.15 : TotalSalary*.15) : 0 TotalSalary*.15 NO: if(ClergyStatusAtTimeOfFiling in PensionAbleStatuses && ServiceTimeAtTimeOfFiling in PensionAbleServiceTimes){ if(CompensationTags==19939){ (TotalSalary*1.25)*.15 } else{ TotalSalary*.15 } } |
||||||||||||||||||
Formula
Visible |
TotalBenefitPackage
|
HealthCareSupp+PensionAmt |
||||||||||||||||||
Formula
Visible |
TotalCompensation
|
TotalSalaryValue+HousingAllowance+MovingExpenses+HealthCareSupp+PensionAmt |
||||||||||||||||||
Formula
Visible |
TotalSalaryValue
|
BaseSalary+EquitableComp+NewChurchComp+OtherComp |