Open main menu

TaticView β

Changes

Template RH/en

1,261 bytes added, 02:28, 5 October 2022
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:
* overtime rates by cost center,
.* which employees with the most absences,
* 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
.* '''Empresa''': Employer's name
* '''Filial''': Name of the branch where the employee works
* '''Sexo''': Employee's gender
.* '''Estado Civil''': Employee's marital status
* '''Grau de Instrução''': Employee's level of education
* '''Faixa Etária''': Employee's age group
.* '''Cargo''': Description of the position that the employee occupies within the company
.* '''Tipo Contrato''': Type of employment association with the employee
.* '''Situação''': Indicates whether the employee is on active staff
.* '''Tipo Situação''': Indicates the employee's dismissal reason
* '''Periculosidade''': Indicates if the employee performs a function considered dangerous
* '''Data Admissão''': The date when the employee started working at the company
.* '''Data Demissão''': The date when the employee was dismissed from the company
.* '''Salário Mês''': The value of the salary paid to the employee in the month of competence
.* '''Remuneração Mês''': The value of the employee's net remuneration in the month of competence
* '''Passivo Décimo Terceiro''': valor provisionado para o décimo terceiro salário
.* '''Passivo Férias''': Amount provisioned for vacations
* '''Passivo FGTS''': valor que foi recolhido para o FGTS do colaborador
* '''Bnf. Transporte''': Amount paid as a voucher benefit
* '''Bnf.Alimentação''': Amount paid for the food voucher
* '''Bnf.Saúde''': Amount paid as health plan benefit
* '''Bnf. Outros''': Amount paid under other benefits
* '''Qtd.Horas Extras''': The amount of overtime worked
* '''Valor Horas Extras''': The value of overtime worked
.Analysis:
* '''Collaboration analysis by cost center'''
* '''Monthly Cost analysis by Cost Center'''
.* '''Management of employees by branch'''
* '''Overtime information'''
.* '''Ranking of employees with more absence'''
.* '''Summary of employees by Sex, Marital Status, level of education and Age Group'''
11,677
edits