Quicksight datasets for customers - Taleo users
Purpose
This article provides an overview of customer datasets on QuickSight that can be accessed via the Dashboard Authoring Console. For information on how to access the Dashboard Authoring Console, refer to the Dashboard Authoring Console document.
QuickSight Datasets
This section lists the datasets and dashboards available via the Dashboard Authoring Console.
List of customer datasets
The following table lists the possible datasets an admin user would see when logged in to the Dashboard Authoring Console from within a customer instance. Note that datasets would only be available for provisioned dashboards.
| List of customer datasets | ||
|---|---|---|
| Dataset suffix | Tables | Dashboards |
| positions | Position | Calibration |
| employee | Employee | - |
| profile | Profile | - |
| server_log_with_positions | Career Site | |
| stage_with_applications_and_positions | Career Site, TA Outcomes, Referral Activity Report | |
| survey_analytics | Survey analytics | Survey |
| application_source_with_app_pos | Sourcing Analytics | |
| user_analytics_with_positions |
|
|
| server_log_with_employee_and_positions | TM Usage | |
| employee_with_profile_and_profile_skill | Employee Skills Analytics |
Base Tables
This section lists the base tables that are used to create QuickSight Datasets.
| Base tables | |
|---|---|
| S.no | Table name |
| 1 | Position |
| 2 | Server log |
| 3 | Application stage |
| 4 | Survey analytics |
| 5 | Application |
| 6 | User analytics |
| 7 | Employee |
| 8 | Profile |
| 9 | Profile skills |
| 10 | Application source |
1. Positions
This table contains all the position data. Each row corresponds to a unique position.
| Positions | ||
|---|---|---|
| Column name | Description | Data type |
| position_id | Primary key: Every job posted has a unique position ID generated by Eightfold. | INTEGER |
| title | Job title associated with the position | STRING |
| location | City in which the job is posted | STRING |
| location_country | Country information extracted out of location | STRING |
| status | The status of the position as shared in customer data (for example, Posted, On Hold, To be approved, Expired) | STRING |
| is_open | If the position is open or closed | BOOLEAN |
| is_posted | If the position is posted or not | BOOLEAN |
| creation_ts | The time at which the position was created | DATETIME |
| last_modified_ts | The latest time at which the position was modified | DATETIME |
| seniority_level | Eightfold inferred seniority level; includes:
|
STRING |
| job_function | The job function associated with the position as provided in customer data. It can also be empty if no data is shared | STRING |
| location_latitude | Based on the location of the position | INTEGER |
| location_longitude | Based on the location of the position | INTEGER |
| business_unit | Business unit associated with the position as provided in customer data; can also be empty if no data is shared | STRING |
| ats_job_id | A requisition id as provided in the customer data | STRING |
| system_id | ATS name associated with the customer | STRING |
| employment_type | Type of employment as shared in customer data. It can be empty if not provided.
Eg: Full time, temporary, intern, etc. |
STRING |
| pay_rate_type | Pay Rate type as shared in customer data. It can be empty if not provided. | STRING |
| is_confidential | It indicates whether a position is confidential | BOOLEAN |
| number_of_openings | Total number of openings for a position | INTEGER |
| calibration_status | Indicates a position’s calibration status as inferred by Eightfold. This can be of three types:
|
STRING |
| title_cluster | Title cluster as determined by Eightfold’s machine learning models for every skill. | INTEGER |
| position_type | Indicates if the position is from eightfold platform or from the company’s ATS | STRING |
| calibration_template_id | The template associated with a Auto calibrated position | STRING |
| workflow_template_id | It's the workflow id associated with the position if shared in customer data. It can be empty if not provided | STRING |
| confirm_calibration_ts | Time at which the calibration was completed | DATETIME |
| num_leads | Number of leads associated with the position | INTEGER |
| hiring_company | Company Name | STRING |
| has_calibrated_location | Indicator if the position’s calibration has at least one or more location | BOOLEAN |
| has_calibrated_skills | Indicator if the position’s calibration has at least three or more skills | BOOLEAN |
| has_calibrated_titles | Indicator if the position’s calibration has at least three or more titles | BOOLEAN |
| has_calibrated_similar_cand | Indicator if the position’s calibration has at least three or more candidates | BOOLEAN |
| has_calibrated_workexp | Indicator if the position’s calibration has either min experience or max experience or in the range defined | BOOLEAN |
2. Server log
This table captures all the user activity that occurs on Eightfold products. Each row corresponds to a unique event/ action associated with a user taken on Eightfold platform. Please refer to the event names table below for details on user actions.
| Server log | ||
|---|---|---|
| Column Name | Description | Data type |
| unique_id | Unique Id associated with every entry in server log table | INTEGER |
| namespace | Unique identifier associated with a product area. Please see the Event names table below. | STRING |
| event | The event associated with the user’s action. Please see the Event names table below for various user actions. | STRING |
| user_email | Email id associated with the user | STRING |
| t_create | Timestamp when the action was taken by a user. | DATETIME |
| request_endpoint | The url associated with a hyperlink that a user might click on as part of user action. | STRING |
| referrer | The url associated with the referring website or page when a user is redirected to another page. | STRING |
| response_code | Indicates whether a specific HTTP request has been successfully completed. Common response codes include:
200 - Success |
INTEGER |
| user_agent | Indicates the device used to perform an action - Windows Laptop, Mac OS, Android, IoS etc. Captures all the metadata associated with the device like OS version etc. | STRING |
| hostname | Url associated with the host | STRING |
| request_path | Virtual path associated with every HTTP request. | STRING |
| referrer_path | The extracted url from referrer. | STRING |
| request_method | HTTP methods used to request data (GET) or send data (POST). | STRING |
| redirect_url | Redirected url associated with a request, if applicable. | STRING |
| vs_cookie | The session ID of the user. | STRING |
| query | Captures search keywords whenever a user performs a search on any relevant Eightfold page. | STRING |
| interface | Indicates the device used to perform an action. Interface is used to classify whether a user is performing an action on desktop or mobile or mobile app. | STRING |
| position_id | Eightfold generated unique ID associated with the profile | INTEGER |
| country | Country code associated with the user location. | STRING |
| utm_source | Populated for Career Site Applications where Eightfold was successfully able to be identify the source from where the candidate was navigated to the Career Site | STRING |
| utm_campaign | It is populated where EIghtfold could identify the campaign associated with the application | STRING |
This table below lists the various event names associated with user actions logged under the event column in the server log table.
Namespace indicates the product area in which the action was performed. Some of the events listed below are captured in a calculated field created on the dataset called_ Cleaned Event Map_.
| Event names | |||
|---|---|---|---|
| Namespace | Event name from the server log table | Cleaned Event Name (if applicable) |
Description |
| career_hub | home_view | User logins | Clicking on ‘Home View’ |
| career_hub | Finish_onboarding, onboarding_completed | Completed Onboarding | User has finished the onboarding process |
| career_hub | Profile_gaps, profile_role_models, career_planner_skill_gap_analysis | Skill Gaps/ Role Model Views | Event fired when a user views Skill gaps, Role models or Career Planner Skill Gap analysis |
| career_hub | profile_paths,profile_role_models | Career Path Views | Event fired when a user views view profile paths & models |
| career_hub | career_planner_next_steps | Next Steps Views | Event fired when a user views next steps |
| career_hub | view_job, position_view | Job Views | Event fired when a user views job/position |
| career_hub | Click_apply_to_job,apply_modal, position_apply_position, {request_method}='GET' | Applications Started | Event fired when a user starts an application for a position |
| career_hub | apply_to_job | Applications Submitted | Event fired when a user submits an application |
| career_hub | Course_view, click_view_course | Course Views | Event fired when a user clicks to view a course |
| career_hub | course_search | Course Searches | Event fired when a user searches for a course |
| career_hub | course_favorite | Courses Favorited | Event fired when a user favorites a course |
| career_hub | course_enroll | Courses Enrolled | Event fired when a user enrolls in a course |
| career_hub_candidate | home_view | Event fired when a user lands on the career hub homepage /careerhub . | |
| career_hub_candidate | position_view | Event fired when a user views a job/position. | |
| career_hub_candidate | profile_view | Event fired when a user visits their profile page. | |
| career_hub_candidate | Click_apply_to_job, position_apply_position | Event fired when a user starts an application for a position (clicks on “Apply Now” button on a job post). | |
| career_hub_candidate | apply_to_job | Event fired when a user submits an application. | |
| career_hub_candidate | onboarding_completed | Event fired when a user finished onboarding. | |
| career_hub_candidate | profile_edit_metadata_wizard_step0 | Event fired when a user edits the meta data section (name, phone, location, etc.) on the profile page. | |
| career_hub_candidate | profile_edit_preferences_wizard_step1 | Event fired when a user edits the preference section (preferred roles, preferred skills, preferred locations) on the profile page. | |
| career_hub_candidate | profile_edit_experience_wizard_step2 | Event fired when a user edits the “work experience” section on the profile page. | |
| career_hub_candidate | profile_edit_education_wizard_step3 | Event fired when a user edits the “education” section on the profile page. | |
| career_hub_candidate | profile_edit_resume | Events fired when a user edits a resume on their profile page (clicks on “pencil” icon) | |
| career_hub_candidate | profile_resume_upload | Event fired when a user uploads a resume on their profile page (clicks on “upload new”) | |
| career_hub_candidate | profile_resume_upload_as_attachment | Event fired when a user uploads a resume on their profile page (clicks on “select file”). | |
| career_hub_candidate | profile_skills_suggest | Event fired when skills suggestions are made when a user edits skills in their profile. | |
| career_signup | candidate_signup_create_accoun | Event fired when a user signs up for Career Hub. | |
| career_login | login | Event fired when a user logs into Career Hub. | |
| smartapply | Api_get_job, api_get_jobs | Event fired when a user views job postings on the career site. | |
| smartapply | api_post_resume | Event fired when a user successfully uploads their resume on the career site. | |
| smartapply | api_post_attachments | Event fired when a user uploads a non-resume attachment in the application process. | |
| smartapply | apply_matches | Event fired when a job match happens (for each job post). Job matches are generated based on data specific to the user. | |
| smartapply | api_get_job_insights | Event fired when job insights are pulled (for each job post). Job insights are generated based on historical data of all applicants, not specific to the user. | |
| smartapply | click_apply_to_job | Event fired when a user starts an application for a position (clicks on “Apply Now” button on a job post). | |
| smartapply | apply_to_job | Event fired when a user submits an application. |
3. Application stage
This table captures all stage advances on an application along with the timestamp.
| Application stage | ||
|---|---|---|
| Column Name | Description | Data type |
| application_id | Unique ID associated with the application | STRING |
| stage | Every stage of the application process that the applicant goes through | STRING |
| stage_ts | The timestamp associated with each stage | DATETIME |
| profile_id | Eightfold generated unique ID associated with the profile | INTEGER |
| position_id | Eightfold generated unique ID associated with the position | INTEGER |
| stage_group | The different application stages are grouped under stage groups | STRING |
| system_id | ATS name associated with the customer | STRING |
4. Survey analytics
This table captures the activity associated with surveys - including surveys displayed and user responses.
| Survey analytics | ||
|---|---|---|
| Column Name | Description | Data type |
| unique_id | ID of each survey response from users | INTEGER |
| embedding_id | Embedding ID indicates different surveys, e.g. “pcs_apply_thank_you_page” (career site candidate post-application survey), “candidate_experience_survey”, “candidate_interview_experience_survey”. | STRING |
| question_id | Unique ID of the questions on the survey. | INTEGER |
| question_label | The questions on the survey, e.g. “How was your application submission experience?” | STRING |
| event | In this table all events are “submit_survey”. | STRING |
| user_email | Email id associated with the user. | STRING |
| vs_cookie | Cookie ID of each user. | STRING |
| request_url | The URL where the survey takes place. | STRING |
| interface | Indicates the device used to perform the action. Interface is used to classify whether the user is performing an action on desktop or mobile or mobile app. | STRING |
| country | Country code associated with the user location. | STRING |
| t_create | Timestamp when the action was taken by the user. | DATETIME |
| rating | A rating (1 to 5) that the user gave as an answer to rating questions such as “How was your application submission experience?” (users are asked to choose 1 to 5 stars on the survey) | INTEGER |
| max_rating | The max rating that a user gave to a question on a survey. Sometimes the user would change the rating, and this column records the max rating that the user gave. | INTEGER |
| utm_source | Populated for Career Site Applications where Eightfold was able to identify the source from which the candidate was navigated to the Career Site. | STRING |
| utm_campaign | It is populated where EIghtfold could identify the campaign associated with the application. | STRING |
| answer | The answer that the user gave to the survey questions. If the question is a rating question, this column would have the same value as raing. | STRING |
| is_promoter | Whether or not the user is a promoter of the product (e.g. the career site) based on their rating. Rating = 5: is_promoter = 1; rating =4, is_promoter is null; rating <=1, is_promoter = -1. | INTEGER |
| is_comment | If the question is not a rating question, is_comment = 1, otherwise is_comment is null. | INTEGER |
5. Application
This table captures application details. Each row corresponds to a unique application.
| Application | ||
|---|---|---|
| Column Name | Description | Data type |
| profile_id | Eightfold generated unique ID associated with the profile | INTEGER |
| application_id | Unique ID associated with the application | STRING |
| source_type | Source type of the Application Eg: Career Site, Job Board, Referral | STRING |
| source_name | Source name associated with the source type | STRING |
| application_ts | Time at which the application was submitted | DATETIME |
| hired_ts | Time at which the applicant was indicated as hired in the system | DATETIME |
| last_stage | The latest interview stage an applicant is in | STRING |
| last_stage_ts | The time associated with the latest stage | DATETIME |
| ats_job_id | It is a requisition id as provided in the customer data | STRING |
| position_id | Eightfold generated unique ID associated with the position | INTEGER |
| match_stars | Match stars associated with the application. It determines how well a candidate is suited for a particular position. The range is between 0-5 | DECIMAL |
| candidate_id | ID associated with the candidate | STRING |
| is_referral | It indicates if the applicant is referred by any employee | BOOLEAN |
| is_internal | Indicates if the candidate is internal (employee) | BOOLEAN |
| status | Indicates if a Candidate is Hired or Rejected | STRING |
| rejection_reason | Reason for rejection | STRING |
| system_id | ATS name associated with the customer | STRING |
| in_talent_network | Indicates repeat applicants who has submitted at least 1 application 28 days prior to their current application | BOOLEAN |
| last_stage_group | Latest stage group associated with the applicant | STRING |
| utm_source | Populated for Career Site Applications where Eightfold was successfully able to be identify the source from where the candidate was navigated to the Career Site | STRING |
| utm_campaign | It is populated where EIghtfold could identify the campaign associated with the application | STRING |
| ef_gender | Eightfold inferred gender information. Includes:
|
STRING |
| ef_race | Eightfold inferred ethnicity | STRING |
| ef_veteran_status | Eightfold inferred veteran status | BOOLEAN |
6. User analytics
This table captures a subset of user activity from the Server Log table. The activities captured are listed in the Event descriptions table below.
| User analytics | ||
|---|---|---|
| Column Name | Description | Data type |
| event | Name of the event associated with a user action taken on an Eightfold powered product | STRING |
| user_id | Email id of the user who performed the action | STRING |
| position_id | Position Id associated with the position against which the action was performed. This column is populated only when the action is associated with a position | INTEGER |
| source | If there is a source associated with an event then it is populated in this column | STRING |
| timestamp | Timestamp when the user performed the action | DATETIME |
| num | Default value for num is 1. It can be used for summarising user actions into counts. | INTEGER |
| profile_id | Profile Id associated with the profile on which a user action was performed. This column is populated for events where the action taken is relevant for a profile. | INTEGER |
The table below provides descriptions of the various events that are present in the user_analytics table.
| Event descriptions | ||
|---|---|---|
| Event name from user analytics table | Cleaned Event Name in QuickSight Dataset (if applicable) | Description |
| add_to_ats | Add profile to ATS | Candidate manually added to ATS |
| add_to_pipeline | Save profile to pipeline (in product or in extension) | Lead/Candidate saved by a user to a pipeline within EF. This includes both save to pipeline for a different position AND save profile using extension |
| extension_click | Extension action (Save, contact, schedule, etc.) | Any action taken from the extension (save, contact, schedule, share, create reminder, find similar, add as ideal candidate) |
| advance | Advance candidate to next stage | Advancing a candidate in the pipeline for any stage enabled in EF for a customer. |
| feedback_request | Feedback request | Profile shared for feedback |
| feedback_response | Feedback response | Profile feedback submitted |
| reject_in_ats | Reject in ATS | Rejecting a candidate in the pipeline at any stage for enabled stages for the customer |
| campaign_confirm | Campaign send | Campaign sent |
| campaign_create_new | Campaign create | New campaign created |
| contact | Contact (email) in EF or mark as contact | Initial contact email sent from EF OR candidate marked as contacted |
| sms_send | Send an SMS in EF | SMS sent from EF |
| diversity_dashboard_view | Diversity dashboard view | A user viewed the diversity dashboard within EF |
| ta_dashboard_view | Talent Analytics Dashboard View | A user viewed the talent analytics dashboard within EF |
| extension_view | Extension view | An external (e.g. LinkedIn) profile viewed when the EF extension was active |
| prview | Profile Resume View | Profile's resume was viewed |
| pview | Profile View | Profile was viewed |
| scheduling_alternate_interviewer | Scheduling - Alternate Interviewer | User edit Interviewers from Scheduling dashboard |
| scheduling_back_to_back | Scheduling - Back to Back | User schedules a meeting with Multiple interview slots |
| scheduling_candidate_choice | Scheduling - Candidate Choice | User schedules a meeting via 'Let the Candidate Choose' scheduling method |
| scheduling_candidate_update_contact_information | Scheduling - Candidate_Update_Contact Information | Contact information updated for candidate on microsite |
| scheduling_one_one | Scheduling - One on One | User schedules a meeting with with one Interview slot |
| scheduling_other_cancel | Scheduling - Other Cancel | User cancels a meeting |
| scheduling_scheduler_reschedule | Scheduling - Scheduler Reschedule | User reschedules a meeting |
| scheduling_send | Scheduling - Send | User schedules a meeting |
| scheduling_specific_time | Scheduling - Specific Time | User schedules a meeting via specific time scheduling method |
| scheduling_suggested_time | Scheduling - Suggested Time | User schedules a meeting via Suggested Timeslots Scheduling method |
| update_profile | - | Do not use - includes all actions that update a candidate profile (including add to pipeline, screen_pass, add_note, star_to_pipeline). Use the underlying events instead |
| open | - | Recipient viewed a contact email from EF |
| bounce | - | Contact email sent from Eightfold bounced |
| click | - | Recipient clicked on a contact email sent from EF |
| reply | - | Recipient replied to a contact email sent from EF |
| spam | - | Recipient marked as spam a contact email sent from EF |
| profile_to_pdf | - | Download profile as EF formatted pdf |
| event_recruiting_create_event | - | Event recruiting event created in Eightfold |
| tag | - | Add tags for profiles in the pipeline |
| pclick | - | Profile click on redirect (/r route) |
| pass | - | Happens when a lead is archived. Corresponds to adding tag: "screen passed" to a candidate |
| campaign_save_schedule | - | Campaign scheduled to be sent (i.e. delayed send) |
| star_to_pipeline | - | Lead/Candidate starred by a recruiter/HM in TA pipeline |
| event_recruiting_activity_uploaded | Candidate being imported/added to the event | |
| event_recruiting_activity_invited_to_event | Candidate being invited to the event using RSVP action | |
| event_recruiting_activity_registered | Candidate registers for the event | |
| event_recruiting_activity_assessed | Candidate gets assessed for the event | |
| event_recruiting_activity_invited | Candidates who were added to the event get invited to register | |
| event_recruiting_activity_responded | Candidate responds to the RSVP request | |
| event_recruiting_activity_all_applied | Candidates who apply to any of the enterprise positions (which were not part of the event he was part of) in the 90 days window | |
| event_recruiting_activity_attended | Candidates who gets mark as attended | |
| event_recruiting_activity_all_offered | Candidates who get offered for any of the enterprise positions (which were not part of the event he was part of) in the 90 days window | |
| event_recruiting_activity_all_hired | Candidates who get offered for any of the hired positions (which were not part of the event he was part of) in the 90 days window | |
| event_recruiting_create_event | Event gets created | |
| event_recruiting_activity_applied | Candidates who apply for positions, which were associated with the event he was part of | |
| event_recruiting_activity_offered | Candidates who get offered for positions, which were associated with the event he was part of | |
| event_recruiting_activity_hired | Candidates who get hired for positions, which were associated with the event he was part of |
7. Employee
This table captures all the employee information. Each row corresponds to a unique employee record.
| Employee information | ||
|---|---|---|
| Column Name | Description | Data type |
| profile_id | Unique Identifier for a Profile in Eightfold’s data model | INTEGER |
| system_id | ATS name associated with the customer | STRING |
| employee_id | Unique identifier for employee | INTEGER |
| role | Role as defined in employee data shared by the customer | STRING |
| title | Title as defined in employee data shared by the customer | STRING |
| level | Level as defined in employee data shared by the customer | STRING |
| seniority | Eightfold inferred seniority level. Includes:
|
STRING |
| last_review_rating | Latest Review Rating as defined in employee data shared by the customer | STRING |
| employee_email | Email Id associated with the employee profile | STRING |
| manager_email | Manager’s email id as defined in employee data shared by the customer | STRING |
| hiring_date | Employee hire date as defined in employee data shared by the customer | DATETIME |
| termination_date | Employee termination date as defined in employee data shared by the customer | DATETIME |
| role_change_date | Employee most recent role change date defined in employee data shared by the customer | DATETIME |
| eligible_for_transfer | Employee’s eligibility for transfer defined in employee data shared by the customer | BOOLEAN |
| tenure_years | Total employee tenure in years computed using employee hiring date if shared in the employee data or tenure years as shared in employee data if hiring date is missing | DECIMAL |
| tenure_current_role_years | Tenure in current role in years computed using employee role change date if shared in the employee data or tenure in current role years as shared in employee data if role change date is missing | DECIMAL |
| lob | Line of business defined in employee data shared by the customer | STRING |
| business_unit | Business Unit as defined in employee data shared by the customer | STRING |
| creation_ts | Timestamp associated with employee login | DATETIME |
| profile_activated_ts | Timestamp when the user accepts privacy notice as part of onboarding on Eightfold powered Career Hub | DATETIME |
| is_alumni | Computed if employee termination date is shared in employee data by the customer. If the employee’s termination date is older than the hiring or rehiring date then the employee is tagged as an alumni. | BOOLEAN |
8. Profile
This table captures candidate profile information. At Eightfold, each candidate is referred to as a profile and is a superset of employees, applicants etc. Each row in this table corresponds to a unique profile.
| Candidate profile information | ||
|---|---|---|
| Column Name | Description | Data type |
| profile_id | Unique Identifier for a Profile in Eightfold’s data model | INTEGER |
| system_id | ATS name associated with the customer | STRING |
| first_name | First Name | STRING |
| last_name | Last Name | STRING |
| gender | Self declared gender information | STRING |
| ef_gender | Eightfold inferred gender information. Includes:
|
STRING |
| title | Current or most recent title inferred from profile data. | STRING |
| last_modified_ts | DATETIME | |
| candidate_id | Unique identifier associated with a profile’s application. Only populated for profiles where at least one application has been submitted. | STRING |
| location_country | Country of current or most recent known location | STRING |
| location_state | State of current or most recent known location | STRING |
| location_city | City of current or most recent known location | STRING |
| location_county | County of current or most recent known location | STRING |
| current_company | Current place of work | STRING |
| exp_years | Total years of experience in years | DECIMAL |
| highest_degree | Highest education degree. Includes normalized to following categories:
|
STRING |
| latest_major | Name of the current or latest major | STRING |
| has_resume | Profile has resume data associated with it:
1: Yes 0: No |
BOOLEAN |
| is_thin_profile | BOOLEAN | |
| num_skills | Count of skills on the profile | INTEGER |
| ef_race | Eightfold inferred ethnicity | STRING |
| seniority_level | Eightfold inferred seniority level. Includes:
|
STRING |
9. Profile skills
This table captures skills associated with employee profiles. It includes both stated and inferred skills sorted by relevance determined using Eightfold’s AI. Each row represents one skill per profile id.
| Profile skills | ||
|---|---|---|
| Column Name | Description | Data type |
| profile_id | Unique Identifier for a Profile in Eightfold’s data model | INTEGER |
| profile_type | Currently the only profile type supported in this table is employee | STRING |
| skill | Name of the skill associated with the profile | STRING |
| skill_cluster | Skill cluster as determined by Eightfold’s machine learning models for every skill. | INTEGER |
| proficiency_level | Information around proficiency level as indicated on Eightfold powered Career Hub. Proficiency Data is only available for customers who use this feature on Career Hub | DECIMAL |
| proficiency_source | Proficiency source as indicated on Eightfold powered Career Hub. Proficiency Source can be of 3 types:
|
STRING |
| proficiency_ts | Timestamp associated with when the proficiency was added on Eightfold powered Career Hub. | DATETIME |
10. Application source
This table captures details of application sources for every application. Please refer to the subsequent source combinations table for details of what each source represents.
| Application source | ||
|---|---|---|
| Column Name | Description | Data type |
| application_id | ID associated with the application | STRING |
| profile_id | ID associated with the applicant who has submitted his/her application | INTEGER |
| position_id | The position to which the applicant has applied to | INTEGER |
| action_user | The user who has performed the sourcing action.
Eg:- Contacted/Imported/Added/ the candidate |
STRING |
| source_type | Type of sourcing event that led to this application.
Eg:- ContactExtension//Import/EFN/Career site/Recruiting Event etc |
STRING |
| source | The first level of drill-down on the source_type column. | STRING |
| source_name | The second level of drill-down on the source_type column. Describe the more granular sourcing event details | STRING |
| sourcing_ts | The timestamp at which the sourcing event has happened. | DATETIME |
The table lists the detailed description of each source type, source and souce_name combination.
| Source combinations | |||
|---|---|---|---|
| Source_type | Source | Source_name | Description |
| Extension | Public/Recruiter | Profile sourced via extension and then became applicants within 90 days. | |
| Campaign | Campaign name | Creator | Profile contacted via campaign and then became applicants within 90 days. |
| Recruiting Event | Event name | Creator | If the profile was added via an event 90 days prior to application |
| Career Site | utm_source/utm_campaign | utm_source/utm_campaign values | Candidate applied via the company’s career site |
| Referral | Referrer Employee | - | Application is a referral |
| Internal | - | - | Internal application. |
| Others | Job boards | - | If the application flows from the ATS and has a source other than career site, referrals or internal applications |
| Contacted | User who has contacted | Contact medium | Profile was contacted and then became applicants within 90 days |
| Talent Network | - | - | If the profile had a pre-existing application within Eightfold for at least 28 days. \
This only reflects that prior to this application this candidate was already in the system. |
| Imported | User who has imported. | - | If profile was added via import resume 90 days prior to application |
| EFN | EFN user | - | If a profile came via the Eightfold Sourcing user 90 days prior to the application |