code: public Map<Integer, DayType> createExceptionTypeMap(List<Row> rows)
     {
        Map<Integer, DayType> map = new HashMap<Integer, DayType>();
        for (Row row : rows)
        {
           Integer id = row.getInteger("EXCEPTIONNID");
           DayType result;
  
           switch (row.getInt("UNIQUE_BIT_FIELD"))
           {
              case 8: // Working
              case 32: // Overtime
              case 128: //Weekend Working
              {
                 result = DayType.WORKING;
                 break;
              }
  
              case 4: // Non Working
              case 16: // Holiday
              case 64: // Weather
              case -2147483648: // Weekend
              default:
              {
                 result = DayType.NON_WORKING;
                 break;
              }
           }
  
           map.put(id, result);
        }
        return map;
     }
docs: Creates a mapping between exception ID values and working/non-working days.
  
  @param rows rows from the exceptions table
  @return exception map