Comp 2022 Click green hover fields to copy
Filing dates 3/1/2022 to: 8/31/2022
Comp dates 7/1/2022 to: 12/31/2022
Splits
BaseSalary,BaseSalary,Number UtilityExclusion,UtilityExclusion,Number HousingAllowance,HousingAllowance,Number TotalSalaryValue,TotalSalaryValue,Number AccountableReimbursement,AccountableReimbursement,Number ChargeChurchPremiumForGroupHealthInsurance,ChargeChurchPremiumForGroupHealthInsurance,Number ChargeChurchPremiumForGroupHealthInsuranceOF,ChargeChurchPremiumForGroupHealthInsuranceOF,Number CRSPCostToChurch,CRSPCostToChurch,Number CRSPCostToChurchOF,CRSPCostToChurchOF,Number CPPCostToChurch,CPPCostToChurch,Number CPPCostToChurchOF,CPPCostToChurchOF,Number ChurchContributionToUMPIP,ChurchContributionToUMPIP,Number ChurchContributionToUMPIPOF,ChurchContributionToUMPIPOF,Number ChurchContributionToUMLifeOption,ChurchContributionToUMLifeOption,Number
Approval stages
Pastor, Local Church Rep, District
Report fields
ConferenceServing,People.FirstName,People.LastName,ClergyStatusAtTimeOfFiling,ServiceTimeAtTimeOfFiling,DateOfChargeConference,PubDate,SalarySourceConference,BaseSalary,UtilityExclusion,TotalCashSalary,CompensationTags,HousingAllowance,ParsonageFairValue,TotalSalaryValue,PlanCompensation,CRSPDC,CRSPDB,CRSPCostToChurch,CRSPCostToChurchOF,CPPCostToChurch,CPPCostToChurchOF,ChargeChurchPremiumForGroupHealthInsurance,ChargeChurchPremiumForGroupHealthInsuranceOF,ChurchContributionToUMPIP,ChurchContributionToUMPIPOF,ChurchContributionToUMLifeOption,OptionalBenefitsAmount,TotalBenefitCosts,AccountableReimbursement,TotalCostForTotalAppointmentTime,Notes,SignatureDistrict,SignaturePastor,SignatureLocalChurchRep,Church.Name,Charges.Name,SalarySourceConference 
<View Id="Comp2022" TableId="Content" Inherits="ClergyCompForm"><Fields><Category Id="Category" Default="Comp2022" Invisible="true" /></Fields></View>
Redirect to: https://gnw-gnw.brtsite.com/peopleportal/compensation
Scripts
<script src="https://gnw-gnw.brtsite.com/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,
	fieldset[data-id="Pips"] legend,
	fieldset[data-id="Insurance"] legend,
	div[data-fieldid="PlaceholderServiceTime"],
	/*div[data-fieldid="PlanCompensation"],*/
	div[data-fieldid="CompCheckAgainstMinimum"],
	div[data-fieldid="MinimumCashComp"],
	div[data-fieldid="MinimumAchieved"],
	div[data-fieldid="ServiceTimeAtTimeOfFiling"] li[data-value="23553"],
	div[data-fieldid="ServiceTimeAtTimeOfFiling"] li[data-value="19746"],
	div[data-fieldid="ConferenceServing"] li[data-value="44441"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="4920"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="23548"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="4922"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="4923"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="4924"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="43931"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="4925"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="4926"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="17738"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="17739"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="4930"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="4931"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="17740"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="4944"],
	div[data-fieldid="SalarySourceConference"] li[data-value="44441"]
	{
		display:none;
	} 
	div[data-fieldid="MinimumCashComp"] .input-block-level,
	div[data-fieldid="PlanCompensation"] .input-block-level,
	div[data-fieldid="TotalSalaryValue"] .input-block-level,
	div[data-fieldid="TotalCashSalary"] .input-block-level,
	div[data-fieldid="TotalCashCompensation"] .input-block-level,
	div[data-fieldid="CRSPDB"] .input-block-level,
	div[data-fieldid="CRSPDC"] .input-block-level,
	div[data-fieldid="CPPCostToChurch"] .input-block-level,
	div[data-fieldid="CRSPCostToChurch"] .input-block-level,
	div[data-fieldid="ChargeChurchPremiumForGroupHealthInsurance"] .input-block-level,
	div[data-fieldid="ChurchContributionToUMPIP"] .input-block-level,
	div[data-fieldid="ChurchContributionToUMLifeOption"] .input-block-level,
	div[data-fieldid="TotalBenefitCosts"] .input-block-level,
	div[data-fieldid="TotalCostForTotalAppointmentTime"] .input-block-level
	{
	    border-color: transparent;
	}
	div[data-fieldid="CRSPDC"],
	div[data-fieldid="CRSPDB"] {
	    display: flex;
        align-items: center;
        margin-top: -20px;
	}
	div[data-fieldid="CRSPDC"] .controls input,
	div[data-fieldid="CRSPDB"] .controls input {
	    margin-bottom: 5px;
	}
	div[data-fieldid="CRSPDC"] .control-label,
	div[data-fieldid="CRSPDC"] .controls input,
	div[data-fieldid="CRSPDB"] .control-label,
	div[data-fieldid="CRSPDB"] .controls input {
	    font-size: 12px;
	}
</style>
Show/Hide
Invisible
AfterTaxPip
 
AfterTaxPipPercent == 32762
Constant
Invisible
AllStatuses

4920 - AF - AFFIL MEMB (AF)
23548 - AL - ADMINISTRATIVE LOCATION (AL)
4921 - AM - ASSOC MEMB (AM)
4922 - BH - BISHOP (BH)
4923 - CC - CERTIFIED CANDIDATE (CC)
4924 - DC - DEACONESS (DC)
43931 - DC* - DEACONESS retired (DC)
4925 - DM - DIACONAL MIN (DM)
4926 - DR - RETIRED DIACONAL MINISTER (DR)
4927 - FD - DEACON IN FULL CONN (FD)
4928 - FE - ELDER IN FULL CONN (FE)
4929 - FL - FULL TIME LOCAL PASTOR (FL)
17738 - HL - HONORABLE LOCATION (HL)
17739 - HR - HONORABLE LOCATION RETIRED (HR)
4930 - LM - CERTIFIED LAY MINISTER (LM)
35212 - LM* - CERTIFIED LAY MINISTER-serving (LM)
17740 - NC - NO LONGER CLERGY (NC)
4931 - NL - LOCAL PASTOR (APPROVED, BUT NOT APPOINTED) (NL)
4932 - OA - ASSOC OTHER CONFERENCE (OA)
4933 - OD - DEACON MEMBER OF OTHER CONFERENCE OR METHODIST DENOMINATION (OD)
4934 - OE - ELDER MEMBER OF OTHER CONFERENCE OR METHODIST DENOMINATION (OE)
4935 - OF - OTHER NON-METHODIST DENOMINATION (OF)
4936 - OP - PM SERVING OTHER CONFER (OP)
4937 - OR - RETIRED MEMBER OTHER CONFERENCE (OR)
4938 - PD - PROVISIONAL DEACON (PD)
4939 - PE - PROVISIONAL ELDER (PE)
4940 - PL - PART TIME LOCAL PASTOR (PL)
4941 - RA - RETIRED ASSOC MEMBER (AM) (RA)
4942 - RD - RETIRED DEACON INFULL CONNECTION (RD)
4943 - RE - RETIRED ELDER (RE)
4944 - RL - RETIRED LOCAL PASTOR (LP) (RL)
20369 - RL* - RETIRED LOCAL PASTOR -serving (RL)
4945 - RP - RETIRED PROVISIONAL MEMBER (PM) (RP)
4946 - SY - SUPPLIED/HIRED/ASSIGNED (SY)
 
Show/Hide
Invisible
BenefitsInfo
 
//TotalBenefitCosts

let statusesOH  = [ 4928 , 4939 , 4927 , 4938 , 4934 , 4936 , 4933 , 4929 , 4940 , 4921 , 4941 , 4943 , 4942 , 20369 , 4937 ];
let statusesAK  = [ 4928 , 4939 , 4927 , 4938 , 4934 , 4936 , 4933 , 4929 , 4940 , 4921 , 4941 , 4943 , 4942 , 20369 , 4937 , 35212 , 4946 ];
let statusesPNW = [ 4928 , 4939 , 4927 , 4938 , 4934 , 4936 , 4933 , 4929 , 4940 , 4921 , 4941 , 4943 , 4942 , 20369 , 4937 , 35212 , 4946 ];

(
    ConferenceServing == 44312 && [4957, 4956].includes(ServiceTimeAtTimeOfFiling)
    &&
    (
        (statusesOH.includes(ClergyStatusAtTimeOfFiling))
        ||
        (ClergyStatusAtTimeOfFiling == 4935 && !NeedGroupHealthInsurance)
    )
)
||
(
    ConferenceServing == 44310 && ServiceTimeAtTimeOfFiling == 4957
    &&
    (
        (statusesAK.includes(ClergyStatusAtTimeOfFiling))
        ||
        (ClergyStatusAtTimeOfFiling == 4935 && !NeedGroupHealthInsurance)
    )
)
||
(
    ConferenceServing == 44311 && ServiceTimeAtTimeOfFiling == 4957
    &&
    (
        (statusesPNW.includes(ClergyStatusAtTimeOfFiling))
        ||
        (ClergyStatusAtTimeOfFiling == 4935 && !NeedGroupHealthInsurance)
    )
)
Show/Hide
Invisible
ChargeChurchAmountInfo
 
NeedGroupHealthInsurance && ClergyStatusAtTimeOfFiling == 4935 && ConferenceServing == 44312
Show/Hide
Visible
ChargeChurchPremiumForGroupHealthInsurance
 
let statuses;
let serviceTime;
let confs = [44312,44311,44310];

if(ConferenceServing == 44312){ //Oregon
    statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921,4941,4943,4942,20369,4937];
    serviceTime = [4957,4956,50684];
} else if(ConferenceServing == 44311 || ConferenceServing == 44310){ //PNW or AK
    statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921,4941,4943,4942,20369,4937,35212,4946];
    serviceTime = [4957];
}

(confs.includes(ConferenceServing) && serviceTime.includes(ServiceTimeAtTimeOfFiling) && statuses.includes(ClergyStatusAtTimeOfFiling)) ||
(NeedGroupHealthInsurance && ClergyStatusAtTimeOfFiling == 4935)
let statuses;
let serviceTime;
let confs = [44312,44311,44310];

if(ConferenceServing == 44312){ //Oregon
    statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921,4941,4943,4942,20369,4937];
    serviceTime = [4957,4956,50684];
} else if(ConferenceServing == 44311 || ConferenceServing == 44310){ //PNW or AK
    statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921,4941,4943,4942,20369,4937,35212,4946];
    serviceTime = [4957];
}

confs.includes(ConferenceServing) && serviceTime.includes(ServiceTimeAtTimeOfFiling) && statuses.includes(ClergyStatusAtTimeOfFiling)
Formula
Visible
ChargeChurchPremiumForGroupHealthInsurance
 
//ChargeChurchPremiumForGroupHealthInsurance

let statusesOH  = [ 4928 , 4939 , 4927 , 4938 , 4934 , 4936 , 4933 , 4929 , 4940 , 4921 , 4941 , 4943 , 4942 , 20369 , 4937 ];
let statusesAK  = [ 4928 , 4939 , 4927 , 4938 , 4934 , 4936 , 4933 , 4929 , 4940 , 4921 , 4941 , 4943 , 4942 , 20369 , 4937 , 35212 , 4946 ];
let statusesPNW = [ 4928 , 4939 , 4927 , 4938 , 4934 , 4936 , 4933 , 4929 , 4940 , 4921 , 4941 , 4943 , 4942 , 20369 , 4937 , 35212 , 4946 ];

if(ConferenceServing == 44312 && [4957,4956,50684].includes(ServiceTimeAtTimeOfFiling)){ //OR at 3/4 or full time
    if(
        (statusesOH.includes(ClergyStatusAtTimeOfFiling))
        ||
        (ClergyStatusAtTimeOfFiling == 4935 && !NeedGroupHealthInsurance)
    ){
        14400
    }
} else if(ConferenceServing == 44310 && ServiceTimeAtTimeOfFiling == 4957){ //AK at full time
    if(
        (statusesAK.includes(ClergyStatusAtTimeOfFiling))
        ||
        (ClergyStatusAtTimeOfFiling == 4935 && NeedGroupHealthInsurance)
    ){
        17004
    }
} else if(ConferenceServing == 44311 && ServiceTimeAtTimeOfFiling == 4957){ //PNW at full time
    if(
        (statusesPNW.includes(ClergyStatusAtTimeOfFiling))
        ||
        (ClergyStatusAtTimeOfFiling == 4935 && !NeedGroupHealthInsurance)
    ){
        9000
    }
} else {
    0
}
Show/Hide
Visible
ChargeChurchPremiumForGroupHealthInsuranceOF
 
//ChargeChurchPremiumForGroupHealthInsuranceOF

let statuses;
let serviceTime;
let confs = [44312,44311,44310];

if(ConferenceServing == 44312){ //Oregon
    statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921,4941,4943,4942,20369,4937];
    serviceTime = [4957,4956,50684];
} else if(ConferenceServing == 44311 || ConferenceServing == 44310){ //PNW or AK
    statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921,4941,4943,4942,20369,4937,35212,4946];
    serviceTime = [4957];
}

confs.includes(ConferenceServing) &&
serviceTime.includes(ServiceTimeAtTimeOfFiling) &&
ClergyStatusAtTimeOfFiling == 4935 &&
!NeedGroupHealthInsurance
//ChargeChurchPremiumForGroupHealthInsuranceOF

let statuses;
let serviceTime;
let confs = [44312,44311,44310];

if(ConferenceServing == 44312){ //Oregon
    statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921,4941,4943,4942,20369,4937];
    serviceTime = [4957,4956,50684];
} else if(ConferenceServing == 44311 || ConferenceServing == 44310){ //PNW or AK
    statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921,4941,4943,4942,20369,4937,35212,4946];
    serviceTime = [4957];
}

confs.includes(ConferenceServing) && 
serviceTime.includes(ServiceTimeAtTimeOfFiling) && 
ClergyStatusAtTimeOfFiling == 4935 && 
!NeedGroupHealthInsurance
Show/Hide
Visible
ChurchContributionToUMLifeOption
 
let statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921]; // does not include OF
let halfUp = [4955,50824,4956,50684]; // 1/2, 0.6, 3/4, 0.8

(
    ConferenceServing == 44311 &&
    (
        ([35212,4946].includes(ClergyStatusAtTimeOfFiling) && ServiceTimeAtTimeOfFiling ==4957) //LM* and SY at full time
        ||
        (statuses.includes(ClergyStatusAtTimeOfFiling) && halfUp.includes(ServiceTimeAtTimeOfFiling)) // statuses at 1/2, 0.6, 3/4, 0.8 service time
    )
)
||
(
    ConferenceServing == 44310 && statuses.includes(ClergyStatusAtTimeOfFiling) && halfUp.includes(ServiceTimeAtTimeOfFiling)
)
Formula
Visible
ChurchContributionToUMLifeOption
 
//ChurchContributionToUMLifeOption

let statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921]; // does not include OF
let halfUp = [4955,50824,4956,50684]; // 1/2, 0.6, 3/4, 0.8

if(
    (
        ConferenceServing == 44311 &&
        (
            ([35212,4946].includes(ClergyStatusAtTimeOfFiling) && ServiceTimeAtTimeOfFiling ==4957) //LM* and SY at full time
            ||
            (statuses.includes(ClergyStatusAtTimeOfFiling) && halfUp.includes(ServiceTimeAtTimeOfFiling)) // statuses at 1/2, 0.6, 3/4, 0.8 service time
        )
    )
    ||
    (
        ConferenceServing == 44310 && statuses.includes(ClergyStatusAtTimeOfFiling) && halfUp.includes(ServiceTimeAtTimeOfFiling)
    )
){
    PlanCompensation * 0.022
}
Show/Hide
Visible
ChurchContributionToUMPIP
 
//ChurchContributionToUMPIP

let statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921]; // does not include OF


ConferenceServing == 44311 &&
(
    //OF not full time who does not need coverage
    (ClergyStatusAtTimeOfFiling == 4935 && ServiceTimeAtTimeOfFiling != 4957 && OFNeedUMPIP) 
    ||
    //several statuses less than full time
    (statuses.includes(ClergyStatusAtTimeOfFiling) && ServiceTimeAtTimeOfFiling != 4957) 
    ||
    //LM* or SY at full time
    ((ClergyStatusAtTimeOfFiling == 35212 || ClergyStatusAtTimeOfFiling == 4946) && ServiceTimeAtTimeOfFiling == 4957) 
)
Formula
Visible
ChurchContributionToUMPIP
 
//ChurchContributionToUMPIP

let match = PlanCompensation * (UMPIPPercentage / 100);
if(match >= (PlanCompensation * 0.02)){
    match = PlanCompensation * 0.02;
}

let statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921]; // does not include OF
let halfUp = [4955,50824,4956,50684]; // 1/2, 0.6, 3/4, 0.8
let halfDown = [50688,4954,50687,50685]; // 0.2, 1/4, 1/3, 0.4

if(ConferenceServing == 44311){
    if(
        ([35212,4946].includes(ClergyStatusAtTimeOfFiling) && ServiceTimeAtTimeOfFiling == 4957) //LM* and SY at full time
        ||
        (statuses.includes(ClergyStatusAtTimeOfFiling) && halfUp.includes(ServiceTimeAtTimeOfFiling)) // statuses at 1/2, 0.6, 3/4, 0.8 service time
        || 
        (ClergyStatusAtTimeOfFiling == 4935 && halfUp.includes(ServiceTimeAtTimeOfFiling) && OFNeedUMPIP) // OF needs UMPIP coverage - 0.5, 0.6, 0.75, 0.8 service time
    ){
        if(UMPIPForMatch){
            (PlanCompensation * 0.08) + match
        } else {
            PlanCompensation * 0.08
        }
    } else if (
        (statuses.includes(ClergyStatusAtTimeOfFiling) && halfDown.includes(ServiceTimeAtTimeOfFiling)) // statuses at 0.2, 1/4, 1/3, 0.4 service time
        ||
        (ClergyStatusAtTimeOfFiling == 4935 && OFNeedUMPIP && halfDown.includes(ServiceTimeAtTimeOfFiling)) // OF not waived UMPIP coverage - 0.2, 1/4, 1/3, 0.4 service time
    ) {
       if(UMPIPForMatch){
            (PlanCompensation * 0.06) + match
        } else {
            PlanCompensation * 0.06
        } 
    }
} else {
    0
}
edited on 220510 
(ServiceTimeAtTimeOfFiling == 4956 || ServiceTimeAtTimeOfFiling == 4955) //1/2 and 3/4

[35212,4946].includes(ClergyStatusAtTimeOfFiling) //LM* and SY

ServiceTimeAtTimeOfFiling ==4957 //full time

Statuses
4921,4928,4927,4939,4938,4934,4936,4933,4929,4940
AM, FE, FD, PE, PD, OE, OP, OD, FL, PL

4935 = OF

Times
4955,50824,4956,50684
1/2, 0.6, 3/4, 0.8

50688,4954,50687,50685
0.2, 1/4, 1/3, 0.4

NOT WAIVED: OFNeedUMPIP = true
Show/Hide
Visible
ChurchContributionToUMPIPOF
 
ConferenceServing == 44311 && ClergyStatusAtTimeOfFiling == 4935 && ServiceTimeAtTimeOfFiling != 4957 && !OFNeedUMPIP
Validation
Visible
CompCheckAgainstMinimum
 
if(ConferenceServing == 44310 || ConferenceServing == 44311){
    // AK or PNW
    CompCheckAgainstMinimum <= TotalCashSalary
} else {
    CompCheckAgainstMinimum <= MinimumCashComp
}
Edited on 8/23/22, originally formula was simply
CompCheckAgainstMinimum >= MinimumCashComp
(which it seems that it was the opposite of what it needed to be)
Formula
Visible
CompCheckAgainstMinimum
 
//CompCheckAgainstMinimum

let checkAmt;

if(ConferenceServing == 44312){ //Oregon
    checkAmt = BaseSalary + UtilityExclusion + HousingAllowance;
} else if(ConferenceServing == 44311 || ConferenceServing == 44310){ //PNW or AK
    checkAmt = BaseSalary + UtilityExclusion;
}
Show/Hide
Visible
CompensationTags
 
ClergyStatusAtTimeOfFiling != 35212 //LM*
&&
ClergyStatusAtTimeOfFiling != 4946 //SY


//&& PensionAbleServiceTimes.includes(ServiceTimeAtTimeOfFiling)
Corrected on 220510
All statuses except LM* and SY, at any service time
Formula
Visible
CPPCostToChurch
 
//CPPCostToChurch

let statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921];
let serviceTime;
let thisAmt = PlanCompensation * 0.03;

if(thisAmt >= 4534.20){
   thisAmt = 4534.20;
}


if(ConferenceServing == 44312 || ConferenceServing == 44310){ //Oregon or Alaska
    serviceTime = [4956,50684,4957]; //3/4 and above
} else { //PNW and others
    serviceTime = [4957]; //only full time
}

if(serviceTime.includes(ServiceTimeAtTimeOfFiling)){
    if(statuses.includes(ClergyStatusAtTimeOfFiling) || (NeedCPP && ClergyStatusAtTimeOfFiling == 4935)){
        if(ConferenceServing == 44312){ //Oregon
            PlanCompensation * 0.03
        } else if(ConferenceServing == 44311 || ConferenceServing == 44310){ //PNW or AK
            thisAmt
        }
    }
}
FE, PE, FD, PD, OE, OP, OD, FL, PL, AM (not LM*/SY and not retired statuses)
Housing/parsonage already accounted for in the PlanCompensation calculation.
Show/Hide
Visible
CPPCostToChurch
 
//CPPCostToChurch

let statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921];
let serviceTime;

if(ConferenceServing == 44312){ //Oregon
    serviceTime = [4956,50684,4957]; //3/4 and above
} else {
    serviceTime = [4957]; //only full time
}

(serviceTime.includes(ServiceTimeAtTimeOfFiling) && statuses.includes(ClergyStatusAtTimeOfFiling))
||
(NeedCPP && ClergyStatusAtTimeOfFiling == 4935)
Show/Hide
Visible
CPPCostToChurchOF
 
//CPPCostToChurchOF

let statuses;
let serviceTime;

if(ConferenceServing == 44312){ //Oregon
    statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921,4941,4943,4942,20369,4937];
    serviceTime = [4957,4956,50684];
} else if(ConferenceServing == 44311 || ConferenceServing == 44310){ //PNW or AK
    statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921,4941,4943,4942,20369,4937,35212,4946];
    serviceTime = [4957];
}

serviceTime.includes(ServiceTimeAtTimeOfFiling) &&
ClergyStatusAtTimeOfFiling == 4935 &&
!NeedCPP
Formula
Visible
CRSPCostToChurch
 
//CRSPCostToChurch

let statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921];
let eligibleStatus = false;

if((statuses.includes(ClergyStatusAtTimeOfFiling)) || (ClergyStatusAtTimeOfFiling == 4935 && NeedCRSP)){
    eligibleStatus = true;
}

if(eligibleStatus){
    if(ConferenceServing == 44312 && [50686,4955,4956,50684,4957].includes(ServiceTimeAtTimeOfFiling)){ //OR at 1/2 or above
        PlanCompensation * 0.13
    } else if(ConferenceServing == 44310 && [50686,4955,4956,50684,4957].includes(ServiceTimeAtTimeOfFiling)){ //AK at 1/2 or above
        PlanCompensation * 0.03
    } else if(ConferenceServing == 44311 && ServiceTimeAtTimeOfFiling == 4957){ //PNW at full time
        (PlanCompensation * 0.03) + 5700
    }
} else {
    0
}


/*
let serviceTime;

if(ConferenceServing == 44312 || ConferenceServing == 44310){ //Oregon or Alaska
    serviceTime = [50686,4955,4956,50684,4957]; //1/2 and above
} else { //PNW and others
    serviceTime = [4957]; //only full time
}

if(serviceTime.includes(ServiceTimeAtTimeOfFiling)){
    if(statuses.includes(ClergyStatusAtTimeOfFiling) || (NeedCRSP && ClergyStatusAtTimeOfFiling == 4935)){
        if(ConferenceServing == 44312){ //Oregon
            PlanCompensation * 0.13
        } else if(ConferenceServing == 44311){ //PNW
            (PlanCompensation * 0.03) + 5700
        } else if(ConferenceServing == 44310) { //AK
            PlanCompensation * 0.03
        }
    }
}
*/

FE, PE, FD, PD, OE, OP, OD, FL, PL, AM (not LM*/SY and not retired statuses)

Housing/parsonage already accounted for in the PlanCompensation calculation. 
if(serviceTime.includes(ServiceTimeAtTimeOfFiling) && statuses.includes(ClergyStatusAtTimeOfFiling)){
    if(ConferenceServing == 44312){ //Oregon
        PlanCompensation * 0.13
    } else if(ConferenceServing == 44311){ //PNW
        (PlanCompensation * 0.03) + 5700
    } else if(ConferenceServing == 44310) { //AK
        PlanCompensation * 0.03
    }
}

  1. CRSP (calculated as percentage of plan compensation)

    1. Plan compensation (dependent on housing tag)

      1. With parsonage, plan compensation = Total Salary (3.f.) * 1.25

      2. With housing allowance, plan compensation = Total Salary (3.f.)

    2. Oregon-Idaho

      1. applies to ½ time to full-time appointments (does not apply to ¼ time)

      2. applies to FE, PE, FD, PD, OE, OP, OD, FL, PL, AM (not LM*/SY and not retired statuses)

      3. AND applies to OF (other non-Methodist denomination) unless they waive coverage because they are enrolled in another plan through their denomination.

        1. if so, need to ask amount of that other plan which will be billed to the church/charge

      4. amount = Plan Compensation X 0.13

    3. PNW  

      1. applies only to full-time appointments

      2. applies to FE, PE, FD, PD, OE, OP, OD, FL, PL, AM (not LM*/SY and not retired statuses)

      3. AND applies to OF (other non-Methodist denomination) unless they waive coverage because they are enrolled in another plan through their denomination.

        1. if so, need to ask amount of that other plan which will be billed to the church/charge

      4. amount = (Plan compensation x 0.03) + $5,700

    4. Alaska 

      1. applies to ½ time to full-time appointments

      2. applies to FE, PE, FD, PD, OE, OP, OD, FL, PL, AM (not LM*/SY and not retired statuses)

      3. AND applies to OF (other non-Methodist denomination) unless they waive coverage because they are enrolled in another plan through their denomination.

        1. if so, need to ask amount of that other plan which will be billed to the church/charge

      4. amount = Plan compensation X 0.03
Show/Hide
Visible
CRSPCostToChurch
 
let statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921];
let serviceTime;

if(ConferenceServing == 44312 || ConferenceServing == 44310){ //Oregon or Alaska
    serviceTime = [50686,4955,4956,50684,4957]; //1/2 and above
} else {
    serviceTime = [4957]; //only full time
}

(serviceTime.includes(ServiceTimeAtTimeOfFiling) && statuses.includes(ClergyStatusAtTimeOfFiling))
||
(NeedCRSP && ClergyStatusAtTimeOfFiling == 4935)


/*
//===================

//POSSIBLE SOLUTION IN CASE ABOVE IS WRONG

(([4928,4939,4927,4938,4934,4936,4933,4929,4940,4921].includes(ClergyStatusAtTimeOfFiling)) || (ClergyStatusAtTimeOfFiling == 4935 && !NeedCRSP))
&&
(
    (ConferenceServing == 44312 && [50686,4955,4956,50684,4957].includes(ServiceTimeAtTimeOfFiling))
    ||
    (ConferenceServing == 44310 && ServiceTimeAtTimeOfFiling == 4957)
    ||
    (ConferenceServing == 44311 && ServiceTimeAtTimeOfFiling == 4957)
)
*/
Show/Hide
Visible
CRSPCostToChurchOF
 
//CRSPCostToChurchOF

let statuses;
let serviceTime;

if(ConferenceServing == 44312){ //Oregon
    statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921,4941,4943,4942,20369,4937];
    serviceTime = [50686,4955,4956,50684,4957]; //1/2 and above
} else if(ConferenceServing == 44311 || ConferenceServing == 44310){ //PNW or AK
    statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921,4941,4943,4942,20369,4937,35212,4946];
    serviceTime = [4957];
}

serviceTime.includes(ServiceTimeAtTimeOfFiling) &&
ClergyStatusAtTimeOfFiling == 4935 &&
!NeedCRSP
Formula
Visible
CRSPDB
 
if(ConferenceServing == 44310){
    0
} else if(ConferenceServing == 44311) {
    5700
}
Show/Hide
Visible
CRSPDB
 
let statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921];
let serviceTime;

if(ConferenceServing == 44312 || ConferenceServing == 44310){ //Oregon or Alaska
    serviceTime = [50686,4955,4956,50684,4957]; //1/2 and above
} else {
    serviceTime = [4957]; //only full time
}

(ConferenceServing == 44310 || ConferenceServing == 44311) && ( // not Oregon
    (serviceTime.includes(ServiceTimeAtTimeOfFiling) && statuses.includes(ClergyStatusAtTimeOfFiling))
    ||
    (NeedCRSP && ClergyStatusAtTimeOfFiling == 4935)
)
Edited on 8/23, originally was
(ConferenceServing == 44310 || ConferenceServing == 44311) && ServiceTimeAtTimeOfFiling == 4957
Show/Hide
Visible
CRSPDC
 
let statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921];
let serviceTime;

if(ConferenceServing == 44312 || ConferenceServing == 44310){ //Oregon or Alaska
    serviceTime = [50686,4955,4956,50684,4957]; //1/2 and above
} else {
    serviceTime = [4957]; //only full time
}
(ConferenceServing == 44310 || ConferenceServing == 44311) && ( // not Oregon
    (serviceTime.includes(ServiceTimeAtTimeOfFiling) && statuses.includes(ClergyStatusAtTimeOfFiling))
    ||
    (NeedCRSP && ClergyStatusAtTimeOfFiling == 4935)
)
Edited on 8/23, originally was
(ConferenceServing == 44310 || ConferenceServing == 44311) && ServiceTimeAtTimeOfFiling == 4957
Formula
Visible
CRSPDC
 
//CRSPDC

PlanCompensation * 0.03
Show/Hide
Visible
GeographicalAreas
 
ConferenceServing == 44310
Show/Hide
Visible
HousingAllowance
 
CompensationTags == 19938 && ClergyStatusAtTimeOfFiling != 35212 && ClergyStatusAtTimeOfFiling != 4946
Show/Hide
Visible
HousingInfo
 
CompensationTags == 49928
Show/Hide
Visible
HousingTags
 
ClergyStatusAtTimeOfFiling != 35212 && ClergyStatusAtTimeOfFiling != 4946
Formula
Visible
MinimumCashComp
 
//MinimumCashComp

let statuses = [4941,4943,4942,20369,4937,4946,35212];
let multiplier;

switch(GeographicalAreas){
    case 50769: //anchorage
        multiplier = 0;
        break;
        
    case 50770: //Fairbanks
        multiplier = 6;
        break;
        
    case 50771: //Juneau
        multiplier = 13;
        break;
        
    case 50772: //Girdwood
        multiplier = 8;
        break;
        
    case 50773: //Kenai Peninsula
        multiplier = 16;
        break;
        
    case 50774: //Homer
        multiplier = 15;
        break;
        
    case 50775: //Ketchikan
        multiplier = 9;
        break;
        
    case 50776: //Nome
        multiplier = 46;
        break;
        
    case 50777: //Sitka
        multiplier = 9;
        break;
        
    case 50778: //Unalaska
        multiplier = 68;
        break;
        
    case 50779: //Wasilla
        multiplier = 3;
        break;
        
    case 50780: //Willow
        multiplier = 12;
        break;
        
    default: //no answer
        multiplier = 0;
        break;
}



if(ConferenceServing == 44312){ //Oregon
    if([4928,4927,4921,4934,4935,4932,4933].includes(ClergyStatusAtTimeOfFiling)){
        //Elders and Deacons in full connection / associate members
        if(CompensationTags == 19938){
            //housing allowance
            60592 * PlaceholderServiceTime
        } else {
            // anything other than housing allowance
            43880 * PlaceholderServiceTime
        }
    } else if ([4938,4939,4936].includes(ClergyStatusAtTimeOfFiling)){
        //Provisional Elders and Deacons
        if(CompensationTags == 19938){
            //housing allowance
            57563 * PlaceholderServiceTime
        } else {
            // anything other than housing allowance
            41686 * PlaceholderServiceTime
        }
    } else if ([4929,4940].includes(ClergyStatusAtTimeOfFiling)){
        //Local Pastors 
        if(CompensationTags == 19938){
            //housing allowance
            54685 * PlaceholderServiceTime
        } else {
            // anything other than housing allowance
            39602 * PlaceholderServiceTime
        }
    } else {
        0
    }
} else if(ConferenceServing == 44311 && !statuses.includes(ClergyStatusAtTimeOfFiling)){ //PNW
    //For all clergy statuses except retired and CLM/SY = $44,010
    44010 * PlaceholderServiceTime
} else if(ConferenceServing == 44310 && !statuses.includes(ClergyStatusAtTimeOfFiling)) {//AK
    //For all clergy statuses except retired and CLM/SY =  $45,500 + $200 per year 
    //lapsed service year since date of initial appointment as a pastor + Area-Cost-of-Living 
    //Adjustment Percentage
    ((45500 + (200*YearsInAppointments)) + ((45500 + (200*YearsInAppointments)) * (multiplier / 100))) * PlaceholderServiceTime
} else {
    0
}
4927 - FD
4928 - FE
4921 - AM

4938 - PD
4939 - PE

4929 - FL

============

15030 - OR
15029 - PNW
15065 - Alaska

============

        //if(ConferenceServing == 15030){
        //    Oregon-Idaho
        //    BaseSalary + UtilityExclusion
        //}
Show/Hide
Visible
MinimumCashComp
 
//MinimumCashComp

let statuses = [4941,4943,4942,20369,4937,4946,35212];

(ConferenceServing == 44312 && [4928,4927,4921,4934,4935,4932,4933,4938,4939,4936,4929,4940].includes(ClergyStatusAtTimeOfFiling))
||
(ConferenceServing == 44311 && !statuses.includes(ClergyStatusAtTimeOfFiling))
||
(ConferenceServing == 44310 && !statuses.includes(ClergyStatusAtTimeOfFiling))
Show/Hide
Invisible
MinimumNotAchieved
 
//MinimumNotAchieved

CompCheckAgainstMinimum > MinimumCashComp
Show/Hide
Visible
NeedCPP
 
ClergyStatusAtTimeOfFiling == 4935 && 
(
    (ConferenceServing == 44312 && PensionAbleServiceTimes.includes(ServiceTimeAtTimeOfFiling)) 
    || 
    ((ConferenceServing == 44311 || ConferenceServing == 44310) && ServiceTimeAtTimeOfFiling == 4957)    
)
Show/Hide
Visible
NeedCRSP
 
ClergyStatusAtTimeOfFiling == 4935 && 
(
    (ConferenceServing == 44312 && [50686,50684,50824,4955,4956,4957].includes(ServiceTimeAtTimeOfFiling)) //OR
    || 
    (ConferenceServing == 44311 && ServiceTimeAtTimeOfFiling == 4957) // PNW
    ||
    (ConferenceServing == 44310 && [50686,50684,50824,4955,4956,4957].includes(ServiceTimeAtTimeOfFiling)) //AK
)
Show/Hide
Visible
NeedGroupHealthInsurance
 
ClergyStatusAtTimeOfFiling == 4935 && 
(
    (ConferenceServing == 44312 && PensionAbleServiceTimes.includes(ServiceTimeAtTimeOfFiling)) 
    || 
    ((ConferenceServing == 44311 || ConferenceServing == 44310) && ServiceTimeAtTimeOfFiling == 4957)    
)
Show/Hide
Visible
OFNeedUMPIP
 
//OFNeedUMPIP

ConferenceServing == 44311 && ServiceTimeAtTimeOfFiling != 4957 && ClergyStatusAtTimeOfFiling == 4935
Show/Hide
Visible
OptionalBenefits
 
ConferenceServing == 44312
Show/Hide
Visible
OptionalBenefitsAmount
 
ConferenceServing == 44312 && OptionalBenefits
Show/Hide
Visible
OptionalBenefitsType
 
ConferenceServing == 44312 && OptionalBenefits
Show/Hide
Visible
ParsonageFairValue
 
CompensationTags == 19939 && ConferenceServing == 44312
Constant
Visible
PensionAbleServiceTimes
 
[4957,4956,50684]
3/4 and above
Constant
Visible
PensionAbleStatuses
 
[4928,4939,4921,4929,47683,4927,4938,4934,4935]
COPIED FROM WI, DOUBLE CHECK WITH LINDA
4928 - FE
4939 - PE
4921 - AM
4929 - FL


4920 - AF - AFFIL MEMB (AF)
23548 - AL - ADMINISTRATIVE LOCATION (AL)
4921 - AM - ASSOC MEMB (AM)
4922 - BH - BISHOP (BH)
4923 - CC - CERTIFIED CANDIDATE (CC)
4924 - DC - DEACONESS (DC)
43931 - DC* - DEACONESS retired (DC)
4925 - DM - DIACONAL MIN (DM)
4926 - DR - RETIRED DIACONAL MINISTER (DR)
4927 - FD - DEACON IN FULL CONN (FD)
4928 - FE - ELDER IN FULL CONN (FE)
4929 - FL - FULL TIME LOCAL PASTOR (FL)
17738 - HL - HONORABLE LOCATION (HL)
17739 - HR - HONORABLE LOCATION RETIRED (HR)
4930 - LM - CERTIFIED LAY MINISTER (LM)
35212 - LM* - CERTIFIED LAY MINISTER-serving (LM)
17740 - NC - NO LONGER CLERGY (NC)
4931 - NL - LOCAL PASTOR (APPROVED, BUT NOT APPOINTED) (NL)
4932 - OA - ASSOC OTHER CONFERENCE (OA)
4933 - OD - DEACON MEMBER OF OTHER CONFERENCE OR METHODIST DENOMINATION (OD)
4934 - OE - ELDER MEMBER OF OTHER CONFERENCE OR METHODIST DENOMINATION (OE)
4935 - OF - OTHER NON-METHODIST DENOMINATION (OF)
4936 - OP - PM SERVING OTHER CONFER (OP)
4937 - OR - RETIRED MEMBER OTHER CONFERENCE (OR)
4938 - PD - PROVISIONAL DEACON (PD)
4939 - PE - PROVISIONAL ELDER (PE)
4940 - PL - PART TIME LOCAL PASTOR (PL)
4941 - RA - RETIRED ASSOC MEMBER (AM) (RA)
4942 - RD - RETIRED DEACON INFULL CONNECTION (RD)
4943 - RE - RETIRED ELDER (RE)
4944 - RL - RETIRED LOCAL PASTOR (LP) (RL)
20369 - RL* - RETIRED LOCAL PASTOR -serving (RL)
4945 - RP - RETIRED PROVISIONAL MEMBER (PM) (RP)
4946 - SY - SUPPLIED/HIRED/ASSIGNED (SY)
 
Formula
Visible
PlaceholderServiceTime
 
switch(ServiceTimeAtTimeOfFiling){
    case 4957:
        //Full Time (FT)
        1;
        break;
    case 50684:
        //80%
        0.8;
        break;
    case 4956:
        //Three Quarters (3/4)
        0.75;
        break;
    case 4955:
        //One Half (1/2)
        0.5;
        break;
    case 4954:
        //One Quarter
        0.25;
        break;
    case 50687:
        //One Third (1/3)
        0.333;
        break;
    case 50686:
        //Two Thirds (2/3)
        0.666;
        break;
    case 50685:
        //Forty Percent (0.4)
        0.4;
        break;
    case 50688:
        //Eighty Percent (0.8)
        0.8;
        break;
    default: 
        0;
        break;
}
Formula
Visible
PlanCompensation
 
//PlanCompensation



if(CompensationTags == 19939){
    //has parsonage
    Math.round(TotalSalaryValue * 1.25)
} else {
    // anything other than parsonage
    Math.round(TotalSalaryValue)
}

FE, PE, FD, PD, OE, OP, OD, FL, PL, AM

@* let amt = 0; if(ConferenceServing == 44312){ amt = TotalSalaryValue } else if(ConferenceServing == 44311 || ConferenceServing == 44310){ amt = TotalCashCompensation } *@
Show/Hide
Invisible
PreTaxPip
 
PreTaxPipPercent == 32762
Show/Hide
Invisible
RothContributions
 
RothContributionsPercent == 32762
Show/Hide
Visible
SalaryDatesInfo
 
ConferenceServing == 44310 || ConferenceServing == 44311
Show/Hide
Visible
SalaryDatesInfoOI
 
ConferenceServing == 44312
Constant
Visible
StatusesLayPastor
 
[4930,35212]
DOUBLE CHECK WHEN ADDING THIS FORM
Constant
Visible
StatusesMODClergy
 
[4935]
DOUBLE CHECK WHEN ADDING THIS FORM
Constant
Visible
StatusesRetiredClergy
 
[4941,4943,20369]
CORRECT
  • Retired Clergy statuses: the reg form names RL, but there are 2 RL categories in BRT: RL (LP-RL) and RL* (serving). Which is the correct one? RL* IS THE CORRECT ONE, FIXED
  • I couldn’t find Retired Member of Other Denomination in the clergy statuses. Someone needs to match it for me. WE WON'T USE THIS ON THE FORM
Constant
Visible
StatusesUMClergy
 
[4921,4927,4928,4938,4939,4929]
CORRECT
Show/Hide
Visible
TestingField
 
false
Formula
Visible
TotalBenefitCosts
 
//TotalBenefitCosts


ChargeChurchPremiumForGroupHealthInsurance
+
ChargeChurchPremiumForGroupHealthInsuranceOF
+
CRSPCostToChurch
+
CRSPCostToChurchOF
+
CPPCostToChurch
+
CPPCostToChurchOF
+
ChurchContributionToUMPIP
+
ChurchContributionToUMPIPOF
+
ChurchContributionToUMLifeOption
+
OptionalBenefitsAmount
4920 - AF - AFFIL MEMB (AF)
23548 - AL - ADMINISTRATIVE LOCATION (AL)
4921 - AM - ASSOC MEMB (AM)
4922 - BH - BISHOP (BH)
4923 - CC - CERTIFIED CANDIDATE (CC)
4924 - DC - DEACONESS (DC)
43931 - DC* - DEACONESS retired (DC)
4925 - DM - DIACONAL MIN (DM)
4926 - DR - RETIRED DIACONAL MINISTER (DR)
4927 - FD - DEACON IN FULL CONN (FD)
4928 - FE - ELDER IN FULL CONN (FE)
4929 - FL - FULL TIME LOCAL PASTOR (FL)
17738 - HL - HONORABLE LOCATION (HL)
17739 - HR - HONORABLE LOCATION RETIRED (HR)
4930 - LM - CERTIFIED LAY MINISTER (LM)
35212 - LM* - CERTIFIED LAY MINISTER-serving (LM)
17740 - NC - NO LONGER CLERGY (NC)
4931 - NL - LOCAL PASTOR (APPROVED, BUT NOT APPOINTED) (NL)
4932 - OA - ASSOC OTHER CONFERENCE (OA)
4933 - OD - DEACON MEMBER OF OTHER CONFERENCE OR METHODIST DENOMINATION (OD)
4934 - OE - ELDER MEMBER OF OTHER CONFERENCE OR METHODIST DENOMINATION (OE)
4935 - OF - OTHER NON-METHODIST DENOMINATION (OF)
4936 - OP - PM SERVING OTHER CONFER (OP)
4937 - OR - RETIRED MEMBER OTHER CONFERENCE (OR)
4938 - PD - PROVISIONAL DEACON (PD)
4939 - PE - PROVISIONAL ELDER (PE)
4940 - PL - PART TIME LOCAL PASTOR (PL)
4941 - RA - RETIRED ASSOC MEMBER (AM) (RA)
4942 - RD - RETIRED DEACON INFULL CONNECTION (RD)
4943 - RE - RETIRED ELDER (RE)
4944 - RL - RETIRED LOCAL PASTOR (LP) (RL)
20369 - RL* - RETIRED LOCAL PASTOR -serving (RL)
4945 - RP - RETIRED PROVISIONAL MEMBER (PM) (RP)
4946 - SY - SUPPLIED/HIRED/ASSIGNED (SY)
 
Show/Hide
Invisible
TotalBenefitCosts
 
//TotalBenefitCosts

let statusesOH  = [ 4928 , 4939 , 4927 , 4938 , 4934 , 4936 , 4933 , 4929 , 4940 , 4921 , 4941 , 4943 , 4942 , 20369 , 4937 ];
let statusesAK  = [ 4928 , 4939 , 4927 , 4938 , 4934 , 4936 , 4933 , 4929 , 4940 , 4921 , 4941 , 4943 , 4942 , 20369 , 4937 , 35212 , 4946 ];
let statusesPNW = [ 4928 , 4939 , 4927 , 4938 , 4934 , 4936 , 4933 , 4929 , 4940 , 4921 , 4941 , 4943 , 4942 , 20369 , 4937 , 35212 , 4946 ];

(
    ConferenceServing == 44312 && [4957, 50684, 4956, 50824, 4955, 50686].includes(ServiceTimeAtTimeOfFiling) //OR at half time or more
    &&
    (
        (statusesOH.includes(ClergyStatusAtTimeOfFiling))
        ||
        (ClergyStatusAtTimeOfFiling == 4935 && !NeedGroupHealthInsurance)
    )
)
||
(
    ConferenceServing == 44310 && ServiceTimeAtTimeOfFiling == 4957 //AK
    &&
    (
        (statusesAK.includes(ClergyStatusAtTimeOfFiling))
        ||
        (ClergyStatusAtTimeOfFiling == 4935 && !NeedGroupHealthInsurance)
    )
)
||
(
    ConferenceServing == 44311 && ServiceTimeAtTimeOfFiling == 4957 //PNW
    &&
    (
        (statusesPNW.includes(ClergyStatusAtTimeOfFiling))
        ||
        (ClergyStatusAtTimeOfFiling == 4935 && !NeedGroupHealthInsurance)
    )
)
This variable was deactivated on 8/23 because Linda believes the field should be visible to everyone. I'm keeping it "alive" just in case, since it's a somewhat complex formula.


4920 - AF - AFFIL MEMB (AF)
23548 - AL - ADMINISTRATIVE LOCATION (AL)
4921 - AM - ASSOC MEMB (AM)
4922 - BH - BISHOP (BH)
4923 - CC - CERTIFIED CANDIDATE (CC)
4924 - DC - DEACONESS (DC)
43931 - DC* - DEACONESS retired (DC)
4925 - DM - DIACONAL MIN (DM)
4926 - DR - RETIRED DIACONAL MINISTER (DR)
4927 - FD - DEACON IN FULL CONN (FD)
4928 - FE - ELDER IN FULL CONN (FE)
4929 - FL - FULL TIME LOCAL PASTOR (FL)
17738 - HL - HONORABLE LOCATION (HL)
17739 - HR - HONORABLE LOCATION RETIRED (HR)
4930 - LM - CERTIFIED LAY MINISTER (LM)
35212 - LM* - CERTIFIED LAY MINISTER-serving (LM)
17740 - NC - NO LONGER CLERGY (NC)
4931 - NL - LOCAL PASTOR (APPROVED, BUT NOT APPOINTED) (NL)
4932 - OA - ASSOC OTHER CONFERENCE (OA)
4933 - OD - DEACON MEMBER OF OTHER CONFERENCE OR METHODIST DENOMINATION (OD)
4934 - OE - ELDER MEMBER OF OTHER CONFERENCE OR METHODIST DENOMINATION (OE)
4935 - OF - OTHER NON-METHODIST DENOMINATION (OF)
4936 - OP - PM SERVING OTHER CONFER (OP)
4937 - OR - RETIRED MEMBER OTHER CONFERENCE (OR)
4938 - PD - PROVISIONAL DEACON (PD)
4939 - PE - PROVISIONAL ELDER (PE)
4940 - PL - PART TIME LOCAL PASTOR (PL)
4941 - RA - RETIRED ASSOC MEMBER (AM) (RA)
4942 - RD - RETIRED DEACON INFULL CONNECTION (RD)
4943 - RE - RETIRED ELDER (RE)
4944 - RL - RETIRED LOCAL PASTOR (LP) (RL)
20369 - RL* - RETIRED LOCAL PASTOR -serving (RL)
4945 - RP - RETIRED PROVISIONAL MEMBER (PM) (RP)
4946 - SY - SUPPLIED/HIRED/ASSIGNED (SY)
 
Show/Hide
Invisible
TotalCashCompensation
 
ConferenceServing == 44310 || ConferenceServing == 44311
Formula
Invisible
TotalCashCompensation
 
//TotalCashCompensation

BaseSalary
+
UtilityExclusion
+
HousingAllowance
Show/Hide
Visible
TotalCashSalary
 
ConferenceServing == 44310 || ConferenceServing == 44311
Formula
Visible
TotalCashSalary
 
//TotalCashSalary (AK or PNW only)

let amt = BaseSalary + UtilityExclusion

if(ConferenceServing == 44310 || ConferenceServing == 44311){
    // AK or PNW
    if(amt > MinimumCashComp){
        amt
    } else {
        MinimumCashComp
    }
}
Formula
Invisible
TotalCompensation
 
//TotalCompensation

let housing = 0;
if(CompensationTags == 19939){
    //has parsonage
    housing = BaseSalary * 0.25;
} else if(CompensationTags == 19938) {
    //housing allowance
    housing = BaseSalary + HousingAllowance;
}

BaseSalary
+
housing
+
UtilityExclusion
NEW FORMULA, DOUBLE CHECK
Formula
Visible
TotalCostForTotalAppointmentTime
 
//TotalCostForTotalAppointmentTime

TotalSalaryValue
+
AccountableReimbursement
+
TotalBenefitCosts
should be right
Formula
Visible
TotalSalaryValue
 
//TotalSalaryValue

BaseSalary
+
UtilityExclusion
+
HousingAllowance
//TotalSalaryValue if(ConferenceServing == 15030){ //Oregon-Idaho if(CompensationTags == 19939){ //has parsonage BaseSalary + UtilityExclusion } else if(CompensationTags == 19938) { //housing allowance BaseSalary + UtilityExclusion + HousingAllowance } } else if (ConferenceServing == 15029){ // PNW BaseSalary + UtilityExclusion } else if (ConferenceServing == 15065){ //Alaska BaseSalary } else { 0 }
Show/Hide
Invisible
TotalSalaryValue
 
ConferenceServing == 44312
Show/Hide
Visible
UMPIPForMatch
 
//UMPIPForMatch

let statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921];

ConferenceServing == 44311 && 
(
    ([35212,4946].includes(ClergyStatusAtTimeOfFiling) && ServiceTimeAtTimeOfFiling == 4957) //full time LM*/SY
    ||
    (statuses.includes(ClergyStatusAtTimeOfFiling) && ServiceTimeAtTimeOfFiling != 4957) //certain statuses at less than full time
    ||
    (ClergyStatusAtTimeOfFiling == 4935 && ServiceTimeAtTimeOfFiling != 4957) //OF at less than full time unless waived
)
THIS SHOULD BE CORRECT
Show/Hide
Visible
UMPIPPercentage
 
//UMPIPPercentage


ConferenceServing == 44311 
&& 
UMPIPForMatch 

//&& 
//ClergyStatusAtTimeOfFiling == 4935 
//&& 
//ServiceTimeAtTimeOfFiling != 4957
THIS IS CORRECT
Validation
Visible
UMPIPPercentage
 
UMPIPPercentage <= 2
Show/Hide
Visible
UMPIPPercentInfo
 
UMPIPPercentage > 2
Show/Hide
Visible
UtilityExclusion
 
ClergyStatusAtTimeOfFiling != 35212 && ClergyStatusAtTimeOfFiling != 4946
Show/Hide
Visible
YearsInAppointments
 
ConferenceServing == 44310
Comp 2023 Click green hover fields to copy
Filing dates 9/1/2022 to: 2/5/2023
Comp dates 1/1/2023 to: 12/31/2023
Splits
BaseSalary,BaseSalary,Number UtilityExclusion,UtilityExclusion,Number HousingAllowance,HousingAllowance,Number TotalSalaryValue,TotalSalaryValue,Number AccountableReimbursement,AccountableReimbursement,Number ChargeChurchPremiumForGroupHealthInsurance,ChargeChurchPremiumForGroupHealthInsurance,Number ChargeChurchPremiumForGroupHealthInsuranceOF,ChargeChurchPremiumForGroupHealthInsuranceOF,Number CRSPCostToChurch,CRSPCostToChurch,Number CRSPCostToChurchOF,CRSPCostToChurchOF,Number CPPCostToChurch,CPPCostToChurch,Number CPPCostToChurchOF,CPPCostToChurchOF,Number ChurchContributionToUMPIP,ChurchContributionToUMPIP,Number ChurchContributionToUMPIPOF,ChurchContributionToUMPIPOF,Number ChurchContributionToUMLifeOption,ChurchContributionToUMLifeOption,Number
Approval stages
Submitter,District,Conference
Report fields
ConferenceServing,People.FirstName,People.LastName,ClergyStatusAtTimeOfFiling,ServiceTimeAtTimeOfFiling,DateOfChargeConference,PubDate,SalarySourceConference,BaseSalary,UtilityExclusion,TotalCashSalary,CompensationTags,HousingAllowance,ParsonageFairValue,TotalSalaryValue,PlanCompensation,CRSPDC,CRSPDB,CRSPCostToChurch,CRSPCostToChurchOF,CPPCostToChurch,CPPCostToChurchOF,ChargeChurchPremiumForGroupHealthInsurance,ChargeChurchPremiumForGroupHealthInsuranceOF,ChurchContributionToUMPIP,ChurchContributionToUMPIPOF,ChurchContributionToUMLifeOption,OptionalBenefitsAmount,TotalBenefitCosts,AccountableReimbursement,TotalCostForTotalAppointmentTime,Notes,SignatureDistrict,SignaturePastor,SignatureLocalChurchRep,Church.Name,Charges.Name,ExtensionMinistryList.Name,SalarySourceConference,SalaryBreakdown.Church.Name,SalaryBreakdown.ExtensionMinistryList.Name,SalaryBreakdown.BaseSalary,SalaryBreakdown.UtilityExclusion,SalaryBreakdown.HousingAllowance,SalaryBreakdown.TotalSalaryValue,SalaryBreakdown.AccountableReimbursement,SalaryBreakdown.ChargeChurchPremiumForGroupHealthInsurance,SalaryBreakdown.ChargeChurchPremiumForGroupHealthInsuranceOF,SalaryBreakdown.CRSPCostToChurch,SalaryBreakdown.CRSPCostToChurchOF,SalaryBreakdown.CPPCostToChurch,SalaryBreakdown.CPPCostToChurchOF,SalaryBreakdown.ChurchContributionToUMPIP,SalaryBreakdown.ChurchContributionToUMPIPOF,SalaryBreakdown.ChurchContributionToUMLifeOption 
<View Id="Comp2022" TableId="Content" Inherits="ClergyCompForm"><Fields><Category Id="Category" Default="Comp2022" Invisible="true" /></Fields></View>
Redirect to: https://gnw-gnw.brtsite.com/peopleportal/compensation
Scripts
<script src="https://gnw-gnw.brtsite.com/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,
	fieldset[data-id="Pips"] legend,
	fieldset[data-id="Insurance"] legend,
	div[data-fieldid="PlaceholderServiceTime"],
	/*div[data-fieldid="PlanCompensation"],*/
	div[data-fieldid="CompCheckAgainstMinimum"],
	div[data-fieldid="MinimumCashComp"],
	div[data-fieldid="MinimumAchieved"],
	div[data-fieldid="ServiceTimeAtTimeOfFiling"] li[data-value="23553"],
	div[data-fieldid="ServiceTimeAtTimeOfFiling"] li[data-value="19746"],
	div[data-fieldid="ConferenceServing"] li[data-value="44441"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="4920"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="23548"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="4922"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="4923"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="4924"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="43931"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="4925"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="4926"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="17738"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="17739"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="4930"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="4931"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="17740"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="4944"],
	div[data-fieldid="SalarySourceConference"] li[data-value="44441"]
	{
		display:none;
	} 
	div[data-fieldid="MinimumCashComp"] .input-block-level,
	div[data-fieldid="PlanCompensation"] .input-block-level,
	div[data-fieldid="TotalSalaryValue"] .input-block-level,
	div[data-fieldid="TotalCashSalary"] .input-block-level,
	div[data-fieldid="TotalCashCompensation"] .input-block-level,
	div[data-fieldid="CRSPDB"] .input-block-level,
	div[data-fieldid="CRSPDC"] .input-block-level,
	div[data-fieldid="CPPCostToChurch"] .input-block-level,
	div[data-fieldid="CRSPCostToChurch"] .input-block-level,
	div[data-fieldid="ChargeChurchPremiumForGroupHealthInsurance"] .input-block-level,
	div[data-fieldid="ChurchContributionToUMPIP"] .input-block-level,
	div[data-fieldid="ChurchContributionToUMLifeOption"] .input-block-level,
	div[data-fieldid="TotalBenefitCosts"] .input-block-level,
	div[data-fieldid="TotalCostForTotalAppointmentTime"] .input-block-level
	{
	    border-color: transparent;
	}
	div[data-fieldid="CRSPDC"],
	div[data-fieldid="CRSPDB"] {
	    display: flex;
        align-items: center;
        margin-top: -20px;
	}
	div[data-fieldid="CRSPDC"] .controls input,
	div[data-fieldid="CRSPDB"] .controls input {
	    margin-bottom: 5px;
	}
	div[data-fieldid="CRSPDC"] .control-label,
	div[data-fieldid="CRSPDC"] .controls input,
	div[data-fieldid="CRSPDB"] .control-label,
	div[data-fieldid="CRSPDB"] .controls input {
	    font-size: 12px;
	}
</style>
Show/Hide
Invisible
AfterTaxPip
 
AfterTaxPipPercent == 32762
Constant
Invisible
AllStatuses

4920 - AF - AFFIL MEMB (AF)
23548 - AL - ADMINISTRATIVE LOCATION (AL)
4921 - AM - ASSOC MEMB (AM)
4922 - BH - BISHOP (BH)
4923 - CC - CERTIFIED CANDIDATE (CC)
4924 - DC - DEACONESS (DC)
43931 - DC* - DEACONESS retired (DC)
4925 - DM - DIACONAL MIN (DM)
4926 - DR - RETIRED DIACONAL MINISTER (DR)
4927 - FD - DEACON IN FULL CONN (FD)
4928 - FE - ELDER IN FULL CONN (FE)
4929 - FL - FULL TIME LOCAL PASTOR (FL)
17738 - HL - HONORABLE LOCATION (HL)
17739 - HR - HONORABLE LOCATION RETIRED (HR)
4930 - LM - CERTIFIED LAY MINISTER (LM)
35212 - LM* - CERTIFIED LAY MINISTER-serving (LM)
17740 - NC - NO LONGER CLERGY (NC)
4931 - NL - LOCAL PASTOR (APPROVED, BUT NOT APPOINTED) (NL)
4932 - OA - ASSOC OTHER CONFERENCE (OA)
4933 - OD - DEACON MEMBER OF OTHER CONFERENCE OR METHODIST DENOMINATION (OD)
4934 - OE - ELDER MEMBER OF OTHER CONFERENCE OR METHODIST DENOMINATION (OE)
4935 - OF - OTHER NON-METHODIST DENOMINATION (OF)
4936 - OP - PM SERVING OTHER CONFER (OP)
4937 - OR - RETIRED MEMBER OTHER CONFERENCE (OR)
4938 - PD - PROVISIONAL DEACON (PD)
4939 - PE - PROVISIONAL ELDER (PE)
4940 - PL - PART TIME LOCAL PASTOR (PL)
4941 - RA - RETIRED ASSOC MEMBER (AM) (RA)
4942 - RD - RETIRED DEACON INFULL CONNECTION (RD)
4943 - RE - RETIRED ELDER (RE)
4944 - RL - RETIRED LOCAL PASTOR (LP) (RL)
20369 - RL* - RETIRED LOCAL PASTOR -serving (RL)
4945 - RP - RETIRED PROVISIONAL MEMBER (PM) (RP)
4946 - SY - SUPPLIED/HIRED/ASSIGNED (SY)
 
Show/Hide
Invisible
BenefitsInfo
 
//TotalBenefitCosts

let statusesOH  = [ 4928 , 4939 , 4927 , 4938 , 4934 , 4936 , 4933 , 4929 , 4940 , 4921 , 4941 , 4943 , 4942 , 20369 , 4937 ];
let statusesAK  = [ 4928 , 4939 , 4927 , 4938 , 4934 , 4936 , 4933 , 4929 , 4940 , 4921 , 4941 , 4943 , 4942 , 20369 , 4937 , 35212 , 4946 ];
let statusesPNW = [ 4928 , 4939 , 4927 , 4938 , 4934 , 4936 , 4933 , 4929 , 4940 , 4921 , 4941 , 4943 , 4942 , 20369 , 4937 , 35212 , 4946 ];

(
    ConferenceServing == 44312 && [4957, 4956].includes(ServiceTimeAtTimeOfFiling)
    &&
    (
        (statusesOH.includes(ClergyStatusAtTimeOfFiling))
        ||
        (ClergyStatusAtTimeOfFiling == 4935 && !NeedGroupHealthInsurance)
    )
)
||
(
    ConferenceServing == 44310 && ServiceTimeAtTimeOfFiling == 4957
    &&
    (
        (statusesAK.includes(ClergyStatusAtTimeOfFiling))
        ||
        (ClergyStatusAtTimeOfFiling == 4935 && !NeedGroupHealthInsurance)
    )
)
||
(
    ConferenceServing == 44311 && ServiceTimeAtTimeOfFiling == 4957
    &&
    (
        (statusesPNW.includes(ClergyStatusAtTimeOfFiling))
        ||
        (ClergyStatusAtTimeOfFiling == 4935 && !NeedGroupHealthInsurance)
    )
)
Show/Hide
Invisible
ChargeChurchAmountInfo
 
NeedGroupHealthInsurance && ClergyStatusAtTimeOfFiling == 4935 && ConferenceServing == 44312
Show/Hide
Visible
ChargeChurchPremiumForGroupHealthInsurance
 
let statuses;
let serviceTime;
let confs = [44312,44311,44310];

if(ConferenceServing == 44312){ //Oregon
    statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921,4941,4943,4942,20369,4937];
    serviceTime = [4957,4956,50684];
} else if(ConferenceServing == 44311 || ConferenceServing == 44310){ //PNW or AK
    statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921,4941,4943,4942,20369,4937,35212,4946];
    serviceTime = [4957];
}

(confs.includes(ConferenceServing) && serviceTime.includes(ServiceTimeAtTimeOfFiling) && statuses.includes(ClergyStatusAtTimeOfFiling)) ||
(NeedGroupHealthInsurance && ClergyStatusAtTimeOfFiling == 4935)
let statuses;
let serviceTime;
let confs = [44312,44311,44310];

if(ConferenceServing == 44312){ //Oregon
    statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921,4941,4943,4942,20369,4937];
    serviceTime = [4957,4956,50684];
} else if(ConferenceServing == 44311 || ConferenceServing == 44310){ //PNW or AK
    statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921,4941,4943,4942,20369,4937,35212,4946];
    serviceTime = [4957];
}

confs.includes(ConferenceServing) && serviceTime.includes(ServiceTimeAtTimeOfFiling) && statuses.includes(ClergyStatusAtTimeOfFiling)
Formula
Visible
ChargeChurchPremiumForGroupHealthInsurance
 
//ChargeChurchPremiumForGroupHealthInsurance

let statusesOH  = [ 4928 , 4939 , 4927 , 4938 , 4934 , 4936 , 4933 , 4929 , 4940 , 4921 , 4941 , 4943 , 4942 , 20369 , 4937 ];
let statusesAK  = [ 4928 , 4939 , 4927 , 4938 , 4934 , 4936 , 4933 , 4929 , 4940 , 4921 , 4941 , 4943 , 4942 , 20369 , 4937 , 35212 , 4946 ];
let statusesPNW = [ 4928 , 4939 , 4927 , 4938 , 4934 , 4936 , 4933 , 4929 , 4940 , 4921 , 4941 , 4943 , 4942 , 20369 , 4937 , 35212 , 4946 ];

if(ConferenceServing == 44312 && [4957,4956,50684].includes(ServiceTimeAtTimeOfFiling)){ //OR at 3/4 or full time
    if(
        (statusesOH.includes(ClergyStatusAtTimeOfFiling))
        ||
        (ClergyStatusAtTimeOfFiling == 4935 && !NeedGroupHealthInsurance)
    ){
        14400
    }
} else if(ConferenceServing == 44310 && ServiceTimeAtTimeOfFiling == 4957){ //AK at full time
    if(
        (statusesAK.includes(ClergyStatusAtTimeOfFiling))
        ||
        (ClergyStatusAtTimeOfFiling == 4935 && NeedGroupHealthInsurance)
    ){
        16200
    }
} else if(ConferenceServing == 44311 && ServiceTimeAtTimeOfFiling == 4957){ //PNW at full time
    if(
        (statusesPNW.includes(ClergyStatusAtTimeOfFiling))
        ||
        (ClergyStatusAtTimeOfFiling == 4935 && !NeedGroupHealthInsurance)
    ){
        8400
    }
} else {
    0
}
Show/Hide
Visible
ChargeChurchPremiumForGroupHealthInsuranceOF
 
//ChargeChurchPremiumForGroupHealthInsuranceOF

let statuses;
let serviceTime;
let confs = [44312,44311,44310];

if(ConferenceServing == 44312){ //Oregon
    statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921,4941,4943,4942,20369,4937];
    serviceTime = [4957,4956,50684];
} else if(ConferenceServing == 44311 || ConferenceServing == 44310){ //PNW or AK
    statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921,4941,4943,4942,20369,4937,35212,4946];
    serviceTime = [4957];
}

confs.includes(ConferenceServing) &&
serviceTime.includes(ServiceTimeAtTimeOfFiling) &&
ClergyStatusAtTimeOfFiling == 4935 &&
!NeedGroupHealthInsurance
//ChargeChurchPremiumForGroupHealthInsuranceOF

let statuses;
let serviceTime;
let confs = [44312,44311,44310];

if(ConferenceServing == 44312){ //Oregon
    statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921,4941,4943,4942,20369,4937];
    serviceTime = [4957,4956,50684];
} else if(ConferenceServing == 44311 || ConferenceServing == 44310){ //PNW or AK
    statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921,4941,4943,4942,20369,4937,35212,4946];
    serviceTime = [4957];
}

confs.includes(ConferenceServing) && 
serviceTime.includes(ServiceTimeAtTimeOfFiling) && 
ClergyStatusAtTimeOfFiling == 4935 && 
!NeedGroupHealthInsurance
Show/Hide
Visible
ChurchContributionToUMLifeOption
 
let statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921]; // does not include OF
let halfUp = [4955,50824,4956,50684]; // 1/2, 0.6, 3/4, 0.8

(
    ConferenceServing == 44311 &&
    (
        ([35212,4946].includes(ClergyStatusAtTimeOfFiling) && ServiceTimeAtTimeOfFiling ==4957) //LM* and SY at full time
        ||
        (statuses.includes(ClergyStatusAtTimeOfFiling) && halfUp.includes(ServiceTimeAtTimeOfFiling)) // statuses at 1/2, 0.6, 3/4, 0.8 service time
    )
)
||
(
    ConferenceServing == 44310 && statuses.includes(ClergyStatusAtTimeOfFiling) && halfUp.includes(ServiceTimeAtTimeOfFiling)
)
Formula
Visible
ChurchContributionToUMLifeOption
 
//ChurchContributionToUMLifeOption

let statuses = [4928,4939,4927,4938,4934,4936,4933,4921]; // does not include OF, FL
let halfUp = [4955,50824,4956,50684]; // 1/2, 0.6, 3/4, 0.8

if(
    (
        ConferenceServing == 44311 &&
        (
            ([35212,4946].includes(ClergyStatusAtTimeOfFiling) && ServiceTimeAtTimeOfFiling ==4957) //LM* and SY at full time
            ||
            (statuses.includes(ClergyStatusAtTimeOfFiling) && halfUp.includes(ServiceTimeAtTimeOfFiling)) // statuses at 1/2, 0.6, 3/4, 0.8 service time
        )
    )
    ||
    (
        ConferenceServing == 44310 && statuses.includes(ClergyStatusAtTimeOfFiling) && halfUp.includes(ServiceTimeAtTimeOfFiling)
    )
){
    PlanCompensation * 0.022
}
12/1 - per Linda Grund-Clampit:
  • Since FT isn't included, we can remove FL   - YES
  • You said that PL should be removed - YES
  • 2/3 time is missing (if it's anything above 50%, but not including FT) – let’s not add that at this time anyway.  I don’t believe they use that time and I don’t want to upset any other formulas!
  • Do you want to keep the OE, OD and OP?  YES


Statuses:
AM 4921, FD 4927, FE 4928, FL 4929, PD 4938, PE 4939, PL 4940, OE 4934, OD 4933, OP 4936 (no OF)
Service times:
½ 4955,  0.6 50824, ¾ 4956, 0.8 50684
PNW also includes LM serving and SY at full time
Plan Compensation * 0.022
 
Show/Hide
Visible
ChurchContributionToUMPIP
 
//ChurchContributionToUMPIP

let statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921]; // does not include OF


ConferenceServing == 44311 &&
(
    //OF not full time who does not need coverage
    (ClergyStatusAtTimeOfFiling == 4935 && ServiceTimeAtTimeOfFiling != 4957 && OFNeedUMPIP) 
    ||
    //several statuses less than full time
    (statuses.includes(ClergyStatusAtTimeOfFiling) && ServiceTimeAtTimeOfFiling != 4957) 
    ||
    //LM* or SY at full time
    ((ClergyStatusAtTimeOfFiling == 35212 || ClergyStatusAtTimeOfFiling == 4946) && ServiceTimeAtTimeOfFiling == 4957) 
)
Formula
Visible
ChurchContributionToUMPIP
 
//ChurchContributionToUMPIP

let match = PlanCompensation * (UMPIPPercentage / 100);
if(match >= (PlanCompensation * 0.02)){
    match = PlanCompensation * 0.02;
}

let statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921]; // does not include OF
let halfUp = [4955,50824,4956,50684]; // 1/2, 0.6, 3/4, 0.8
let halfDown = [50688,4954,50687,50685]; // 0.2, 1/4, 1/3, 0.4

if(ConferenceServing == 44311){
    if(
        ([35212,4946].includes(ClergyStatusAtTimeOfFiling) && ServiceTimeAtTimeOfFiling == 4957) //LM* and SY at full time
        ||
        (statuses.includes(ClergyStatusAtTimeOfFiling) && halfUp.includes(ServiceTimeAtTimeOfFiling)) // statuses at 1/2, 0.6, 3/4, 0.8 service time
        || 
        (ClergyStatusAtTimeOfFiling == 4935 && halfUp.includes(ServiceTimeAtTimeOfFiling) && OFNeedUMPIP) // OF needs UMPIP coverage - 0.5, 0.6, 0.75, 0.8 service time
    ){
        if(UMPIPForMatch){
            (PlanCompensation * 0.08) + match
        } else {
            PlanCompensation * 0.08
        }
    } else if (
        (statuses.includes(ClergyStatusAtTimeOfFiling) && halfDown.includes(ServiceTimeAtTimeOfFiling)) // statuses at 0.2, 1/4, 1/3, 0.4 service time
        ||
        (ClergyStatusAtTimeOfFiling == 4935 && OFNeedUMPIP && halfDown.includes(ServiceTimeAtTimeOfFiling)) // OF not waived UMPIP coverage - 0.2, 1/4, 1/3, 0.4 service time
    ) {
       if(UMPIPForMatch){
            (PlanCompensation * 0.06) + match
        } else {
            PlanCompensation * 0.06
        } 
    }
} else {
    0
}
edited on 220510 
(ServiceTimeAtTimeOfFiling == 4956 || ServiceTimeAtTimeOfFiling == 4955) //1/2 and 3/4

[35212,4946].includes(ClergyStatusAtTimeOfFiling) //LM* and SY

ServiceTimeAtTimeOfFiling ==4957 //full time

Statuses
4921,4928,4927,4939,4938,4934,4936,4933,4929,4940
AM, FE, FD, PE, PD, OE, OP, OD, FL, PL

4935 = OF

Times
4955,50824,4956,50684
1/2, 0.6, 3/4, 0.8

50688,4954,50687,50685
0.2, 1/4, 1/3, 0.4

NOT WAIVED: OFNeedUMPIP = true
Show/Hide
Visible
ChurchContributionToUMPIPOF
 
ConferenceServing == 44311 && ClergyStatusAtTimeOfFiling == 4935 && ServiceTimeAtTimeOfFiling != 4957 && !OFNeedUMPIP
Validation
Visible
CompCheckAgainstMinimum
 
if(ConferenceServing == 44310 || ConferenceServing == 44311){
    // AK or PNW
    if(![4941,4943,4942,20369,4937,4946,35212].includes(ClergyStatusAtTimeOfFiling)){ //IF NOT RETIRED  //RA, RE, RD, RL*, OR, SY, LM*
        CompCheckAgainstMinimum <= TotalCashSalary
    } else {
        true
    }
} else if(ConferenceServing == 44312) {
    if(![4941,4943,4942,20369,4937,4946,35212].includes(ClergyStatusAtTimeOfFiling)){ //IF NOT RETIRED  //RA, RE, RD, RL*, OR, SY, LM*
        CompCheckAgainstMinimum >= MinimumCashComp
    } else {
        true
    }
}
Edited on 8/23/22, originally formula was simply
CompCheckAgainstMinimum >= MinimumCashComp
(which it seems that it was the opposite of what it needed to be)




 
Formula
Visible
CompCheckAgainstMinimum
 
//CompCheckAgainstMinimum

//let checkAmt;

if(ConferenceServing == 44312){ //Oregon
    BaseSalary + UtilityExclusion + HousingAllowance;
} else if(ConferenceServing == 44311 || ConferenceServing == 44310){ //PNW or AK
    BaseSalary + UtilityExclusion;
}
Show/Hide
Visible
CompensationTags
 
ClergyStatusAtTimeOfFiling != 35212 //LM*
&&
ClergyStatusAtTimeOfFiling != 4946 //SY


//&& PensionAbleServiceTimes.includes(ServiceTimeAtTimeOfFiling)
Corrected on 220510
All statuses except LM* and SY, at any service time
Formula
Visible
CPPCostToChurch
 
//CPPCostToChurch

let statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921];
let serviceTime;
let thisAmt = PlanCompensation * 0.03;

if(thisAmt >= 4573.26){
   thisAmt = 4573.26;
}


if(ConferenceServing == 44312 || ConferenceServing == 44310){ //Oregon or Alaska
    serviceTime = [4956,50684,4957]; //3/4 and above
} else { //PNW and others
    serviceTime = [4957]; //only full time
}

if(serviceTime.includes(ServiceTimeAtTimeOfFiling)){
    if(statuses.includes(ClergyStatusAtTimeOfFiling) || (NeedCPP && ClergyStatusAtTimeOfFiling == 4935)){
        if(ConferenceServing == 44312){ //Oregon
            PlanCompensation * 0.03
        } else if(ConferenceServing == 44311 || ConferenceServing == 44310){ //PNW or AK
            thisAmt
        }
    }
}
FE, PE, FD, PD, OE, OP, OD, FL, PL, AM (not LM*/SY and not retired statuses)
Housing/parsonage already accounted for in the PlanCompensation calculation.
Show/Hide
Visible
CPPCostToChurch
 
//CPPCostToChurch

let statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921];
let serviceTime;

if(ConferenceServing == 44312){ //Oregon
    serviceTime = [4956,50684,4957]; //3/4 and above
} else {
    serviceTime = [4957]; //only full time
}

(serviceTime.includes(ServiceTimeAtTimeOfFiling) && statuses.includes(ClergyStatusAtTimeOfFiling))
||
(NeedCPP && ClergyStatusAtTimeOfFiling == 4935)
Show/Hide
Visible
CPPCostToChurchOF
 
//CPPCostToChurchOF

let statuses;
let serviceTime;

if(ConferenceServing == 44312){ //Oregon
    statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921,4941,4943,4942,20369,4937];
    serviceTime = [4957,4956,50684];
} else if(ConferenceServing == 44311 || ConferenceServing == 44310){ //PNW or AK
    statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921,4941,4943,4942,20369,4937,35212,4946];
    serviceTime = [4957];
}

serviceTime.includes(ServiceTimeAtTimeOfFiling) &&
ClergyStatusAtTimeOfFiling == 4935 &&
!NeedCPP
Formula
Visible
CRSPCostToChurch
 
//CRSPCostToChurch

let statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921];
let eligibleStatus = false;

if((statuses.includes(ClergyStatusAtTimeOfFiling)) || (ClergyStatusAtTimeOfFiling == 4935 && NeedCRSP)){
    eligibleStatus = true;
}

if(eligibleStatus){
    if(ConferenceServing == 44312 && [50686,4955,4956,50684,4957].includes(ServiceTimeAtTimeOfFiling)){ //OR at 1/2 or above
        PlanCompensation * 0.13
    } else if(ConferenceServing == 44310 && [50686,4955,4956,50684,4957].includes(ServiceTimeAtTimeOfFiling)){ //AK at 1/2 or above
        PlanCompensation * 0.03
    } else if(ConferenceServing == 44311 && ServiceTimeAtTimeOfFiling == 4957){ //PNW at full time
        (PlanCompensation * 0.03) + 5200
    }
} else {
    0
}


/*
let serviceTime;

if(ConferenceServing == 44312 || ConferenceServing == 44310){ //Oregon or Alaska
    serviceTime = [50686,4955,4956,50684,4957]; //1/2 and above
} else { //PNW and others
    serviceTime = [4957]; //only full time
}

if(serviceTime.includes(ServiceTimeAtTimeOfFiling)){
    if(statuses.includes(ClergyStatusAtTimeOfFiling) || (NeedCRSP && ClergyStatusAtTimeOfFiling == 4935)){
        if(ConferenceServing == 44312){ //Oregon
            PlanCompensation * 0.13
        } else if(ConferenceServing == 44311){ //PNW
            (PlanCompensation * 0.03) + 5700
        } else if(ConferenceServing == 44310) { //AK
            PlanCompensation * 0.03
        }
    }
}
*/

11/28/2022 calculation was updated for PNW - the addition of $5,700 was changed to $5,200. 


FE, PE, FD, PD, OE, OP, OD, FL, PL, AM (not LM*/SY and not retired statuses)

Housing/parsonage already accounted for in the PlanCompensation calculation. 
if(serviceTime.includes(ServiceTimeAtTimeOfFiling) && statuses.includes(ClergyStatusAtTimeOfFiling)){
    if(ConferenceServing == 44312){ //Oregon
        PlanCompensation * 0.13
    } else if(ConferenceServing == 44311){ //PNW
        (PlanCompensation * 0.03) + 5700
    } else if(ConferenceServing == 44310) { //AK
        PlanCompensation * 0.03
    }
}

  1. CRSP (calculated as percentage of plan compensation)

    1. Plan compensation (dependent on housing tag)

      1. With parsonage, plan compensation = Total Salary (3.f.) * 1.25

      2. With housing allowance, plan compensation = Total Salary (3.f.)

    2. Oregon-Idaho

      1. applies to ½ time to full-time appointments (does not apply to ¼ time)

      2. applies to FE, PE, FD, PD, OE, OP, OD, FL, PL, AM (not LM*/SY and not retired statuses)

      3. AND applies to OF (other non-Methodist denomination) unless they waive coverage because they are enrolled in another plan through their denomination.

        1. if so, need to ask amount of that other plan which will be billed to the church/charge

      4. amount = Plan Compensation X 0.13

    3. PNW  

      1. applies only to full-time appointments

      2. applies to FE, PE, FD, PD, OE, OP, OD, FL, PL, AM (not LM*/SY and not retired statuses)

      3. AND applies to OF (other non-Methodist denomination) unless they waive coverage because they are enrolled in another plan through their denomination.

        1. if so, need to ask amount of that other plan which will be billed to the church/charge

      4. amount = (Plan compensation x 0.03) + $5,700

    4. Alaska 

      1. applies to ½ time to full-time appointments

      2. applies to FE, PE, FD, PD, OE, OP, OD, FL, PL, AM (not LM*/SY and not retired statuses)

      3. AND applies to OF (other non-Methodist denomination) unless they waive coverage because they are enrolled in another plan through their denomination.

        1. if so, need to ask amount of that other plan which will be billed to the church/charge

      4. amount = Plan compensation X 0.03
Show/Hide
Visible
CRSPCostToChurch
 
let statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921];
let serviceTime;

if(ConferenceServing == 44312 || ConferenceServing == 44310){ //Oregon or Alaska
    serviceTime = [50686,4955,4956,50684,4957]; //1/2 and above
} else {
    serviceTime = [4957]; //only full time
}

(serviceTime.includes(ServiceTimeAtTimeOfFiling) && statuses.includes(ClergyStatusAtTimeOfFiling))
||
(NeedCRSP && ClergyStatusAtTimeOfFiling == 4935)


/*
//===================

//POSSIBLE SOLUTION IN CASE ABOVE IS WRONG

(([4928,4939,4927,4938,4934,4936,4933,4929,4940,4921].includes(ClergyStatusAtTimeOfFiling)) || (ClergyStatusAtTimeOfFiling == 4935 && !NeedCRSP))
&&
(
    (ConferenceServing == 44312 && [50686,4955,4956,50684,4957].includes(ServiceTimeAtTimeOfFiling))
    ||
    (ConferenceServing == 44310 && ServiceTimeAtTimeOfFiling == 4957)
    ||
    (ConferenceServing == 44311 && ServiceTimeAtTimeOfFiling == 4957)
)
*/
Show/Hide
Visible
CRSPCostToChurchOF
 
//CRSPCostToChurchOF

let statuses;
let serviceTime;

if(ConferenceServing == 44312){ //Oregon
    statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921,4941,4943,4942,20369,4937];
    serviceTime = [50686,4955,4956,50684,4957]; //1/2 and above
} else if(ConferenceServing == 44311 || ConferenceServing == 44310){ //PNW or AK
    statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921,4941,4943,4942,20369,4937,35212,4946];
    serviceTime = [4957];
}

serviceTime.includes(ServiceTimeAtTimeOfFiling) &&
ClergyStatusAtTimeOfFiling == 4935 &&
!NeedCRSP
Formula
Visible
CRSPDB
 
if(ConferenceServing == 44310){
    0
} else if(ConferenceServing == 44311) {
    5200
}
Show/Hide
Visible
CRSPDB
 
let statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921];
let serviceTime;

if(ConferenceServing == 44312 || ConferenceServing == 44310){ //Oregon or Alaska
    serviceTime = [50686,4955,4956,50684,4957]; //1/2 and above
} else {
    serviceTime = [4957]; //only full time
}

(ConferenceServing == 44310 || ConferenceServing == 44311) && ( // not Oregon
    (serviceTime.includes(ServiceTimeAtTimeOfFiling) && statuses.includes(ClergyStatusAtTimeOfFiling))
    ||
    (NeedCRSP && ClergyStatusAtTimeOfFiling == 4935)
)
Edited on 8/23, originally was
(ConferenceServing == 44310 || ConferenceServing == 44311) && ServiceTimeAtTimeOfFiling == 4957
Show/Hide
Visible
CRSPDC
 
let statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921];
let serviceTime;

if(ConferenceServing == 44312 || ConferenceServing == 44310){ //Oregon or Alaska
    serviceTime = [50686,4955,4956,50684,4957]; //1/2 and above
} else {
    serviceTime = [4957]; //only full time
}
(ConferenceServing == 44310 || ConferenceServing == 44311) && ( // not Oregon
    (serviceTime.includes(ServiceTimeAtTimeOfFiling) && statuses.includes(ClergyStatusAtTimeOfFiling))
    ||
    (NeedCRSP && ClergyStatusAtTimeOfFiling == 4935)
)
Edited on 8/23, originally was
(ConferenceServing == 44310 || ConferenceServing == 44311) && ServiceTimeAtTimeOfFiling == 4957
Formula
Visible
CRSPDC
 
//CRSPDC

PlanCompensation * 0.03
Show/Hide
Visible
GeographicalAreas
 
ConferenceServing == 44310
Show/Hide
Visible
HousingAllowance
 
CompensationTags == 19938 && ClergyStatusAtTimeOfFiling != 35212 && ClergyStatusAtTimeOfFiling != 4946
Show/Hide
Visible
HousingInfo
 
CompensationTags == 49928
Show/Hide
Visible
HousingTags
 
ClergyStatusAtTimeOfFiling != 35212 && ClergyStatusAtTimeOfFiling != 4946
Formula
Visible
MinimumCashComp
 
//MinimumCashComp

let statuses = [4941,4943,4942,20369,4937,4946,35212];
let multiplier;

switch(GeographicalAreas){
    case 50769: //anchorage
        multiplier = 0;
        break;
        
    case 50770: //Fairbanks
        multiplier = 6;
        break;
        
    case 50771: //Juneau
        multiplier = 13;
        break;
        
    case 50772: //Girdwood
        multiplier = 8;
        break;
        
    case 50773: //Kenai Peninsula
        multiplier = 16;
        break;
        
    case 50774: //Homer
        multiplier = 15;
        break;
        
    case 50775: //Ketchikan
        multiplier = 9;
        break;
        
    case 50776: //Nome
        multiplier = 46;
        break;
        
    case 50777: //Sitka
        multiplier = 9;
        break;
        
    case 50778: //Unalaska
        multiplier = 68;
        break;
        
    case 50779: //Wasilla
        multiplier = 3;
        break;
        
    case 50780: //Willow
        multiplier = 12;
        break;
        
    default: //no answer
        multiplier = 0;
        break;
}

if(ConferenceServing == 44312){ //Oregon
    if([4928,4927,4921,4934,4935,4932,4933].includes(ClergyStatusAtTimeOfFiling)){
        //Elders and Deacons in full connection / associate members
        if(CompensationTags == 19938){
            //housing allowance
            65439 * PlaceholderServiceTime
        } else {
            // anything other than housing allowance
            47390 * PlaceholderServiceTime
        }
    } else if ([4938,4939,4936].includes(ClergyStatusAtTimeOfFiling)){
        //Provisional Elders and Deacons
        if(CompensationTags == 19938){
            //housing allowance
            62168 * PlaceholderServiceTime
        } else {
            // anything other than housing allowance
            45020 * PlaceholderServiceTime
        }
    } else if ([4929,4940].includes(ClergyStatusAtTimeOfFiling)){
        //Local Pastors 
        if(CompensationTags == 19938){
            //housing allowance
            59060 * PlaceholderServiceTime
        } else {
            // anything other than housing allowance
            42770 * PlaceholderServiceTime
        }
    } else {
        0
    }
} else if(ConferenceServing == 44311 && !statuses.includes(ClergyStatusAtTimeOfFiling)){ //PNW
    //For all clergy statuses except retired and CLM/SY = $46,400
    46400 * PlaceholderServiceTime
} else if(ConferenceServing == 44310 && !statuses.includes(ClergyStatusAtTimeOfFiling)) {//AK
    //For all clergy statuses except retired and CLM/SY =  $48,800 + $200 per year 
    //lapsed service year since date of initial appointment as a pastor + Area-Cost-of-Living 
    //Adjustment Percentage
    ((48800 + (200*YearsInAppointments)) + ((48800 + (200*YearsInAppointments)) * (multiplier / 100))) * PlaceholderServiceTime
} else {
    0
}
4927 - FD
4928 - FE
4921 - AM

4938 - PD
4939 - PE

4929 - FL

============

15030 - OR
15029 - PNW
15065 - Alaska

============

        //if(ConferenceServing == 15030){
        //    Oregon-Idaho
        //    BaseSalary + UtilityExclusion
        //}
Show/Hide
Visible
MinimumCashComp
 
//MinimumCashComp

let statuses = [4941,4943,4942,20369,4937,4946,35212]; //RA, RE, RD, RL*, OR, SY, LM*

(ConferenceServing == 44312 && [4928,4927,4921,4934,4935,4932,4933,4938,4939,4936,4929,4940].includes(ClergyStatusAtTimeOfFiling)) //OR
||
(ConferenceServing == 44311 && !statuses.includes(ClergyStatusAtTimeOfFiling)) //PNW
||
(ConferenceServing == 44310 && !statuses.includes(ClergyStatusAtTimeOfFiling)) //AK
Show/Hide
Invisible
MinimumNotAchieved
 
//MinimumNotAchieved

CompCheckAgainstMinimum > MinimumCashComp
Show/Hide
Visible
NeedCPP
 
ClergyStatusAtTimeOfFiling == 4935 && 
(
    (ConferenceServing == 44312 && PensionAbleServiceTimes.includes(ServiceTimeAtTimeOfFiling)) 
    || 
    ((ConferenceServing == 44311 || ConferenceServing == 44310) && ServiceTimeAtTimeOfFiling == 4957)    
)
Show/Hide
Visible
NeedCRSP
 
ClergyStatusAtTimeOfFiling == 4935 && 
(
    (ConferenceServing == 44312 && [50686,50684,50824,4955,4956,4957].includes(ServiceTimeAtTimeOfFiling)) //OR
    || 
    (ConferenceServing == 44311 && ServiceTimeAtTimeOfFiling == 4957) // PNW
    ||
    (ConferenceServing == 44310 && [50686,50684,50824,4955,4956,4957].includes(ServiceTimeAtTimeOfFiling)) //AK
)
Show/Hide
Visible
NeedGroupHealthInsurance
 
ClergyStatusAtTimeOfFiling == 4935 && 
(
    (ConferenceServing == 44312 && PensionAbleServiceTimes.includes(ServiceTimeAtTimeOfFiling)) 
    || 
    ((ConferenceServing == 44311 || ConferenceServing == 44310) && ServiceTimeAtTimeOfFiling == 4957)    
)
Show/Hide
Visible
OFNeedUMPIP
 
//OFNeedUMPIP

ConferenceServing == 44311 && ServiceTimeAtTimeOfFiling != 4957 && ClergyStatusAtTimeOfFiling == 4935
Show/Hide
Visible
OptionalBenefits
 
ConferenceServing == 44312
Show/Hide
Visible
OptionalBenefitsAmount
 
ConferenceServing == 44312 && OptionalBenefits
Show/Hide
Visible
OptionalBenefitsType
 
ConferenceServing == 44312 && OptionalBenefits
Show/Hide
Visible
ParsonageFairValue
 
CompensationTags == 19939 && ConferenceServing == 44312
Constant
Visible
PensionAbleServiceTimes
 
[4957,4956,50684]
3/4 and above
Constant
Visible
PensionAbleStatuses
 
[4928,4939,4921,4929,47683,4927,4938,4934,4935]
COPIED FROM WI, DOUBLE CHECK WITH LINDA
4928 - FE
4939 - PE
4921 - AM
4929 - FL


4920 - AF - AFFIL MEMB (AF)
23548 - AL - ADMINISTRATIVE LOCATION (AL)
4921 - AM - ASSOC MEMB (AM)
4922 - BH - BISHOP (BH)
4923 - CC - CERTIFIED CANDIDATE (CC)
4924 - DC - DEACONESS (DC)
43931 - DC* - DEACONESS retired (DC)
4925 - DM - DIACONAL MIN (DM)
4926 - DR - RETIRED DIACONAL MINISTER (DR)
4927 - FD - DEACON IN FULL CONN (FD)
4928 - FE - ELDER IN FULL CONN (FE)
4929 - FL - FULL TIME LOCAL PASTOR (FL)
17738 - HL - HONORABLE LOCATION (HL)
17739 - HR - HONORABLE LOCATION RETIRED (HR)
4930 - LM - CERTIFIED LAY MINISTER (LM)
35212 - LM* - CERTIFIED LAY MINISTER-serving (LM)
17740 - NC - NO LONGER CLERGY (NC)
4931 - NL - LOCAL PASTOR (APPROVED, BUT NOT APPOINTED) (NL)
4932 - OA - ASSOC OTHER CONFERENCE (OA)
4933 - OD - DEACON MEMBER OF OTHER CONFERENCE OR METHODIST DENOMINATION (OD)
4934 - OE - ELDER MEMBER OF OTHER CONFERENCE OR METHODIST DENOMINATION (OE)
4935 - OF - OTHER NON-METHODIST DENOMINATION (OF)
4936 - OP - PM SERVING OTHER CONFER (OP)
4937 - OR - RETIRED MEMBER OTHER CONFERENCE (OR)
4938 - PD - PROVISIONAL DEACON (PD)
4939 - PE - PROVISIONAL ELDER (PE)
4940 - PL - PART TIME LOCAL PASTOR (PL)
4941 - RA - RETIRED ASSOC MEMBER (AM) (RA)
4942 - RD - RETIRED DEACON INFULL CONNECTION (RD)
4943 - RE - RETIRED ELDER (RE)
4944 - RL - RETIRED LOCAL PASTOR (LP) (RL)
20369 - RL* - RETIRED LOCAL PASTOR -serving (RL)
4945 - RP - RETIRED PROVISIONAL MEMBER (PM) (RP)
4946 - SY - SUPPLIED/HIRED/ASSIGNED (SY)
 
Formula
Visible
PlaceholderServiceTime
 
switch(ServiceTimeAtTimeOfFiling){
    case 4957:
        //Full Time (FT)
        1;
        break;
    case 50684:
        //80%
        0.8;
        break;
    case 4956:
        //Three Quarters (3/4)
        0.75;
        break;
    case 4955:
        //One Half (1/2)
        0.5;
        break;
    case 4954:
        //One Quarter
        0.25;
        break;
    case 50687:
        //One Third (1/3)
        0.333;
        break;
    case 50686:
        //Two Thirds (2/3)
        0.666;
        break;
    case 50685:
        //Forty Percent (0.4)
        0.4;
        break;
    case 50688:
        //Eighty Percent (0.8)
        0.8;
        break;
    default: 
        0;
        break;
}
Formula
Visible
PlanCompensation
 
//PlanCompensation



if(CompensationTags == 19939){
    //has parsonage
    Math.round(TotalSalaryValue * 1.25)
} else {
    // anything other than parsonage
    Math.round(TotalSalaryValue)
}

FE, PE, FD, PD, OE, OP, OD, FL, PL, AM

@* let amt = 0; if(ConferenceServing == 44312){ amt = TotalSalaryValue } else if(ConferenceServing == 44311 || ConferenceServing == 44310){ amt = TotalCashCompensation } *@
Show/Hide
Invisible
PreTaxPip
 
PreTaxPipPercent == 32762
Show/Hide
Invisible
RothContributions
 
RothContributionsPercent == 32762
Show/Hide
Visible
SalaryDatesInfo
 
ConferenceServing == 44310 || ConferenceServing == 44311
Show/Hide
Visible
SalaryDatesInfoOI
 
ConferenceServing == 44312
Constant
Visible
StatusesLayPastor
 
[4930,35212]
DOUBLE CHECK WHEN ADDING THIS FORM
Constant
Visible
StatusesMODClergy
 
[4935]
DOUBLE CHECK WHEN ADDING THIS FORM
Constant
Visible
StatusesRetiredClergy
 
[4941,4943,20369]
CORRECT
  • Retired Clergy statuses: the reg form names RL, but there are 2 RL categories in BRT: RL (LP-RL) and RL* (serving). Which is the correct one? RL* IS THE CORRECT ONE, FIXED
  • I couldn’t find Retired Member of Other Denomination in the clergy statuses. Someone needs to match it for me. WE WON'T USE THIS ON THE FORM
Constant
Visible
StatusesUMClergy
 
[4921,4927,4928,4938,4939,4929]
CORRECT
Show/Hide
Visible
TestingField
 
false
Formula
Visible
TotalBenefitCosts
 
//TotalBenefitCosts


ChargeChurchPremiumForGroupHealthInsurance
+
ChargeChurchPremiumForGroupHealthInsuranceOF
+
CRSPCostToChurch
+
CRSPCostToChurchOF
+
CPPCostToChurch
+
CPPCostToChurchOF
+
ChurchContributionToUMPIP
+
ChurchContributionToUMPIPOF
+
ChurchContributionToUMLifeOption
+
OptionalBenefitsAmount
4920 - AF - AFFIL MEMB (AF)
23548 - AL - ADMINISTRATIVE LOCATION (AL)
4921 - AM - ASSOC MEMB (AM)
4922 - BH - BISHOP (BH)
4923 - CC - CERTIFIED CANDIDATE (CC)
4924 - DC - DEACONESS (DC)
43931 - DC* - DEACONESS retired (DC)
4925 - DM - DIACONAL MIN (DM)
4926 - DR - RETIRED DIACONAL MINISTER (DR)
4927 - FD - DEACON IN FULL CONN (FD)
4928 - FE - ELDER IN FULL CONN (FE)
4929 - FL - FULL TIME LOCAL PASTOR (FL)
17738 - HL - HONORABLE LOCATION (HL)
17739 - HR - HONORABLE LOCATION RETIRED (HR)
4930 - LM - CERTIFIED LAY MINISTER (LM)
35212 - LM* - CERTIFIED LAY MINISTER-serving (LM)
17740 - NC - NO LONGER CLERGY (NC)
4931 - NL - LOCAL PASTOR (APPROVED, BUT NOT APPOINTED) (NL)
4932 - OA - ASSOC OTHER CONFERENCE (OA)
4933 - OD - DEACON MEMBER OF OTHER CONFERENCE OR METHODIST DENOMINATION (OD)
4934 - OE - ELDER MEMBER OF OTHER CONFERENCE OR METHODIST DENOMINATION (OE)
4935 - OF - OTHER NON-METHODIST DENOMINATION (OF)
4936 - OP - PM SERVING OTHER CONFER (OP)
4937 - OR - RETIRED MEMBER OTHER CONFERENCE (OR)
4938 - PD - PROVISIONAL DEACON (PD)
4939 - PE - PROVISIONAL ELDER (PE)
4940 - PL - PART TIME LOCAL PASTOR (PL)
4941 - RA - RETIRED ASSOC MEMBER (AM) (RA)
4942 - RD - RETIRED DEACON INFULL CONNECTION (RD)
4943 - RE - RETIRED ELDER (RE)
4944 - RL - RETIRED LOCAL PASTOR (LP) (RL)
20369 - RL* - RETIRED LOCAL PASTOR -serving (RL)
4945 - RP - RETIRED PROVISIONAL MEMBER (PM) (RP)
4946 - SY - SUPPLIED/HIRED/ASSIGNED (SY)
 
Show/Hide
Invisible
TotalBenefitCosts
 
//TotalBenefitCosts

let statusesOH  = [ 4928 , 4939 , 4927 , 4938 , 4934 , 4936 , 4933 , 4929 , 4940 , 4921 , 4941 , 4943 , 4942 , 20369 , 4937 ];
let statusesAK  = [ 4928 , 4939 , 4927 , 4938 , 4934 , 4936 , 4933 , 4929 , 4940 , 4921 , 4941 , 4943 , 4942 , 20369 , 4937 , 35212 , 4946 ];
let statusesPNW = [ 4928 , 4939 , 4927 , 4938 , 4934 , 4936 , 4933 , 4929 , 4940 , 4921 , 4941 , 4943 , 4942 , 20369 , 4937 , 35212 , 4946 ];

(
    ConferenceServing == 44312 && [4957, 50684, 4956, 50824, 4955, 50686].includes(ServiceTimeAtTimeOfFiling) //OR at half time or more
    &&
    (
        (statusesOH.includes(ClergyStatusAtTimeOfFiling))
        ||
        (ClergyStatusAtTimeOfFiling == 4935 && !NeedGroupHealthInsurance)
    )
)
||
(
    ConferenceServing == 44310 && ServiceTimeAtTimeOfFiling == 4957 //AK
    &&
    (
        (statusesAK.includes(ClergyStatusAtTimeOfFiling))
        ||
        (ClergyStatusAtTimeOfFiling == 4935 && !NeedGroupHealthInsurance)
    )
)
||
(
    ConferenceServing == 44311 && ServiceTimeAtTimeOfFiling == 4957 //PNW
    &&
    (
        (statusesPNW.includes(ClergyStatusAtTimeOfFiling))
        ||
        (ClergyStatusAtTimeOfFiling == 4935 && !NeedGroupHealthInsurance)
    )
)
This variable was deactivated on 8/23 because Linda believes the field should be visible to everyone. I'm keeping it "alive" just in case, since it's a somewhat complex formula.


4920 - AF - AFFIL MEMB (AF)
23548 - AL - ADMINISTRATIVE LOCATION (AL)
4921 - AM - ASSOC MEMB (AM)
4922 - BH - BISHOP (BH)
4923 - CC - CERTIFIED CANDIDATE (CC)
4924 - DC - DEACONESS (DC)
43931 - DC* - DEACONESS retired (DC)
4925 - DM - DIACONAL MIN (DM)
4926 - DR - RETIRED DIACONAL MINISTER (DR)
4927 - FD - DEACON IN FULL CONN (FD)
4928 - FE - ELDER IN FULL CONN (FE)
4929 - FL - FULL TIME LOCAL PASTOR (FL)
17738 - HL - HONORABLE LOCATION (HL)
17739 - HR - HONORABLE LOCATION RETIRED (HR)
4930 - LM - CERTIFIED LAY MINISTER (LM)
35212 - LM* - CERTIFIED LAY MINISTER-serving (LM)
17740 - NC - NO LONGER CLERGY (NC)
4931 - NL - LOCAL PASTOR (APPROVED, BUT NOT APPOINTED) (NL)
4932 - OA - ASSOC OTHER CONFERENCE (OA)
4933 - OD - DEACON MEMBER OF OTHER CONFERENCE OR METHODIST DENOMINATION (OD)
4934 - OE - ELDER MEMBER OF OTHER CONFERENCE OR METHODIST DENOMINATION (OE)
4935 - OF - OTHER NON-METHODIST DENOMINATION (OF)
4936 - OP - PM SERVING OTHER CONFER (OP)
4937 - OR - RETIRED MEMBER OTHER CONFERENCE (OR)
4938 - PD - PROVISIONAL DEACON (PD)
4939 - PE - PROVISIONAL ELDER (PE)
4940 - PL - PART TIME LOCAL PASTOR (PL)
4941 - RA - RETIRED ASSOC MEMBER (AM) (RA)
4942 - RD - RETIRED DEACON INFULL CONNECTION (RD)
4943 - RE - RETIRED ELDER (RE)
4944 - RL - RETIRED LOCAL PASTOR (LP) (RL)
20369 - RL* - RETIRED LOCAL PASTOR -serving (RL)
4945 - RP - RETIRED PROVISIONAL MEMBER (PM) (RP)
4946 - SY - SUPPLIED/HIRED/ASSIGNED (SY)
 
Show/Hide
Invisible
TotalCashCompensation
 
ConferenceServing == 44310 || ConferenceServing == 44311
Formula
Invisible
TotalCashCompensation
 
//TotalCashCompensation

BaseSalary
+
UtilityExclusion
+
HousingAllowance
Show/Hide
Visible
TotalCashSalary
 
ConferenceServing == 44310 || ConferenceServing == 44311
Formula
Visible
TotalCashSalary
 
//TotalCashSalary (AK or PNW only)

let amt = BaseSalary + UtilityExclusion

if(ConferenceServing == 44310 || ConferenceServing == 44311){
    // AK or PNW
    if(amt > MinimumCashComp){
        amt
    } else {
        MinimumCashComp
    }
}
Formula
Invisible
TotalCompensation
 
//TotalCompensation

let housing = 0;
if(CompensationTags == 19939){
    //has parsonage
    housing = BaseSalary * 0.25;
} else if(CompensationTags == 19938) {
    //housing allowance
    housing = BaseSalary + HousingAllowance;
}

BaseSalary
+
housing
+
UtilityExclusion
NEW FORMULA, DOUBLE CHECK
Formula
Visible
TotalCostForTotalAppointmentTime
 
//TotalCostForTotalAppointmentTime

TotalSalaryValue
+
AccountableReimbursement
+
TotalBenefitCosts
should be right
Formula
Visible
TotalSalaryValue
 
//TotalSalaryValue

BaseSalary
+
UtilityExclusion
+
HousingAllowance
//TotalSalaryValue if(ConferenceServing == 15030){ //Oregon-Idaho if(CompensationTags == 19939){ //has parsonage BaseSalary + UtilityExclusion } else if(CompensationTags == 19938) { //housing allowance BaseSalary + UtilityExclusion + HousingAllowance } } else if (ConferenceServing == 15029){ // PNW BaseSalary + UtilityExclusion } else if (ConferenceServing == 15065){ //Alaska BaseSalary } else { 0 }
Show/Hide
Invisible
TotalSalaryValue
 
ConferenceServing == 44312
Show/Hide
Visible
UMPIPForMatch
 
//UMPIPForMatch

let statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921];

ConferenceServing == 44311 && 
(
    ([35212,4946].includes(ClergyStatusAtTimeOfFiling) && ServiceTimeAtTimeOfFiling == 4957) //full time LM*/SY
    ||
    (statuses.includes(ClergyStatusAtTimeOfFiling) && ServiceTimeAtTimeOfFiling != 4957) //certain statuses at less than full time
    ||
    (ClergyStatusAtTimeOfFiling == 4935 && ServiceTimeAtTimeOfFiling != 4957) //OF at less than full time unless waived
)
THIS SHOULD BE CORRECT
Show/Hide
Visible
UMPIPPercentage
 
//UMPIPPercentage


ConferenceServing == 44311 
&& 
UMPIPForMatch 

//&& 
//ClergyStatusAtTimeOfFiling == 4935 
//&& 
//ServiceTimeAtTimeOfFiling != 4957
THIS IS CORRECT
Validation
Visible
UMPIPPercentage
 
UMPIPPercentage <= 2
Show/Hide
Visible
UMPIPPercentInfo
 
UMPIPPercentage > 2
Show/Hide
Visible
UtilityExclusion
 
ClergyStatusAtTimeOfFiling != 35212 && ClergyStatusAtTimeOfFiling != 4946
Show/Hide
Visible
YearsInAppointments
 
ConferenceServing == 44310
Comp 2023 - mid-year appointment change Click green hover fields to copy
Filing dates 2/6/2023 to: 12/31/2023
Comp dates 7/1/2023 to: 12/31/2023
Splits
BaseSalary,BaseSalary,Number UtilityExclusion,UtilityExclusion,Number HousingAllowance,HousingAllowance,Number TotalSalaryValue,TotalSalaryValue,Number AccountableReimbursement,AccountableReimbursement,Number ChargeChurchPremiumForGroupHealthInsurance,ChargeChurchPremiumForGroupHealthInsurance,Number ChargeChurchPremiumForGroupHealthInsuranceOF,ChargeChurchPremiumForGroupHealthInsuranceOF,Number CRSPCostToChurch,CRSPCostToChurch,Number CRSPCostToChurchOF,CRSPCostToChurchOF,Number CPPCostToChurch,CPPCostToChurch,Number CPPCostToChurchOF,CPPCostToChurchOF,Number ChurchContributionToUMPIP,ChurchContributionToUMPIP,Number ChurchContributionToUMPIPOF,ChurchContributionToUMPIPOF,Number ChurchContributionToUMLifeOption,ChurchContributionToUMLifeOption,Number
Approval stages
Submitter,District,Conference
Report fields
ConferenceServing,People.FirstName,People.LastName,ClergyStatusAtTimeOfFiling,ServiceTimeAtTimeOfFiling,DateOfChargeConference,PubDate,SalarySourceConference,BaseSalary,UtilityExclusion,TotalCashSalary,CompensationTags,HousingAllowance,ParsonageFairValue,TotalSalaryValue,PlanCompensation,CRSPDC,CRSPDB,CRSPCostToChurch,CRSPCostToChurchOF,CPPCostToChurch,CPPCostToChurchOF,ChargeChurchPremiumForGroupHealthInsurance,ChargeChurchPremiumForGroupHealthInsuranceOF,ChurchContributionToUMPIP,ChurchContributionToUMPIPOF,ChurchContributionToUMLifeOption,OptionalBenefitsAmount,TotalBenefitCosts,AccountableReimbursement,TotalCostForTotalAppointmentTime,Notes,SignatureDistrict,SignaturePastor,SignatureLocalChurchRep,Church.Name,Charges.Name,ExtensionMinistryList.Name,SalarySourceConference,SalaryBreakdown.Church.Name,SalaryBreakdown.ExtensionMinistryList.Name,SalaryBreakdown.BaseSalary,SalaryBreakdown.UtilityExclusion,SalaryBreakdown.HousingAllowance,SalaryBreakdown.TotalSalaryValue,SalaryBreakdown.AccountableReimbursement,SalaryBreakdown.ChargeChurchPremiumForGroupHealthInsurance,SalaryBreakdown.ChargeChurchPremiumForGroupHealthInsuranceOF,SalaryBreakdown.CRSPCostToChurch,SalaryBreakdown.CRSPCostToChurchOF,SalaryBreakdown.CPPCostToChurch,SalaryBreakdown.CPPCostToChurchOF,SalaryBreakdown.ChurchContributionToUMPIP,SalaryBreakdown.ChurchContributionToUMPIPOF,SalaryBreakdown.ChurchContributionToUMLifeOption 
<View Id="Comp2022" TableId="Content" Inherits="ClergyCompForm"><Fields><Category Id="Category" Default="Comp2022" Invisible="true" /></Fields></View>
Redirect to: https://gnw-gnw.brtsite.com/peopleportal/compensation
Scripts
<script src="https://gnw-gnw.brtsite.com/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,
	fieldset[data-id="Pips"] legend,
	fieldset[data-id="Insurance"] legend,
	div[data-fieldid="PlaceholderServiceTime"],
	/*div[data-fieldid="PlanCompensation"],*/
	div[data-fieldid="CompCheckAgainstMinimum"],
	div[data-fieldid="MinimumCashComp"],
	div[data-fieldid="MinimumAchieved"],
	div[data-fieldid="ServiceTimeAtTimeOfFiling"] li[data-value="23553"],
	div[data-fieldid="ServiceTimeAtTimeOfFiling"] li[data-value="19746"],
	div[data-fieldid="ConferenceServing"] li[data-value="44441"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="4920"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="23548"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="4922"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="4923"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="4924"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="43931"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="4925"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="4926"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="17738"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="17739"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="4930"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="4931"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="17740"],
	div[data-fieldid="ClergyStatusAtTimeOfFiling"] li[data-value="4944"],
	div[data-fieldid="SalarySourceConference"] li[data-value="44441"]
	{
		display:none;
	} 
	div[data-fieldid="MinimumCashComp"] .input-block-level,
	div[data-fieldid="PlanCompensation"] .input-block-level,
	div[data-fieldid="TotalSalaryValue"] .input-block-level,
	div[data-fieldid="TotalCashSalary"] .input-block-level,
	div[data-fieldid="TotalCashCompensation"] .input-block-level,
	div[data-fieldid="CRSPDB"] .input-block-level,
	div[data-fieldid="CRSPDC"] .input-block-level,
	div[data-fieldid="CPPCostToChurch"] .input-block-level,
	div[data-fieldid="CRSPCostToChurch"] .input-block-level,
	div[data-fieldid="ChargeChurchPremiumForGroupHealthInsurance"] .input-block-level,
	div[data-fieldid="ChurchContributionToUMPIP"] .input-block-level,
	div[data-fieldid="ChurchContributionToUMLifeOption"] .input-block-level,
	div[data-fieldid="TotalBenefitCosts"] .input-block-level,
	div[data-fieldid="TotalCostForTotalAppointmentTime"] .input-block-level
	{
	    border-color: transparent;
	}
	div[data-fieldid="CRSPDC"],
	div[data-fieldid="CRSPDB"] {
	    display: flex;
        align-items: center;
        margin-top: -20px;
	}
	div[data-fieldid="CRSPDC"] .controls input,
	div[data-fieldid="CRSPDB"] .controls input {
	    margin-bottom: 5px;
	}
	div[data-fieldid="CRSPDC"] .control-label,
	div[data-fieldid="CRSPDC"] .controls input,
	div[data-fieldid="CRSPDB"] .control-label,
	div[data-fieldid="CRSPDB"] .controls input {
	    font-size: 12px;
	}
</style>
Show/Hide
Invisible
AfterTaxPip
 
AfterTaxPipPercent == 32762
Constant
Invisible
AllStatuses

4920 - AF - AFFIL MEMB (AF)
23548 - AL - ADMINISTRATIVE LOCATION (AL)
4921 - AM - ASSOC MEMB (AM)
4922 - BH - BISHOP (BH)
4923 - CC - CERTIFIED CANDIDATE (CC)
4924 - DC - DEACONESS (DC)
43931 - DC* - DEACONESS retired (DC)
4925 - DM - DIACONAL MIN (DM)
4926 - DR - RETIRED DIACONAL MINISTER (DR)
4927 - FD - DEACON IN FULL CONN (FD)
4928 - FE - ELDER IN FULL CONN (FE)
4929 - FL - FULL TIME LOCAL PASTOR (FL)
17738 - HL - HONORABLE LOCATION (HL)
17739 - HR - HONORABLE LOCATION RETIRED (HR)
4930 - LM - CERTIFIED LAY MINISTER (LM)
35212 - LM* - CERTIFIED LAY MINISTER-serving (LM)
17740 - NC - NO LONGER CLERGY (NC)
4931 - NL - LOCAL PASTOR (APPROVED, BUT NOT APPOINTED) (NL)
4932 - OA - ASSOC OTHER CONFERENCE (OA)
4933 - OD - DEACON MEMBER OF OTHER CONFERENCE OR METHODIST DENOMINATION (OD)
4934 - OE - ELDER MEMBER OF OTHER CONFERENCE OR METHODIST DENOMINATION (OE)
4935 - OF - OTHER NON-METHODIST DENOMINATION (OF)
4936 - OP - PM SERVING OTHER CONFER (OP)
4937 - OR - RETIRED MEMBER OTHER CONFERENCE (OR)
4938 - PD - PROVISIONAL DEACON (PD)
4939 - PE - PROVISIONAL ELDER (PE)
4940 - PL - PART TIME LOCAL PASTOR (PL)
4941 - RA - RETIRED ASSOC MEMBER (AM) (RA)
4942 - RD - RETIRED DEACON INFULL CONNECTION (RD)
4943 - RE - RETIRED ELDER (RE)
4944 - RL - RETIRED LOCAL PASTOR (LP) (RL)
20369 - RL* - RETIRED LOCAL PASTOR -serving (RL)
4945 - RP - RETIRED PROVISIONAL MEMBER (PM) (RP)
4946 - SY - SUPPLIED/HIRED/ASSIGNED (SY)
 
Show/Hide
Invisible
BenefitsInfo
 
//TotalBenefitCosts

let statusesOH  = [ 4928 , 4939 , 4927 , 4938 , 4934 , 4936 , 4933 , 4929 , 4940 , 4921 , 4941 , 4943 , 4942 , 20369 , 4937 ];
let statusesAK  = [ 4928 , 4939 , 4927 , 4938 , 4934 , 4936 , 4933 , 4929 , 4940 , 4921 , 4941 , 4943 , 4942 , 20369 , 4937 , 35212 , 4946 ];
let statusesPNW = [ 4928 , 4939 , 4927 , 4938 , 4934 , 4936 , 4933 , 4929 , 4940 , 4921 , 4941 , 4943 , 4942 , 20369 , 4937 , 35212 , 4946 ];

(
    ConferenceServing == 44312 && [4957, 4956].includes(ServiceTimeAtTimeOfFiling)
    &&
    (
        (statusesOH.includes(ClergyStatusAtTimeOfFiling))
        ||
        (ClergyStatusAtTimeOfFiling == 4935 && !NeedGroupHealthInsurance)
    )
)
||
(
    ConferenceServing == 44310 && ServiceTimeAtTimeOfFiling == 4957
    &&
    (
        (statusesAK.includes(ClergyStatusAtTimeOfFiling))
        ||
        (ClergyStatusAtTimeOfFiling == 4935 && !NeedGroupHealthInsurance)
    )
)
||
(
    ConferenceServing == 44311 && ServiceTimeAtTimeOfFiling == 4957
    &&
    (
        (statusesPNW.includes(ClergyStatusAtTimeOfFiling))
        ||
        (ClergyStatusAtTimeOfFiling == 4935 && !NeedGroupHealthInsurance)
    )
)
Show/Hide
Invisible
ChargeChurchAmountInfo
 
NeedGroupHealthInsurance && ClergyStatusAtTimeOfFiling == 4935 && ConferenceServing == 44312
Show/Hide
Visible
ChargeChurchPremiumForGroupHealthInsurance
 
let statuses;
let serviceTime;
let confs = [44312,44311,44310];

if(ConferenceServing == 44312){ //Oregon
    statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921,4941,4943,4942,20369,4937];
    serviceTime = [4957,4956,50684];
} else if(ConferenceServing == 44311 || ConferenceServing == 44310){ //PNW or AK
    statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921,4941,4943,4942,20369,4937,35212,4946];
    serviceTime = [4957];
}

(confs.includes(ConferenceServing) && serviceTime.includes(ServiceTimeAtTimeOfFiling) && statuses.includes(ClergyStatusAtTimeOfFiling)) ||
(NeedGroupHealthInsurance && ClergyStatusAtTimeOfFiling == 4935)
let statuses;
let serviceTime;
let confs = [44312,44311,44310];

if(ConferenceServing == 44312){ //Oregon
    statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921,4941,4943,4942,20369,4937];
    serviceTime = [4957,4956,50684];
} else if(ConferenceServing == 44311 || ConferenceServing == 44310){ //PNW or AK
    statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921,4941,4943,4942,20369,4937,35212,4946];
    serviceTime = [4957];
}

confs.includes(ConferenceServing) && serviceTime.includes(ServiceTimeAtTimeOfFiling) && statuses.includes(ClergyStatusAtTimeOfFiling)
Formula
Visible
ChargeChurchPremiumForGroupHealthInsurance
 
//ChargeChurchPremiumForGroupHealthInsurance

let statusesOH  = [ 4928 , 4939 , 4927 , 4938 , 4934 , 4936 , 4933 , 4929 , 4940 , 4921 , 4941 , 4943 , 4942 , 20369 , 4937 ];
let statusesAK  = [ 4928 , 4939 , 4927 , 4938 , 4934 , 4936 , 4933 , 4929 , 4940 , 4921 , 4941 , 4943 , 4942 , 20369 , 4937 , 35212 , 4946 ];
let statusesPNW = [ 4928 , 4939 , 4927 , 4938 , 4934 , 4936 , 4933 , 4929 , 4940 , 4921 , 4941 , 4943 , 4942 , 20369 , 4937 , 35212 , 4946 ];

if(ConferenceServing == 44312 && [4957,4956,50684].includes(ServiceTimeAtTimeOfFiling)){ //OR at 3/4 or full time
    if(
        (statusesOH.includes(ClergyStatusAtTimeOfFiling))
        ||
        (ClergyStatusAtTimeOfFiling == 4935 && !NeedGroupHealthInsurance)
    ){
        14400
    }
} else if(ConferenceServing == 44310 && ServiceTimeAtTimeOfFiling == 4957){ //AK at full time
    if(
        (statusesAK.includes(ClergyStatusAtTimeOfFiling))
        ||
        (ClergyStatusAtTimeOfFiling == 4935 && NeedGroupHealthInsurance)
    ){
        16200
    }
} else if(ConferenceServing == 44311 && ServiceTimeAtTimeOfFiling == 4957){ //PNW at full time
    if(
        (statusesPNW.includes(ClergyStatusAtTimeOfFiling))
        ||
        (ClergyStatusAtTimeOfFiling == 4935 && !NeedGroupHealthInsurance)
    ){
        8400
    }
} else {
    0
}
Show/Hide
Visible
ChargeChurchPremiumForGroupHealthInsuranceOF
 
//ChargeChurchPremiumForGroupHealthInsuranceOF

let statuses;
let serviceTime;
let confs = [44312,44311,44310];

if(ConferenceServing == 44312){ //Oregon
    statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921,4941,4943,4942,20369,4937];
    serviceTime = [4957,4956,50684];
} else if(ConferenceServing == 44311 || ConferenceServing == 44310){ //PNW or AK
    statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921,4941,4943,4942,20369,4937,35212,4946];
    serviceTime = [4957];
}

confs.includes(ConferenceServing) &&
serviceTime.includes(ServiceTimeAtTimeOfFiling) &&
ClergyStatusAtTimeOfFiling == 4935 &&
!NeedGroupHealthInsurance
//ChargeChurchPremiumForGroupHealthInsuranceOF

let statuses;
let serviceTime;
let confs = [44312,44311,44310];

if(ConferenceServing == 44312){ //Oregon
    statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921,4941,4943,4942,20369,4937];
    serviceTime = [4957,4956,50684];
} else if(ConferenceServing == 44311 || ConferenceServing == 44310){ //PNW or AK
    statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921,4941,4943,4942,20369,4937,35212,4946];
    serviceTime = [4957];
}

confs.includes(ConferenceServing) && 
serviceTime.includes(ServiceTimeAtTimeOfFiling) && 
ClergyStatusAtTimeOfFiling == 4935 && 
!NeedGroupHealthInsurance
Show/Hide
Visible
ChurchContributionToUMLifeOption
 
let statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921]; // does not include OF
let halfUp = [4955,50824,4956,50684]; // 1/2, 0.6, 3/4, 0.8

(
    ConferenceServing == 44311 &&
    (
        ([35212,4946].includes(ClergyStatusAtTimeOfFiling) && ServiceTimeAtTimeOfFiling ==4957) //LM* and SY at full time
        ||
        (statuses.includes(ClergyStatusAtTimeOfFiling) && halfUp.includes(ServiceTimeAtTimeOfFiling)) // statuses at 1/2, 0.6, 3/4, 0.8 service time
    )
)
||
(
    ConferenceServing == 44310 && statuses.includes(ClergyStatusAtTimeOfFiling) && halfUp.includes(ServiceTimeAtTimeOfFiling)
)
Formula
Visible
ChurchContributionToUMLifeOption
 
//ChurchContributionToUMLifeOption

let statuses = [4928,4939,4927,4938,4934,4936,4933,4921]; // does not include OF, FL
let halfUp = [4955,50824,4956,50684]; // 1/2, 0.6, 3/4, 0.8

if(
    (
        ConferenceServing == 44311 &&
        (
            ([35212,4946].includes(ClergyStatusAtTimeOfFiling) && ServiceTimeAtTimeOfFiling ==4957) //LM* and SY at full time
            ||
            (statuses.includes(ClergyStatusAtTimeOfFiling) && halfUp.includes(ServiceTimeAtTimeOfFiling)) // statuses at 1/2, 0.6, 3/4, 0.8 service time
        )
    )
    ||
    (
        ConferenceServing == 44310 && statuses.includes(ClergyStatusAtTimeOfFiling) && halfUp.includes(ServiceTimeAtTimeOfFiling)
    )
){
    PlanCompensation * 0.022
}
12/1 - per Linda Grund-Clampit:
  • Since FT isn't included, we can remove FL   - YES
  • You said that PL should be removed - YES
  • 2/3 time is missing (if it's anything above 50%, but not including FT) – let’s not add that at this time anyway.  I don’t believe they use that time and I don’t want to upset any other formulas!
  • Do you want to keep the OE, OD and OP?  YES


Statuses:
AM 4921, FD 4927, FE 4928, FL 4929, PD 4938, PE 4939, PL 4940, OE 4934, OD 4933, OP 4936 (no OF)
Service times:
½ 4955,  0.6 50824, ¾ 4956, 0.8 50684
PNW also includes LM serving and SY at full time
Plan Compensation * 0.022
 
Show/Hide
Visible
ChurchContributionToUMPIP
 
//ChurchContributionToUMPIP

let statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921]; // does not include OF


ConferenceServing == 44311 &&
(
    //OF not full time who does not need coverage
    (ClergyStatusAtTimeOfFiling == 4935 && ServiceTimeAtTimeOfFiling != 4957 && OFNeedUMPIP) 
    ||
    //several statuses less than full time
    (statuses.includes(ClergyStatusAtTimeOfFiling) && ServiceTimeAtTimeOfFiling != 4957) 
    ||
    //LM* or SY at full time
    ((ClergyStatusAtTimeOfFiling == 35212 || ClergyStatusAtTimeOfFiling == 4946) && ServiceTimeAtTimeOfFiling == 4957) 
)
Formula
Visible
ChurchContributionToUMPIP
 
//ChurchContributionToUMPIP

let match = PlanCompensation * (UMPIPPercentage / 100);
if(match >= (PlanCompensation * 0.02)){
    match = PlanCompensation * 0.02;
}

let statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921]; // does not include OF
let halfUp = [4955,50824,4956,50684]; // 1/2, 0.6, 3/4, 0.8
let halfDown = [50688,4954,50687,50685]; // 0.2, 1/4, 1/3, 0.4

if(ConferenceServing == 44311){
    if(
        ([35212,4946].includes(ClergyStatusAtTimeOfFiling) && ServiceTimeAtTimeOfFiling == 4957) //LM* and SY at full time
        ||
        (statuses.includes(ClergyStatusAtTimeOfFiling) && halfUp.includes(ServiceTimeAtTimeOfFiling)) // statuses at 1/2, 0.6, 3/4, 0.8 service time
        || 
        (ClergyStatusAtTimeOfFiling == 4935 && halfUp.includes(ServiceTimeAtTimeOfFiling) && OFNeedUMPIP) // OF needs UMPIP coverage - 0.5, 0.6, 0.75, 0.8 service time
    ){
        if(UMPIPForMatch){
            (PlanCompensation * 0.08) + match
        } else {
            PlanCompensation * 0.08
        }
    } else if (
        (statuses.includes(ClergyStatusAtTimeOfFiling) && halfDown.includes(ServiceTimeAtTimeOfFiling)) // statuses at 0.2, 1/4, 1/3, 0.4 service time
        ||
        (ClergyStatusAtTimeOfFiling == 4935 && OFNeedUMPIP && halfDown.includes(ServiceTimeAtTimeOfFiling)) // OF not waived UMPIP coverage - 0.2, 1/4, 1/3, 0.4 service time
    ) {
       if(UMPIPForMatch){
            (PlanCompensation * 0.06) + match
        } else {
            PlanCompensation * 0.06
        } 
    }
} else {
    0
}
edited on 220510 
(ServiceTimeAtTimeOfFiling == 4956 || ServiceTimeAtTimeOfFiling == 4955) //1/2 and 3/4

[35212,4946].includes(ClergyStatusAtTimeOfFiling) //LM* and SY

ServiceTimeAtTimeOfFiling ==4957 //full time

Statuses
4921,4928,4927,4939,4938,4934,4936,4933,4929,4940
AM, FE, FD, PE, PD, OE, OP, OD, FL, PL

4935 = OF

Times
4955,50824,4956,50684
1/2, 0.6, 3/4, 0.8

50688,4954,50687,50685
0.2, 1/4, 1/3, 0.4

NOT WAIVED: OFNeedUMPIP = true
Show/Hide
Visible
ChurchContributionToUMPIPOF
 
ConferenceServing == 44311 && ClergyStatusAtTimeOfFiling == 4935 && ServiceTimeAtTimeOfFiling != 4957 && !OFNeedUMPIP
Validation
Visible
CompCheckAgainstMinimum
 
if(ConferenceServing == 44310 || ConferenceServing == 44311){
    // AK or PNW
    if(![4941,4943,4942,20369,4937,4946,35212].includes(ClergyStatusAtTimeOfFiling)){ //IF NOT RETIRED  //RA, RE, RD, RL*, OR, SY, LM*
        CompCheckAgainstMinimum <= TotalCashSalary
    } else {
        true
    }
} else if(ConferenceServing == 44312) {
    if(![4941,4943,4942,20369,4937,4946,35212].includes(ClergyStatusAtTimeOfFiling)){ //IF NOT RETIRED  //RA, RE, RD, RL*, OR, SY, LM*
        CompCheckAgainstMinimum >= MinimumCashComp
    } else {
        true
    }
}
Edited on 8/23/22, originally formula was simply
CompCheckAgainstMinimum >= MinimumCashComp
(which it seems that it was the opposite of what it needed to be)




 
Formula
Visible
CompCheckAgainstMinimum
 
//CompCheckAgainstMinimum

//let checkAmt;

if(ConferenceServing == 44312){ //Oregon
    BaseSalary + UtilityExclusion + HousingAllowance;
} else if(ConferenceServing == 44311 || ConferenceServing == 44310){ //PNW or AK
    BaseSalary + UtilityExclusion;
}
Show/Hide
Visible
CompensationTags
 
ClergyStatusAtTimeOfFiling != 35212 //LM*
&&
ClergyStatusAtTimeOfFiling != 4946 //SY


//&& PensionAbleServiceTimes.includes(ServiceTimeAtTimeOfFiling)
Corrected on 220510
All statuses except LM* and SY, at any service time
Formula
Visible
CPPCostToChurch
 
//CPPCostToChurch

let statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921];
let serviceTime;
let thisAmt = PlanCompensation * 0.03;

if(thisAmt >= 4573.26){
   thisAmt = 4573.26;
}


if(ConferenceServing == 44312 || ConferenceServing == 44310){ //Oregon or Alaska
    serviceTime = [4956,50684,4957]; //3/4 and above
} else { //PNW and others
    serviceTime = [4957]; //only full time
}

if(serviceTime.includes(ServiceTimeAtTimeOfFiling)){
    if(statuses.includes(ClergyStatusAtTimeOfFiling) || (NeedCPP && ClergyStatusAtTimeOfFiling == 4935)){
        if(ConferenceServing == 44312){ //Oregon
            PlanCompensation * 0.03
        } else if(ConferenceServing == 44311 || ConferenceServing == 44310){ //PNW or AK
            thisAmt
        }
    }
}
FE, PE, FD, PD, OE, OP, OD, FL, PL, AM (not LM*/SY and not retired statuses)
Housing/parsonage already accounted for in the PlanCompensation calculation.
Show/Hide
Visible
CPPCostToChurch
 
//CPPCostToChurch

let statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921];
let serviceTime;

if(ConferenceServing == 44312){ //Oregon
    serviceTime = [4956,50684,4957]; //3/4 and above
} else {
    serviceTime = [4957]; //only full time
}

(serviceTime.includes(ServiceTimeAtTimeOfFiling) && statuses.includes(ClergyStatusAtTimeOfFiling))
||
(NeedCPP && ClergyStatusAtTimeOfFiling == 4935)
Show/Hide
Visible
CPPCostToChurchOF
 
//CPPCostToChurchOF

let statuses;
let serviceTime;

if(ConferenceServing == 44312){ //Oregon
    statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921,4941,4943,4942,20369,4937];
    serviceTime = [4957,4956,50684];
} else if(ConferenceServing == 44311 || ConferenceServing == 44310){ //PNW or AK
    statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921,4941,4943,4942,20369,4937,35212,4946];
    serviceTime = [4957];
}

serviceTime.includes(ServiceTimeAtTimeOfFiling) &&
ClergyStatusAtTimeOfFiling == 4935 &&
!NeedCPP
Formula
Visible
CRSPCostToChurch
 
//CRSPCostToChurch

let statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921];
let eligibleStatus = false;

if((statuses.includes(ClergyStatusAtTimeOfFiling)) || (ClergyStatusAtTimeOfFiling == 4935 && NeedCRSP)){
    eligibleStatus = true;
}

if(eligibleStatus){
    if(ConferenceServing == 44312 && [50686,4955,4956,50684,4957].includes(ServiceTimeAtTimeOfFiling)){ //OR at 1/2 or above
        PlanCompensation * 0.13
    } else if(ConferenceServing == 44310 && [50686,4955,4956,50684,4957].includes(ServiceTimeAtTimeOfFiling)){ //AK at 1/2 or above
        PlanCompensation * 0.03
    } else if(ConferenceServing == 44311 && ServiceTimeAtTimeOfFiling == 4957){ //PNW at full time
        (PlanCompensation * 0.03) + 5200
    }
} else {
    0
}


/*
let serviceTime;

if(ConferenceServing == 44312 || ConferenceServing == 44310){ //Oregon or Alaska
    serviceTime = [50686,4955,4956,50684,4957]; //1/2 and above
} else { //PNW and others
    serviceTime = [4957]; //only full time
}

if(serviceTime.includes(ServiceTimeAtTimeOfFiling)){
    if(statuses.includes(ClergyStatusAtTimeOfFiling) || (NeedCRSP && ClergyStatusAtTimeOfFiling == 4935)){
        if(ConferenceServing == 44312){ //Oregon
            PlanCompensation * 0.13
        } else if(ConferenceServing == 44311){ //PNW
            (PlanCompensation * 0.03) + 5700
        } else if(ConferenceServing == 44310) { //AK
            PlanCompensation * 0.03
        }
    }
}
*/

11/28/2022 calculation was updated for PNW - the addition of $5,700 was changed to $5,200. 


FE, PE, FD, PD, OE, OP, OD, FL, PL, AM (not LM*/SY and not retired statuses)

Housing/parsonage already accounted for in the PlanCompensation calculation. 
if(serviceTime.includes(ServiceTimeAtTimeOfFiling) && statuses.includes(ClergyStatusAtTimeOfFiling)){
    if(ConferenceServing == 44312){ //Oregon
        PlanCompensation * 0.13
    } else if(ConferenceServing == 44311){ //PNW
        (PlanCompensation * 0.03) + 5700
    } else if(ConferenceServing == 44310) { //AK
        PlanCompensation * 0.03
    }
}

  1. CRSP (calculated as percentage of plan compensation)

    1. Plan compensation (dependent on housing tag)

      1. With parsonage, plan compensation = Total Salary (3.f.) * 1.25

      2. With housing allowance, plan compensation = Total Salary (3.f.)

    2. Oregon-Idaho

      1. applies to ½ time to full-time appointments (does not apply to ¼ time)

      2. applies to FE, PE, FD, PD, OE, OP, OD, FL, PL, AM (not LM*/SY and not retired statuses)

      3. AND applies to OF (other non-Methodist denomination) unless they waive coverage because they are enrolled in another plan through their denomination.

        1. if so, need to ask amount of that other plan which will be billed to the church/charge

      4. amount = Plan Compensation X 0.13

    3. PNW  

      1. applies only to full-time appointments

      2. applies to FE, PE, FD, PD, OE, OP, OD, FL, PL, AM (not LM*/SY and not retired statuses)

      3. AND applies to OF (other non-Methodist denomination) unless they waive coverage because they are enrolled in another plan through their denomination.

        1. if so, need to ask amount of that other plan which will be billed to the church/charge

      4. amount = (Plan compensation x 0.03) + $5,700

    4. Alaska 

      1. applies to ½ time to full-time appointments

      2. applies to FE, PE, FD, PD, OE, OP, OD, FL, PL, AM (not LM*/SY and not retired statuses)

      3. AND applies to OF (other non-Methodist denomination) unless they waive coverage because they are enrolled in another plan through their denomination.

        1. if so, need to ask amount of that other plan which will be billed to the church/charge

      4. amount = Plan compensation X 0.03
Show/Hide
Visible
CRSPCostToChurch
 
let statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921];
let serviceTime;

if(ConferenceServing == 44312 || ConferenceServing == 44310){ //Oregon or Alaska
    serviceTime = [50686,4955,4956,50684,4957]; //1/2 and above
} else {
    serviceTime = [4957]; //only full time
}

(serviceTime.includes(ServiceTimeAtTimeOfFiling) && statuses.includes(ClergyStatusAtTimeOfFiling))
||
(NeedCRSP && ClergyStatusAtTimeOfFiling == 4935)


/*
//===================

//POSSIBLE SOLUTION IN CASE ABOVE IS WRONG

(([4928,4939,4927,4938,4934,4936,4933,4929,4940,4921].includes(ClergyStatusAtTimeOfFiling)) || (ClergyStatusAtTimeOfFiling == 4935 && !NeedCRSP))
&&
(
    (ConferenceServing == 44312 && [50686,4955,4956,50684,4957].includes(ServiceTimeAtTimeOfFiling))
    ||
    (ConferenceServing == 44310 && ServiceTimeAtTimeOfFiling == 4957)
    ||
    (ConferenceServing == 44311 && ServiceTimeAtTimeOfFiling == 4957)
)
*/
Show/Hide
Visible
CRSPCostToChurchOF
 
//CRSPCostToChurchOF

let statuses;
let serviceTime;

if(ConferenceServing == 44312){ //Oregon
    statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921,4941,4943,4942,20369,4937];
    serviceTime = [50686,4955,4956,50684,4957]; //1/2 and above
} else if(ConferenceServing == 44311 || ConferenceServing == 44310){ //PNW or AK
    statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921,4941,4943,4942,20369,4937,35212,4946];
    serviceTime = [4957];
}

serviceTime.includes(ServiceTimeAtTimeOfFiling) &&
ClergyStatusAtTimeOfFiling == 4935 &&
!NeedCRSP
Formula
Visible
CRSPDB
 
if(ConferenceServing == 44310){
    0
} else if(ConferenceServing == 44311) {
    5200
}
Show/Hide
Visible
CRSPDB
 
let statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921];
let serviceTime;

if(ConferenceServing == 44312 || ConferenceServing == 44310){ //Oregon or Alaska
    serviceTime = [50686,4955,4956,50684,4957]; //1/2 and above
} else {
    serviceTime = [4957]; //only full time
}

(ConferenceServing == 44310 || ConferenceServing == 44311) && ( // not Oregon
    (serviceTime.includes(ServiceTimeAtTimeOfFiling) && statuses.includes(ClergyStatusAtTimeOfFiling))
    ||
    (NeedCRSP && ClergyStatusAtTimeOfFiling == 4935)
)
Edited on 8/23, originally was
(ConferenceServing == 44310 || ConferenceServing == 44311) && ServiceTimeAtTimeOfFiling == 4957
Show/Hide
Visible
CRSPDC
 
let statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921];
let serviceTime;

if(ConferenceServing == 44312 || ConferenceServing == 44310){ //Oregon or Alaska
    serviceTime = [50686,4955,4956,50684,4957]; //1/2 and above
} else {
    serviceTime = [4957]; //only full time
}
(ConferenceServing == 44310 || ConferenceServing == 44311) && ( // not Oregon
    (serviceTime.includes(ServiceTimeAtTimeOfFiling) && statuses.includes(ClergyStatusAtTimeOfFiling))
    ||
    (NeedCRSP && ClergyStatusAtTimeOfFiling == 4935)
)
Edited on 8/23, originally was
(ConferenceServing == 44310 || ConferenceServing == 44311) && ServiceTimeAtTimeOfFiling == 4957
Formula
Visible
CRSPDC
 
//CRSPDC

PlanCompensation * 0.03
Show/Hide
Visible
GeographicalAreas
 
ConferenceServing == 44310
Show/Hide
Visible
HousingAllowance
 
CompensationTags == 19938 && ClergyStatusAtTimeOfFiling != 35212 && ClergyStatusAtTimeOfFiling != 4946
Show/Hide
Visible
HousingInfo
 
CompensationTags == 49928
Show/Hide
Visible
HousingTags
 
ClergyStatusAtTimeOfFiling != 35212 && ClergyStatusAtTimeOfFiling != 4946
Formula
Visible
MinimumCashComp
 
//MinimumCashComp

let statuses = [4941,4943,4942,20369,4937,4946,35212];
let multiplier;

switch(GeographicalAreas){
    case 50769: //anchorage
        multiplier = 0;
        break;
        
    case 50770: //Fairbanks
        multiplier = 6;
        break;
        
    case 50771: //Juneau
        multiplier = 13;
        break;
        
    case 50772: //Girdwood
        multiplier = 8;
        break;
        
    case 50773: //Kenai Peninsula
        multiplier = 16;
        break;
        
    case 50774: //Homer
        multiplier = 15;
        break;
        
    case 50775: //Ketchikan
        multiplier = 9;
        break;
        
    case 50776: //Nome
        multiplier = 46;
        break;
        
    case 50777: //Sitka
        multiplier = 9;
        break;
        
    case 50778: //Unalaska
        multiplier = 68;
        break;
        
    case 50779: //Wasilla
        multiplier = 3;
        break;
        
    case 50780: //Willow
        multiplier = 12;
        break;
        
    default: //no answer
        multiplier = 0;
        break;
}

if(ConferenceServing == 44312){ //Oregon
    if([4928,4927,4921,4934,4935,4932,4933].includes(ClergyStatusAtTimeOfFiling)){
        //Elders and Deacons in full connection / associate members
        if(CompensationTags == 19938){
            //housing allowance
            65439 * PlaceholderServiceTime
        } else {
            // anything other than housing allowance
            47390 * PlaceholderServiceTime
        }
    } else if ([4938,4939,4936].includes(ClergyStatusAtTimeOfFiling)){
        //Provisional Elders and Deacons
        if(CompensationTags == 19938){
            //housing allowance
            62168 * PlaceholderServiceTime
        } else {
            // anything other than housing allowance
            45020 * PlaceholderServiceTime
        }
    } else if ([4929,4940].includes(ClergyStatusAtTimeOfFiling)){
        //Local Pastors 
        if(CompensationTags == 19938){
            //housing allowance
            59060 * PlaceholderServiceTime
        } else {
            // anything other than housing allowance
            42770 * PlaceholderServiceTime
        }
    } else {
        0
    }
} else if(ConferenceServing == 44311 && !statuses.includes(ClergyStatusAtTimeOfFiling)){ //PNW
    //For all clergy statuses except retired and CLM/SY = $46,400
    46400 * PlaceholderServiceTime
} else if(ConferenceServing == 44310 && !statuses.includes(ClergyStatusAtTimeOfFiling)) {//AK
    //For all clergy statuses except retired and CLM/SY =  $48,800 + $200 per year 
    //lapsed service year since date of initial appointment as a pastor + Area-Cost-of-Living 
    //Adjustment Percentage
    ((48800 + (200*YearsInAppointments)) + ((48800 + (200*YearsInAppointments)) * (multiplier / 100))) * PlaceholderServiceTime
} else {
    0
}
4927 - FD
4928 - FE
4921 - AM

4938 - PD
4939 - PE

4929 - FL

============

15030 - OR
15029 - PNW
15065 - Alaska

============

        //if(ConferenceServing == 15030){
        //    Oregon-Idaho
        //    BaseSalary + UtilityExclusion
        //}
Show/Hide
Visible
MinimumCashComp
 
//MinimumCashComp

let statuses = [4941,4943,4942,20369,4937,4946,35212]; //RA, RE, RD, RL*, OR, SY, LM*

(ConferenceServing == 44312 && [4928,4927,4921,4934,4935,4932,4933,4938,4939,4936,4929,4940].includes(ClergyStatusAtTimeOfFiling)) //OR
||
(ConferenceServing == 44311 && !statuses.includes(ClergyStatusAtTimeOfFiling)) //PNW
||
(ConferenceServing == 44310 && !statuses.includes(ClergyStatusAtTimeOfFiling)) //AK
Show/Hide
Invisible
MinimumNotAchieved
 
//MinimumNotAchieved

CompCheckAgainstMinimum > MinimumCashComp
Show/Hide
Visible
NeedCPP
 
ClergyStatusAtTimeOfFiling == 4935 && 
(
    (ConferenceServing == 44312 && PensionAbleServiceTimes.includes(ServiceTimeAtTimeOfFiling)) 
    || 
    ((ConferenceServing == 44311 || ConferenceServing == 44310) && ServiceTimeAtTimeOfFiling == 4957)    
)
Show/Hide
Visible
NeedCRSP
 
ClergyStatusAtTimeOfFiling == 4935 && 
(
    (ConferenceServing == 44312 && [50686,50684,50824,4955,4956,4957].includes(ServiceTimeAtTimeOfFiling)) //OR
    || 
    (ConferenceServing == 44311 && ServiceTimeAtTimeOfFiling == 4957) // PNW
    ||
    (ConferenceServing == 44310 && [50686,50684,50824,4955,4956,4957].includes(ServiceTimeAtTimeOfFiling)) //AK
)
Show/Hide
Visible
NeedGroupHealthInsurance
 
ClergyStatusAtTimeOfFiling == 4935 && 
(
    (ConferenceServing == 44312 && PensionAbleServiceTimes.includes(ServiceTimeAtTimeOfFiling)) 
    || 
    ((ConferenceServing == 44311 || ConferenceServing == 44310) && ServiceTimeAtTimeOfFiling == 4957)    
)
Show/Hide
Visible
OFNeedUMPIP
 
//OFNeedUMPIP

ConferenceServing == 44311 && ServiceTimeAtTimeOfFiling != 4957 && ClergyStatusAtTimeOfFiling == 4935
Show/Hide
Visible
OptionalBenefits
 
ConferenceServing == 44312
Show/Hide
Visible
OptionalBenefitsAmount
 
ConferenceServing == 44312 && OptionalBenefits
Show/Hide
Visible
OptionalBenefitsType
 
ConferenceServing == 44312 && OptionalBenefits
Show/Hide
Visible
ParsonageFairValue
 
CompensationTags == 19939 && ConferenceServing == 44312
Constant
Visible
PensionAbleServiceTimes
 
[4957,4956,50684]
3/4 and above
Constant
Visible
PensionAbleStatuses
 
[4928,4939,4921,4929,47683,4927,4938,4934,4935]
COPIED FROM WI, DOUBLE CHECK WITH LINDA
4928 - FE
4939 - PE
4921 - AM
4929 - FL


4920 - AF - AFFIL MEMB (AF)
23548 - AL - ADMINISTRATIVE LOCATION (AL)
4921 - AM - ASSOC MEMB (AM)
4922 - BH - BISHOP (BH)
4923 - CC - CERTIFIED CANDIDATE (CC)
4924 - DC - DEACONESS (DC)
43931 - DC* - DEACONESS retired (DC)
4925 - DM - DIACONAL MIN (DM)
4926 - DR - RETIRED DIACONAL MINISTER (DR)
4927 - FD - DEACON IN FULL CONN (FD)
4928 - FE - ELDER IN FULL CONN (FE)
4929 - FL - FULL TIME LOCAL PASTOR (FL)
17738 - HL - HONORABLE LOCATION (HL)
17739 - HR - HONORABLE LOCATION RETIRED (HR)
4930 - LM - CERTIFIED LAY MINISTER (LM)
35212 - LM* - CERTIFIED LAY MINISTER-serving (LM)
17740 - NC - NO LONGER CLERGY (NC)
4931 - NL - LOCAL PASTOR (APPROVED, BUT NOT APPOINTED) (NL)
4932 - OA - ASSOC OTHER CONFERENCE (OA)
4933 - OD - DEACON MEMBER OF OTHER CONFERENCE OR METHODIST DENOMINATION (OD)
4934 - OE - ELDER MEMBER OF OTHER CONFERENCE OR METHODIST DENOMINATION (OE)
4935 - OF - OTHER NON-METHODIST DENOMINATION (OF)
4936 - OP - PM SERVING OTHER CONFER (OP)
4937 - OR - RETIRED MEMBER OTHER CONFERENCE (OR)
4938 - PD - PROVISIONAL DEACON (PD)
4939 - PE - PROVISIONAL ELDER (PE)
4940 - PL - PART TIME LOCAL PASTOR (PL)
4941 - RA - RETIRED ASSOC MEMBER (AM) (RA)
4942 - RD - RETIRED DEACON INFULL CONNECTION (RD)
4943 - RE - RETIRED ELDER (RE)
4944 - RL - RETIRED LOCAL PASTOR (LP) (RL)
20369 - RL* - RETIRED LOCAL PASTOR -serving (RL)
4945 - RP - RETIRED PROVISIONAL MEMBER (PM) (RP)
4946 - SY - SUPPLIED/HIRED/ASSIGNED (SY)
 
Formula
Visible
PlaceholderServiceTime
 
switch(ServiceTimeAtTimeOfFiling){
    case 4957:
        //Full Time (FT)
        1;
        break;
    case 50684:
        //80%
        0.8;
        break;
    case 4956:
        //Three Quarters (3/4)
        0.75;
        break;
    case 4955:
        //One Half (1/2)
        0.5;
        break;
    case 4954:
        //One Quarter
        0.25;
        break;
    case 50687:
        //One Third (1/3)
        0.333;
        break;
    case 50686:
        //Two Thirds (2/3)
        0.666;
        break;
    case 50685:
        //Forty Percent (0.4)
        0.4;
        break;
    case 50688:
        //Eighty Percent (0.8)
        0.8;
        break;
    default: 
        0;
        break;
}
Formula
Visible
PlanCompensation
 
//PlanCompensation



if(CompensationTags == 19939){
    //has parsonage
    Math.round(TotalSalaryValue * 1.25)
} else {
    // anything other than parsonage
    Math.round(TotalSalaryValue)
}

FE, PE, FD, PD, OE, OP, OD, FL, PL, AM

@* let amt = 0; if(ConferenceServing == 44312){ amt = TotalSalaryValue } else if(ConferenceServing == 44311 || ConferenceServing == 44310){ amt = TotalCashCompensation } *@
Show/Hide
Invisible
PreTaxPip
 
PreTaxPipPercent == 32762
Show/Hide
Invisible
RothContributions
 
RothContributionsPercent == 32762
Show/Hide
Visible
SalaryDatesInfo
 
ConferenceServing == 44310 || ConferenceServing == 44311
Show/Hide
Visible
SalaryDatesInfoOI
 
ConferenceServing == 44312
Constant
Visible
StatusesLayPastor
 
[4930,35212]
DOUBLE CHECK WHEN ADDING THIS FORM
Constant
Visible
StatusesMODClergy
 
[4935]
DOUBLE CHECK WHEN ADDING THIS FORM
Constant
Visible
StatusesRetiredClergy
 
[4941,4943,20369]
CORRECT
  • Retired Clergy statuses: the reg form names RL, but there are 2 RL categories in BRT: RL (LP-RL) and RL* (serving). Which is the correct one? RL* IS THE CORRECT ONE, FIXED
  • I couldn’t find Retired Member of Other Denomination in the clergy statuses. Someone needs to match it for me. WE WON'T USE THIS ON THE FORM
Constant
Visible
StatusesUMClergy
 
[4921,4927,4928,4938,4939,4929]
CORRECT
Show/Hide
Visible
TestingField
 
false
Formula
Visible
TotalBenefitCosts
 
//TotalBenefitCosts


ChargeChurchPremiumForGroupHealthInsurance
+
ChargeChurchPremiumForGroupHealthInsuranceOF
+
CRSPCostToChurch
+
CRSPCostToChurchOF
+
CPPCostToChurch
+
CPPCostToChurchOF
+
ChurchContributionToUMPIP
+
ChurchContributionToUMPIPOF
+
ChurchContributionToUMLifeOption
+
OptionalBenefitsAmount
4920 - AF - AFFIL MEMB (AF)
23548 - AL - ADMINISTRATIVE LOCATION (AL)
4921 - AM - ASSOC MEMB (AM)
4922 - BH - BISHOP (BH)
4923 - CC - CERTIFIED CANDIDATE (CC)
4924 - DC - DEACONESS (DC)
43931 - DC* - DEACONESS retired (DC)
4925 - DM - DIACONAL MIN (DM)
4926 - DR - RETIRED DIACONAL MINISTER (DR)
4927 - FD - DEACON IN FULL CONN (FD)
4928 - FE - ELDER IN FULL CONN (FE)
4929 - FL - FULL TIME LOCAL PASTOR (FL)
17738 - HL - HONORABLE LOCATION (HL)
17739 - HR - HONORABLE LOCATION RETIRED (HR)
4930 - LM - CERTIFIED LAY MINISTER (LM)
35212 - LM* - CERTIFIED LAY MINISTER-serving (LM)
17740 - NC - NO LONGER CLERGY (NC)
4931 - NL - LOCAL PASTOR (APPROVED, BUT NOT APPOINTED) (NL)
4932 - OA - ASSOC OTHER CONFERENCE (OA)
4933 - OD - DEACON MEMBER OF OTHER CONFERENCE OR METHODIST DENOMINATION (OD)
4934 - OE - ELDER MEMBER OF OTHER CONFERENCE OR METHODIST DENOMINATION (OE)
4935 - OF - OTHER NON-METHODIST DENOMINATION (OF)
4936 - OP - PM SERVING OTHER CONFER (OP)
4937 - OR - RETIRED MEMBER OTHER CONFERENCE (OR)
4938 - PD - PROVISIONAL DEACON (PD)
4939 - PE - PROVISIONAL ELDER (PE)
4940 - PL - PART TIME LOCAL PASTOR (PL)
4941 - RA - RETIRED ASSOC MEMBER (AM) (RA)
4942 - RD - RETIRED DEACON INFULL CONNECTION (RD)
4943 - RE - RETIRED ELDER (RE)
4944 - RL - RETIRED LOCAL PASTOR (LP) (RL)
20369 - RL* - RETIRED LOCAL PASTOR -serving (RL)
4945 - RP - RETIRED PROVISIONAL MEMBER (PM) (RP)
4946 - SY - SUPPLIED/HIRED/ASSIGNED (SY)
 
Show/Hide
Invisible
TotalBenefitCosts
 
//TotalBenefitCosts

let statusesOH  = [ 4928 , 4939 , 4927 , 4938 , 4934 , 4936 , 4933 , 4929 , 4940 , 4921 , 4941 , 4943 , 4942 , 20369 , 4937 ];
let statusesAK  = [ 4928 , 4939 , 4927 , 4938 , 4934 , 4936 , 4933 , 4929 , 4940 , 4921 , 4941 , 4943 , 4942 , 20369 , 4937 , 35212 , 4946 ];
let statusesPNW = [ 4928 , 4939 , 4927 , 4938 , 4934 , 4936 , 4933 , 4929 , 4940 , 4921 , 4941 , 4943 , 4942 , 20369 , 4937 , 35212 , 4946 ];

(
    ConferenceServing == 44312 && [4957, 50684, 4956, 50824, 4955, 50686].includes(ServiceTimeAtTimeOfFiling) //OR at half time or more
    &&
    (
        (statusesOH.includes(ClergyStatusAtTimeOfFiling))
        ||
        (ClergyStatusAtTimeOfFiling == 4935 && !NeedGroupHealthInsurance)
    )
)
||
(
    ConferenceServing == 44310 && ServiceTimeAtTimeOfFiling == 4957 //AK
    &&
    (
        (statusesAK.includes(ClergyStatusAtTimeOfFiling))
        ||
        (ClergyStatusAtTimeOfFiling == 4935 && !NeedGroupHealthInsurance)
    )
)
||
(
    ConferenceServing == 44311 && ServiceTimeAtTimeOfFiling == 4957 //PNW
    &&
    (
        (statusesPNW.includes(ClergyStatusAtTimeOfFiling))
        ||
        (ClergyStatusAtTimeOfFiling == 4935 && !NeedGroupHealthInsurance)
    )
)
This variable was deactivated on 8/23 because Linda believes the field should be visible to everyone. I'm keeping it "alive" just in case, since it's a somewhat complex formula.


4920 - AF - AFFIL MEMB (AF)
23548 - AL - ADMINISTRATIVE LOCATION (AL)
4921 - AM - ASSOC MEMB (AM)
4922 - BH - BISHOP (BH)
4923 - CC - CERTIFIED CANDIDATE (CC)
4924 - DC - DEACONESS (DC)
43931 - DC* - DEACONESS retired (DC)
4925 - DM - DIACONAL MIN (DM)
4926 - DR - RETIRED DIACONAL MINISTER (DR)
4927 - FD - DEACON IN FULL CONN (FD)
4928 - FE - ELDER IN FULL CONN (FE)
4929 - FL - FULL TIME LOCAL PASTOR (FL)
17738 - HL - HONORABLE LOCATION (HL)
17739 - HR - HONORABLE LOCATION RETIRED (HR)
4930 - LM - CERTIFIED LAY MINISTER (LM)
35212 - LM* - CERTIFIED LAY MINISTER-serving (LM)
17740 - NC - NO LONGER CLERGY (NC)
4931 - NL - LOCAL PASTOR (APPROVED, BUT NOT APPOINTED) (NL)
4932 - OA - ASSOC OTHER CONFERENCE (OA)
4933 - OD - DEACON MEMBER OF OTHER CONFERENCE OR METHODIST DENOMINATION (OD)
4934 - OE - ELDER MEMBER OF OTHER CONFERENCE OR METHODIST DENOMINATION (OE)
4935 - OF - OTHER NON-METHODIST DENOMINATION (OF)
4936 - OP - PM SERVING OTHER CONFER (OP)
4937 - OR - RETIRED MEMBER OTHER CONFERENCE (OR)
4938 - PD - PROVISIONAL DEACON (PD)
4939 - PE - PROVISIONAL ELDER (PE)
4940 - PL - PART TIME LOCAL PASTOR (PL)
4941 - RA - RETIRED ASSOC MEMBER (AM) (RA)
4942 - RD - RETIRED DEACON INFULL CONNECTION (RD)
4943 - RE - RETIRED ELDER (RE)
4944 - RL - RETIRED LOCAL PASTOR (LP) (RL)
20369 - RL* - RETIRED LOCAL PASTOR -serving (RL)
4945 - RP - RETIRED PROVISIONAL MEMBER (PM) (RP)
4946 - SY - SUPPLIED/HIRED/ASSIGNED (SY)
 
Show/Hide
Invisible
TotalCashCompensation
 
ConferenceServing == 44310 || ConferenceServing == 44311
Formula
Invisible
TotalCashCompensation
 
//TotalCashCompensation

BaseSalary
+
UtilityExclusion
+
HousingAllowance
Show/Hide
Visible
TotalCashSalary
 
ConferenceServing == 44310 || ConferenceServing == 44311
Formula
Visible
TotalCashSalary
 
//TotalCashSalary (AK or PNW only)

let amt = BaseSalary + UtilityExclusion

if(ConferenceServing == 44310 || ConferenceServing == 44311){
    // AK or PNW
    if(amt > MinimumCashComp){
        amt
    } else {
        MinimumCashComp
    }
}
Formula
Invisible
TotalCompensation
 
//TotalCompensation

let housing = 0;
if(CompensationTags == 19939){
    //has parsonage
    housing = BaseSalary * 0.25;
} else if(CompensationTags == 19938) {
    //housing allowance
    housing = BaseSalary + HousingAllowance;
}

BaseSalary
+
housing
+
UtilityExclusion
NEW FORMULA, DOUBLE CHECK
Formula
Visible
TotalCostForTotalAppointmentTime
 
//TotalCostForTotalAppointmentTime

TotalSalaryValue
+
AccountableReimbursement
+
TotalBenefitCosts
should be right
Formula
Visible
TotalSalaryValue
 
//TotalSalaryValue

BaseSalary
+
UtilityExclusion
+
HousingAllowance
//TotalSalaryValue if(ConferenceServing == 15030){ //Oregon-Idaho if(CompensationTags == 19939){ //has parsonage BaseSalary + UtilityExclusion } else if(CompensationTags == 19938) { //housing allowance BaseSalary + UtilityExclusion + HousingAllowance } } else if (ConferenceServing == 15029){ // PNW BaseSalary + UtilityExclusion } else if (ConferenceServing == 15065){ //Alaska BaseSalary } else { 0 }
Show/Hide
Invisible
TotalSalaryValue
 
ConferenceServing == 44312
Show/Hide
Visible
UMPIPForMatch
 
//UMPIPForMatch

let statuses = [4928,4939,4927,4938,4934,4936,4933,4929,4940,4921];

ConferenceServing == 44311 && 
(
    ([35212,4946].includes(ClergyStatusAtTimeOfFiling) && ServiceTimeAtTimeOfFiling == 4957) //full time LM*/SY
    ||
    (statuses.includes(ClergyStatusAtTimeOfFiling) && ServiceTimeAtTimeOfFiling != 4957) //certain statuses at less than full time
    ||
    (ClergyStatusAtTimeOfFiling == 4935 && ServiceTimeAtTimeOfFiling != 4957) //OF at less than full time unless waived
)
THIS SHOULD BE CORRECT
Show/Hide
Visible
UMPIPPercentage
 
//UMPIPPercentage


ConferenceServing == 44311 
&& 
UMPIPForMatch 

//&& 
//ClergyStatusAtTimeOfFiling == 4935 
//&& 
//ServiceTimeAtTimeOfFiling != 4957
THIS IS CORRECT
Validation
Visible
UMPIPPercentage
 
UMPIPPercentage <= 2
Show/Hide
Visible
UMPIPPercentInfo
 
UMPIPPercentage > 2
Show/Hide
Visible
UtilityExclusion
 
ClergyStatusAtTimeOfFiling != 35212 && ClergyStatusAtTimeOfFiling != 4946
Show/Hide
Visible
YearsInAppointments
 
ConferenceServing == 44310