JPM_RLATCFGA_VW (SQL View)	Index Back
JPM Rlat Config view JPM Rlat Config view

JPM_RLATCFGA_VW

(SQL View)

JPM Rlat Config view

SELECT A.JPM_RLAT_NAME , A.JPM_JP_XRLAT_TYPE , B.DESCR FROM PS_JPM_RLAT_CFG A , PS_JPM_RLAT_SEL B WHERE A.JPM_RLAT_NAME = B.JPM_RLAT_NAME AND B.JPM_JP_RLTN_ENABLD = 'Y' AND A.JPM_JP_XRLAT_TYPE = 'ASSC'

# 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 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
Default Value: ASSC

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	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 Default Value: ASSC
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description