JPM_PROF_SUBVW (SQL View)	Index Back
JPM subsection Items view JPM subsection Items view

JPM_PROF_SUBVW

(SQL View)

JPM subsection Items view

SELECT A.JPM_PROFILE_ID , E.JPM_CAT_TYPE , D.JPM_ITEM_KEY_ID , B.JPM_JP_SECTION_ID , D.JPM_CAT_ITEM_ID , A.JPM_CAT_TYPE , B.JPM_JP_PSECTION_ID , B.JPM_CAT_RLAT_CD , C.EMPLID FROM PS_JPM_JP_CAT_TYPE A , PS_JPM_JP_SECTION B , PS_JPM_PROFILE C , PS_JPM_JP_CRITM_VW D , PS_JPM_JP_SECTION E WHERE C.JPM_JP_TYPE = B.JPM_JP_TYPE AND A.JPM_PROFILE_ID = C.JPM_PROFILE_ID AND A.JPM_CAT_TYPE = B.JPM_CAT_TYPE AND B.JPM_JP_PSECTION_ID > 0 AND A.JPM_PROFILE_ID = D.JPM_PROFILE_ID AND E.JPM_JP_TYPE = B.JPM_JP_TYPE AND E.JPM_JP_SECTION_ID = B.JPM_JP_PSECTION_ID AND D.JPM_CAT_TYPE = E.JPM_CAT_TYPE

# 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 JPM_CAT_TYPE Character(12) VARCHAR2(12) NOT NULL The name of the type of items that will be used in a Catalog and or in a Profile.

3 JPM_ITEM_KEY_ID Number(12,0) DECIMAL(12) NOT NULL Unique identifier of an item within a profile. This is the primary key of profile items. It is a generic autoassigned value (a number). The unique key permits the addition of items that are not inheritently unique. They may have the same effective date, item type, item id, yet differ in a property or other value. The concept of key fields in a profile is a loose term as an object in a profile can have very different needs in identification.

4 JPM_JP_SECTION_ID Number(4,0) SMALLINT NOT NULL JPM

5 JPM_CAT_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.

6 JPM_CAT_TYPE2 Character(12) VARCHAR2(12) NOT NULL Secondary content item type (as in a related item- such as a child or a supporting item of another item).

7 JPM_JP_PSECTION_ID Number(4,0) SMALLINT NOT NULL Parent Section Id on Profile Types

8 JPM_CAT_RLAT_CD Character(1) VARCHAR2(1) NOT NULL Talent Mgmt - Describes the relationship of one Catalog Item to another Catalog Item.
C=Is a child of
I=Supports
P=Is a parent of
R=Is Supported By

9 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee 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	JPM_CAT_TYPE	Character(12)	VARCHAR2(12) NOT NULL	The name of the type of items that will be used in a Catalog and or in a Profile.
3	JPM_ITEM_KEY_ID	Number(12,0)	DECIMAL(12) NOT NULL	Unique identifier of an item within a profile. This is the primary key of profile items. It is a generic autoassigned value (a number). The unique key permits the addition of items that are not inheritently unique. They may have the same effective date, item type, item id, yet differ in a property or other value. The concept of key fields in a profile is a loose term as an object in a profile can have very different needs in identification.
4	JPM_JP_SECTION_ID	Number(4,0)	SMALLINT NOT NULL	JPM
5	JPM_CAT_ITEM_ID	Character(12)	VARCHAR2(12) NOT NULL	Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.
6	JPM_CAT_TYPE2	Character(12)	VARCHAR2(12) NOT NULL	Secondary content item type (as in a related item- such as a child or a supporting item of another item).
7	JPM_JP_PSECTION_ID	Number(4,0)	SMALLINT NOT NULL	Parent Section Id on Profile Types
8	JPM_CAT_RLAT_CD	Character(1)	VARCHAR2(1) NOT NULL	Talent Mgmt - Describes the relationship of one Catalog Item to another Catalog Item. C=Is a child of I=Supports P=Is a parent of R=Is Supported By
9	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID