JPM_PIDENT_CV

(SQL View)
 Index Back

Profile Ext Relationship Clair

Clone of JPM_JP_X_RLAT record for Clairvia Fullsync message

SELECT DISTINCT RLAT.JPM_PROFILE_ID , RLAT.JPM_CAT_SETID , RLAT.JPM_RLAT_KEY1 , RLAT.JPM_RLAT_KEY2 , RLAT.JPM_RLAT_KEY3 , RLAT.JPM_RLAT_KEY4 , RLAT.JPM_RLAT_NAME , RLAT.EFFDT , 'A' , RLAT.JPM_JP_XRLAT_TYPE FROM PS_JPM_JP_X_RLAT_I RLAT , PS_JPM_JP_PERTYP_I PRIM , PS_PER_ORG_ASG_INT ASG , PS_JPM_PROFILE_I PRF WHERE %EffdtCheck(JPM_JP_X_RLAT,RLAT,%CurrentDateIn) AND ASG.EMPLID = RLAT.EMPLID AND ASG.INT_APP_TYPE = 'SCH' AND ASG.INTEGR_PROD_CD = 'CV' AND ASG.ENROLLED_FLAG = 'Y' AND PRIM.JPM_PRI_PERS_TYPE = RLAT.JPM_JP_TYPE AND PRF.JPM_PROFILE_ID = RLAT.JPM_PROFILE_ID AND PRF.JPM_JP_PRFL_STATUS = 'A'

  • Parent record: JPM_PROFILE_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.

    Prompt Table: JPM_PROFILE

    2 JPM_CAT_SETID Character(5) VARCHAR2(5) NOT NULL Optional property of an item in Profiles to provide a setid value, often used in conjunction with another property that is setid based.

    Prompt Table: SETID_TBL

    3 JPM_RLAT_KEY1 Character(30) VARCHAR2(30) NOT NULL Key value identifying the external data being related to JPM data. Example- Job Codes (external data) being related to a Profile of a Job (JPM data).

    Prompt Table: %EDITTABLE

    4 JPM_RLAT_KEY2 Character(30) VARCHAR2(30) NOT NULL Key value identifying the external data being related to JPM data. Example- Job Codes (external data) being related to a Profile of a Job (JPM data).
    5 JPM_RLAT_KEY3 Character(30) VARCHAR2(30) NOT NULL Key value identifying the external data being related to JPM data. Example- Job Codes (external data) being related to a Profile of a Job (JPM data).
    6 JPM_RLAT_KEY4 Character(30) VARCHAR2(30) NOT NULL Key value identifying the external data being related to JPM data. Example- Job Codes (external data) being related to a Profile of a Job (JPM data).
    7 JPM_RLAT_NAME Character(30) VARCHAR2(30) NOT NULL Name of the relationship being established between JPM Data and External Data. Example - JOB CODE might be used to indicate that the relationship is between a JPM Profile of Job and External Data such as the Job Code on the Job Code table.

    Prompt Table: JPM_JP_PID_VW

    8 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    9 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    10 JPM_JP_XRLAT_TYPE Character(4) VARCHAR2(4) NOT NULL Indicates the type of relationship - profile identity, profile association, search filter, etc - that is represented for JPM Profiles
    ASSC=Profile Association
    FLT=Search Filter
    PIDO=Profile Identity Option