HRS_BIP_SCT_VW

(SQL View)
 Index Back

Content Section Config View

View to content types from JPM that exist in the Primary Profile Type that has been designated for use in Recruting Solutions. Used as a search view on the Content Section Configuration component

SELECT DISTINCT JPMCFG.JPM_JP_TYPE , JPMCFG.JPM_CAT_TYPE , JPMCFG.DESCR , JPMCFG.JPM_ADHOC_FLG , 'N' FROM PS_JPM_PRI_P_CAT_I JPMCFG , PS_JPM_JP_ROLES JPMROL WHERE JPMCFG.JPM_JP_TYPE = JPMROL.JPM_JP_TYPE AND JPMCFG.JPM_JP_SECTION_ID = JPMROL.JPM_JP_SECTION_ID AND %EffdtCheck(JPM_JP_ROLES JPMROL2, JPMROL, %CurrentDateIn) AND JPMROL.JPM_ROLE = 'EMP' AND JPMROL.JPM_SCRTY_MODIFY = 'Y'

  • Related Language Record: HRS_SCT_CFG_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 JPM_JP_TYPE Character(12) VARCHAR2(12) NOT NULL Profile Type name for a JPM Profile Type
    2 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.
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 JPM_ADHOC_FLG Character(1) VARCHAR2(1) NOT NULL Indicates that the Catalog Type is Adhoc or FreeForm.
    5 FLAG Character(1) VARCHAR2(1) NOT NULL Flag

    Y/N Table Edit

    Default Value: N