JPM_RLAT_CFG_LV (SQL View)	Index Back
Enabled Profile Identity Opt Related Lang view of all enabled profile identity options

JPM_RLAT_CFG_LV

(SQL View)

Enabled Profile Identity Opt

Related Lang view of all enabled profile identity options

SELECT DISTINCT A.JPM_RLAT_NAME , C.LANGUAGE_CD , C.DESCR FROM PS_JPM_RLAT_CFG A , PS_JPM_RLAT_SEL B , PS_JPM_RLAT_SEL_LN C WHERE A.JPM_RLAT_NAME = B.JPM_RLAT_NAME AND B.JPM_RLAT_NAME = C.JPM_RLAT_NAME AND B.JPM_JP_RLTN_ENABLD = 'Y' AND A.JPM_JP_XRLAT_TYPE = 'PIDO' AND A.JPM_PROFILE_USAGE = 'J'

Related Language Record for JPM_RLAT_CFG_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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.

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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.
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description