JPM_NP_X_RLAT (SQL View)	Index Back
Non-Person Profile Identifier Non-Person Profile Identifier query view

JPM_NP_X_RLAT

(SQL View)

Non-Person Profile Identifier

Non-Person Profile Identifier query view

SELECT B.JPM_PROFILE_ID , B.JPM_CAT_SETID , B.JPM_RLAT_KEY1 , B.JPM_RLAT_KEY2 , B.JPM_RLAT_KEY3 , B.JPM_RLAT_KEY4 , B.JPM_RLAT_NAME , B.EFFDT , B.EFF_STATUS , B.JPM_JP_XRLAT_TYPE FROM PS_JPM_PROFILE A , PS_JPM_JP_X_RLAT B WHERE A.JPM_PROFILE_ID = B.JPM_PROFILE_ID AND A.JPM_PROFILE_USAGE = 'J'

Parent record: JPM_NP_PROFILE

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

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

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.

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

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

#	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.
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).
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.
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
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