The Organization consists of three levels of organizational hierarchy.

The Organization consists of three levels of organizational hierarchy. There are one or more Groups to a Department and one or more Departments to a Division. When a Division is deleted all associated Departments and Groups are also deleted. Organization data (including all three parts) is maintained by the Payroll application.

All the remaining tables are maintained by the HR application.

All the remaining data is maintained by the HR application.

The HR application stores information on the employee in the Employee logical file. Employee dependent information about the spouse and children of the employee are stored on the Employee Dependent table.

Health insurance plan, dental insurance plan, life insurance, and accident insurance data is stored in the Benefits logical file.

Pay rate, bonus percentage, vacation accrual rate, vacation balance, and pension accrual rate are stored on the Compensation logical file.

Training classes attended and scheduled are stored in the Training logical file.

The health insurance table contains the code and description for all Health Insurance plans offered to the employees for health coverage.

The dental insurance table contains the code and description for all Dental Insurance plans offered to the employee for dental coverage

From the Names of Possible Functions listed identify the data functions for the HR application. Select N/A if a Name of Possible Function does not apply.

Identify the data functions used: