John and I spent the whole time working on some database updates for the payroll changes. The new updates will add some new columns to help flag timecards with special flags for sick pay, holiday pay, regular hours, overtime hours, and a special flag for manual assistance needed. We also added some math to go backwards and fill in all of the valid timecards with a decimal total time value. Currently, we have to calculate that total time on the fly (convert the time to seconds and then divide by the total number of seconds in a day to get a decimal total time per timecard). Anyways, we added some new database columns, wrote a migration and update script, and did some other clean-up on the timecards. This will help us go faster and potentially be able to pull faster reports, do bulk payroll, and even eventually accrual liabilities for outstanding (but not yet booked) payroll expenses.