Employee Pay Rate update

unknown

Hi,

    Every January, finance people change the pay rate on every employee (one by one). We have two sites, but only one is use for labor ticket reporting. Do you have a better way to change the pay rate for many employees?

 

Thanks

 

Nancy

 

0905290751295332.pdf

fernando-pittella

HI there,

All personal actions are performed on an Human Resource application 100% independent from Infor Manufacturing

On this HR app salaries modifications can be upload from an SpreadSheet or be made by department bty range, department, etc.

At 14:00 and 18:00 hours an SQL Server job is executed to:

- Mark as inactive all personal that do not work with us anymore

- Add all new personal

- Update any personal data changed on our Human Resource application

Human Resource database := [INFOR_HTIS]

Manufacturing database := [VEP]

We calculater hour pay rate as  Monthly Salary / 240 (hours / month) * 1.419 (aditional costs (Social Security, provisioning, etc.)

/*
Crea Recursos por Sitio (new employees)
*/

INSERT INTO [VEP].[dbo].[EMPLOYEE_SITE]
                           ([SITE_ID]
                          ,[EMPLOYEE_ID]
                          ,[DEFAULT_SITE]
                         ,[BASE_PAY_RATE])

select [Site ID] = 'ORE',
           [Employee ID] = [infor_htis].[dbo].[fn_formatear_dato]( empleado.[COD_EMPLEADO],
                                                                                                4),
           [DEFAULT_SITE] = 'Y',
            [BASE_PAY_RATE]   = isnull( cast( ( empresa.SUELDO * 1.419) / 240 as decimal(22,8)),
                                                            0.00)
from    [INFOR_HTIS].[dbo].[EMPL_EMPLEADO]              empleado left join
           [INFOR_HTIS].[dbo].[EMPL_EMPLEADO_EMPR] empresa on empresa.COD_EMPRESA    = 1 and
                                                                                                                empresa.COD_EMPLEADO = empleado.COD_EMPLEADO
                                                                                                  left join
           [VEP].[dbo].[EMPLOYEE_SITE]                              sitio        on sitio.SITE_ID = 'ORE' and
                                                                                                               sitio.EMPLOYEE_ID = [infor_htis].[dbo].[fn_formatear_dato]( empleado.                                                                                                                                                                                 [COD_EMPLEADO],
                                                                                                                                                                               4)
where sitio.EMPLOYEE_ID is null

/*
Actualiza Recursos por Sitio (existing employees)
*/

update [VEP].[dbo].[EMPLOYEE_SITE]
set        [BASE_PAY_RATE]  =  isnull( cast( ( empresa.SUELDO * 1.419) / 240 as decimal(22,8)),
                                                           0.00)
from [VEP].[dbo].[EMPLOYEE_SITE]                               sitio        join
         [INFOR_HTIS].[dbo].[EMPL_EMPLEADO_EMPR] empresa on empresa.COD_EMPRESA = 1 and
                                                                                                              empresa.COD_EMPLEADO = cast(sitio.employee_id as int)