Agmt11 Bartel Associates, LLC - Laserfiche WebLink

Browse Search

Mr. Brian 1"'"), January 13, 2011 Page 3 • All quarterly and annual trust statements received from Ca1PERS CERBT. • Contributions and dates made and expected to be made for 2009/10 and 2010/11. • Active and retired participant data in electronic format (Excel workbook): • Active Data - name, employee number, gender, birth date, hire date, medical plan, single /2- party/family coverage, Ca1PERS pension plan (Miscellaneous, Police, Fire), total Ca1PERS agency service (if available), employee classification (full -time or part- time), bargaining or employee group, and annual PERSable compensation. Indicate the pay period for the compensation reported. Include any active employees who have waived healthcare coverage. Note if hours for part-time employees are less than 20 hours per week. • Retiree Data - name, employee number, gender, birth date, hire date, retirement type (service retirement, disability retirement, surviving spouse), retirement date, medical plan, single /2- party/family coverage, Ca1PERS pension plan (Miscellaneous, Police, Fire), bargaining or employee group, spouse's birth date (if available), portion of premium paid by the City, and portion of premium paid by the retiree. Include any retirees or surviving spouses of retirees who have waived coverage. • The City may request a copy of its Ca1PERS PEMHCA database by downloading and submitting the Ca1PERS "GASB 45 Data Extract Request and Non - Disclosure Agreement" and the "GASB 45 Data Extract Receiving Party Sending Electronic Information Agreement" from the Ca1PERS website. This data extract may be helpful to the City in assembling the requested employee census information, including retirees who waived coverage. If the City wants us to use the Ca1PERS data extract for the valuation, it should (1) add PERSable compensation to each active record, (2) add bargaining unit or employee group to each active and retiree record if results are needed by employee group, (3) remove any retirees who are not eligible to participate in the City's retiree healthcare plan, for example, if they did not retiree directly from the City, and (4) make any additions or deletions necessary to make the file current as of the valuation date. • In order to maintain confidentiality, do not provide Social Security numbers for the employee number. We will not accept any files that contain Social Security Numbers. • Our fee estimate assumes that the City will merge and reconcile all data files and provide one census file with one complete record for each employee and eligible retiree. If the City needs our help to merge and reconcile data, our fees will be higher. We may need additional data, depending on our review of the City's retiree medical plan design. Timing We are prepared to begin this project immediately. Normally, the valuation results meeting is set about 4- 6 weeks after receipt of the requested information and the City replies to any questions we may have after our initial review of the requested data. mnain :. • fax. , > . _ ...3 ` • web. z.