CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `aerion`@`localhost` 
    SQL SECURITY DEFINER
VIEW `aerion`.`vw_rpt_hours_calc_all` AS
    SELECT 
        `aerion`.`rpt_hours_calc`.`rpt_hour_id` AS `rpt_hour_id`,
        `aerion`.`rpt_hours_calc`.`hour_id` AS `hour_id`,
        `aerion`.`rpt_hours_calc`.`emp_id` AS `emp_id`,
        `aerion`.`emp`.`firstname` AS `firstname`,
        `aerion`.`emp`.`lastname` AS `lastname`,
        `aerion`.`rpt_hours_calc`.`comp_id` AS `comp_id`,
        `aerion`.`company`.`companyname` AS `companyname`,
        `aerion`.`rpt_hours_calc`.`bill_cycle_start_dt` AS `bill_cycle_start_dt`,
        `aerion`.`rpt_hours_calc`.`bill_cycle_end_dt` AS `bill_cycle_end_dt`,
        `aerion`.`rpt_hours_calc`.`expected_hrs` AS `expected_hrs`,
        `aerion`.`rpt_hours_calc`.`billable` AS `billable`,
        `aerion`.`rpt_hours_calc`.`non_billable` AS `non_billable`,
        `aerion`.`rpt_hours_calc`.`total_hrs` AS `total_hrs`,
        `aerion`.`rpt_hours_calc`.`hrs_diff` AS `hrs_diff`,
        `aerion`.`rpt_hours_calc`.`inv_diff` AS `inv_diff`,
        `aerion`.`rpt_hours_calc`.`cycle_type` AS `cycle_type`,
        `aerion`.`rpt_hours_calc`.`bill_due_dt` AS `bill_due_dt`,
        `aerion`.`rpt_hours_calc`.`hrs_date` AS `hrs_date`
    FROM
        ((`aerion`.`rpt_hours_calc`
        LEFT JOIN `aerion`.`emp` ON ((`aerion`.`rpt_hours_calc`.`emp_id` = `aerion`.`emp`.`emp_id`)))
        LEFT JOIN `aerion`.`company` ON ((`aerion`.`rpt_hours_calc`.`comp_id` = `aerion`.`company`.`comp_id`)))