Find definitions of the fields and measures included in the Vista: Human Resources dataset organized by folder.
The Vista: Human Resources dataset provides a consolidated source of data related to employee metrics and payroll. It includes fields and measures related to current and terminated employees, tenure, turnover rates, age range, gender, race, occupation, and payroll.
About Data Security
| DataType - Table |
| bPRCo - bPRCO, bPREH |
| bEmployee - bPREH |
Employee Metrics
- Active Employees Running Total
If used independently, it will return the current total number of employees. If used across a time period, it will consider whether an employee is active during that time period, and if their termination date (if applicable) is before the date on the visual. Conditions: 1. Hire Date <= Max date on visual 2. Active YN = Y 3. Blank Term Date OR Term Date > Max date on visual (accounts for those who may be active despite having a term date and those who are inactive with a blank term date).
- Average Tenure
Average tenure in years. To be used across various dimensions.
- Current Active Employees
Total number of distinct employees where Active YN = "Y". Based on hire date and a given point in time. If visualized with a time period (i.e. Year, Month) it will show results for that point in time. Use Running Total for "to date" totals.
- Employee Tenure
The tenure for a given employee based on hire date.
- New Hires
Total amount of distinct employees. To be used in conjunction with a date. References the Hire Date.
- Terminated Employees
Total number of distinct employees where Active YN = "N". To be used with a date. Based on the Termination Date.
- Terminated Employees Running Total
Cumulative running total of terminated employees. Use with date fields to see the trending total of terminated employees.
- Turnover Rate
Terminated employees / Active employees.
Payroll Accumulations
- Eligible Amount
The portion of subject earnings actually used for calculation after applying all caps, max limits, and system rules.
Vista table.field: bPREA.EligibleAmt
- Subject Amount
The gross portion of an employee's earnings that is potentially subject to a specific tax, deduction, or benefit calculation.
Vista table.field: bPREA.SubjectAmt
- Total Amount
The final calculated dollar value to be paid out or withheld for an employee.
Vista table.field: bPREA.Amount
- Total Hours
The total number of hours worked or accumulated associated with a specific employee.
Vista table.field: bPREA.Hours
Age Range
- Age Range
Provides a list of different age range buckets based on employee birth date.
Calendar Date
- Date
The calendar date.
Note: Date refers to different dates determined by which metric it's being used with. Terminated Employees, Terminated Employees Running Total, and Turnover Rate reference 'Termination Date'. Active Employees Running Total, Average Tenure, Current Active Employees, Employee Tenure, and New Hires reference the 'Hire Date'.- Month
-
Includes all dates from the start of the month through the end of the month.
- Quarter
-
Includes all dates from the start of the quarter through the end of the quarter.
- Year
-
The numerical value of the calendar year.
Category Status
- Category Status
Used to identify a list of all category status'.
Vista table.field: bPREH.CatStatus
Class
- Class
Used to identify a list of all classes.
Vista table.field: bPRCC.Class
- Class - Description
Class concatenated with description
Vista table.field: bPRCC.Class - bPRCC.Description
- Class Description
A description of the class.
Vista table.field: bPRCC.Description
Craft
Used to identify a list of all crafts.
- Craft
The employee's trade or skill.
Vista table.field: bPRCM.Craft
- Craft - Description
Craft concatenated with description .
Vista table.field: bPRCM.Craft - bPRCM.Description
- Craft Description
A description of the employee's trade or skill.
Vista table.field: bPRCM.Description
EDL Code
- EDL Type
Denotes whether a record is an earnings, deductions, or liabilities type.
Vista table.field: bPREC.EarnCode & bPRDL.DLCode
- EDL Code
Numeric code of earnings, deductions, or liabilities (EDL) type.
Vista table.field: bPREC.EarnCode & bPRDL.DLCode
- EDL Description
Text description of EDL codes.
Vista table.field: bPREC.Description& bPRDL.Description
- EDL Code - Description
Concatenated list of EDL Code & EDL Description.
Vista table.field: bPREC.EarnCode & bPRDL.DLCode - bPREC.Description& bPRDL.Description
Gender
- Gender Identity
Used to identify different employee gender identities.
Vista table.field: bPREH.GenderIdentity
Occupational Category
- Occupational Category
Categorical group an employee belongs to related to their occupation.
Vista table.field: bPROP.OccupCat
- Occupational Category - Description
Occupational concatenated with description.
Vista table.field: bPROP.OccupCat - bPROP.Description
- Occupational Category Description
Description of the occupational category that an employee belongs to.
Vista table.field: bPROP.Description
Payroll Company
- Payroll Company
Used for identifying a list of Payroll Companies
Vista table.field: bPRCO.PRCo
- Payroll Company - Name
Payroll company concatenated with payroll company name.
Vista table.field: bPRCO.PRCo - bHQCO.Name
- Payroll Company Name
The name of the payroll company.
Vista table.field: bHQCO.Name
Payroll Department
Used for identifying list of Payroll Departments.
- Payroll Department
The name of the payroll department.
Vista table.field: bPRDB.PRDept
- Payroll Department - Description
Payroll department concatenated with description .
Vista table.field: bPRDB.PRDept - bPRDB.Description
- Payroll Department Description
A description of the payroll department.
Vista table.field: bPRDB.Description
Payroll Employees
Used to identify different attributes related to an employee.
- Active YN
The current employment status of the employee.
Vista table.field: bPREH.ActiveYN
- Address
The primary location information (street name, number) for the employee.
Vista table.field: bPREH.Address
- Address 2
The secondary location information (apartment, unit, suite, office) for the employee.
Vista table.field: bPREH.Address2
- Birth Date
The employee's date of birth.
Vista table.field: bPREH.BirthDate
- City
The city the employee resides in.
Vista table.field: bPREH.City
- Country
The country the employee resides in.
Vista table.field: bPREH.Country
The employee's email address.
Vista table.field: bPREH.Email
- Employee
The employee number.
Vista table.field: bPREH.Employee
- Full Name
The employee's full name.
Vista table.field: Concatenated bPREH.FirstName & bPREH.LastName
- Hire Date
The date the employee's employment commenced.
Vista table.field: bPREH.HireDate
- Phone
The phone number for the employee.
Vista table.field: bPREH.Phone
- Recent Rehire Date
Date on which the employee was most recently rehired if previously separated.
Vista table.field: bPREH.RecentRehireDate
- Recent Separation Date
Date in which the employee was most recently separated, if applicable.
Vista table.field: bPREH.RecentSeparationDate
- State
The U.S. State where the employee resides.
Vista table.field: bPREH.State
- Termination Date
The employment termination date for the employee.
Vista table.field: bPREH.TermDate
- Zip
The postal code for the employee.
Vista table.field: bPREH.Zip
Payroll Group
- Payroll Group
Used for identifying a list of Payroll Groups.
Vista table.field: bPRGR.PRGroup
- Payroll Group - Description
Payroll group concatenated with description.
Vista table.field: bPRGR.PRGroup - bPRGR.Description
- Payroll Group Description
A description of the payroll group.
Vista table.field: bPRGR.Description
Race
- Race Description
Used for list of employee races.
Vista table.field: bPRRC.Description