Select Code to Download

 Field     Type         Null     Key     Default     Extra    
 --------  -----------  -------  ------  ----------  -------- 
 id        int(11)               PRI     0                    
 int_dow   varchar(50)

Field         Type           Null     Key     Default     Extra       
+   
 ------------  -------------  -------  ------  ----------  -----------
+--- 
...
 int_start     time                            00:00:00               
+    
 int_end       time                            00:00:00               
+    
 int_int       decimal(10,0)                   00

package AppSys::DBI;
use Class::DBI::Iterator;
...
package AppSys::DOW;
use base AppSys::DBI;
AppSys::DOW->set_up_table("as_dow");

    @ints = AppSys::BusinessHours->search( provider_id => $provider_id
+, {order_by => 'int_dow'});
    my @loh;
...
        };
        push ( @loh, $hashref );
    }