Election year field is blank in pm_benefit_election in Munis 2018.1 and later versions

Clients want to be able to select an election year based on enrollments.

• Munis 2018.1 and later versions

• SSRS reports

• Crystal reports

• SaaS, Tyler-hosted clients

• OnPrem, Self-hosted clients

• Benefits enrollments

With the introduction of campaigns in Munis version 2018.1 and later, a_election_year will be zero in the pm_benefit_election view. This is to allow multiple enrollment campaigns in the same year. 

Please see the query below on how to get enrollment records for all employees:

select B.a_projection,

B.a_employee_number,

E.Code, S.pmes_code,

S.pmes_seq,

S.pmes_short,

S.pmes_long,

B.be_section,

B.be_section_sequence,

B.be_election_choice,

B.be_choice,

B.be_election_status,

B.be_empe_cost,

B.be_premium from pmenrsec as S inner join BenefitsEnrollmentCampaigns as E

on S.pmes_campaign_id = E.Id

inner join pm_benefit_election as B on

S.pmes_seq = B.be_section_sequence

and B.a_projection = 0