HRS_NP_PROFLVW

(SQL View)
 Index Back

Search View - Non-Person Prfls

Search record for JPM Non-Person Profiles. Language version

SELECT PROF.JPM_PROFILE_ID , LNG.LANGUAGE_CD , PROF.DESCR , PROF.DESCRSHORT FROM PS_JPM_PROFILE PROF , PS_JPM_JP_TYPES JPTYPE , PS_JPM_JP_SEC_VW SEC , PS_JPM_PROFILE_LNG LNG WHERE PROF.EMPLID = ' ' AND PROF.JPM_PROFILE_USAGE <> 'P' AND LNG.JPM_PROFILE_ID = PROF.JPM_PROFILE_ID AND JPTYPE.JPM_JP_TYPE = PROF.JPM_JP_TYPE AND JPTYPE.JPM_JP_TYPE_STATUS = 'A' AND JPTYPE.JPM_JP_END_PROFILE = 'Y' AND %EffdtCheck(JPM_JP_TYPES JPTYPE1, JPTYPE, %CurrentDateIn) AND SEC.JPM_JP_TYPE = PROF.JPM_JP_TYPE AND SEC.JPM_ROLE = 'EMP'

  • Related Language Record for HRS_NP_PROF_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 JPM_PROFILE_ID Character(12) VARCHAR2(12) NOT NULL The id, autoassigned or user assigned of the profile. This id is used to group items and other related material together into one coherent profile.

    Prompt Table: JPM_PROFILE

    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description