JPM_JP_ACTYP_VW

(SQL View)
 Index Back

Active Profile Types

This view selects profile Types active as at the cureent date.

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

  • Related Language Record: JPM_JP_ACTY_LVW

    • # 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
    3 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.
    A=Administrator Only
    J=End / Final / Job
    P=Person
    T=Template
    4 JPM_SRCH_CTL Character(1) VARCHAR2(1) NOT NULL JPM Search Control field
    N=Never
    P=Specified on Profile
    Y=Always

    Default Value: P

    5 JPM_SUBSCRIBE_CTL Character(1) VARCHAR2(1) NOT NULL JPM Subscribe Control field
    N=Never
    P=Specified on Profile
    Y=Always

    Default Value: P