Compensation for 2022 year Click green hover fields to copy
Filing dates 5/1/2022 to: 7/31/2022
Comp dates 6/1/2022 to: 12/31/2022
Splits
BaseSalary,Salary,Number HousingAllowance,HousingAllowance,Number BenefitsCalcForBreakdown,BenefitsCalcForBreakdown,Number PensionCalcForBreakdown,PensionCalcForBreakdown,Number
Approval stages
Submitter,District
Report fields
People.FirstName,People.LastName,ClergyStatusAtTimeOfFiling,ServiceTimeAtTimeOfFiling,Church,ChurchDistrict,DateOfChargeConference,BaseSalary,SalaryBreakdown,Charges,District,BenefitsTitle,HealthInsurancePlan,DentalInsurancePlan,VisionInsurancePlan,TotalClergyPortionOfInsurancePremium,ClergyInsurancePortionChurchPaysAsAdditionalBenefit,PersonalExpensesPaidByCharge,TotalSalaryValue,TotalComp,HealthCareCompensation,HousingTitle,CompensationTags,HousingAllowance,PensionCalculationTitle,CRSP,CPP,UMPIP,PensionCalculationForGrandTotal,AccountableReimbursementTitle,ProfessionalExpensesReimbursed,BookExpenses,TravelReimbursement,EducationExpenses,AccountableReimbursement,UtilityExclusion,TotalCompensation,GrandTotal,SalaryBreakdown.Church.Name,SalaryBreakdown.Salary,SalaryBreakdown.HousingAllowance,SalaryBreakdown.BenefitsCalcForBreakdown,SalaryBreakdown.PensionCalcForBreakdown,SignaturePastor,SignatureDistrict,Submitted,FullyApproved,Approvals 
<View Id="CompJan2022" TableId="Content" Inherits="ClergyCompForm" Name="Compensation Form" Invisible="true"><Fields><FieldSet Id="FilingInfo"><Category Id="ClergyStatusAtTimeOfFiling" Required="true" /><Category Id="ServiceTimeAtTimeOfFiling" Required="true" /></FieldSet><FieldSet Id="SalaryInfo"><CustomField Id="BaseSalary" Required="true" /><Relationship Id="HealthInsurancePlan" /><Category Id="CompensationTags" Required="true" /><CustomField Id="AccountableReimbursement" /><CustomField Id="UtilityExclusion" Name="Parsonage Utilities paid by Charge" /></FieldSet></Fields><ListFields><Ref Id="AccountableReimbursement" /></ListFields></View>
Redirect to: https://www.wisconsinumc.org/peopleportal/compensation?lastperson=yes
Scripts
<script src="https://www.wisconsinumc.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,
div[data-fieldid="BenefitsCalcForBreakdown"],
div[data-fieldid="PensionCalcForBreakdown"]
{
    display:none;
}
</style>
<script>
    $(document).ready(function() {
        if ( window.location !== window.parent.location ) {
            $(".btn-large").hide();
        }
    });
</script>
Header
<style type="text/css">div[data-fieldId="PensionCalculationForGrandTotal"]{
display: none;
}
</style>
Formula
Visible
AccountableReimbursement
 
//AccountableReimbursement
ProfessionalExpensesReimbursed + 
BookExpenses + 
TravelReimbursement + 
EducationExpenses
=ProfessionalExpensesOtherThanThoseExplicityListedBelowReimbursedToTheClergyPersonInExchangeForAReceiptOrVoucherForExampleAnnualConferenceExpenses +
BookAndPublicationExpensesReimbursedToTheClergyInExchangeForAReceiptOrVoucher +
TravelExpensesReimbursedToTheClergyPersonInExchangeForAReceiptOrVoucher +
EducationExpensesReimbursedToTheClergyPersonInExchangeForAReceiptOrVoucher
Formula
Visible
BenefitsCalcForBreakdown
 
//BenefitsCalcForBreakdown

ClergyInsurancePortionChurchPaysAsAdditionalBenefit + HealthCareCompensation
Show/Hide
Visible
BenefitsTitle
 
PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling) && PensionAbleServiceTimes.includes(ServiceTimeAtTimeOfFiling)
Formula
Visible
CPP
 
//CPP
if(PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling) && PensionAbleServiceTimes.includes(ServiceTimeAtTimeOfFiling)){ // eligible
	if(CompensationTags == 19939){ // with parsonage
		(TotalSalaryValue * 1.25) * 0.024
	} else { // without parsonage
		(TotalSalaryValue + HousingAllowance) * 0.024
	}
} else {
	0
}
Show/Hide
Visible
CPP
 
PensionAbleServiceTimes.includes(ServiceTimeAtTimeOfFiling)
&&
PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling)
Formula
Visible
CRSP
 
//CRSP
if(PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling) && PensionAbleServiceTimes.includes(ServiceTimeAtTimeOfFiling)){ // eligible
	if(CompensationTags == 19939){//with parsonage
		(TotalSalaryValue * 1.25) * 0.12
	} else { //without parsonage
		(TotalSalaryValue + HousingAllowance) * 0.12
	}
} else {
	0
}
Show/Hide
Visible
CRSP
 
PensionAbleServiceTimes.includes(ServiceTimeAtTimeOfFiling)
&&
PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling)
Show/Hide
Visible
DentalInsurancePlan
 
PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling) && PensionAbleServiceTimes.includes(ServiceTimeAtTimeOfFiling)
PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling) && PensionAbleServiceTimes.includes(ServiceTimeAtTimeOfFiling)
Validation
Visible
EducationExpenses
 
EducationExpenses >= 900
Formula
Visible
HealthCareCompensation
 
//HealthCareCompensation
if(PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling) && PensionAbleServiceTimes.includes(ServiceTimeAtTimeOfFiling)){
    //if eligible
	16020
} else {
    //if not eligible
	0
}
Show/Hide
Visible
HealthInsurancePlan
 
PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling) && PensionAbleServiceTimes.includes(ServiceTimeAtTimeOfFiling)
Show/Hide
Visible
HousingAllowance
 
CompensationTags == 19938
Constant
Visible
PensionAbleServiceTimes
 
[4957,4956]
Full time and 3/4
Constant
Visible
PensionAbleStatuses
 
[4928,4939,4921,4929,47683,4927,4938,4934,4935,4940]
An array of clergy statuses that allow them to have a pension
ELIGIBLE
[4928,4939,4921,4929,47683,4927,4938,4934,4935]

FE - 4928
PE - 4939
AM - 4921
FL - 4929
SP - 47683 (CUSTOM)
FD - 4927
PD - 4938
OE - 4934
OF - 4935
PL - 4940

NOT ELIGIBLE
[4946,4943,4944,4945,4942]

SY - 4946
RE - 4943
RL - 4944
RP - 4945
RD - 4942
 
Formula
Visible
PensionCalcForBreakdown
 
//PensionCalcForBreakdown

CRSP
+
CPP
+
UMPIP
Formula
Visible
PensionCalculationForGrandTotal
 
//PensionCalculationForGrandTotal

if (PensionAbleServiceTimes.includes(ServiceTimeAtTimeOfFiling)) { //full or 3/4 time
    let val1;
    if(PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling)){
		val1 = (TotalSalaryValue * 1.25) * 0.024
	} else {
		val1 = 0
	}
	if(CompensationTags == 19939){ //with parsonage
		CRSP + 
		val1
	} else { //without parsonage
		if(PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling)){			
			((TotalSalaryValue + HousingAllowance) * 0.12) + 
			((TotalSalaryValue + HousingAllowance) * 0.024)
		}
	}
} else { //1/2 or 1/4 time
	if(CompensationTags == 19939){ //with parsonage
		if(PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling)){
			(TotalSalaryValue * 1.25) * 0.06
		}
	} else { //without parsonage
		if(PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling)){
			((TotalSalaryValue + HousingAllowance) * 0.06)
		}
	}
}
Show/Hide
Visible
PensionCalculationTitle
 
PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling)
Formula
Visible
TotalClergyPortionOfInsurancePremium
 
//TotalClergyPortionOfInsurancePremium
getInsurance(HealthInsurancePlan) + getInsurance(DentalInsurancePlan) + getInsurance(VisionInsurancePlan)
Formula
Visible
TotalCompensation
 
//TotalCompensation (GrandTotal)
TotalSalaryValue + 
HousingAllowance + 
PensionCalculationForGrandTotal + 
AccountableReimbursement + 
HealthCareCompensation + 
UtilityExclusion
Formula
Visible
TotalSalaryValue
 
BaseSalary+ClergyInsurancePortionChurchPaysAsAdditionalBenefit+PersonalExpensesPaidByCharge
Formula
Visible
UMPIP
 
//UMPIP
if(PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling) && !PensionAbleServiceTimes.includes(ServiceTimeAtTimeOfFiling)){ // eligible
	if(CompensationTags == 19939){//with parsonage
		(TotalSalaryValue * 1.25) * 0.06
	} else { //without parsonage
		(TotalSalaryValue + HousingAllowance) * 0.06
	}
} else {
	0
}
Show/Hide
Visible
UMPIP
 
PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling) && !PensionAbleServiceTimes.includes(ServiceTimeAtTimeOfFiling)
Show/Hide
Visible
VisionInsurancePlan
 
PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling) && PensionAbleServiceTimes.includes(ServiceTimeAtTimeOfFiling)
Compensation for 2023 year Click green hover fields to copy
Filing dates 8/1/2022 to: 1/31/2023
Comp dates 1/1/2023 to: 12/31/2023
Splits
BaseSalary,Salary,Number HousingAllowance,HousingAllowance,Number BenefitsCalcForBreakdown,BenefitsCalcForBreakdown,Number PensionCalcForBreakdown,PensionCalcForBreakdown,Number
Approval stages
Submitter,District
Report fields
People.FirstName,People.LastName,ClergyStatusAtTimeOfFiling,ServiceTimeAtTimeOfFiling,Church,ChurchDistrict,DateOfChargeConference,BaseSalary,SalaryBreakdown,Charges,District,BenefitsTitle,HealthInsurancePlan,DentalInsurancePlan,VisionInsurancePlan,TotalClergyPortionOfInsurancePremium,ClergyInsurancePortionChurchPaysAsAdditionalBenefit,PersonalExpensesPaidByCharge,TotalSalaryValue,TotalComp,HealthCareCompensation,HousingTitle,CompensationTags,HousingAllowance,PensionCalculationTitle,CRSP,CPP,UMPIP,PensionCalculationForGrandTotal,AccountableReimbursementTitle,ProfessionalExpensesReimbursed,BookExpenses,TravelReimbursement,EducationExpenses,AccountableReimbursement,UtilityExclusion,TotalCompensation,GrandTotal,SalaryBreakdown.Church.Name,SalaryBreakdown.Salary,SalaryBreakdown.HousingAllowance,SalaryBreakdown.BenefitsCalcForBreakdown,SalaryBreakdown.PensionCalcForBreakdown,SignaturePastor,SignatureDistrict,Submitted,FullyApproved,Approvals 
<View Id="CompJan2022" TableId="Content" Inherits="ClergyCompForm" Name="Compensation Form" Invisible="true"><Fields><FieldSet Id="FilingInfo"><Category Id="ClergyStatusAtTimeOfFiling" Required="true" /><Category Id="ServiceTimeAtTimeOfFiling" Required="true" /></FieldSet><FieldSet Id="SalaryInfo"><CustomField Id="BaseSalary" Required="true" /><Relationship Id="HealthInsurancePlan" /><Category Id="CompensationTags" Required="true" /><CustomField Id="AccountableReimbursement" /><CustomField Id="UtilityExclusion" Name="Parsonage Utilities paid by Charge" /></FieldSet></Fields><ListFields><Ref Id="AccountableReimbursement" /></ListFields></View>
Redirect to: https://www.wisconsinumc.org/peopleportal/compensation?lastperson=yes
Scripts
<script src="https://www.wisconsinumc.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,
div[data-fieldid="BenefitsCalcForBreakdown"],
div[data-fieldid="PensionCalcForBreakdown"]
{
    display:none;
}
</style>
<script>
    $(document).ready(function() {
        if ( window.location !== window.parent.location ) {
            $(".btn-large").hide();
        }
    });
</script>
Header
<style type="text/css">div[data-fieldId="PensionCalculationForGrandTotal"]{
display: none;
}
</style>
Formula
Visible
AccountableReimbursement
 
ProfessionalExpensesReimbursed + BookExpenses + TravelReimbursement + EducationExpenses
=ProfessionalExpensesOtherThanThoseExplicityListedBelowReimbursedToTheClergyPersonInExchangeForAReceiptOrVoucherForExampleAnnualConferenceExpenses +
BookAndPublicationExpensesReimbursedToTheClergyInExchangeForAReceiptOrVoucher +
TravelExpensesReimbursedToTheClergyPersonInExchangeForAReceiptOrVoucher +
EducationExpensesReimbursedToTheClergyPersonInExchangeForAReceiptOrVoucher
Formula
Visible
BenefitsCalcForBreakdown
 
//BenefitsCalcForBreakdown

ClergyInsurancePortionChurchPaysAsAdditionalBenefit + HealthCareCompensation
Show/Hide
Visible
BenefitsTitle
 
PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling) && PensionAbleServiceTimes.includes(ServiceTimeAtTimeOfFiling)
Formula
Visible
CPP
 
//CPP
if(PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling) && PensionAbleServiceTimes.includes(ServiceTimeAtTimeOfFiling)){ // eligible
	if(CompensationTags == 19939){ // with parsonage
		(TotalSalaryValue * 1.25) * 0.020
	} else { // without parsonage
		(TotalSalaryValue + HousingAllowance) * 0.020
	}
} else {
	0
}
Show/Hide
Visible
CPP
 
PensionAbleServiceTimes.includes(ServiceTimeAtTimeOfFiling)
&&
PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling)
Formula
Visible
CRSP
 
//CRSP
if(PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling) && PensionAbleServiceTimes.includes(ServiceTimeAtTimeOfFiling)){ // eligible
	if(CompensationTags == 19939){//with parsonage
		(TotalSalaryValue * 1.25) * 0.12
	} else { //without parsonage
		(TotalSalaryValue + HousingAllowance) * 0.12
	}
} else {
	0
}
Show/Hide
Visible
CRSP
 
PensionAbleServiceTimes.includes(ServiceTimeAtTimeOfFiling)
&&
PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling)
Show/Hide
Visible
DentalInsurancePlan
 
PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling) && PensionAbleServiceTimes.includes(ServiceTimeAtTimeOfFiling)
PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling) && PensionAbleServiceTimes.includes(ServiceTimeAtTimeOfFiling)
Validation
Visible
EducationExpenses
 
EducationExpenses >= 900
Formula
Visible
HealthCareCompensation
 
//HealthCareCompensation
if(PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling) && PensionAbleServiceTimes.includes(ServiceTimeAtTimeOfFiling)){
    //if eligible
	16020
} else {
    //if not eligible
	0
}
Show/Hide
Visible
HealthInsurancePlan
 
PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling) && PensionAbleServiceTimes.includes(ServiceTimeAtTimeOfFiling)
Show/Hide
Visible
HousingAllowance
 
CompensationTags == 19938
Constant
Visible
PensionAbleServiceTimes
 
[4957,4956]
Full time and 3/4
Constant
Visible
PensionAbleStatuses
 
[4928,4939,4921,4929,47683,4927,4938,4934,4935,4940]
An array of clergy statuses that allow them to have a pension
ELIGIBLE
[4928,4939,4921,4929,47683,4927,4938,4934,4935]

FE - 4928
PE - 4939
AM - 4921
FL - 4929
SP - 47683 (CUSTOM)
FD - 4927
PD - 4938
OE - 4934
OF - 4935
PL - 4940

NOT ELIGIBLE
[4946,4943,4944,4945,4942]

SY - 4946
RE - 4943
RL - 4944
RP - 4945
RD - 4942
 
Formula
Visible
PensionCalcForBreakdown
 
//PensionCalcForBreakdown

CRSP
+
CPP
+
UMPIP
Formula
Visible
PensionCalculationForGrandTotal
 
//PensionCalculationForGrandTotal

if (PensionAbleServiceTimes.includes(ServiceTimeAtTimeOfFiling)) { //full or 3/4 time
    let val1;
    if(PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling)){
		val1 = (TotalSalaryValue * 1.25) * 0.020
	} else {
		val1 = 0
	}
	if(CompensationTags == 19939){ //with parsonage
		CRSP + 
		val1
	} else { //without parsonage
		if(PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling)){			
			((TotalSalaryValue + HousingAllowance) * 0.12) + 
			((TotalSalaryValue + HousingAllowance) * 0.020)
		}
	}
} else { //1/2 or 1/4 time
	if(CompensationTags == 19939){ //with parsonage
		if(PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling)){
			(TotalSalaryValue * 1.25) * 0.06
		}
	} else { //without parsonage
		if(PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling)){
			((TotalSalaryValue + HousingAllowance) * 0.06)
		}
	}
}
Show/Hide
Visible
PensionCalculationTitle
 
PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling)
Formula
Visible
TotalClergyPortionOfInsurancePremium
 
//TotalClergyPortionOfInsurancePremium
getInsurance(HealthInsurancePlan, 'Price') + getInsurance(DentalInsurancePlan, 'Price') + getInsurance(VisionInsurancePlan, 'Price')
Formula
Visible
TotalCompensation
 
//TotalCompensation (GrandTotal)
TotalSalaryValue + 
HousingAllowance + 
PensionCalculationForGrandTotal + 
AccountableReimbursement + 
HealthCareCompensation + 
UtilityExclusion
Formula
Visible
TotalSalaryValue
 
BaseSalary+ClergyInsurancePortionChurchPaysAsAdditionalBenefit+PersonalExpensesPaidByCharge
Formula
Visible
UMPIP
 
//UMPIP
if(PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling) && !PensionAbleServiceTimes.includes(ServiceTimeAtTimeOfFiling)){ // eligible
	if(CompensationTags == 19939){//with parsonage
		(TotalSalaryValue * 1.25) * 0.06
	} else { //without parsonage
		(TotalSalaryValue + HousingAllowance) * 0.06
	}
} else {
	0
}
Show/Hide
Visible
UMPIP
 
PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling) && !PensionAbleServiceTimes.includes(ServiceTimeAtTimeOfFiling)
Show/Hide
Visible
VisionInsurancePlan
 
PensionAbleStatuses.includes(ClergyStatusAtTimeOfFiling) && PensionAbleServiceTimes.includes(ServiceTimeAtTimeOfFiling)