JPM_PRF_TYPE_VW (SQL View)	Index Back
Profile View Content types for the profile

JPM_PRF_TYPE_VW

(SQL View)

Profile View

Content types for the profile

SELECT A.JPM_JP_TYPE , A.JPM_CAT_TYPE , A.JPM_JP_SECTION_ID , A.JPM_JP_TABNUM , A.SEQNUM , B.JPM_JP_TABNAME , A.JPM_JP_MULTI_FLG , A.JPM_JP_QUAL_SET , A.JPM_JP_QUAL_SET2 , A.JPM_JP_APPRVL_FLG , A.JPM_JP_PSECTION_ID , A.JPM_CAT_REQUIRED , A.JPM_CAT_RLAT_CD , A.JPM_SECT_SUB_FLG FROM PS_JPM_JP_SECTION A , PS_JPM_JP_TAB B WHERE A.JPM_JP_TYPE = B.JPM_JP_TYPE AND A.JPM_JP_TABNUM = B.JPM_JP_TABNUM AND %EffdtCheck(JPM_JP_TYPES D, A, %CurrentDateIn) AND %EffdtCheck(JPM_JP_TYPES E, B, %CurrentDateIn)

Related Language Record: JPM_PRFTYP_LNVW

# 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

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_JP_SECTION_ID Number(4,0) SMALLINT NOT NULL JPM

4 JPM_JP_TABNUM Number(3,0) SMALLINT NOT NULL Tab number to be moved or re-ordered in a JPM Profile Content Section within a Profile Type

5 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

6 JPM_JP_TABNAME Character(30) VARCHAR2(30) NOT NULL Tab Name

7 JPM_JP_MULTI_FLG Character(1) VARCHAR2(1) NOT NULL Mulitple instances indicator for JPM Profile Items

8 JPM_JP_QUAL_SET Character(12) VARCHAR2(12) NOT NULL 1st Instance Qualifier Set Name for a JPM Profile Item

9 JPM_JP_QUAL_SET2 Character(12) VARCHAR2(12) NOT NULL 2nd Instance Qualifier Set Name for a JPM Profile Item

10 JPM_JP_APPRVL_FLG Character(1) VARCHAR2(1) NOT NULL Flag used in Profile Types to indicate whether approvals are required for a given Catalog Type.

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

12 JPM_CAT_REQUIRED Character(1) VARCHAR2(1) NOT NULL Used to indicate that the property, item or relationship must be used.

13 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

14 JPM_SECT_SUB_FLG Character(1) VARCHAR2(1) NOT NULL This flag is used on the profile type section to identify if the section can have subitems or not.

#	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
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_JP_SECTION_ID	Number(4,0)	SMALLINT NOT NULL	JPM
4	JPM_JP_TABNUM	Number(3,0)	SMALLINT NOT NULL	Tab number to be moved or re-ordered in a JPM Profile Content Section within a Profile Type
5	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
6	JPM_JP_TABNAME	Character(30)	VARCHAR2(30) NOT NULL	Tab Name
7	JPM_JP_MULTI_FLG	Character(1)	VARCHAR2(1) NOT NULL	Mulitple instances indicator for JPM Profile Items
8	JPM_JP_QUAL_SET	Character(12)	VARCHAR2(12) NOT NULL	1st Instance Qualifier Set Name for a JPM Profile Item
9	JPM_JP_QUAL_SET2	Character(12)	VARCHAR2(12) NOT NULL	2nd Instance Qualifier Set Name for a JPM Profile Item
10	JPM_JP_APPRVL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Flag used in Profile Types to indicate whether approvals are required for a given Catalog Type.
11	JPM_JP_PSECTION_ID	Number(4,0)	SMALLINT NOT NULL	Parent Section Id on Profile Types
12	JPM_CAT_REQUIRED	Character(1)	VARCHAR2(1) NOT NULL	Used to indicate that the property, item or relationship must be used.
13	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
14	JPM_SECT_SUB_FLG	Character(1)	VARCHAR2(1) NOT NULL	This flag is used on the profile type section to identify if the section can have subitems or not.