JPM_JPCATPRP_VW (SQL View)	Index Back
Profile Type/Cat Type Props Profile Type Properties by Cat Type

JPM_JPCATPRP_VW

(SQL View)

Profile Type/Cat Type Props

Profile Type Properties by Cat Type

SELECT B.JPM_JP_TYPE , A.JPM_CAT_TYPE , B.FIELDNAME , B.JPM_LABEL_TEXT , B.JPM_KEY_FLG , B.JPM_CAT_MIN_VALUE , B.JPM_CAT_MAX_VALUE , B.JPM_CAT_MAX_LENGTH , B.JPM_CAT_REQUIRED , B.JPM_JP_DISPLAY , B.JPM_JP_DISP_SUMM , B.JPM_SRCH_FLG , B.JPM_JP_PROP_SRC , B.JPM_PRP_DEFAULT , B.JPM_PRP_DISPLAY , B.JPM_C_LIST_ID , A.JPM_JP_QUAL_SET , A.JPM_JP_QUAL_SET2 FROM PS_JPM_JP_SECTION A , PS_JPM_JP_PROPS B WHERE %EffdtCheck(JPM_JP_SECTION A1, A, %CurrentDateIn) AND B.JPM_JP_TYPE = A.JPM_JP_TYPE AND B.EFFDT = A.EFFDT AND B.JPM_JP_SECTION_ID = A.JPM_JP_SECTION_ID

Related Language Record: JPM_JPCATPRPLVW

# 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 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
Prompt Table: JPM_JP_PROPS_VW

4 JPM_LABEL_TEXT Character(30) VARCHAR2(30) NOT NULL User defined text to be displayed as a label for a field or property within JPM User Interfaces.

5 JPM_KEY_FLG Character(1) VARCHAR2(1) NOT NULL Indicates if this JPM Profile or Catalog property is to be considered a key on the Profile or Catalog Item.
Y/N Table Edit
Default Value: N

6 JPM_CAT_MIN_VALUE Number(10,2) DECIMAL(9,2) NOT NULL Specifies the minimum value a property in a Catalog Item or Profile Item may be.

7 JPM_CAT_MAX_VALUE Number(10,2) DECIMAL(9,2) NOT NULL Specifies the maximum value a property in a Catalog Item or Profile Item may be.

8 JPM_CAT_MAX_LENGTH Number(4,0) SMALLINT NOT NULL Specifies the maximum length in characters that a property value in a Catalog Item or Profile Item may be.

9 JPM_CAT_REQUIRED Character(1) VARCHAR2(1) NOT NULL Used to indicate that the property, item or relationship must be used.
Y/N Table Edit
Default Value: N

10 JPM_JP_DISPLAY Character(1) VARCHAR2(1) NOT NULL Flag to indicate whether a JPM profile item field should be displayed on the profile item detail page
Y/N Table Edit
Default Value: Y

11 JPM_JP_DISP_SUMM Character(1) VARCHAR2(1) NOT NULL Flag to indicate if field is to be shown on the JPM Profile content summary grid
Y/N Table Edit
Default Value: N

12 JPM_SRCH_FLG Character(1) VARCHAR2(1) NOT NULL When ON indicates that the item, object or property is used during Search/Match processing.
Y/N Table Edit
Default Value: N

13 JPM_JP_PROP_SRC Character(1) VARCHAR2(1) NOT NULL Indicates the source of a JPM catalog property
C=Catalog
P=Profile
Default Value: P

14 JPM_PRP_DEFAULT Character(10) VARCHAR2(10) NOT NULL Property Default
Prompt Table: %EDITTABLE

15 JPM_PRP_DISPLAY Character(1) VARCHAR2(1) NOT NULL Property Display Options
D=Display Only
E=Editable
H=Hidden
Default Value: E

16 JPM_C_LIST_ID Character(18) VARCHAR2(18) NOT NULL JPM Custom prompt list id

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

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

#	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	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: JPM_JP_PROPS_VW
4	JPM_LABEL_TEXT	Character(30)	VARCHAR2(30) NOT NULL	User defined text to be displayed as a label for a field or property within JPM User Interfaces.
5	JPM_KEY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Indicates if this JPM Profile or Catalog property is to be considered a key on the Profile or Catalog Item. Y/N Table Edit Default Value: N
6	JPM_CAT_MIN_VALUE	Number(10,2)	DECIMAL(9,2) NOT NULL	Specifies the minimum value a property in a Catalog Item or Profile Item may be.
7	JPM_CAT_MAX_VALUE	Number(10,2)	DECIMAL(9,2) NOT NULL	Specifies the maximum value a property in a Catalog Item or Profile Item may be.
8	JPM_CAT_MAX_LENGTH	Number(4,0)	SMALLINT NOT NULL	Specifies the maximum length in characters that a property value in a Catalog Item or Profile Item may be.
9	JPM_CAT_REQUIRED	Character(1)	VARCHAR2(1) NOT NULL	Used to indicate that the property, item or relationship must be used. Y/N Table Edit Default Value: N
10	JPM_JP_DISPLAY	Character(1)	VARCHAR2(1) NOT NULL	Flag to indicate whether a JPM profile item field should be displayed on the profile item detail page Y/N Table Edit Default Value: Y
11	JPM_JP_DISP_SUMM	Character(1)	VARCHAR2(1) NOT NULL	Flag to indicate if field is to be shown on the JPM Profile content summary grid Y/N Table Edit Default Value: N
12	JPM_SRCH_FLG	Character(1)	VARCHAR2(1) NOT NULL	When ON indicates that the item, object or property is used during Search/Match processing. Y/N Table Edit Default Value: N
13	JPM_JP_PROP_SRC	Character(1)	VARCHAR2(1) NOT NULL	Indicates the source of a JPM catalog property C=Catalog P=Profile Default Value: P
14	JPM_PRP_DEFAULT	Character(10)	VARCHAR2(10) NOT NULL	Property Default Prompt Table: %EDITTABLE
15	JPM_PRP_DISPLAY	Character(1)	VARCHAR2(1) NOT NULL	Property Display Options D=Display Only E=Editable H=Hidden Default Value: E
16	JPM_C_LIST_ID	Character(18)	VARCHAR2(18) NOT NULL	JPM Custom prompt list id
17	JPM_JP_QUAL_SET	Character(12)	VARCHAR2(12) NOT NULL	1st Instance Qualifier Set Name for a JPM Profile Item
18	JPM_JP_QUAL_SET2	Character(12)	VARCHAR2(12) NOT NULL	2nd Instance Qualifier Set Name for a JPM Profile Item