JPM_RLAT_ENB_VW

(SQL View)

SELECT C.JPM_PROFILE_USAGE , C.JPM_RLAT_NAME , S.DESCR FROM PS_JPM_RLAT_SEL S , PS_JPM_RLAT_CFG C WHERE S.JPM_JP_RLTN_ENABLD = 'Y' AND C.JPM_JP_XRLAT_TYPE = 'PIDO' AND S.JPM_RLAT_NAME = C.JPM_RLAT_NAME

Related Language Record: JPM_RLAT_ENB_LN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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.
A=Administrator Only
J=End / Final / Job
P=Person
T=Template

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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. A=Administrator Only J=End / Final / Job P=Person T=Template
2	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.
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description