JPM_JP_TYPES_V2

(SQL View)
 Index Back

Profile Types

This view selects the latest effective-dated row for those profile types that are currently active.

SELECT T.JPM_JP_TYPE , T.DESCR FROM PS_JPM_JP_TYPES T WHERE T.JPM_JP_TYPE_STATUS = 'A' AND %EffdtCheck(JPM_JP_TYPES T1, T, %CurrentDateIn)

  • Related Language Record: JPM_JP_TYPE_LV2

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description