CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `aerion`@`localhost` 
    SQL SECURITY DEFINER
VIEW `vw_emp_org` AS
    SELECT 
        `a`.`emp_org_id` AS `emp_org_id`,
        `a`.`emp_id` AS `emp_id`,
        `a`.`comp_id` AS `comp_id`,
        `b`.`companyname` AS `companyname`,
        `a`.`org_start_dt` AS `org_start_dt`,
        `a`.`org_end_dt` AS `org_end_dt`,
        IF(ISNULL(`a`.`org_start_dt`),
            'No Started',
            CONCAT(CONVERT( DATE_FORMAT(`a`.`org_start_dt`, '%m-%d-%y') USING LATIN1),
                    ' ')) AS `org_start_dt_formatted`,
        IF(ISNULL(`a`.`org_end_dt`),
            'No End Date',
            CONCAT(CONVERT( DATE_FORMAT(`a`.`org_end_dt`, '%m-%d-%y') USING LATIN1),
                    ' ')) AS `org_end_dt_formatted`,
        `a`.`emp_type` AS `emp_type`,
        `c`.`emp_value` AS `emp_type_nm`,
        `a`.`run_script` AS `run_script`,
        `a`.`updater` AS `updater`,
        ISNULL(`a`.`updater`) AS `ISNULL(``a``.``updater``)`,
        'Admin' AS `Admin`,
        CONCAT(`e`.`firstname`, ' ', `e`.`lastname`) AS `updater_nm`,
        `s`.`file_name` AS `updater_file_name`,
        `a`.`last_updated` AS `last_updated`,
        CONCAT(CONVERT( DATE_FORMAT(`a`.`last_updated`,
                        '%m-%d-%y %H:%i:%s %p') USING LATIN1),
                ' ') AS `format_last_updated`
    FROM
        ((((`emp_org` `a`
        LEFT JOIN `company` `b` ON ((`a`.`comp_id` = `b`.`comp_id`)))
        LEFT JOIN `emp_lk_val` `c` ON ((`a`.`emp_type` = `c`.`idemp_lk_value`)))
        LEFT JOIN `emp` `e` ON ((`a`.`updater` = `e`.`emp_id`)))
        LEFT JOIN `storages` `s` ON ((`e`.`idstorage` = `s`.`idstorage`)))