JPM_PER_TYP_VW

(SQL View)
 Index Back

Profile Types - Talent Mgmt

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

SELECT DISTINCT T.JPM_JP_TYPE , T.DESCR , T.JPM_JP_TYPE_STATUS FROM PS_JPM_JP_TYPES T , PS_JPM_JP_SEC_VW S WHERE S.JPM_JP_TYPE = T.JPM_JP_TYPE AND T.JPM_PROFILE_USAGE = 'P' AND %EffdtCheck(JPM_JP_TYPES T1, T, %CurrentdateIn) AND T.JPM_JP_TYPE_STATUS = 'A'

  • Related Language Record: JPM_PER_TYPLVW

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

    Prompt Table: %EDITTABLE

    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 JPM_JP_TYPE_STATUS Character(1) VARCHAR2(1) NOT NULL Status of Job Profile Type
    A=Active
    I=Inactive
    P=Pending

    Default Value: A