You may request a data export of all your data by contacting CivicPlus Support. In this export, you will receive a raw collection of data in its purest format directly into CSVs. Learn how to Download Your CivicHR Export.
Important Note
- All dates and times are stored in UTC (Coordinated Universal Time).
Article Navigation
- Where to Find Source Table Settings (List Settings)
- Where to Find Job Master Data
- Where to Find Requisition Data
- Where to Find General Candidate Data
- How to Get Raw Candidate Application Data
- Where to Find Job Alert Recipients
- Where to Find Employee Data
- Where to Find Assessment Question Bank
- How to Get Raw Onboarding Data
- How to Get Performance Evaluation Library Data
- How to Get Raw Performance Review Data
Where to Find Source Table Settings (List Settings)
In CivicHR, when you navigate to Settings, these are the files where you will find the data that populates your settings.
| Data | File Name |
| Candidate Groups | Ats.CandidateGroup |
| Candidate Statuses | Ats.CandidateStatus |
| Departments | Ats.JobDepartment |
| Dismissal Reasons | Ats.CandidateRejection |
| Divisions | Ats.Division |
| Job Classification (ex. Exempt, Non-Exempt) | Ats.JobClassification |
| Job Source Channels | Ats.CandidateSource |
| Locations | Ats.ClientLocation |
| Pay Basis (ex. Hourly, salaried) | Ats.JobPayBasis |
| Pay Frequency | Ats.JobPayFrequency |
| Pay Ranges | Ats.JobSalaryRange |
| Pay Status (ex. Full-Time, Part-Time) | Ats.JobPayStatus |
| Requisition Status (Ex. “Accepting Applications”) | Ats.JobRequisitionStatus |
| Requisition Type (Ex. Internship, Volunteer, etc) | Ats.JobRequisitionType |
Where to Find Job Master Data
The Job Master in CivicHR has configurable tabs that can be renamed. You may have repurposed these tabs to suit the way you wish to describe your jobs. Therefore, below we will be referring to each tab in the order they appear in the UI (user interface).
| Tab in UI | File Name |
| 1st, 2nd, 7th, 8th, 9th, and 10th tab | Ats.JobMaster |
| 3rd tab | Ats.JobResponsibility |
| 4th tab | Ats.JobPerformanceMeasurement |
| 5th tab | Ats.JobKsa |
| 6th tab | Ats.JobPhysicalRequirement |
Where to Find Requisition Data
| Data | File Name |
| Requisitions | Ats.JobRequisition |
Where to Find General Candidate Data
| Data | File Name |
| Name | Cnd.CandidateUser |
| Cnd.CandidateUserMemebership | |
| Address, City, Zip | Cnd.CandidatePersonal |
| Applications | Ats.Application – see below for how to get to the raw data |
| Resources | Cnd.CandidateResource |
| Application Data | Ats.ApplicationSectionData – see below for how to get to the raw data |
| Notes | Ats.CandidateNotes |
Note: A candidate may have two PDFs for their job application if they are utilizing the VSID section or have sensitive assessments. The redacted version is ResourceTypeId 19 and the sensitive version is ResourceTypeID 20. You can find the PDFs in the folder “Candidate Application And Resources”. The sensitive version contains “sensitive” in the file name.
How to Get Raw Candidate Application Data
Every application is listed in ats.Application. Each application is one record. A candidate could apply to more than one job requisition and therefore be listed here for each requisition that they applied to. The ApplicationId from ats.Application would have one or more matches in ats.ApplicationSectionData. Each record in ats.ApplicationSectionData represents one section of a job application. For example, a job application may have the base application, a VSID section, and 0 or more assessment sections. Once you find all records in the ats.ApplicationSectionData, there is a file name that stores the raw XML. The XML contains each question as an XML tag.
For internal candidates, you will use the same process but look at ats.ApplicationInternal and ats.ApplicationInternalSectionData.
Note: The printed (PDF) version of every application is also included in the export. Those can be found in the folder “Candidate Application and Resources”.
Where to Find Job Alert Recipients
| Data | File Name |
| Passive Candidates / Job Alert Recipients | Cnd.JobAlertRecipient |
Where to Find Employee Data
| Data | File Name |
| Name | Ats.AgileUser |
| Email, main role | Ats.AgileUserMembership |
| Job title, supervisor, hire date, start date, termination date, gender, race, vet status, disability | Ats.Employee |
| Logged history and notes | Ats.ActivityLog |
Note: RaceIDs can be found on ats.EmployeeRace.
If you are using Onboarding, you can get additional information about your employees that have filled out onboarding plans.
| Data | File Name |
| Address, Phone, DOB, SSN, marital status | Onb.EmployeePersonal |
Where to Find Assessment Question Bank
You can get a list of your sections (base application, VSID, and assessment section titles) from ats.ApplicationSectionHeader. The column called IsBase denotes whether it is a section for the main job application. The ApplicationSectionHeaderID from this file then ties to the file ats.ApplicationSectionDetail. The detail ID then goes to ats.Question. The answers are then on ats.QuestionItem.
Sometimes there will be two application section details for one header ID that points to duplicate copies of the questions! This is because if you publish a requisition using those questions, the set of questions is now set in stone and can't be changed. If a user goes back and updates the questions, it makes a fresh copy.
If there are multiple section details, use the version with the larger ID. It should be the most recent.
How to Get Raw Onboarding Data
You can get the PDF version of every onboarding form that was filled out by looking in the folder “Onboarding Forms”. A list of all onboarding plans can be found in onb.OnboardingPlan. The OnboardingPlanID then ties to various files such as onb.OnboardingPlanSection, onb.OnboardingPlanVideo, and onb.OnboardingPlanForm. Form data lookup can be traced from onb.OnboardingPlanFormData which would then have the name of the XML file for you to get the raw form data. Each question on the form is its own tag in the XML.
How to Get Performance Evaluation Library Data
There are four main sections that make up reviews: competencies, core values, goals, and objectives. These sections can be renamed and therefore called something different in your system. However, the file/table names remain the same.
| Data | File Name |
| Competency Category Names | Pfm.LibraryCompetencyCategory |
| Competency Items | Pfm.LibraryCompetencyDescription |
| Core Values Category Names (2nd section) | Pfm.LibraryCoreValueCategory |
| Core Value Items | Pfm.LibraryCoreValueDescription |
| Goal Category Names | Pfm.LibraryGoalCategory |
| Goal Items | Pfm.LibraryGoalDescription |
| Objectives | Pfm.LibraryObjectiveDescription |
Note: If you are using sub-competencies, then you will need to look at these tables instead for your competency library:
| Sub-Competency Library Data | File Name |
| Competency Category | Lib.MasterCompetencyCategory |
| Competency | Lib.MasterCompetency |
| Sub-Competency | Lib.MasterSubCompetency |
| Coaching Levels | Lib.MasterCoachingLevel |
| Feedback Coaching Descriptions | Lib.MasterCoachingDescription |
How to Get Raw Performance Review Data
The Final Merge Report for all reviews that are ‘Completed” or “Closed” can be found in the folder “PM Reviews”.
| Data | File Name |
| A list of all reviews | Pfm.Review |
| Competencies on each review | Pfm.ReviewCompetency |
| Competency scoring | Pfm.ReviewCompetencyEvaluation |
| Competency feedback | Pfm.ReviewCompetencyFeedback |
| Core Values on each review | Pfm.ReviewCoreValue |
| Core Value scoring | Pfm.CoreValueEvaluation |
| Core Value Feedback | Pfm.CoreValueFeedback |
| Goals on each review | Pfm.ReviewGoal |
| Goal Scoring | Pfm.ReviewGoalEvaluation |
| Goal Feedback | Pfm.ReviewGoalFeedback |
| Objectives on each review | Pfm.ReviewObjective |
| Objective Scoring | Pfm.ReviewObjectiveEvaluation |
| Objective Feedback | Pfm.ReviewObjectiveFeedback |
If you are using sub-competencies, then use these files instead:
| Sub-Competency Data | File Name |
| Sub competencies on each review | Pfm.ReviewSubCompetency |
| Sub Competency Scoring | Pfm.ReviewSubCompetencyEvaluation |
Comments
Let us know what was helpful or not helpful about the article.0 comments
Please sign in to leave a comment.