JPM_JP_TYPES_VW

(SQL View)
Index Back

Profile Types - Search

Search view for Profile Types

SELECT A.JPM_JP_TYPE , A.EFFDT , A.DESCR , A.JPM_JP_SUMMARY , A.JPM_JP_TYPE_STATUS , A.JPM_PROFILE_USAGE , A.JPM_SRCH_CTL , A.JPM_SUBSCRIBE_CTL , A.END_EFFDT , A.TRANSACTION_NAME , A.EOAWDEFN_ID , A.JPM_PID_APPRVL_FLG , A.SYSTEM_DATA_FLG FROM PS_JPM_JP_TYPES A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_JPM_JP_TYPES B WHERE A.JPM_JP_TYPE = B.JPM_JP_TYPE AND B.EFFDT <= %CurrentDateIn)

  • Related Language Record: JPM_JP_TYPES_LN
  • # 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 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 JPM_JP_SUMMARY Long Character CLOB Summary description of the Profile Type
    5 JPM_JP_TYPE_STATUS Character(1) VARCHAR2(1) NOT NULL Status of Job Profile Type
    A=Active
    I=Inactive
    P=Pending

    Default Value: A

    6 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

    Prompt Table: JPM_JP_USAGE_VW

    7 JPM_SRCH_CTL Character(1) VARCHAR2(1) NOT NULL JPM Search Control field
    N=Never
    P=Specified on Profile
    Y=Always

    Default Value: P

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

    Default Value: P

    9 END_EFFDT Date(10) DATE End Effdt
    10 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name

    Prompt Table: JPM_EO_TRANS_I

    11 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID

    Prompt Table: EOAW_PRCS

    12 JPM_PID_APPRVL_FLG Character(1) VARCHAR2(1) NOT NULL Indicates if Approval is required for updates to Profile Identities for Profiles of this Type.

    Y/N Table Edit

    Default Value: N

    13 SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.

    Y/N Table Edit

    Default Value: N