{"id":5314,"date":"2016-05-03T14:05:01","date_gmt":"2016-05-03T18:05:01","guid":{"rendered":"http:\/\/www.pcrecruiter.net\/two-minute-tuesday\/geographic-searches-2\/"},"modified":"2016-05-03T14:05:01","modified_gmt":"2016-05-03T18:05:01","slug":"relational-database","status":"publish","type":"post","link":"https:\/\/www.pcrecruiter.net\/site\/2016\/05\/03\/relational-database\/","title":{"rendered":"Two Minute Tuesday: Relational Database Structure"},"content":{"rendered":"

In this week’s\u00a0Two Minute Tuesday<\/a>\u00a0video, we’re going to take a departure from how-to and take a broader look at how PCRecruiter’s internal database is laid out.<\/p>\n

If you have any comments\u00a0or suggestions for something we can explain in about two minutes, send an email to twominutetuesday@mainsequence.net<\/a><\/p>\n

\n

Video Transcript<\/h3>\n

Welcome to this week\u2019s Two Minute Tuesday, Main Sequence\u2019s series of short videos with tips, tricks, and tutorials to make you a more powerful PCRecruiter user.<\/p>\n

We\u2019ve been together in this video series for a few months now, and we think it\u2019s time to discuss the relationship. Specifically, the relationship between the major record types in PCRecruiter. While most users will never need to or want to know how the SQL database under the hood of PCR is laid out, a mental picture of how records are related can be helpful \u2013 particularly if you\u2019re building an advanced search query, custom report, or planning a development project using the PCRecruiter API.<\/p>\n

PCRecruiter uses a relational database with multiple tables to contain different kinds of information. For example, there is a table for companies, a table for names, and a table for jobs. Each table has columns of data for the specific attributes of that record type, such as a city, title, middle name, and so on.<\/p>\n

Every record in the main tables has a unique global identifier so that the system can track which records are related to each other and how. Setting things up this way allows the same piece of information to be used in relation to multiple records, or to be easily re-associated with a different record at any time.<\/p>\n

PCRecruiter is somewhat unique among recruiting systems because it uses the Company record as the central record type, although a company record can really represent any group of related names or jobs, not just an actual physical company. While it may appear that the names and jobs are \u2018part of the company,\u2019 the Company record itself just contains the info about the company. The people and jobs associated with that company are in the Name and Position tables. So, when you view the names belonging to a company, PCR is actually querying the Name table of the database for any records that match the global identifier of the selected company.<\/p>\n

The critical advantage here is that a name can be moved from one company to another simply by changing the company identifier, allowing a candidate to become a client, or a vendor to become an employee, without duplicating or recreating their contact record. All of that person\u2019s activity logs and attachments (which, incidentally are kept in their own separate tables), stay linked to that name no matter what jobs or company the name is associated with. Over time, PCR\u2019s company-centric database structure lets you build up a much clearer picture of where your contacts have been and how they relate to one another.<\/p>\n

The connection between jobs and candidates is managed in the same way. When you view an applicant Pipeline, you\u2019re looking at records from the Interviews table. Interview records (which in PCRecruiter terms represent any step in the recruiting process \u2013 not just phone and face-to-face interviews) include things like the date, time, and status of that step in the process, but they don\u2019t include the information about the job or the candidate. Instead, they include the global identifiers indicating which job and which names those pipeline records are pertinent to. This setup lets you have multiple candidates tied to multiple jobs, regardless of what company the job or candidate are associated with.<\/p>\n

In fact, most of the time your candidates will belong to the \u2018default company\u2019, which is a special company record that PCR uses to group all the names that don\u2019t belong to any more specific company. A talent pool. When you place someone, PCR changes their company identifier to the one from the job they were just placed in, effectively making them a name under that company, but without losing or changing any of the history they came with.<\/p>\n

Fortunately, as you interact with your database, whether that\u2019s through PCR itself or a third-party tool using the API, the software builds all the structured queries necessary to navigate the database and return the info you want, whether or not you fully understand how it\u2019s all connected. If you do need more specifics on the tables in a PCRecruiter database, contact our support team at support@mainsequence.net.<\/p>\n

And for more Two Minute Tuesdays, subscribe to this YouTube channel and watch our social networks or your PCR login screen. If you have any suggestions for future episodes, send an email to twominutetuesday@mainsequence.net.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

In this week’s\u00a0Two Minute Tuesday<\/a>\u00a0video, we’re going to take a departure from how-to and take a broader look at how PCRecruiter’s internal database is laid out.<\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"video","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[33,104,105],"tags":[],"class_list":["post-5314","post","type-post","status-publish","format-video","hentry","category-topics","category-two-minute-tuesday","category-video","post_format-post-format-video"],"acf":[],"yoast_head":"\r\nTwo Minute Tuesday: Relational Database Structure - PCRecruiter<\/title>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/www.pcrecruiter.net\/site\/2016\/05\/03\/relational-database\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Two Minute Tuesday: Relational Database Structure - PCRecruiter\" \/>\r\n<meta property=\"og:description\" content=\"In this week's\u00a0Two Minute Tuesday\u00a0video, we're going to take a departure from how-to and take a broader look at how PCRecruiter's internal database is laid out.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/www.pcrecruiter.net\/site\/2016\/05\/03\/relational-database\/\" \/>\r\n<meta property=\"og:site_name\" content=\"PCRecruiter\" \/>\r\n<meta property=\"article:publisher\" content=\"https:\/\/facebook.com\/PCRecruiter\" \/>\r\n<meta property=\"article:published_time\" content=\"2016-05-03T18:05:01+00:00\" \/>\r\n<meta name=\"author\" content=\"PCRecruiter\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:creator\" content=\"@PCRecruiter\" \/>\r\n<meta name=\"twitter:site\" content=\"@PCRecruiter\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"PCRecruiter\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.pcrecruiter.net\/site\/2016\/05\/03\/relational-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.pcrecruiter.net\/site\/2016\/05\/03\/relational-database\/\"},\"author\":\"PCRecruiter\",\"headline\":\"Two Minute Tuesday: Relational Database Structure\",\"datePublished\":\"2016-05-03T18:05:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.pcrecruiter.net\/site\/2016\/05\/03\/relational-database\/\"},\"wordCount\":803,\"publisher\":{\"@id\":\"https:\/\/www.pcrecruiter.net\/site\/#organization\"},\"articleSection\":[\"Topics\",\"Two Minute Tuesday\",\"Video\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.pcrecruiter.net\/site\/2016\/05\/03\/relational-database\/\",\"url\":\"https:\/\/www.pcrecruiter.net\/site\/2016\/05\/03\/relational-database\/\",\"name\":\"Two Minute Tuesday: Relational Database Structure - PCRecruiter\",\"isPartOf\":{\"@id\":\"https:\/\/www.pcrecruiter.net\/site\/#website\"},\"datePublished\":\"2016-05-03T18:05:01+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.pcrecruiter.net\/site\/2016\/05\/03\/relational-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.pcrecruiter.net\/site\/2016\/05\/03\/relational-database\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.pcrecruiter.net\/site\/2016\/05\/03\/relational-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.pcrecruiter.net\/site\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Two Minute Tuesday: Relational Database Structure\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.pcrecruiter.net\/site\/#website\",\"url\":\"https:\/\/www.pcrecruiter.net\/site\/\",\"name\":\"PCRecruiter\",\"description\":\"PCRM & PCR - Software for Recruiters\",\"publisher\":{\"@id\":\"https:\/\/www.pcrecruiter.net\/site\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.pcrecruiter.net\/site\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.pcrecruiter.net\/site\/#organization\",\"name\":\"PCRecruiter\",\"alternateName\":\"Main Sequence Technology, Inc.\",\"url\":\"https:\/\/www.pcrecruiter.net\/site\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.pcrecruiter.net\/site\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.pcrecruiter.net\/site\/wp-content\/uploads\/2020\/08\/PCRecruiter-1200px.png\",\"contentUrl\":\"https:\/\/www.pcrecruiter.net\/site\/wp-content\/uploads\/2020\/08\/PCRecruiter-1200px.png\",\"width\":1200,\"height\":627,\"caption\":\"PCRecruiter\"},\"image\":{\"@id\":\"https:\/\/www.pcrecruiter.net\/site\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/facebook.com\/PCRecruiter\",\"https:\/\/x.com\/PCRecruiter\",\"https:\/\/linkedin.com\/company\/PCRecruiter\"]}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Two Minute Tuesday: Relational Database Structure - PCRecruiter","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.pcrecruiter.net\/site\/2016\/05\/03\/relational-database\/","og_locale":"en_US","og_type":"article","og_title":"Two Minute Tuesday: Relational Database Structure - PCRecruiter","og_description":"In this week's\u00a0Two Minute Tuesday\u00a0video, we're going to take a departure from how-to and take a broader look at how PCRecruiter's internal database is laid out.","og_url":"https:\/\/www.pcrecruiter.net\/site\/2016\/05\/03\/relational-database\/","og_site_name":"PCRecruiter","article_publisher":"https:\/\/facebook.com\/PCRecruiter","article_published_time":"2016-05-03T18:05:01+00:00","author":"PCRecruiter","twitter_card":"summary_large_image","twitter_creator":"@PCRecruiter","twitter_site":"@PCRecruiter","twitter_misc":{"Written by":"PCRecruiter","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.pcrecruiter.net\/site\/2016\/05\/03\/relational-database\/#article","isPartOf":{"@id":"https:\/\/www.pcrecruiter.net\/site\/2016\/05\/03\/relational-database\/"},"author":"PCRecruiter","headline":"Two Minute Tuesday: Relational Database Structure","datePublished":"2016-05-03T18:05:01+00:00","mainEntityOfPage":{"@id":"https:\/\/www.pcrecruiter.net\/site\/2016\/05\/03\/relational-database\/"},"wordCount":803,"publisher":{"@id":"https:\/\/www.pcrecruiter.net\/site\/#organization"},"articleSection":["Topics","Two Minute Tuesday","Video"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.pcrecruiter.net\/site\/2016\/05\/03\/relational-database\/","url":"https:\/\/www.pcrecruiter.net\/site\/2016\/05\/03\/relational-database\/","name":"Two Minute Tuesday: Relational Database Structure - PCRecruiter","isPartOf":{"@id":"https:\/\/www.pcrecruiter.net\/site\/#website"},"datePublished":"2016-05-03T18:05:01+00:00","breadcrumb":{"@id":"https:\/\/www.pcrecruiter.net\/site\/2016\/05\/03\/relational-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pcrecruiter.net\/site\/2016\/05\/03\/relational-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.pcrecruiter.net\/site\/2016\/05\/03\/relational-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pcrecruiter.net\/site\/"},{"@type":"ListItem","position":2,"name":"Two Minute Tuesday: Relational Database Structure"}]},{"@type":"WebSite","@id":"https:\/\/www.pcrecruiter.net\/site\/#website","url":"https:\/\/www.pcrecruiter.net\/site\/","name":"PCRecruiter","description":"PCRM & PCR - Software for Recruiters","publisher":{"@id":"https:\/\/www.pcrecruiter.net\/site\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pcrecruiter.net\/site\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.pcrecruiter.net\/site\/#organization","name":"PCRecruiter","alternateName":"Main Sequence Technology, Inc.","url":"https:\/\/www.pcrecruiter.net\/site\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.pcrecruiter.net\/site\/#\/schema\/logo\/image\/","url":"https:\/\/www.pcrecruiter.net\/site\/wp-content\/uploads\/2020\/08\/PCRecruiter-1200px.png","contentUrl":"https:\/\/www.pcrecruiter.net\/site\/wp-content\/uploads\/2020\/08\/PCRecruiter-1200px.png","width":1200,"height":627,"caption":"PCRecruiter"},"image":{"@id":"https:\/\/www.pcrecruiter.net\/site\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/facebook.com\/PCRecruiter","https:\/\/x.com\/PCRecruiter","https:\/\/linkedin.com\/company\/PCRecruiter"]}]}},"_links":{"self":[{"href":"https:\/\/www.pcrecruiter.net\/site\/wp-json\/wp\/v2\/posts\/5314","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pcrecruiter.net\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.pcrecruiter.net\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.pcrecruiter.net\/site\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pcrecruiter.net\/site\/wp-json\/wp\/v2\/comments?post=5314"}],"version-history":[{"count":0,"href":"https:\/\/www.pcrecruiter.net\/site\/wp-json\/wp\/v2\/posts\/5314\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.pcrecruiter.net\/site\/wp-json\/wp\/v2\/media?parent=5314"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pcrecruiter.net\/site\/wp-json\/wp\/v2\/categories?post=5314"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pcrecruiter.net\/site\/wp-json\/wp\/v2\/tags?post=5314"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}