JPM_JP_XRLT_LVW

(SQL View)
 Index Back

Profile Relationships - Interf

Interface RL view for the Profile External Relationships record (JPM_JP_X_RLAT). This interface also includes the Profile Type field from the JPM_PROFILE record.

SELECT B.JPM_PROFILE_ID , B.EFFDT , B.JPM_RLAT_NAME , B.JPM_CAT_SETID , B.JPM_RLAT_KEY1 , B.JPM_RLAT_KEY2 , B.JPM_RLAT_KEY3 , B.JPM_RLAT_KEY4 , A.LANGUAGE_CD , A.DESCR FROM PS_JPM_PROFILE_LNG A , PS_JPM_JP_X_RLAT B , PS_JPM_RLAT_CFG C WHERE A.JPM_PROFILE_ID = B.JPM_PROFILE_ID AND B.JPM_RLAT_NAME = C.JPM_RLAT_NAME AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_JPM_JP_X_RLAT D WHERE B.JPM_PROFILE_ID = D.JPM_PROFILE_ID AND B.JPM_RLAT_NAME = D.JPM_RLAT_NAME AND B.JPM_CAT_SETID = D.JPM_CAT_SETID AND B.JPM_RLAT_KEY1= D.JPM_RLAT_KEY1 AND B.JPM_RLAT_KEY2 = D.JPM_RLAT_KEY2 AND B.JPM_RLAT_KEY3 = D.JPM_RLAT_KEY3 AND B.JPM_RLAT_KEY4 = D.JPM_RLAT_KEY4) AND B.EFF_STATUS = 'A'

  • Related Language Record for JPM_JP_X_RLAT_I

    • # 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 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 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.
    4 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.
    5 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).
    6 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).
    7 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).
    8 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).
    9 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description