CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `ATS`@`localhost` 
    SQL SECURITY DEFINER
VIEW `ATS`.`vw_load_emp_details` AS
    SELECT 
        `ATS`.`load_emp_details`.`emp_id` AS `emp_id`,
        `ATS`.`load_emp_details`.`idstorage` AS `idstorage`,
        `ATS`.`load_emp_details`.`file_name` AS `file_name`,
        `ATS`.`load_emp_details`.`personal_details` AS `personal_details`,
        CONCAT('SSN:',
                IFNULL(`ATS`.`emp`.`ssn`, _LATIN1''),
                ' ',
                'DOB:',
                CONVERT( (CASE
                    WHEN (`ATS`.`emp`.`dob` <> '0000-00-00') THEN DATE_FORMAT(`ATS`.`emp`.`dob`, '%m-%d-%y')
                    ELSE ''
                END) USING LATIN1),
                ' ',
                'Age:',
                FLOOR(((CASE
                            WHEN (`ATS`.`emp`.`dob` <> '0000-00-00') THEN (TO_DAYS(CURDATE()) - TO_DAYS(`ATS`.`emp`.`dob`))
                            ELSE 0
                        END) / 365.25)),
                'year',
                ',',
                FLOOR(((CASE
                            WHEN (`ATS`.`emp`.`dob` <> '0000-00-00') THEN (TO_DAYS(CURDATE()) - TO_DAYS(`ATS`.`emp`.`dob`))
                            ELSE 0
                        END) - (FLOOR(((CASE
                                    WHEN (`ATS`.`emp`.`dob` <> '0000-00-00') THEN (TO_DAYS(CURDATE()) - TO_DAYS(`ATS`.`emp`.`dob`))
                                    ELSE 0
                                END) / 365.25)) * 365.25))),
                'days',
                ',',
                'Gender:',
                IFNULL(`f`.`look_values`, ''),
                ' ',
                '  ',
                'TaxId:',
                IFNULL(`ATS`.`emp`.`taxid`, _LATIN1'\''),
                'Storage:',
                IFNULL(`ATS`.`emp`.`sto_limit`, '')) AS `other_details`,
        FLOOR(((CASE
                    WHEN (`ATS`.`emp`.`dob` <> '0000-00-00') THEN (TO_DAYS(CURDATE()) - TO_DAYS(`ATS`.`emp`.`dob`))
                    ELSE 0
                END) - (FLOOR(((CASE
                            WHEN (`ATS`.`emp`.`dob` <> '0000-00-00') THEN (TO_DAYS(CURDATE()) - TO_DAYS(`ATS`.`emp`.`dob`))
                            ELSE 0
                        END) / 365.25)) * 365.25))) AS `new_days`,
        FLOOR(((CASE
                    WHEN (`ATS`.`emp`.`dob` <> '0000-00-00') THEN (TO_DAYS(CURDATE()) - TO_DAYS(`ATS`.`emp`.`dob`))
                    ELSE 0
                END) / 365.25)) AS `new_age`,
        `ATS`.`load_emp_details`.`contacts` AS `contacts`,
        `ATS`.`load_emp_details`.`mod_last_updated` AS `mod_last_updated`,
        `ATS`.`load_emp_details`.`addresses` AS `addresses`,
        `ATS`.`load_emp_details`.`companies` AS `companies`,
        `ATS`.`load_emp_details`.`employment_days` AS `employment_days`,
        `ATS`.`load_emp_details`.`consulting_companies` AS `consulting_companies`,
        `ATS`.`load_emp_details`.`consulting_days` AS `consulting_days`
    FROM
        ((`ATS`.`load_emp_details`
        LEFT JOIN `ATS`.`emp` ON ((`ATS`.`load_emp_details`.`emp_id` = `ATS`.`emp`.`emp_id`)))
        LEFT JOIN `ATS`.`look_values` `f` ON ((`ATS`.`emp`.`gender` = `f`.`look_values_id`)))
    ORDER BY `ATS`.`emp`.`last_updated` DESC