JPM_JP_G_RLAT (SQL Table)	Index Back
Catalog Groups - Talent Mgmt

JPM_JP_G_RLAT

(SQL Table)

Catalog Groups - Talent Mgmt

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 JPM_JP_TYPE Character(12) VARCHAR2(12) NOT NULL Profile Type name for a JPM Profile Type
Prompt Table: JPM_JP_TYPES

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

3 JPM_CAT_GROUP Character(12) VARCHAR2(12) NOT NULL Content Group

4 JPM_JP_GROUP Character(12) VARCHAR2(12) NOT NULL ID of the Profile Group to which a JPM profile belongs

5 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.
Prompt Table: JPM_RLAT_CFG

6 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.
Prompt Table: SETID_TBL

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

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

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

10 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_JP_TYPE	Character(12)	VARCHAR2(12) NOT NULL	Profile Type name for a JPM Profile Type Prompt Table: JPM_JP_TYPES
2	JPM_JP_GRP_TYPE	Character(12)	VARCHAR2(12) NOT NULL	Group type to which a JPM profile group belongs Prompt Table: JPM_JP_GTYPE
3	JPM_CAT_GROUP	Character(12)	VARCHAR2(12) NOT NULL	Content Group
4	JPM_JP_GROUP	Character(12)	VARCHAR2(12) NOT NULL	ID of the Profile Group to which a JPM profile belongs
5	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. Prompt Table: JPM_RLAT_CFG
6	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. Prompt Table: SETID_TBL
7	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).
8	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).
9	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).
10	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).