11,677
edits
Changes
Updating to match new version of source page
<languages/>
<b style="color:red;">Notice:</b> This template has not yet been translated into ''English'' and ''Spanish''.
Through the ''HRRH'' template, the HR managers can automate, with a low cost, a generation and a distribution, with security and confidentiality, like information on the staff.
Learn through the available dashboards:
* the distribution of labor force by cost center,
* if the employee's level of education and age group are within the company's standards.
Download the [https://wiki.taticview.com/taticfiles/rh.xlsx HR] example worksheet and , using the link below, replace it with your data and update the [[Data Sources|datasource]] to start reviewing analyzing immediately and improving improve the management of your employees.
If you do not have all the data available, leave the corresponding columns blank.
[[Special:FilePath/RH.xlsx|Download Sample Worksheet]]
Information on the ''HRRH'' spreadsheet:
* '''Data Competência''': Date of data collection on the HR system
* '''Filial''': Name of the branch where the employee works
* '''Sexo''': Employee's gender
* '''Grau de Instrução''': Employee's level of education
* '''Cargo''': Description of the position that the employee occupies within the company
* '''Situação''': Indicates whether the employee is on active staff
* '''Periculosidade''': Indicates if the employee performs a function considered dangerous
* '''Data Admissão''': The date when the employee started working at the company
* '''Salário Mês''': The value of the salary paid to the employee in the month of competence
* '''Passivo Décimo Terceiro''': valor provisionado para o décimo terceiro salário
* '''Passivo FGTS''': valor que foi recolhido para o FGTS do colaborador
* '''Bnf. Outros''': Amount paid under other benefits
* '''Qtd.Horas Extras''': The amount of overtime worked
* '''Valor Horas Extras''': The value of overtime worked
* '''Qtd.Horas Pagas''': The number of hours paid
* '''Qtd. Horas Faltas''': The number of hours the employee missed work
Analysis:
* '''Monthly Cost analysis by Cost Center'''
* '''Overtime information'''
* '''Ranking of employees with more absence'''