HRS_SCH_APRP_VW

(SQL View)
 Index Back

HRS Appl Srch Prop w JPM Intg

if JPM integration is on, selects all properties that are searchable for the intersection of sections for applicant items's with the primary person profile type's sections with TAM content sections.

SELECT DISTINCT APPITEM.HRS_PERSON_ID ,HRSCTCFG.JPM_JP_TYPE ,HRSCTCFG.JPM_CAT_TYPE ,JPMPRIPI.FIELDNAME ,JPMPRIPI.JPM_LABEL_TEXT FROM PS_HRS_SCT_CFG_VW HRSCTCFG , PS_JPM_PRI_P_PRP_I JPMPRIPI , PS_HRS_APP_ITEMS APPITEM WHERE HRSCTCFG.JPM_JP_TYPE = JPMPRIPI.JPM_JP_TYPE AND HRSCTCFG.JPM_CAT_TYPE = JPMPRIPI.JPM_CAT_TYPE AND JPMPRIPI.JPM_JP_SRCH_FLG = 'Y' AND APPITEM.JPM_CAT_TYPE = HRSCTCFG.JPM_CAT_TYPE AND APPITEM.EFF_STATUS = 'A'

  • Related Language Record: HRS_SCH_APRPLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    2 JPM_JP_TYPE Character(12) VARCHAR2(12) NOT NULL Profile Type name for a JPM Profile Type
    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.
    4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    5 JPM_LABEL_TEXT Character(30) VARCHAR2(30) NOT NULL User defined text to be displayed as a label for a field or property within JPM User Interfaces.