Fall 2021 Filing for 2022 Compensation Click green hover fields to copy
Filing dates 10/1/2021 to: 11/30/2022
Comp dates 1/1/2022 to: 12/31/2022
Splits
Approval stages
District
Report fields
People.FistName,People.LastName,Church,SalaryBreakdown,ClergyStatusAtTimeOfFiling,ServiceTimeAtTimeOfFiling,DateOfChargeConference,CompiledCompensationFiles,BaseSalary,PastorPensionShare,AdditionalAnnuityContributions,CashAllowance,UtilityAllowancesPaidToPastor,UtilityAllowancesPaidForPastor,AdditionalCompensationTotal,TotalSalaryAndOtherCompensation,CompensationTags,HousingAllowance,OtherHousingAllowance,TotalHousingAllowance,HealthCareCompensation,TotalCompensation,TravelReimbursement,OtherReimbursedExpense,ContinuingEducationExpense,AnnualConferenceExpense,AccountableReimbursement,ParsonagePhone,CableOrSatTv,InternetAtParsonage,PensionAmountPaidByChurch,PensionAmountPaidByChurchPart2,PensionAmountTotal,PreTaxPipPercent,PreTaxPip,RothContributionsPercent,RothContributions,AfterTaxPipPercent,AfterTaxPip,SignaturePastor,SignatureDistrict,Submitted,FullyApproved
<View Id="Comp2022" TableId="Content" Inherits="ClergyCompForm"><Fields><FieldSet Id="SalarySource" Invisible="false" /></Fields></View>
                                                
Redirect to: https://www.igrc.org/peopleportal/compensation?lastperson=yes
Scripts
<script src="https://www.igrc.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;
}
div[data-fieldid="TotalSalaryValue"] .input-block-level,
div[data-fieldid="HealthCareCompensation"] .input-block-level,
div[data-fieldid="AccountableReimbursement"] .input-block-level,
div[data-fieldid="TotalCompensation"] .input-block-level,
div[data-fieldid="PensionAmountPaidByChurch"] .input-block-level,
div[data-fieldid="PensionAmountPaidByChurchPart2"] .input-block-level,
div[data-fieldid="PensionAmountTotal"] .input-block-level,
div[data-fieldid="TotalHousingAllowance"] .input-block-level
{
    border-color: transparent;
}
</style>
<script>
    $(document).ready(function() {
        if ( window.location !== window.parent.location ) {
            $(".btn-large").hide();
        }
    });
</script>
                                
Header
<style type="text/css">div[data-fieldid="AdditionalCompensationTotal"]{
display: none;
}
</style>
                                
Formula
Visible
AccountableReimbursement
TravelReimbursement+OtherReimbursedExpense+ContinuingEducationExpense+AnnualConferenceExpense
                                
Formula
Visible
AdditionalCompensationTotal
//AdditionalCompensationTotal

PastorPensionShare
+
AdditionalAnnuityContributions
+
CashAllowance
+
UtilityAllowancesPaidToPastor
                                
Constant
Visible
HealthCareCompAmount
17500
                                
Formula
Visible
HealthCareCompensation
if(PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling) && ServiceTimeAtTimeOfFiling == 4957){
    HealthCareCompAmount
} else {
    0
}
                                
SHOULD THIS FIELD BE OVERRIDEABLE WHEN APPOINTMENT STATUS IS 3/4?
Show/Hide
Visible
HealthCareCompensationAdjustment
ServiceTimeAtTimeOfFiling == 4956
                                
Show/Hide
Visible
HousingAllowance
CompensationTags == 19938
                                
Constant
Invisible
NotEligibleForPension
[4943, 4942, 4941, 4944, 4930, 48976, 49168, 4946, 48975]
                                
NEED TO CHECK THESE VALUES. ALSO, POSSIBLY INVERT TO USE ELIGIBLE STATUSES INSTEAD.
Constant
Visible
PartTimeStatuses
[23553,4956,4955,4954,19746]
                                
Constant
Visible
PensionAbleStatuses
[4928,4934,4935,4929,45547,4927,4932,4933,4938,4939,4940,45546]
                                
Eligible
FE, OE, OF, FL, OL

Additions from call
FD - DEACON IN FULL CONN
FE - ELDER IN FULL CONN
FL - FULL TIME LOCAL PASTOR
OA - ASSOC OTHER CONFERENCE
OD - DEACON MEMBER OF OTHER CONFERENCE OR METHODIST DENOMINATION
PD - PROVISIONAL DEACON
PE - PROVISIONAL ELDER
PL - PART TIME LOCAL PASTOR
SLP - Student Local Pastor

 
Formula
Visible
PensionAmountPaidByChurch
//PensionAmountPaidByChurch
if(PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling)){//eligible clergy status
    if(ServiceTimeAtTimeOfFiling == 4957){ //full time
        if(CompensationTags == 19939){ //parsonage
            (TotalSalaryValue * 1.25) * 0.06
        } else { //not parsonage
            (TotalSalaryValue  + TotalHousingAllowance) * 0.06
        }
    } else { //not full time
        if(CompensationTags == 19939){ //parsonage
            (TotalSalaryValue * 1.25) * 0.03
        } else { //not parsonage
            (TotalSalaryValue  + TotalHousingAllowance) * 0.03
        }
    }
}
                                
CLERGY STATUSES LIST MAY NOT BE COMPLETE. VERIFY PensionAbleStatuses ARRAY IF NECESSARY


 
For full-time pastors who live in parsonages (Line 3 x 1.25) x .06 = annual pension bill
For full-time pastors who live in their own home (Line 3 + Line 6) x .06 = annual pension bill
For part-time pastors who live in parsonages (Line 3 x 1.25) x .03 = annual pension bill
For part-time pastors who live in their own home (Line 3 + Line 6) x .03 = annual pension bill


OLD FORMULA
if(PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling) && ServiceTimeAtTimeOfFiling == 4957 && CompensationTags == 19939){
    (TotalSalaryValue* 1.25) * 0.06
} else if(PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling) && ServiceTimeAtTimeOfFiling == 4957 && CompensationTags == 19938){
    (TotalSalaryValue+ TotalHousingAllowance) * 0.06
} else if(PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling) && ServiceTimeAtTimeOfFiling == 23553 && CompensationTags == 19939){
    (TotalSalaryValue* 1.25) * 0.03
} else if(PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling) && ServiceTimeAtTimeOfFiling == 23553 && CompensationTags == 19938){
    (TotalSalaryValue+ TotalHousingAllowance) * 0.03
} else {
    0
}


 
Formula
Visible
PensionAmountPaidByChurchPart2
if(PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling)){ //eligible
    if(ServiceTimeAtTimeOfFiling == 4957){ //full time
        5700
    } else if (ServiceTimeAtTimeOfFiling == 4956){ //3/4 time
        4275
    } else if(ServiceTimeAtTimeOfFiling == 4955){ //1/2 time
        2850
    } else {
        0
    }
}
                                
Formula
Visible
PensionAmountTotal
PensionAmountPaidByChurch + PensionAmountPaidByChurchPart2
                                
Formula
Visible
TotalCompensation
TotalSalaryValue+TotalHousingAllowance+HealthCareCompensation+HealthCareCompensationAdjustment
                                
Formula
Visible
TotalHousingAllowance
HousingAllowance+OtherHousingAllowance
                                
Formula
Visible
TotalSalaryValue
BaseSalary+AdditionalCompensationTotal