Tables installed with HR Service Management

Human Resources Application: Core plugin adds the following tables.

Table Description
HR Case Model

[cmdb_hr_case_product_model]

The product models used for HR case record producers.
HR Task Model

[cmdb_hr_task_product_model]

The product models used for HR task record producers.
HR Assignment Data Lookup

[dl_hr_assignment]

The details of who HR cases can be assigned to.
HR Case

[hr_case]

The details of a submitted HR case.
HR Category

[hr_category]

The categories that can be assigned to HR cases, used for assignment and reporting.
HR Document Acknowledgement

[hr_document_acknowledgement]

Record that a preboarding employee has signed an online document.
HR Document Template

[hr_document_template]

Templates for generating HR documents as PDF files in HR cases.
HR Contact

[hr_emergency_contact]

The name and contact information for emergency contacts. The details of emergency contacts, displayed in the hr_profile record for a sys_user. Contains a reference to Profile [hr_profile].
Employment History

[hr_employment_history]

The details of employment history, displayed in the hr_profile record for a sys_user. Contains a reference to Profile [hr_profile].
Position

[hr_position]

The job positions and a reference to the departments the positions are part of.
HR Profile

[hr_profile]

The details of a profile for an employee that contains sensitive information.
HR Task

[hr_task]

The details of a task associated with a particular HR case.
HR Case Flow

[sf_hr_case]

The details of HR case state flows.
HR Task Flow

[sf_hr_task]

The details of HR task state flows.
HR link

[hr_link]

The details of HR links.
HR links for template lookup

[hr_m2m_link_template_lookup]

The details of HR links for looking up templates.
HR todo tasks for template lookup

[hr_m2m_task_template_lookup]

The details of to-do tasks for looking up templates.
Task templates

[hr_template_lookup]

The details of looking up templates.
Content Block Open Header

[content_block_open_header]

Signature Image

[signature_image]

Contains images of captured signatures.
Table 1. Tables for PDF generator
Table Description
General Element

[general_elements]

The formats used by the PDF generator that can be used to customize the template for the PDF document.
General List

[general_list]

A list of the properties and query used to generate the PDF document, for example, the employment verification letter.