\nOne of the fundamentals of relational database design is the use of unique identifiers. So it\u2019s a reasonable assumption that Payroll Elements can be easily identified by a unique ID of some sort. However nothing is that simple in PeopleSoft Global Payroll.\n<\/p>\n
\nEach Element is assigned a numerical value called a Pin Number (PIN_NUM). Pin Numbers can be used to identify Elements within the scope of a single instance of PeopleSoft. However, when Elements are migrated to another instance they may be assigned a new Pin Number. Accordingly, Pin Numbers are not a reliable method of identifying Elements.\n<\/p>\n
\nEach Element has a Pin Name (PIN_NM). The Pin Name field is the primary method by which users lookup\/identify Elements using the PeopleSoft GUI. Whilst at first glance Pin Names seem to be unique, it is possible to have duplicate Pin Names in different countries. As a result it is not good practice to identify Elements using Pin Name.\n<\/p>\n
\nUsing the combination of the PIN_NM and COUNTRY fields to uniquely identify Elements is awkward at best. Fortunately PeopleSoft provide a solution. The Pin Code (PIN_CODE) field is a system maintained field that combines the Pin Name and Country Code.\n<\/p>\n
\nYour choice of unique identifier may change depending on what you\u2019re doing, however in general it is best to use the PIN_CODE. This is especially true when it comes to hard coding Elements references.<\/p>\n","protected":false},"excerpt":{"rendered":"
One of the fundamentals of relational database design is the use of unique identifiers. So it\u2019s a reasonable assumption that Payroll Elements can be easily identified by a unique ID of some sort. However nothing is that simple in PeopleSoft Global Payroll. Each Element is assigned a numerical value called a Pin Number (PIN_NUM). Pin\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,4,8,21,1],"tags":[],"class_list":["post-92","post","type-post","status-publish","format-standard","hentry","category-all-posts","category-configuration","category-global-payroll","category-peoplesoft","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/posts\/92","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/comments?post=92"}],"version-history":[{"count":0,"href":"https:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/posts\/92\/revisions"}],"wp:attachment":[{"href":"https:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/media?parent=92"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/categories?post=92"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/tags?post=92"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}