{"id":188,"date":"2013-11-17T11:44:27","date_gmt":"2013-11-17T17:44:27","guid":{"rendered":"https:\/\/linux.asberry.org\/blog_tech\/?p=188"},"modified":"2024-05-14T09:15:05","modified_gmt":"2024-05-14T14:15:05","slug":"tcc-decode-function","status":"publish","type":"post","link":"https:\/\/asberry.org\/blog_tech\/?p=188","title":{"rendered":"TCC – DECODE Function"},"content":{"rendered":"

This is one that I’m not 100% familiar with the Oracle counterpart of the Decode function<\/a>. \u00a0In this particular instance it’s used to parse out and assign the gender component of the EEO questions. \u00a0This is very hard to extract from the system and is only done so after a hire is made so that the information can be passed to the HRIS for hiring and payroll purposes.<\/p>\n

\r\n<quer:projection id="idGender" alias="Gender">\r\n <quer:query projectedClass="Candidate" alias="CandGenderNo">\r\n <quer:projections>\r\n <quer:projection alias="EEOGender_AnswerNo">\r\n <quer:decode>\r\n <quer:field path="QuestionAnswers,Answer"\/>\r\n <quer:string>-11<\/quer:string>\r\n <quer:string>M<\/quer:string>\r\n <quer:string>-12<\/quer:string>\r\n <quer:string>F<\/quer:string>\r\n <quer:string>Not Specified<\/quer:string>\r\n <\/quer:decode>\r\n <\/quer:projection>\r\n <\/quer:projections>\r\n <quer:filterings>\r\n <quer:filtering>\r\n <quer:equal>\r\n <quer:field path="QuestionAnswers,Question"\/>\r\n <quer:integer>-3<\/quer:integer>\r\n <\/quer:equal>\r\n <\/quer:filtering>\r\n <quer:filtering>\r\n <quer:equal>\r\n <quer:field path="Number"\/>\r\n <quer:field ownerQuery="MainQuery" path="Candidate"\/>\r\n <\/quer:equal>\r\n <\/quer:filtering>\r\n <\/quer:filterings>\r\n <\/quer:query>\r\n<\/quer:projection>\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
This is one that I’m not 100% familiar with the Oracle counterpart of the Decode function. \u00a0In this particular instance it’s used to parse out and assign the gender component of the EEO questions. \u00a0This is very hard to extract from the system and is only done so after a hire is made so that […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[13],"tags":[],"class_list":["post-188","post","type-post","status-publish","format-standard","hentry","category-tcc","author-aron"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4bBkH-32","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/posts\/188","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=188"}],"version-history":[{"count":6,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/posts\/188\/revisions"}],"predecessor-version":[{"id":995,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/posts\/188\/revisions\/995"}],"wp:attachment":[{"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=188"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=188"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=188"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}