Open main menu

TaticView β

Changes

Template RH

3,928 bytes added, 14:30, 30 September 2022
no edit summary
<languages/>
 
<translate>
 
<!--T:55-->
<b style="color:red;">Notice:</b> This template has not yet been translated into ''English'' and ''Spanish''.
 
<!--T:1-->
In competitive environments and with the lack of qualified human resources, a proper management of those resources has a major role in retaining talents and in maintaining productivity.
<!--T:2-->
In this situation, to achieve these goals, it is vital that the human resources departments provide reliable and up-to-date information on the staff to other managers
<!--T:3-->
Through the ''RH'' template, the HR managers can automate, with a low cost, a generation and a distribution, with security and confidentiality, like information on the staff.
<!--T:4-->
.Learn through the available dashboards:
<!--T:5-->
.* the distribution of labor force by cost center,
<!--T:6-->
.* the HR costs by cost center,
<!--T:7-->
.* overtime rates by cost center,
<!--T:8-->
.* which employees with the most absences,
<!--T:9-->
* if the employee's level of education and age group are within the company's standards
<!--T:10-->
Download the example worksheet, using the link below, replace with your data and update the [[Data Sources|datasource]] to start analyzing immediately and improve the management of your employees.
<!--T:11-->
If you do not have all the data available, leave the corresponding columns blank.  <!--T:56-->[[Special:FilePath/RH.xlsx|Download Sample Worksheet]] 
<!--T:12-->
[[Share dashboards|Share]] your information with other company managers by displaying only the information relevant to them while you still have full access to all information
<!--T:13-->
.Information on the ''RH'' spreadsheet:
<!--T:14-->
.* '''Data Competência''': Date of data collection on the HR system
<!--T:15-->
.* '''Empresa''': Employer's name
<!--T:16-->
.* '''Filial''': Name of the branch where the employee works
<!--T:17-->
.* '''Centro de Custo''': Name of the cost center where the employee is designated
<!--T:18-->
.* '''Colaborador''': Employee's name and code
<!--T:19-->
.* '''Sexo''': Employee's gender
<!--T:20-->
.* '''Estado Civil''': Employee's marital status
<!--T:21-->
.* '''Grau de Instrução''': Employee's level of education
<!--T:22-->
.* '''Faixa Etária''': Employee's age group
<!--T:23-->
.* '''Cargo''': Description of the position that the employee occupies within the company
<!--T:24-->
.* '''Tipo Contrato''': Type of employment association with the employee
<!--T:25-->
.* '''Situação''': Indicates whether the employee is on active staff
<!--T:26-->
.* '''Tipo Situação''': Indicates the employee's dismissal reason
<!--T:27-->
.* '''Periculosidade''': Indicates if the employee performs a function considered dangerous
<!--T:28-->
.* '''Insalubridade''': Indicates if the employee performs a function considered unhealthy
<!--T:29-->
.* '''Data Admissão''': The date when the employee started working at the company
<!--T:30-->
.* '''Data Demissão''': The date when the employee was dismissed from the company
<!--T:31-->
.* '''Salário Mês''': The value of the salary paid to the employee in the month of competence
<!--T:32-->
.* '''Remuneração Mês''': The value of the employee's net remuneration in the month of competence
<!--T:33-->
.* '''Passivo Décimo Terceiro''': valor provisionado para o décimo terceiro salário
<!--T:34-->
.* '''Passivo Férias''': Amount provisioned for vacations
<!--T:35-->
.* '''Passivo FGTS''': valor que foi recolhido para o FGTS do colaborador
<!--T:36-->
* '''Bnf.Transporte''': Amount paid as a voucher benefit
<!--T:37-->
* '''Bnf.Alimentação''': Amount paid for the food voucher
<!--T:38-->
* '''Bnf.Saúde''': Amount paid as health plan benefit
<!--T:39-->
* '''Bnf.Outros''': Amount paid under other benefits
<!--T:40-->
* '''Qtd.Horas Extras''': The amount of overtime worked
<!--T:41-->
.* '''Valor Horas Extras''': The value of overtime worked
<!--T:42-->
* '''Qtd.Horas Pagas''': The number of hours paid
<!--T:43-->
* '''Qtd.Horas Faltas''': The number of hours the employee missed work
<!--T:44-->
.* '''Percentual de Horas Faltas''': Percentage of absences over hours paid 
<!--T:45-->
.Analysis:
<!--T:46-->
.* '''Collaboration analysis by cost center'''
<!--T:47-->
.* '''Monthly Cost analysis by Cost Center'''
<!--T:48-->
.* '''Management of employees by branch'''
<!--T:49-->
.* '''Overtime information'''
<!--T:50-->
.* '''Ranking of employees with more absence'''
<!--T:51-->
* '''Summary of employees by Sex, Marital Status, level of education and Age Group'''  <!--T:52-->[[File:rh_exemplo_1.PNG|link=]]  <!--T:53-->[[File:rh_exemplo_2.PNG|link=]] 
<!--T:54-->
[[File:rh_exemplo_3.PNG|link=]]
</translate>