JPM_PROFILE_CV

(SQL View)
 Index Back

JPM Profile Header Clairvia

Clone of JPM_PROFILE record for Clairvia Fullsync message

SELECT PRF.JPM_PROFILE_ID , PRF.DESCR , PRF.JPM_JP_PRFL_STATUS , PRF.JPM_PROFILE_USAGE , PRF.EMPLID , PRF.JPM_LGCY_PRFL_ID , PRF.JPM_JP_TYPE , PRF.JPM_OWNER_EMPLID , PRF.STATUS_DT , PRF.LASTUPDDTTM , PRF.LASTUPDOPRID , PRF.JPM_SUBSCRIBE , PRF.DESCRSHORT , PRF.DESCRLONG FROM PS_JPM_PROFILE_I PRF , PS_JPM_JP_PERTYP_I PRIM WHERE PRIM.JPM_PRI_PERS_TYPE = PRF.JPM_JP_TYPE AND PRF.JPM_JP_PRFL_STATUS = 'A' AND EXISTS ( SELECT 'X' FROM PS_PER_ORG_ASG_INT ASG2 WHERE ASG2.EMPLID = PRF.EMPLID AND ASG2.INT_APP_TYPE = 'SCH' AND ASG2.INTEGR_PROD_CD = 'CV' AND ASG2.ENROLLED_FLAG = 'Y')

  • Related Language Record: JPM_PROFILE_LNG

  • Parent Record Of JPM_PIDENT_CV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 JPM_PROFILE_ID Character(12) VARCHAR2(12) NOT NULL The id, autoassigned or user assigned of the profile. This id is used to group items and other related material together into one coherent profile.
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 JPM_JP_PRFL_STATUS Character(1) VARCHAR2(1) NOT NULL Status of JPM Profile
    A=Active
    I=Inactive

    Default Value: A

    4 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
    5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: %EDITTABLE2

    6 JPM_LGCY_PRFL_ID Character(12) VARCHAR2(12) NOT NULL Previous Profile ID that has been carried across during upgrade of Profiles to JPM
    7 JPM_JP_TYPE Character(12) VARCHAR2(12) NOT NULL Profile Type name for a JPM Profile Type

    Prompt Table: %EDITTABLE

    8 JPM_OWNER_EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID (or person id) of the owner of the profile.

    Prompt Table: PERSON_NAME

    9 STATUS_DT Date(10) DATE Status Date

    Default Value: %date

    10 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    11 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    12 JPM_SUBSCRIBE Character(1) VARCHAR2(1) NOT NULL JPM Subscribe field

    Y/N Table Edit

    Default Value: N

    13 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    14 DESCRLONG Long Character CLOB Long Description