HCTS_JPM_DTL_VW (SQL View)	Index Back
JPM modal page parameters Used to pass values to the modal page

HCTS_JPM_DTL_VW

(SQL View)

JPM modal page parameters

Used to pass values to the modal page

SELECT ' ' , A.JPM_CAT_ITEM_ID , A.JPM_CAT_TYPE , ' ' , ' ' , ' ' , 0 , 0 , ' ' , ' ' , ' ' FROM PS_JPM_CAT_ITEMS A WHERE A.JPM_CAT_TYPE = 'COMPETENCY'

Related Language Record: HCTS_JPM_DT_LVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DESCR Character(30) VARCHAR2(30) NOT NULL Description

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

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

4 HCTS_ACTUAL_DESCR Character(30) VARCHAR2(30) NOT NULL Description of Actual

5 HCTS_TARGET_DESCR Character(30) VARCHAR2(30) NOT NULL Description of Actual

6 HR_HTMLAREA_01 Long Character CLOB HTML Area

7 HCTS_ACTUAL_VALUE Number(3,0) SMALLINT NOT NULL Actual Value

8 HCTS_TARGET_VALUE Number(3,0) SMALLINT NOT NULL Target Value

9 JPM_CAT_ITEM_QUAL Character(12) VARCHAR2(12) NOT NULL Low Order Item key for Catalog Items when appearing in a Profile. For most Catalog Types, this will be blank - but is available if an Item needs to have multiple instances for a given Effdt in a Profile. Example: for CatalogType = Compentency, there can be multiple instances for a particular Competency, each representing a different evaluation source (Self-Eval, Mgr Eval, Approved/Official, Learning, Recruiting).

10 JPM_CAT_ITEM_QUAL2 Character(12) VARCHAR2(12) NOT NULL Low Order Item key for Catalog Items when appearing in a Profile. For most Catalog Types, this will be blank - but is available if an Item needs to have multiple instances for a given Effdt in a Profile. Example: for CatalogType = Compentency, there can be multiple instances for a particular Competency, each representing a different evaluation source (Self-Eval, Mgr Eval, Approved/Official, Learning, Recruiting).

11 EFFDT Date(10) DATE Effective Date
Default Value: %date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
2	JPM_CAT_ITEM_ID	Character(12)	VARCHAR2(12) NOT NULL	Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.
3	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.
4	HCTS_ACTUAL_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description of Actual
5	HCTS_TARGET_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description of Actual
6	HR_HTMLAREA_01	Long Character	CLOB	HTML Area
7	HCTS_ACTUAL_VALUE	Number(3,0)	SMALLINT NOT NULL	Actual Value
8	HCTS_TARGET_VALUE	Number(3,0)	SMALLINT NOT NULL	Target Value
9	JPM_CAT_ITEM_QUAL	Character(12)	VARCHAR2(12) NOT NULL	Low Order Item key for Catalog Items when appearing in a Profile. For most Catalog Types, this will be blank - but is available if an Item needs to have multiple instances for a given Effdt in a Profile. Example: for CatalogType = Compentency, there can be multiple instances for a particular Competency, each representing a different evaluation source (Self-Eval, Mgr Eval, Approved/Official, Learning, Recruiting).
10	JPM_CAT_ITEM_QUAL2	Character(12)	VARCHAR2(12) NOT NULL	Low Order Item key for Catalog Items when appearing in a Profile. For most Catalog Types, this will be blank - but is available if an Item needs to have multiple instances for a given Effdt in a Profile. Example: for CatalogType = Compentency, there can be multiple instances for a particular Competency, each representing a different evaluation source (Self-Eval, Mgr Eval, Approved/Official, Learning, Recruiting).
11	EFFDT	Date(10)	DATE	Effective Date Default Value: %date