JPM_CPS_NPP_VW (SQL View)	Index Back
Non-Person Profiles This view contains non-person profiles that a person could express interest in.

JPM_CPS_NPP_VW

(SQL View)

Non-Person Profiles

This view contains non-person profiles that a person could express interest in.

SELECT DISTINCT A.JPM_PROFILE_ID , A.DESCR , A.JPM_JP_TYPE , A.JPM_JP_PRFL_STATUS , A.JPM_PROFILE_USAGE , B.JPM_RLAT_NAME , B.JPM_CAT_SETID , B.JPM_RLAT_KEY1 , B.JPM_RLAT_KEY2 , B.JPM_RLAT_KEY3 , B.JPM_RLAT_KEY4 FROM PS_JPM_PROFILE_VW A , PS_JPM_JP_X_RLAT B WHERE A.JPM_PROFILE_ID=B.JPM_PROFILE_ID (+)

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

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

3 JPM_JP_TYPE Character(12) VARCHAR2(12) NOT NULL Profile Type name for a JPM Profile Type

4 JPM_JP_PRFL_STATUS Character(1) VARCHAR2(1) NOT NULL Status of JPM Profile
A=Active
I=Inactive
Default Value: A

5 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

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

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

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

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

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

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

#	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.
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	JPM_JP_TYPE	Character(12)	VARCHAR2(12) NOT NULL	Profile Type name for a JPM Profile Type
4	JPM_JP_PRFL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status of JPM Profile A=Active I=Inactive Default Value: A
5	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
6	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.
7	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.
8	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).
9	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).
10	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).
11	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).