Dynamic Views - Clocking Event 2.0 | HCM
As visões dinâmicas são recursos da senior X Platform que permitem consultar e exportar dados em forma de relatórios.
Estes dados podem ser usados também para construir uma visão gerencial personalizada, usando o Analytics Studio.
Usar as visões dinâmicas para emitir relatórios
Os dados são agrupados por visões (views), sendo que cada visão serve para buscar tipos diferentes de informações.
As visões podem ser selecionadas na tela de cadastro das visões dinâmicas, em:
- Tecnologia > Customização > Relatórios > Visões dinâmicas
Depois de selecioná-las,
Também é possível automatizar a execução desses relatórios, clicando em Agendar Execução. O agendamento permite selecionar o formato desejado (PDF, XLS, entre outros) e a forma de entrega (via notificação da plataforma ou por e-mail).
Para saber tudo o que você pode fazer com as visões, acesse a documentação de Visões Dinâmicas no manual da plataforma senior X.
Usar os dados das visões com o Analytics Studio
O Analytics Studio permite cruzar as informações contidas nas tabelas das visões, com a finalidade de criar gráficos e visões gerenciais dessas informações. Esta ferramenta auxilia na análise dos dados e na tomada de decisão.
Para saber como cruzar essas informações e montar os gráficos, acesse a documentação do Analytics Studio no manual da plataforma senior X.
Views available for Clocking Event 2.0 | HCM
Note
When the module provides a new view, so that it can be selected when creating a dynamic view, it is necessary to access the senior X platform with a useradministrator and update thereporting database.
Using the reporting database is optional. For more information about it, see the documentation forDynamic Views in the platform manual.
Service: hcm-pontomobile
Clocking events (v_clocking_event)
This view is used to list the employees' clocking events.
Fields that can be displayed
| Translated name (Visual editor) | Name in the database (SQL Editor) | Key field Key fields are those that can be used to make the link between the tables of the dynamic view |
|---|---|---|
| Clocking event ID | clock_id | |
| Date | date | |
| Time | time | |
| App Version | app_version | |
| Exported Clocking Event | exported | |
| Fence State Code | fence_state | |
| Fence State | fence_statedesc | |
| Use Code | use | |
| Clocking Event Use | usedesc | |
| Mode code | mode | |
| Clocking event mode | modedesc | |
| Signature Code | signature | |
| Signature | signaturedesc | |
| Latitude | geolocation_latitude | |
| Longitude | geolocation_longitude | |
| Device ID | device_id | |
| Employee ID | employee_id | |
| Platform | platform |
Devices (v_device)
This view lists information about the registered devices.
Fields that can be displayed
| Translated name (Visual editor) | Name in the database (SQL Editor) | Key field Key fields are those that can be used to make the link between the tables of the dynamic view |
|---|---|---|
| Device ID | device_id | |
| Name | name | |
| Model | model | |
| Identifier | identity |
Employees (v_employee)
This view lists information about the employees' data.
Fields that can be displayed
| Translated name (Visual editor) | Name in the database (SQL Editor) | Key field Key fields are those that can be used to make the link between the tables of the dynamic view |
|---|---|---|
| Employee ID | employee_id | |
| Employee's Name | name | |
| PIS (Social Integration Plan) | pis | |
| Employee's external ID | external_id | |
| Enabled | enabled | |
| Company ID | company_id | |
| Company name | company_name | |
| Allows time change | allow_change_time | |
| Allows driving time definition | allow_driving_time | |
| NFC Mode | nfc_mode | |
| Operation mode code | operation_mode | |
| Operation mode | operation_modedesc | |
| Uses overnight stay | overnight | |
| Controls overnight stay | control_overnight | |
| Time zone | timezone |
Employees' virtual fences (v_fence_employee)
This view lists the virtual fence for each Employee.
Fields that can be displayed
| Translated name (Visual editor) | Name in the database (SQL Editor) | Key field Key fields are those that can be used to make the link between the tables of the dynamic view |
|---|---|---|
| Fence ID | fence_id | |
| Fence name | fence_name | |
| Employee ID | employee_id | |
| Employee's Name | employee_name |
Overnight stays (overnight_id)
This view lists information about the overnight stay.
Fields that can be displayed
| Translated name (Visual editor) | Name in the database (SQL Editor) | Key field Key fields are those that can be used to make the link between the tables of the dynamic view |
|---|---|---|
| Overnight stay ID | overnight_id | |
| Overnight stay date | date | |
| Overnight stay type code | type | |
| Overnight stay type | typedesc | |
| Employee ID | employee_id | |
| Employee's Name | employee_name |
English
Español
