JPM_JP_PTP_LNVW

(SQL View)
 Index Back

Profile Types - Talent Mgmt

This table defines the different TYPES of Talent Management Job Profiles.

SELECT S.JPM_ROLE , T.JPM_JP_TYPE , T.LANGUAGE_CD , T.DESCR FROM PS_JPM_JP_TYPE_LNG T , PS_JPM_JP_SEC_VW S WHERE S.JPM_JP_TYPE = T.JPM_JP_TYPE AND %EffdtCheck(JPM_JP_TYPES T1, T, %CurrentDateIn)

  • Related Language Record for JPM_JP_NTYPE_VW JPM_JP_NTYPSSVW JPM_JP_PTYPE_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 JPM_ROLE Character(3) VARCHAR2(3) NOT NULL Role
    ADM=Administrator
    EMP=Employee
    MGR=Manager
    2 JPM_JP_TYPE Character(12) VARCHAR2(12) NOT NULL Profile Type name for a JPM Profile Type
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description