This partition strategy is not going to work for all job types. I think we will need to use the reference data to determine the job. This whole field is going to need to correspond to `job_type.name`. Use that to see if there is an entry in `job_type` with a job group id, if not we should have a default group id that gets assigned. I think for now we will need to use the `symbol` column in the spreadsheet ed morley supplied to map try to map the job_type to a group dynamically. We should discuss this in detail...