HRS_JO_TMPLS_V2

(SQL View)
 Index Back

Job Opening Template Sections

Job opening template sections

SELECT A.HRS_JO_TMPL_ID , A.HRS_PAGE_NBR , B.HRS_JO_TMPL_SCTN12 , B.HRS_REQ_SRC , B.JPM_ADHOC_FLG , B.DESCR FROM PS_HRS_JO_TMPL_SCT A , PS_HRS_JO_TMPLS_VW B WHERE A.HRS_JO_TMPL_SCTN12 = B.HRS_JO_TMPL_SCTN12 AND B.HRS_REQ_SRC = 'J'

  • Parent record: HRS_JO_TMPL_PG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_JO_TMPL_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Template ID

    Prompt Table: HRS_JO_TMPL

    2 HRS_PAGE_NBR Number(3,0) SMALLINT NOT NULL Page Number

    Prompt Table: HRS_JO_TMPL_PG

    3 JPM_CAT_TYPE Character(12) VARCHAR2(12) NOT NULL The name of the type of items that will be used in a Catalog and or in a Profile.

    Prompt Table: JPM_CAT_TYPE_VW

    4 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
    5 JPM_ADHOC_FLG Character(1) VARCHAR2(1) NOT NULL Indicates that the Catalog Type is Adhoc or FreeForm.
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description