JPM_TYPUSG_P_VW

(SQL View)
 Index Back

Prof Group Type member Vw

Limits profile types that can be selected as a profile group type member based on the usage of the first member selected. This is for person profile types

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

  • Related Language Record: JPM_TYPUSG_PLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 JPM_PROFILE_USAGE Character(1) VARCHAR2(1) NOT NULL Value used to specify how the profile is used in business logic. This profile may represent a person profile, a profile in progress and not available for use, a job profile, etc.
    J=Non-Person
    P=Person
    2 JPM_JP_TYPE Character(12) VARCHAR2(12) NOT NULL Profile Type name for a JPM Profile Type
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description