Home > Guides > Reporting > Report Writer > Building Reports > Functionality > Data Sources > Data Source Listing
Data Source Listing
Data Sources are the starting point of any report. These sources are NOT individual SQL tables. They are views within the SQL database which have been custom formatted to allow for simplicity of linking between tables as well as reporting on items which are not already in the table. Often only one source is needed, even though it is pulling from more than one screen in the system.
These data sources will provide information for the vast majority of reports.
Applicant views will only include applicants in the report that have records in the related table. For example, Education will only list applicants who have education records.
Requisition views will only include requisitions in the report that have records in the related table. For example, Req Notes will only list requisition where there are notes added to the requisition page.
Applicant Specific Views
Views are shown in the order they appear in the Applicant Profile
| Source Name |
When to Use: |
Information from which Screen/Area |
All Applicants and Connected Reqs
|
For reports where you want to include all applicants and attached requisition information if any.
|
Applicant Demographics, Status, Resume. If a requisition is attached, then it will also include Activity > Reqs, Req Main, Req Job Description. If a requisition is not attached the column will be blank.
|
Applicants and Connected Reqs
|
For reports where you want to include only applicants with attached requisition information.
|
Applicant Demographics, Status, Resume, Activity > Reqs, Req Main, Req Job Description
NOTE: This data source assumes there is a record on the Activity > Reqs tab.
|
Routings
|
For reporting an applicant's routings, including req information
|
Main, Job Description and Applicant Activity > Routing
|
Interviews
|
For reporting an applicant's invitations for interviews, including information about the requisition.
|
Applicant Demographics, Status, Resume, and Activity >Invites
|
Interview Evaluations
|
For reporting an applicant's invitations for interviews, including req information and the evaluation questions.
|
Applicant Demographics, Status, Resume, and Activity >Invites > Evaluations
|
Offers
|
For reporting applicants with offers and the offer information.
|
Applicant Demographics, Status, Resume, and Activity >Offers
|
Offer Questions
|
For reporting applicants with offers including the offer questions/answers and the related requisitions.
|
Applicant Demographics, Status, Resume, and Activity >Offers > Questions and Req>Main
|
Offer Approvals
|
For reporting applicants with offers and the approval information if any.
|
Applicant Demographics, Status, Resume, and Activity >Offers > Approvals
|
| Skills |
For reporting applicants with skills.
|
Applicant Demographics, Status, Resume, and Experience/Skills
|
| Education |
For reports requiring an applicant's educational information.
|
Applicant Demographics, Status, Resume and Education |
| Previous Employment |
For reporting applicants with their previous employment records.
|
Applicant Demographics, Status, Resume, and Experience/Employment
|
| Military History |
For reporting applicants with their military history.
|
Applicant Demographics, Status, Resume, and Experience/Military History
|
| Security Clearance |
For reporting an applicant's security clearance information.
|
Applicant Demographics, Status, Resume, and Experience/Security Clearance
|
| Application Questions |
For reporting applicants with their application questions. This report can include all applicants regardless of whether or not they have answered any questions.
|
Applicant Demographics, Status, Resume, and Application
|
| Applicant Req Questions and Answers |
For reporting applicants with their requisition questions and answers.
|
Applicant Demographics, Status, Resume, Requisitions and the subsequent questions and answers.
|
| Applicant History |
For applicant reports that include the dates and other specifics of changes to an applicant's status.
|
Applicant Demographics, Status, Resume, and Status/History
|
| Correspondence |
For reporting the correspondence types and dates sent to applicant.
|
Applicant Demographics, Status, Resume, and Correspondence
|
| Attachments |
For reporting an applicant's attachment types and dates of attachment. |
Applicant Demographics, Status, Resume, and Attachments |
| Applicant Notes |
For reporting notes, type and date attached to an applicant's record. (Note this view will only show applicants that have notes other than routing, interview and offer notes in their records.)
|
Applicant Demographics, Status, Resume, and Notes
|
Applicant Main
|
For reports requiring current basic applicant information on any/all applicants. Applicant Demographics, Status, and Resume
|
|
| Applicant Tasks |
For reports requiring information on tasks |
Applicant Demographics, Status, Resume, and tasks
|
References
|
For reporting listed applicant references. It does not include the questions.
|
Applicant Demographics, Status, Resume, and References
|
Reference Questions
|
For reporting how references answered reference questions about the applicant. This report can include all references regardless of answers.
|
Applicant Demographics, Status, Resume, and References > Questions
|
Resume History
|
For reporting applicants' resume history. Note: this includes only applicant's with resume history, not those with just a current resume.
|
Applicant Demographics, Status, Resume, and Resume History
|
Employee Referral
|
For reporting employees (hired applicants) who have referred other applicants and bonus information if any.
|
Applicant Demographics, Status, Resume, and Employee Referral page
|
Inbox
|
|
Inbox view
|
| Applicant Rankings |
For reporting how users have ranked applicants from within their Inbox view. |
Applicant Demographics, Status, Resume and the User Rankings assigned |
Job Notifications
|
Use this view to create a report which will display which applicants have alerts set up. All alerts will show, but the filter can be used to narrow down the list to just active alerts based on the DateAdded and the current 'expire' options set up in the configuration. The view will display the applicant's name, date the alert was added (DateAdded), which type (ie.org structure, misc, field, etc.) (NotifType) and value the applicant was interested in (NotifValue).
|
Applicant Demographics, Status, Resume, and Job Alerts which are monitored
|
Job Notifications Sent
|
Use this view to create a report to see which applicants have received alerts. The view which will display the applicant's name, which type (org structure, misc, field, etc.) (NotifType), value the applicant was interested in (NotifValue) as well as the email itself (EmailSubject and EmailText).
|
Applicant Demographics, Status, Resume, Job Alert definition, and email details.
|
Applicant Integration Views
Use these sources to pull information from the system related to other products which are integrated with Cyber Recruiter.
| Source Name |
When to Use: |
Information from which Screen/Area |
| HRIS Integration...ADP |
For reports requiring an applicant's ADP information. |
Applicant Demographics, Status, Resume, and ADP |
HRIS Integration...Deltek Costpoint
|
For reports requiring an applicant's Costpoint information. |
Applicant Demographics, Status, Resume, and Costpoint |
HRIS Integration...Deltek GCS
|
For reports requiring an applicant's Deltek GCS Premier information. |
Applicant Demographics, Status, Resume, and GCS Premier |
HRIS Integration...Microsoft Dynamics GP
|
For reports requiring an applicant's Great Plains information. |
Applicant Demographics, Status, Resume, and Great Plains |
HRIS Integration...HR Office
|
For reports requiring an applicant's HR Office information. |
Applicant Demographics, Status, Resume, and HROffice |
HRIS Integration...HR-XML
|
For reports requiring an applicant's HRXML information. |
Applicant Demographics, Status, Resume, and HRXML |
HRIS Integration...Deltek Vision
|
For reports requiring an applicant's Deltek Vision information. |
Applicant Demographics, Status, Resume, and Visions |
Requisition Specific Views
Views are shown in the order they appear in the Requisition Profile
| Source Name |
When to Use: |
Information from which Screen/Area |
Requisition Main
|
For reporting basic requisition information.
|
Main and Job Description
|
All Reqs and Connected Applicants
|
For reports where you want to include all requisitions and attached applicant information if any.
|
Req Main, Req Job Description. If an applicant is attached, then it will also include Activity > Reqs, Applicant Demographics, Status, and Resume
|
| Req Approval |
For reporting on requisition approvals. |
Main, Job Description, and Approvals |
Req History
|
For reporting requisition history.
|
Main, Job Description and History
|
Req Notes
|
For reporting on notes attached to requisitions.
|
Main, Job Description and Notes
|
Req Skill Requirements
|
For reporting on requisition skill requirements.
|
Main, Job Description and Requirements
|
Req Education Requirements
|
For reporting on requisition education requirements.
|
Main, Job Description and Requirements
|
| Req Costs |
For reporting cost associated to requisitions.
|
Main, Job Description and Costs
|
| Req Attachments |
For reporting on requisition attachments. |
Main, Job Description and Attachments |
| Reqs from Agencies |
For reporting on which requisitions are assigned to Agencies |
Main, Job Description and Agencies |
Requisition Integration Views
Use these sources to pull information from the system related to job board posting.
| Source Name |
When to Use: |
Information from which Screen/Area |
| Reqs Posted to CareerBuilder |
For reporting requisitions posted to Career Builder. |
Main, Job Description and CareerBuilder |
| Reqs Posted to Dice |
For reporting requisitions posted to Dice. |
Main, Job Description and Dice |
| Reqs Posted to Monster |
For reporting requisitions posted to Monster. |
Main, Job Description and Monster |
Administrative Views
| Source Name |
When to Use: |
Information from which Screen/Area |
| Agencies |
For reporting on the agencies which are currently being used.
|
Admin > Website > Agency Portal > Agencies |
Agency Users
|
For reporting on the individual agents at an agency.
|
Admin > Website > Agency Portal > Agencies > User Page |
| Code Tables |
For reporting codes, descriptions and the tables to which they apply. |
Admin > Codes |
| Deleted Applicants |
For reporting a list of deleted applicants and deletion information |
Stores all the applicants who have been manually removed from the system
|
Deleted Requisitions
|
For reporting a list of deleted requisitions and deletion information.
|
Stores all the requisition which have been manually removed from the system |
| Email Log |
For reporting the email log records. |
Admin > Logs > Email Log |
| Error Log |
For reporting the error log records. |
Admin > Logs > Error Log |
| Logins |
For reporting on the user security. |
Admin > Security > Users |
| Login History |
For reporting user login history. |
Admin > Security > Login History |
| Search Log |
For reporting search log history. |
Admin > Logs > Search Log |
See also
| For reporting a list of deleted applicants and deletion information. |
|