Tiffany, Steve and Unknown at the DVICA Golf Classic 2008
Tiffany, Steve and Unknown at the DVICA Golf Classic 2008

I posted last week about how I learned a lot about golf at the recent DVICA golf tournament. Thankfully I remembered to bring my digital camera to commemorate the event.

A belated congratulations to Tom Biskobing, Joe Domingo, Ray Hoang, and Thomas Kim for winning the tourney with an impressive 53!

Jeff, Chris, Steve, and I managed a 65. That isn’t to say we didn’t walk away with a few souvenirs. Each one of us won a raffle prize! Jeff won a bottle of Coppala wine, Chris a magnetic white board in the shape of a surf board, and Steve got a bluetooth headset!

I received a $100 gift card to Nordstrom’s courtesy of Jeff Gary of WorkCompTV.com.

Jeff and Keith at the DVICA Golf Classic 2008
Jeff and Keith at the DVICA Golf Classic 2008

While I was slightly less than diligent about taking pictures at the tourney, I did get two good pics. The top photo would have included me between the two blonds except that Steve’s photography kung fu is weak. (Sorry, man, but its true!) I think he was faking just so he could get his picture taken.

Not convinced? Well, here’s his photo of me with the same girls:

Steve's Photography Kung Fu
Weak Photo Kung Fu

I received a few handouts regarding the new EAMS system while at the San Francisco WCAB yesterday. The WCAB SFO only had a limited number of these documents, so I’ve scanned my copy for everyone else’s benefit.

I also learned some interesting things about EAMS:

  1. Everyone knows that EAMS and the WCAB will reject your filings if you’re not registered with EAMS. Did you know that the Judges aren’t sure if EAMS will reject your filings if the employer is not registered?
  2. If a party brings physical paper exhibits, Judges will only be accepting the most important documents for filing (since the WCAB will be doing the scanning)
    • The parties will be expected to bring any possibly relevant exhibits. Any documents not accepted will be returned to the parties or shredded.
    • Judges will mainly be accepting just permanent and stationary reports.
  3. A party bringing a CD burned with scanned exhibits, will need to submit all medical files and documents which are typically required to be filed with the WCAB.
    • They will will not have the option of only submitting the most relevant exhibits.
  4. For the time being, normal walk through procedures are gone. Any new case activation would not be assigned a Board number until approximately 3 am after the day of submission. Be ready to drop off your walk throughs the day before you want to obtain approval.
  5. The EAMS forms haven’t been approved by the Office of Administrative Law and won’t be mandatory until approved.
  6. For the time being, every Board will have a telephone conference each morning starting at 8 am with their “command center.”
  7. The decision to go ahead with EAMS starting August 25, 2008 was only made on August 22, 2008!

I recently gave a brief overview of my permanent disability and workers’ compensation benefit calculators. In that post I wrote a little bit about how my online benefits calculators work. Since then I’ve posted about my use of javascript, PHP, and AJAX in creating these permanent disability and permanent impairment calculators.

As I mentioned in the prior post in this series, my first few versions of this website and its workers’ compensation calculators did not use MySQL.  The initial versions of this site only saved information – which meant I only had to use PHP to open a file on the server, add an extra line of information, and then close the file.  This had several problems:

  1. Once my website became more popular, it was not uncommon to have more than one user online.  That meant the server tried to open the file – but couldn’t since it was already open.  This caused the program to freak out.
  2. In order to view just a little bit of information, I had to download the entire file.  This got crazy pretty quickly.
  3. Each time the file got larger, it would take slightly longer to open, append with more information, and close.

MySQL is an incredible tool for storing, organizing, and retrieving a large amount of data.   Like PHP, it is also open-source.  This means it is:

  • Well supported.  There are lots of online resources and books to help you learn.
  • Secure.  Lots of people spend a lot of time thinking of ways to prevent security vulnerabilities.
  • Customizable.  You can configure or even rewrite it, if you wish.
  • Interoperability.  You can save it to just about any format – including MS Excel spreadsheets.
  • Free.  Unlike Oracle or any of the MS alternatives, it is totally free.

So, why did I avoid MySQL?  I didn’t want to have to learn a whole new programming language.  I had to learn how to set up a database, tables within the database, how to search for information in a table, how to put information into a table, and how to change information which was already in a table.  There was a lot of trial and error.  I ended up doing some pretty cool things in the process of learning this language.  Some examples:

  • Teaching others some of the basics of MySQL
  • Writing a program for cataloging books
  • Writing several programs which performed various calculations to track invoices, billings, etc
  • Setting up several blogs/websites

The end result of learning this language is a more interactive website.  One of the last incarnations of this site was a version that would show different color schemes, advertisers, and messages depending upon the user.  All of this was made possible by large amounts of data stored in MySQL.

Thus ends my technical overview of my workers’ compensation permanent disability calculators!  If you have any questions, please feel free to email me or leave a comment below!

When a user registers with this website they are given the option of listing a little bit of biographical information about themselves. Have you ever wondered who else uses this website? Well, wonder no longer! The people using this website include:

  • Injured workers without attorneys
  • Claims administrators and supervisors
  • Applicant attorneys
  • Office managers and paralegals
  • Defense attorneys
  • In-house counsel
  • City and state agencies
  • Medical groups
  • Doctors

That’s a pretty diverse group!