JPM_PROF_NP_LVW

(SQL View)
 Index Back

Search View - Non-Person Prfls

This is related language view of JPM_PROFILE_VW

SELECT P.JPM_JP_TYPE , P.JPM_PROFILE_ID , LN.LANGUAGE_CD , LN.DESCR , LN.DESCRSHORT , LN.DESCRLONG FROM PS_JPM_PROFILE P , PS_JPM_PROFILE_LNG LN , PS_JPM_JP_SEC_VW S WHERE P.EMPLID = ' ' AND P.JPM_PROFILE_USAGE <> 'P' AND S.JPM_JP_TYPE = P.JPM_JP_TYPE AND LN.JPM_PROFILE_ID = P.JPM_PROFILE_ID AND S.JPM_ROLE = 'ADM'

  • Related Language Record for JPM_PROF_NP_VW

    • # 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_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

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 DESCRLONG Long Character CLOB Long Description