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

JPM_COM_SRCH_VW

(SQL View)

Non-Person Profiles

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

SELECT ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' FROM PS_INSTALLATION

# 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_LGCY_PRFL_ID Character(12) VARCHAR2(12) NOT NULL Previous Profile ID that has been carried across during upgrade of Profiles to JPM

6 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

7 JPM_JP_GRP_TYPE Character(12) VARCHAR2(12) NOT NULL Group type to which a JPM profile group belongs
Prompt Table: JPM_JP_GTYPE

8 JPM_JP_GROUP Character(12) VARCHAR2(12) NOT NULL ID of the Profile Group to which a JPM profile belongs
Prompt Table: JPM_JP_GROUPS

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

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

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

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

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

14 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_LGCY_PRFL_ID	Character(12)	VARCHAR2(12) NOT NULL	Previous Profile ID that has been carried across during upgrade of Profiles to JPM
6	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
7	JPM_JP_GRP_TYPE	Character(12)	VARCHAR2(12) NOT NULL	Group type to which a JPM profile group belongs Prompt Table: JPM_JP_GTYPE
8	JPM_JP_GROUP	Character(12)	VARCHAR2(12) NOT NULL	ID of the Profile Group to which a JPM profile belongs Prompt Table: JPM_JP_GROUPS
9	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.
10	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.
11	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).
12	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).
13	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).
14	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).