Home » Categories » Multiple Categories

Is there a glossary of terms mapping the Looker® Ad-Hoc Reporting and Data Management Solution terminology to the GradLeaders Career Center naming conventions?

Your GradLeaders Career Center platform data has already been modeled to make using Looker® even easier to use. But if you're not familiar with the GradLeaders Career Center terminology (or Looker®) we've created this handy glossary to help you better understand what each term means:

 

General Looker Terminology

Look = Report

Space = Folder to contain saved Looks

Data Model = GradLeaders has built the GradLeaders Career Center data architecture into Looker in a hopefully user-friendly way.  This model can be easily changed and improved without GradLeaders Career Center system changes.

Explore = major GradLeaders Career Center Data Module

  • Examples:   Job Postings, Advising Appointments or Students
  • The GradLeaders Career Center Data Model contains many Explores

View = GradLeaders Career Center Data Table or CSO Database

  • Examples: Job Master, Advising Activity, Candidate Profile Details
  • An Explore contains many Views

Dimension = Data Field found in GradLeaders Career Center

  • Examples: Job Posting Date, Student Last Name
  • A View contains many Dimensions

Measure = Pre-Defined Calculated Fields.  These are not actual GradLeaders Career Center data fields, but GradLeaders added them to the model for ease of use.

  • Examples: Count Jobs, Count Workshops, Average Salary
  • A View can contain one or more Measures.

Drills (Drill-downs) = click-through details on a Look

Custom Calculations = Columns that a user can add to a Look

 

GradLeaders Data Model Standards

GradLeaders Career Center allows flexible configurations and many schools name things differently.  These are the generic names used in the GradLeaders Career Center Looker Data Model.

Advising = Advising, Career Coaching, Career Counseling, etc.

Candidates = candidates, students, alumni, members, etc.

Employers = employers, companies, organizations, etc.

Employment / Job Offers = all variations of employment data, outcomes, placement, etc.

Events = all variations of Employer / Company Events.

  • Multi-Company includes Career Fairs, Industry Nights, Networking events, etc.
  • Single-Company includes Presentations, Info Sessions, Coffee Chats, and Other Events

Jobs = used for Job Postings and it also includes on-campus interview jobs

Mock Interviews = Mock interviews, practice interviews, group advising, small groups, etc.

Notes = Notes, observations, etc.

On-Campus Interview Visits = all variations of OCR, OCI, Interview Dates, etc.

  • Visit = the main data record indicating that a given Employer is conducting interviews for one or more jobs, with one or more schedules, on given date(s).
  • Round = a grouping of Visits with similar dates (Round, Cycle, Interview Week, Season, etc.)

Recruiter = recruiter, contact, etc.

School Staff = all admin users

  • advisors, coaches, counselors, etc.
  • account managers, company relationship managers, etc.
  • co-op managers

Workshops = workshops, programs, professional development, etc.

 

View Naming Conventions

Master = the primary view for a given data entity.  Examples: Workshop Master, Candidate Master, Job Master.  This will contain most of the standard Dimensions (fields) that you see in your GLCC system, including many that schools can customize (like student major or company industry).

  • Note that there are two “masters” for the Candidate File. 
  • For most circumstances, the “Candidate Master – Current PIDs” view will meet your needs.  This view includes all of your students and alumni, across all active PIDs, and includes only their current default profile.
  • If your school has used the system for many years, and has many old, inactive PIDs (example: “Graduating Class of 2013”), the “Candidate Master – All PIDs” will give you a way to access and include that historical data with your current data.

Details = the view where school's customizable profile fields are contained.  Examples: Workshop Details, Candidate Profile Details, Job Details.  In the various “Details” views, all of the nomenclature is the same:

  • Custom Field Name – this is the label for the field / Question in GradLeaders Career Center which varies by school.  Examples: Workshop Topic, Student Ethnicity, Club Affiliation, etc.
  • Field Text Value – This is the data value for fields/questions that are text.  Any field that is directly typed in, and all pick list fields, have the responses stored here.
  • Field Date Value – custom fields with date input have the responses stored here.
  • Field Numeric Value – custom fields with numeric input have the responses stored here.  

Activity = transactional data.  Examples: Event Candidate Activity, Advising Activity Details, etc.

 

 

 

Attachments Attachments
There are no attachments for this article.
Comments Comments
There are no comments for this article. Be the first to post a comment.
Related Articles RSS Feed
Which Reports Allow You to View Major and Last Login?
Viewed 713 times since Sep 19, 2017
What Are Term Replacements and How Do I Change Them?
Viewed 868 times since Oct 13, 2017
Deleting an OCR Request
Viewed 1053 times since Nov 11, 2013
Can Advisors Get Email Notifications When Students Check in With the Swipe Card Utility?
Viewed 1011 times since Sep 11, 2017
Can Cerkl automatically create "Categories" based on fields that exist in the GradLeaders Career Center APIs?
Viewed 565 times since Aug 31, 2018
How do I change the widgets on my Metrics dashboard?
Viewed 1016 times since Aug 22, 2017
A candidates resume is not visible on the admin side
Viewed 1038 times since Nov 11, 2013
FAQ: How do I direct my students to external assessment tools?
Viewed 665 times since Nov 15, 2017
What is the difference between Run Schedule and Confirm Schedule?
Viewed 912 times since Oct 29, 2010
Using the Metrics Dashboard
Viewed 2784 times since Aug 22, 2017