HRS_JO_TMSEC_VW

(SQL View)
 Index Back

Template Sections

Template Sections

SELECT RCR.HRS_RCRT_TMPL_ID , JOP.HRS_JO_TMPL_ID , JOP.HRS_PAGE_NBR , JOT.HRS_JO_TMPL_SCTN12 , JOP.DESCR , JOTVW.DESCR , JOTVW.HRS_REQ_SRC FROM PS_HRS_RCRT_TMPL RCR , PS_HRS_JO_TMPL_PG JOP , PS_HRS_JO_TMPL_SCT JOT , PS_HRS_JO_TMPLS_VW JOTVW WHERE RCR.HRS_JO_TMPL_ID = JOP.HRS_JO_TMPL_ID AND RCR.EFFDT = ( SELECT MAX(A.EFFDT) FROM PS_HRS_RCRT_TMPL A WHERE A.EFFDT <= %CurrentDateIn AND RCR.HRS_RCRT_TMPL_ID = A.HRS_RCRT_TMPL_ID AND A.EFF_STATUS = 'A') AND JOP.HRS_JO_TMPL_ID = JOT.HRS_JO_TMPL_ID AND JOP.HRS_PAGE_NBR = JOT.HRS_PAGE_NBR AND JOTVW.HRS_JO_TMPL_SCTN12 = JOT.HRS_JO_TMPL_SCTN12

  • Related Language Record: HRS_JO_TMSEC_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_RCRT_TMPL_ID Number(15,0) DECIMAL(15) NOT NULL Recruitment Template ID
    2 HRS_JO_TMPL_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Template ID
    3 HRS_PAGE_NBR Number(3,0) SMALLINT NOT NULL Page Number
    4 HRS_JO_TMPL_SCTN12 Character(12) VARCHAR2(12) NOT NULL Job Opening Template Sections
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    7 HRS_REQ_SRC Character(1) VARCHAR2(1) NOT NULL Resume or Job Opening Template sections including recruiting-specific sections from PSXLATITEM - identified by HRS_REQ_SRC = 'X' - and JPM Content Sections - identified by HRS_REQ_SRC = 'J'. Only those JPM Content sections that have been configured for Recruiting Solutions will be available for selection.
    J=JPM Content Type
    X=Translate Value