tv Government Access Programming SFGTV November 17, 2017 12:00am-1:01am PST
16, a new business sign defined 602, within 200 feet of the city park and visible from the city park, shall be personal -- permitted if it meets the following requirements. i don't see a need to continue this item. i think everyone was notified. being that the language is clear, i will move forward with the first two amendments that i have stated on the record. so i would like to make a motion to amend for the first two amendments that i stated. >> a motion by supervisor kim as to the inclusion of other public agencies and to the language at page 4, line 20, painted or unpainted, and i'm reading this language again, i read it over
the weekend, at line 16, new business sign following requirements, fine by me. without objection, we'll send the item to the full board with recommendation. >> as amended? >> as amended? >> yes. >> thank you. >> we have two items left. madam clerk, can you call items 5 and 6 together, please? >> yes. 5 and 6 are resolution and hearing discussing and approving a the biannual housing report dated may 12, 2017. >> supervisor kim? >> thank you. i would like to continue this item to the land use committee of monday, november 27. many of our stake holders could not stay because of the length of the hearing and hopefully that it won't be continued as well, but if so, i will ask that the hearing be called prior.
>> ms. secretary please call roll call >> yes. thank you. roll call president trent scott present, lim here, breslin here, ferrigno, follansbee here, sass expected sheehy we have a quorum. >> thank you will take up action item 1. >> item one action item approval of the possible modifications of the minutes of the meeting set forth below. regular meeting of august 10, 2017, special close session of august 24, 2017. >> is there any discussion of the item by members of the board? hearing none, i'm ready to entertain a motion. >> moved approval >> second.
>> moving approval for both sets of minutes. we've done properly second. at the regular meeting minutes of we've done properly second. at the regular meeting minutes of august 10, 2017 special close session of august 24, 2017 the approved. is there any discussion? any public comment? seeing none, we are now ready to vote. all those in favor say, aye. [chorus of ayes.] opposed, nay. it carries unanimously >> [gavel] >> we are now ready to go to discussion item 2. >> thank you. item 2 discussion item, general public comment on matters within the board's jurisdiction not appearing on today's agenda. >> is there any public comment on any item on matters within the board's jurisdiction not on today's agenda? we have some public comments. >> my name is diane ehrlich
and the reason i'm here i use the benefit the best doctors and an excellent expense. the problem came with that coordination with kaiser. kaiser refused to give best doctors the fax number to fax the reports. i got a message when i came home one day about that. they were just fedex a me the report to give to my doctors. i would request that kaiser be asked to cooperate with a second opinion benefit we have. >> all right. thank you for the public comment and a last director griggs to make note of that. we will see if we can follow up to get a corrective action. discussion item 3. >> item three discussion item, presidents report get president scott. >> thank you. i have my report in part on my iphone. so this is going to be a very
interesting activity. the item i want to cover is the status of the executive director's search, which has been going on and what our next steps will be. the application process continues in full swing. i do want to stress that we will remain open for qualified applications right up until the time that we start down the list of final [inaudible] with candidates. there's always passive candidates in a search like this and the search firm has done an excellent job of following up on leads and having discussions with prospects. we welcome, as we said in several other times during the course of this process, if someone has a name of qualifications of someone you think would meet the qualifications published and posted on the website we welcome the opportunity to screen those candidates. as a reminder, everyone can provide
additional-remember the health service service system, will provide some input to the kind of capabilities and expectations that we might have for an executive director of the system. the survey that is on on you can participate in. i believe there's paper copies available as well. those who might be in the room. we are looking forward to receiving that input during the course of this process. as of yesterday we had 49 applicants for the position. as you heard, as we open the meeting we are close session on the 24th as you heard, as we open the meeting we are close session on 24 august at which time the board did some initial screening of candidates and we expect we will start the first of our screening interviews next-later this month on the 22nd. the search for consultant is working with some candidates to
see if they might be available for interviews on that date. the board has been solicited to determine if they have the time on their calendars and everyone thus far, has indicated they do. so, as we have gone forward to try to get more direct feedback , we have had meetings with various groups and most recently working with a past board member diligently we were able to pull together a meeting of seven retiree associations across the city and county of san francisco and the bay area, west bay, east bay, i should say as well. it was a very productive meeting for the portion that i attended. i excused myself so they might talk freely to the consultant and the feedback that i got is that it was very beneficial meeting and from the standpoint of her providing perspectives
the retirees are in a very unique position to provide to consultant as we begin taking a further look at these candidates. so publicly i want to thank [inaudible] for helping me get this organized. i know that she went off a little bit at the end of the last meeting and i've gone back with my [inaudible] to try to get a corrected and i think were on the right path here. so, again, it's critically important that people step forward and share your views. we are soliciting those who use from active as well as retired members in the system and as we get further into the process we think that will bear fruit as we find the appropriate person to provide executive leadership for the system. the other item that i want to highlight and i communicated to the board is that we have had a recent change in our senior actuarial
assignment. from aon hewitt. i knew [inaudible] will be leaving aon hewitt. we were told so, today i would like to some of the representatives from aon hewitt planning to speak to advise me the account executive is here, and can walk us through some of the steps of the transition. as they come, this is not an agenda item as my counsel has advised me good so we won't be resenting a lot of details about the change today. that will be taken up at a later meeting. but i did one for the general public and those present to be aware of the change and what we are planning to do going for. so, please. >> thank you president scott. i'm very pleased >> you are? >> sorry. i'm pleased to introduce you to make clerk
today was standing her to my left and i will let him speak a little bit about his background and discuss with you. >> all right. >> good afternoon >> one other thing i would encourage you today, you have to look like you are eating the microphone. you are particularly tall persons you may have to bend forward a little bit to be heard. >> i am mike clark with aon hewitt. i've coached well by and get thank you for the comments or. president scott and the board of commissioners, again my name is mike clark. i'm a 29 year veteran of aon hewitt i've been a health actuary the entire time. i'm a fellow of the society of actuaries. a member of the american academy of actuaries and a fellow of the conference of consulting actuaries. as you indicated mr. coach are is leaving the aon hewitt organization. i'm assuming his responsibilities as a lead actuary on our work with the health services system. i very
much look forward to working with all of you, including on behalf of your of your members as i carry forward in replacement of mr. coach are on the actuarial responsibilities. backed by my team, is not changing but i will be your new lead actuary. >> all right. and you have members your team here so would you take the time to introduce them? as the case may be. >> would you like them to come up? >> i like them for at least two stands of they can be recognized >> okay. so tom ricks, who is in actuary as well who supported mr. coach are in the past and will continue to support mike. todd--who is our west region practice leader for health and benefits is here today as well. rocky my tory, who will actually be presenting in a little bit about on the timeline as well. then, scott-- is here as well in attendance
why think many of you are familiar with. >> yes. a former board member. >> yes. former board member. >> it reminds me. [laughing]. well, thank you very much for this brief introduction today. as i said will have a more substantive conversation about the transition plan, your plans for support going forward. and, something else? >> also i just want to mention loni anderson is not in attendance today due to personal reasons and i know she wishes she could be here to see all of you but i do not want her to go without mention >> all right. thank you very much for that. neil is out of town speaking at a prior conference engagement and i've asked we reach out to him to have him come back for public recognition by this board for his service to us for the past number of years. so, we will
arrange for that to happen at a subsequent board meeting. are there any questions or comments from the board regarding the change? >> i just want to say that [inaudible] the fiduciary-i mean the actuary to remind ar a fiduciary to the members of the trust and that means work solely for the benefit of the members, and also we need transparency to the board which you know, we should note.. thank you. >> thank you. any other board comment? questions? is there any public comment on my reports? >> good afternoon board members. claire's on ski. ccsf. i just want to come forward and publicly thank you. commissioner scott, for your assistance for that meeting. i thought it went very well and
thought it was most productive and i think the retiree organization felt very good about being able to come forward and have that specific meeting. it is really great to see former commissioners scott -who still a commissioner in other commission-yes, civil service, right? but it's always good to see commissioner--here and to welcome the new team. i was just wondering also about page? is she still part of the team >> yes. >> so we just welcome them but i had to publicly thank you after i went off several times at prior meetings if i don't come forward and rectify that and it's not good. so, thank you again. >> thank you very much. any other public comment? hearing and see none will now move on to discussion item number four. >> item for discussion item, directors report. acting executive director griggs. >> good afternoon president scott and board members did i
want to do directors report today in remembering this is the end of our rates and benefits cycle. were going to end open enrollment at the next board meeting, or the next directors report will be strategizing about future plans for hss. i just want to recognize that and the amount of work that's put in to this process and again thanking the board for the vote of faith and having the act as executive director which appointed me in march. it's been a great experience during this rates and benefits in the cycle. >> there's other been some sidebars as well. >> yes. [laughing]. the directors for today will be kind of brief because as you'll see in your copies we are all about open enrollment right now and each one of our divisions is highlighted that that is what we are working on but i want to talk a little bit about the open positions and we are filling some of those position we were 1209, one pcs permanent
civil service position that we are opening and underway with recruitment. for open enrollment because we are expecting a busy open enrollment we decided to hire two temporary, 1209 benefit technicians to help us out with the technical work. we stole a lot of manual enrollment data entry type of processes review auditing aromas before we send them over to the health plans so we will have two temporary 1209's to help us without. all of our other permanent staff will be more available to help members face-to-face or on the phone or off-site this year which were doing plenty of those. we also have a 5320 which is an illustrator and art design or graphic designer, if you will. deposition has been open for a little bit. we've done some interviewing. were just about ready to make a candidate selection preparing an offer for that position. we also now that i've got the 5320
interviews done and work on the 1802, which is a research assistant which was very helpful. assessing the director prepare these reports especially in a legislative and federal regulation updates and stuff like that. so we are really looking for to fill in opposition and right now i'm looking on the job ad for that position. we are also cannabis 1694, we are going to select an intern from the citywide accounting intern program to help us work in a position that's technically not fillable at the time because of a leave of absence on opposition board hoping to select an intern to help out on the accounting and finance area. for operations, again we're gearing up for october which is very busy in the area and part of the preparation, there is just a lot of training. especially since we are introducing a new health plan that's blue shield trio. the question we are going to get, we build our questions that are frequently asked questions type of scripts and
stuff for the benefits analyst to answer these questions. and to train them in all the aspects as well as, we are enrolling of the sp implement in the bsp premier plan, which is on top of the basic plan. so we are doing a lot of training, as well as conjoin our training with our employee assistance program and recalled making it work it today we had our last one before open enrollment, which is managing ourselves and we are doing this type of making it work at work just to help people with workloads and the stress of doing something like large open enrollments we seem to be doing these days. to move onto the enterprise system, and analytics, and again a reminder a lot of this is about open enrollment as you know were doing a sub service pilot so there putting that altogether, developing a, working with our comptroller's office and the people in pay.
people that do the programming and office configuration. which is a whole lot of work. on top of that, as we prepare for the mailings and as we prepare for datafiles we sent out for enrollment there's a lot of test cases we have to do. we just don't program this entry these mailings and send them out. we do a lot of different scenarios and we look at them by hand going through and making sure they're accurate and correct before we send them out. again, all the open enrollments, lot of bandwidth and time is modifying our website which has becoming more and more important. people are looking to the web to get information. they want electronic, easy access, searchable, quick things so there's another-a lot of work especially happening right now as were getting to post these things. finance and accounting, as you can see some of the comments here that pamela our cfo has put in hip get the ssp
project, which came live july 1, it is working. occasionally we have some something we have to work through and get help on either through hr or the comptroller's office to correct, but as she's duly noted vendors are properly paid. so our bills are being paid. which is good. we are continuing efforts in calculating the medical and dental rates. again this is bear head load for the open enrollment is calculating all those different rates based on the mo you, based on the different plans the coverage levels etc. it's a lot of work. also, our audit right now is on schedule. ahead of schedule. everything is going well with that with rk pgm audit. with contracting and vendor management were working really hard and contracting with the consultants that we use. for open enrollment. were also just completed an agreement with lab communications group, which we
are- a citizen group to provide additional booklets. this is a strategy that i worked on stephanie fisher, our well-being manager, to do some type of communication we can have-given new hires for new retirees, so they can see that the well-being benefit we provide has dimension to it. when you have your medical plan your dental plan, but you have these benefits wrapped up in what were calling well-being. to communicate that and make sure people are aware of it and utilize it. it's very important so we have been working on this booklet to provide new hires and new retirees so they can go through these things and just like that can are benefic guides and see comparisons and types of benefits we provide. so were looking forward to when that is complete. in communications, again, very heavy with open enrollment could our new coming occasions venture started three having four days before last-minute show she's been here a little over four weeks now. has worked out very well.
she hit the ground running and been actually helpful especially tying up the ends of getting our benefit guides and open enrollment materials to the printer and to the mail house. she's very energetic. everyone enjoyed working with her >> issue here today? >> well, she asked if she could stay at work because running out of time. for open enrollment some deadlines were trying to meet >> her name is? >> her name is carol carini. i announced it last week that she had been hired but i will bring the rupp in november perhaps we can meet her in person. as fellows the well-being is concerned again some of the work we do and produce out there during open enrollment as many flu shot clinics. part of what they do in september is work with the champions and training them on these clinics, or how to access information to help us communicate that they are out there. we want as many people
to as possible to access those flu shots. again, some of our own well-being activities that were doing in august. we do special been at the wellness center at the catherine douglas wellness center which we call [inaudible] and everyone brings their favorite sets of recipes of salsa? about 56 participants. that's way more we had last year though so that was a successful campaign. some of the fewer of the meetings that-as acting director that i participated in and one of the meetings this past month was with brown and toland kumar are aco advisory meeting which brown and tolan is very important to us for 2018 particularly, with a blue shield trio implementation and getting there willingness to work with us on that. were very engaged. it was very collaborative meeting and went very well. they are project
managers on it just like we do for implementation and we had a very good discussion about communications. communications that should come from us, come from them and blue shield so it was one of the better meetings we've had with aco. the last thing which is not included in the director's report, which we just found out yesterday is that sb-17 which is the pharmacy transparency bill passed the state legislative has passed it. that is a bill that the health service for supported back in march this year. asking the mayor to support it as well. this particular bill ask drug companies-they would have to alert health insurers at least 60 days before they plan to increase the price of a drug if increases at least 16% over a two-year period. so it's a notification about increases.
they also is a requirement they have to say, why they are increasing it. again, this is about transparency and so one of our strategies going into 2018-2019 is looking is what we can do about extremely escalating pharmacy costs and this is good timing to start that. we talked lots and a lot of the meetings i go to. everyone talks about and try to expand the different types of pharmaceutical drugs, why they're so expensive. i was asked, okay, what do we do now and part of that is legislation. so were on the start without in california, certainly leading in that area. that's very good news. >> so the next step is the governor signature? >> the next up is the governor signature, correct. so were doing a presentation updating an open enrollment so i kept it short. because really that's a lot what we have to talk about so that is my directors report for this month >> any questions of the board of the executive director?
>> just thank you again for your work. we know you are doing two jobs and doing a great job. your customer service skills are excellent. so i thank you very much but i know it's not easy. >> thank you commissioner and present i appreciate it. >> i call every once in a while to make sure he showing up for work. [laughing]. any other comments from the board? >> yes. i would second our thanks for all the hard work and the clarity of this report. the question i have and maybe will be addressed later on the trio conversion, since you mentioned brown and tolan and the aco, a lot of members will call for an urgent advisor if you're told to go to the emergency room or urgent care. so are the brown toland staff as far as we can tell from the collaborative efforts, been educate about how to advise trio members-if they are trail and advised him where to go? because the instruction will be different >> right. so part of this meeting with advisor group
meeting we have which is semi annual. we had a quarterly aco meeting believe a semi annual with the leaders of the medical groups. and the aco's. so they were there at this particular meeting and i feel very assured they are being trained and talking to their staff about how to answer those questions and to know for this group where to send patients and later on in this meeting were also going to have an update on the trio implementation and jeanette-are blue shield executive account manager if you have anything further to comment on that you can do that at that time. >> i just have one more question. when we did the big transition to the medicare advantage healthcare had staff at hss to help out on the phones. maybe, is that possible for blue shield could also go do that? have one of their staff dedicated to the line to help our members. were going to get a lot of calls
>> right. we will reschedule that and put that into implementations they will be there he was one of the staff will be [inaudible] >> i think, too, perhaps. i think of her 2-3. >> two. >> they are physically going to be there and have phone lines and voicemail and we do warm transfer calls older or assistance for her own benefit analyst. >> any other questions? commissioners? is there any public comment on the directors report? hearing and see none were ready to move to the next discussion i'm >> item five discussion item, open enrollment update acting executive director griggs. >> as he's approaching the podium i want to communicate some of the hhs staff might be looking where hearing these proceedings, your work during in preparation during this time is not gone unnoticed by me and i'm sure other members of the board as we prepare for this
season of open enrollment. i want to thank each and everyone of you for what you have done today and what i absolutely know you be doing on behalf of the members as we enter this new season oh open enrollment. so, thank you again on behalf of the board. acting director griggs. >> mitchell griggs thank you pres. scott for that introduction and because that's exactly what i want to make sure that is understood of the amount of work everyone has done this year, and people have really rolled up their sleeves and their staffing changes we've had a couple surprises this year. it has-we have got this work done. so we are very very happy. we don't often get an opportunity to come up here and describe open enrollment to you before it happens. typically in november-december we do an overview and give you my of applications we have entered, or, how many flu shots we did but we don't really talk about what goes into the work. so
that's what were trying to do here. i want to preface, too, by saying this presentation is not this a very visual presentation. there's a lot of pictures that just show you the size of the data, or can i show you the piece of work is not necessarily meant to be read. that's why it is small. a lot of these things were being drafted when we created this presentation so we did i want to put it out there until it's really final. so it is just visual. >> sfgov tv, thank you. >> so on the first slide, i want to talk about our theme. we did a lot of work this year and thinking about what type of theme we want to put out there. early last year we worked with a consultant and are rebranding. to give us an idea for open enrollment of having a circle of pictures but we often use pictures on our benefit guides
and showing the diversity of the retirees, the diversity of active employees. so, we took that and i talked to the staff this year and i said that looks really good. people can see that circle and that o and i means open enrollment and they see that packet in the mail this year and in futures. hopefully they can see that means open enrollment but in addition to the pictures of our fellow coworkers, fellow retirees, want to make sure you can look at it and also see it san francisco. i think it's very important these days to realize how good it is to be in san francisco and the workforce is driving to keep the advances we made moving forward. we want to make sure people knew we were talking open enrollment in san francisco. so these
particular-this theme as you will see, the circle, like a large circle will be our larger envelopes. the of two-sided envelopes something were to use the half circle for the smaller size envelopes. these envelopes contain the initial open enrollment letter from our booklet expanding all the changes in enrollment applications. for retirees is also can have a flu shot education flyer. on the next page, again, believe me it's a lot of work when we sit here decide if it's just three pictures, or five pictures, and how it's going to look and how the colors are going to balance. these are benefit guides for 20 teen. these are the covers. a lot of discussion and work between the employers, city college, unified school district, and the city itself and what do they want these to look at and what color is best fitting. so the blue is active guide for 2018. community college, city college of san francisco is ingrained. unified school district is blue and the
retirees is ggray. >> wears the superior court? >> the superior court we include in the city and county of san francisco. sometimes we do their own smaller type of guide that's only electronic we don't usually print those >> all right. thank you. >> so in a again this is just a visual to show you. this is just the front side of these applications. every year we have to create these enrollment applications. go through every word for compliance issues, some language the plans require for us to be on their for signature, and again we work with each individual employer especially school district and ccd for specifics they need because they have some very interesting complicated mo mou. so it's can it's a lot of work. this year, which will get into a little bit later you will see there's a barcode in the upper
right-hand corner, a square barcode. we will get more into that but it's very exciting. are planning on what were doing as far as automating, bringing these forms into our office. a lot of planning goes into the events we do this year. 20-21 events were doing as open enrollment and those events and plus, or more will be 26 flu shot clinics this year. last year, we did about 4500 flu shots. we are expecting even more this year. again, we have our one week there and in october could if you're just looking at the visual counter-i know you can't read it i will-because we've had changes since we put the present it presentation to get we have a tickler vendor work were everyone is coming in at hss catherine dodd wellness center and people can talk to the plans. they can talk to the benefits analyst and the
benefits analyst are down there to talk with people all month long. this year, we are adding two new informational sessions. we did this last year. off-site session specifically for a group of people last year. last year was the medicare people when we moved people into united healthcare medicare advantage kaiser. so we went on to do plans. so i think we did about 18 sessions. we decided to do to this year for active in early retirees plans to have kaiser united healthcare and blue shield here. to walk people through the blue shield trio. change if needed and that the plan there to describe their plans. each plan will have about 10 minutes for presentation and then we will have 10-50 minute answer question answer after that and then of course we will be there for a little while for them to
ask questions face to face. this will be from 5:30 pm-7:30 pm. so it's out of typical business hours. our other offsites we do during the month are usually within business hours. so we want to offer something people can't make it to where the sites during work hours. again, the other visual here with the circle, we are showing how we use the theme in the advertisement for off-site. on the left is typical open enrollment with flu shot clinic and to the right there, would be just open enrollment or healthcare off-site. so the project plan. last year we implement a process of having brian rodrigo our it administrators also provide project manager. to manage the project for us. we needed someone-i need someone to come in and nagged me they need this for me. going through the particular plan and looking at the timeline because there's
lots of moving parts and it's difficult for any individual to do that. it's nice to have a project manager. that was pretty successful last year and so we did it again this year and it's been extremely successful. brian has done a superior job. >> is this brian? >> brian rodriguez, our it administrator. especially, considering for a why we do not have a communications manager. that position was unfilled until like i said earlier until 1 august. so it's been extremely helpful. i want to just to show you here that this is our project plan. this is the gantt chart. gantt charts show a typically a timeline as well as dependencies from other one test to the other. to the right, is just an overall and of color-coded i think my colors were grey and red this year. so you can see the things i had to be responsible for. brian does a great job getting all this together keeping the timelines together and then reminding us. so that's just one page on the right here.
there's 10 pages with a total 450 separate tasks. something personally i've been excited about this year is doing for the first time we will do a video about open enrollment. a very high level quick reminders visual things just to show people with a need to do. >> will this be embedded on the website? available on the website? >> yes. i was hoping to have some of it today but it is still kind of a very rough draft situation so i gave a couple of those storyboards. i've learned we have the storyboards with pictures and words the voiceover is going to search it on the right-hand side you can see there's going to be a voiceover it's going to calendar and the voiceover will say what day it is today. so this is very much the look of the video. it's more of an animated type of video. so, pictures will fade in and fade out and there is a hand-looks
like a hand drawing. here you see an arrow that's point to the calendar for you to make sure your pain attention to the calendar and watching out for october 31 because that's the last day. it will be about-i think it's just under three minutes. it is short. it doesn't go into a lot of detail but what it's doing is reminding you what you can do when you need to do it, and to go look at your open enrollment materials online, or, in the materials that we mail. i'm going as marina to come up here and really go into some of the details of the system modifications. what it takes for us to prepare systems to prepare these benefits from year to year. >> good afternoon. maria coleridge enterprise systems and analytics manager. thank you very much to director griggs allow me to speak for a couple minutes because when you're in the technical space you're supposed to make things be understandable with just means we say things like, were
configuring the system. it sounds like good, we are done. but actually, this is a menace my work that goes into that. so if you will just put up with me for a couple mattel tried to go into a little bit more of a deep dive about what we do. mitchell has already mentioned, we have got the new treo plan coming before us and 2018.. we have the vision from your plan. we also have the kaiser multi-region and-so these are some of the big items on our radar. all of those have significant system impacts. this slide here is just showing early on we took a look at what some of the system modifications would be in this is really just from a programming perspective. so there was something like 45 programs impacted, and when we had to do the split carrier that we delivered for the current plan year wasn't until april of this era reportedly finish the programming for the.
some of these programs have thousands upon thousands of lines of code in them and they have downstream impacts, if there something wrong with them and messes up with one of our programs. the process [inaudible] we have to go through and do our specifications and our development request. so we write it up so it's very specific. then, he goes for program development which is either some of the people on the pay side of the house, but we also have a programmer on our own team that's doing a tremendous amount of this work. that can be [inaudible] a lot of programs. the same small group of people are testing to make sure all that coding change did what it was supposed to do and did not do anything else that wasn't supposed to do. some of these have to be done sequentially because one impacts other programs. we have to make sure it is right first, and we only have really, a team
of three that sort of work in the space. when doing programming, one that does a lot of the functional configurations, and writing specifications, and then a couple of them that work in testing. so, we have to fit that all in as you know, on a compressed timeline so we try to look at what we absolutely need to have done by the time october 1 comes and what we need done by the time the first interface files are going out for the year, which happens to start as early as november and what we need by the time we had our first deductions of the new plan year. so we try to triage things accordingly to make sure we fit it all in. so, this is just a big high-level look at some the programs that are impacted. something, for example, like vision premier plan has new deduction goes because that this is an employee paid benefit and so it's not just our own systems. we publish deduction files with various pension systems. we do it with the unified school
district and the committee college district. as with a workout and work with those groups and alert them we now have new codes and new changes that are showing up on those. so there's downstream implications whether organizations as well. that's just programming. then, there's configuration. without looks like is, for example, adding treo. so options available in the system. a lot of bloggers [inaudible] senior principal analyst that works on this and this year she said for configuration time has doubled with the vision and turning that configuration on for every single benefit program and we have about 50 benefit programs. likewise, for the trio, and medical is not just one option turn on or off,. there's actually a lot of subset options related to medical. again, for all 50 of those benefit programs that we have. so, it's a very timely -time-consuming activity to do that. there is also options for
deleting this year it's a long swing that as we go to the next slide. this is a look at some of the detailed rate calculations. so you see rates. we put them in our guys and we put there what we call, simple rates such as coverage codes for [inaudible] e +1, or e +2 or family. but in the system we actually have [inaudible / off mic]. in the system it is more than just those simple rates. what you are looking at here again not to necessarily enter read to stop it it just giving you an idea what load files look like. there is actually something to the magnitude of 45 some fields that are in these tables. 44. 44 columns in the stables. last year we had over 5000 rates. again that's
the various benefit programs. we've a lot of coverage codes because you know, you have domestic partners there's implications in terms of pretax or post-tax applications different mou and with those contribution rules are. all the allocations say what am i supposed to play [inaudible] what parts cultivation with part -where does it go to dental. and then of course, we start with those rate sheets that get presented to you by our actuaries and that is again, very simple version of that. then we get an import file from aon hewitt to start that out but that input file again, is just a very vanilla three coverage levels, no things happen with tax or nothing with the other unity at wheaton to bring here just the main contribution models of the winter 96 were [inaudible] but we have a number of other contributions with the school districts and unified school districts committee college plus our retirees. so it's over 5000 race but it's a lot of
work. we also then converted to biweekly because that's how weekly peoples deductions have been a lot of times but things don't abide out prohibited there's rounding things, and so things might be off by a penny and in that people soft load for you if one record doesn't tire perfectly that were this amount should add up to this over here it's going to fail the hall. just to say this is a tremendous amount of work to get to these detailed rates, and so knowing that we had treo meant we were essentially doubling all the blue shield rates and i was can choose another couple thousand rates, and so if you months ago when we had a sense of what is coming did a whole rate analysis to say, are there ways to simplify this burden, and we took them up with a 21 page document with 10 recommendations to-i guess in a nutshell the biggest change is that normally we created every type of possible combinations that could ever happen and we've decided the work to support that is just
too great and we are better off now to really analyze where are 90% of our population today and we get all of those rates be counted actually, what do and if or when a percent of our population today but we have different levels [inaudible]. everything else that we just used to great a value for just in case nobody walks and someday and has that, we are not doing that anymore. that's usually a day turnaround time between finance and my team to get that rate calculated in the system. to spend all the countless hours calculating all those have time just was not some feasible anymore in terms of the behemoth it takes to maintain. so that is-that's what we've done. even this workbook here we have has 50 different tabs in it. some of those [inaudible] some of the cell form as if you were just to copy copy and paste into
excel format would be more than two pages long. that's how nested and extensive these forms are with what 30. that just high-level. then when we get this, again i team is working closely with a finance team because we share whose calculating what they were looking to-where are the errors and it's a lot of looking through these files for anything that went wrong anything that was a missed on that. so moving forward were trying to have that done by the end of the week we'll see if we get there. on the next slide, this is also with the piece looks like around our notification letters. you all get those nice letters in the mail but we need data to support that. so the picture is sort of on the left and behind his with the data files look like for this. of course, [inaudible] has been completely removed from the screen. [inaudible]. every year we end up having to change the program to generates this file because we've got new things coming in and we want to make sure it's reflective of picking up all those new benefits so we can really customize a lot of that were within [inaudible] then,
we have a lot of manual work to do because we like to put in for some members, especially cff court, in their letters is if you make no enrollment changes this is what you are pain next year. it is a nice service that we do that but those rates are not yet in our system. as i said, we still may be trying to get by the end of this week but i think we'll probably slip to early next week. so we do that all outside databases we say okay here's the rates recalibrated let's merge them to the individual, nothing went wrong. it's the right union. the right benefit program so we can tell you what your rates are going to be. we go through and this is an example of some test cases which mitchell mentioned earlier. we have all these scenarios. we look for individuals that meet these scenarios so we can check in the source files and then also with what our print house- we just turned over all the data source how files to them last
night and first thing this morning. then, will pull back the subset of records and look at all those individual letters , which i think is maybe upwards of 80 letters that we will be pulling across a lot of different scenarios and a lot of different groups, to say, is this information going on out letter correct? that's the work we are headlong into today. that is also quite extensive. next slide, though, something we are trying to deliver. also, is some additional automation. we have something like more than 7000 enrollment applications that we are turned in last year and as you know, we have digitized all our member records and we went and implement an enterprise contact management system to help streamline workflows. we had just come up with the ecm right before [inaudible] last year. it was so new to our team but it was going to be more confusing than less and also it
takes some manual intervention for individuals to scan in those files and link them so they can say, this open enrollment obligation goes to this member could we recognize it's time-consuming so were trying to make up this year. the barcode that mitchell showed you earlier on the top right of all of our enrollment applications and you see more of is human here, is trying to first off tell us what type of application [inaudible] because for the operational team there able to assign workflows based on which group were trying to take care of and sometimes based on deadline files or changes to take care of retiree applications first, or other groups, or knowing how many are in their, it helps our minister better assign resources to workflows. then, the other thing were trying to do is you will see on this particular printout esw 123456, it's just not assigned to anybody were preventing these forms [inaudible] we are actually pre-printing people's information on enrollment form.
not all your information because you only go down [inaudible] to any kind of identity theft but were [inaudible] so when you fax that in or it comes into other channels we can we got into the system we already know, that is a usb application for this particular person. because we get lots of calls all through the month. did you get my application? it's very time-consuming to do that. not only does it help streamline our workforce because we already have everything identified to an individual but also helps if while were doing our member services is getting calls from individuals to up their application they will already be able to put up your >> how will you address the issue, i've lost my open enrollment form it had my personal code and information on it? >> that's what we have in preprinted any other information in that psw is not tied to anything that's out there and any other way. other than what
we have done to minimize from our perspective, because if you lose your form, i don't mean to sound rude, but that is on you. >> yes. how do i go about getting a new form? >> yes. for that if you just worried about new forms you'll be able to download those from our website and handwrite it and will take care of the recognition on his writing is a great. that's why were pre-printing. for us, to your point, to make sure people are not getting the wrong forms were doing something else we've never done before, which is actually have your letter and your form together. that's have a perforated seal perforate your form out there. we make sure that way people are getting the right information we don't have wrong forms going to the wrong people. so a lot's been gone into that. i'm still hopeful [inaudible / off mic] >> if i could ask a question, i like the presentation of on automation as well. so when an application is received does that go into-can member access that on his or her own chart to
see the application was received and been coded? [inaudible] phone call >> no. not at this time. over the next couple years we got other things coming so that might help address that >> people to start using the website and their own- >> yes. yes we really do hope to deliver this. i'm very optimistic it is still taking a lot of work and same resources that doing all that other stuff but i am feeling good today we will make it happen. if you asked that same question last week, i would be like him i don't know. that's a good segway commissioner follansbee because in addition to everything else let's also try to get that self-service pilot going and that's a whole other environment that needs configuration. we are going with been a lot out-of-the-box because we do not have time to do a lot of customization work and we reckon us we want take
the information from this pilot to then influence all the customization will do next year when we go more big bang with this. it is a whole you'll see are these are just 26 test cases we had. we had to configure again [inaudible] had to configure this whole environment. were working with people in pay team around preparing welcome videos and instruction videos and faqs and all of our outreach communications and documentation were setting up training environment. were setting up environments. will be open labs or people having questions about how to do it will come in. working again with siobhan and member services team around training on this environment and how that will workflows and assistance for the open enrollment environments. it is one more environment that needs to configuration and testing with that i'll turn it back over to- >> thank you very much. >> so just quickly wrapping up,
when we talk about developing our mailings and arc medications, that is going to 75,000 people this year. so we are sending full enrollment package and can medications to even people of waived coverage in the past. typically we just sent him a letter saying it's open enrollment and go online and look at your benefits that's available for you to change. this year, we thought with a new-a lot of the changes were doing with the vision with the blue shield trio and with the kaiser multi-region for early retirees in terms of medicare that's important to everyone who gets of that information, so we are being a bit more cautious this year. beck includes our presentation on open enrollment and if you have questions i'll certainly entertain those. >> questions from the commission regarding the open enrollment process were anything they've described? commissioner breslin >> last year there was an issue
. a lot of actives were not sent open enrollment package intention because they wanted them to do it on the internet. >> so even last year everyone got a package. >> [inaudible] there were complaints about it >> i think what the issue was last year, two years ago, this will be the third year-two years ago we started not signing the full benefit guide, the 44 page booklet with a colorful things. what we did for active employees and early retirees is send a summary of the open enrollment changes and the smaller booklet size. but we have always sent an open enrollment letter in that booklet or guide so if they did not receive it, i'm trying to recall if there was a mailing issue with a male house last year >> i think the whole email
issue went back and forth. >> right. i thing i know which one you're talking about. yes, it was about not getting the full benefit guide. >> so okay. >> in our open enrollment letters in our announcements, when people call people can request one if they just get the booklet but they want that full 44 page guide they can just go online and request or call our office and we will mail one to them. >> were are saving some trees. >> yes. it is. >> all right. any other questions? >> just one comments. i just want to complement director griggs and marina and all the stuff and pamela for all your hard work during this open enrollment and thank you. >> thank you very much commissioner. >> all right. any public comment on this discussion item?
>> claire-re: csf. i'm wondering is there any ability to process any of this completely online? some of our retirees have asked that but we also have a number of retirees who still don't have computers and, so, i heard director griggs indicate you could get a replacement open enrollment form if you lose it by downloading it, but we do have members don't have that capability. so i am hoping that if they call the office to be able to get hard copies be sent to them. we've a number of retirees who are going to be coming to the october 11 event for retirees and early retirees at the scottish rite, and i hope there will be some representatives