JPM_APPRMON_VW (SQL View)	Index Back
Items Submitted for Approval Talent Profile items that are being submitted for approval

JPM_APPRMON_VW

(SQL View)

Items Submitted for Approval

Talent Profile items that are being submitted for approval

SELECT I.JPM_JP_TRAN_NUM , I.JPM_PROFILE_ID , I.JPM_CAT_TYPE , I.JPM_CAT_ITEM_ID , I.JPM_CAT_ITEM_QUAL , I.JPM_CAT_ITEM_QUAL2 , I.JPM_ADHOC_DESCR , I.JPM_JP_QUAL_SET , I.JPM_JP_QUAL_SET2 , I.JPM_JP_UPD_ACTION , (CASE WHEN JPM_PARENT_KEY_ID > 0 THEN JPM_PARENT_KEY_ID ELSE JPM_ITEM_KEY_ID END) , (CASE WHEN JPM_PARENT_KEY_ID > 0 THEN 2 ELSE 1 END) FROM PS_JPM_JP_WF_ITEMS I

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 JPM_JP_TRAN_NUM Number(12,0) DECIMAL(12) NOT NULL Transaction Number assigned by JPM when Profile updates are submitted for approval.

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

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

4 JPM_CAT_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.
Prompt Table: JPM_CAT_ITEMS

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

6 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).
Prompt Table: %EDITTABLE3

7 JPM_ADHOC_DESCR Character(80) VARCHAR2(80) NOT NULL Page Title

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_UPD_ACTION Character(1) VARCHAR2(1) NOT NULL Disposition
A=Add
C=Change
D=Delete

11 JPM_SORT1 Character(12) VARCHAR2(12) NOT NULL Sort

12 JPM_SORT2 Character(1) VARCHAR2(1) NOT NULL Sort

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	JPM_JP_TRAN_NUM	Number(12,0)	DECIMAL(12) NOT NULL	Transaction Number assigned by JPM when Profile updates are submitted for approval.
2	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.
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. Prompt Table: JPM_CAT_TYPES
4	JPM_CAT_ITEM_ID	Character(12)	VARCHAR2(12) NOT NULL	Catalog Item Id. Identifies a unique catalog item defintion within a catalog type. Prompt Table: JPM_CAT_ITEMS
5	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). Prompt Table: JPM_JP_QUAL_INS
6	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). Prompt Table: %EDITTABLE3
7	JPM_ADHOC_DESCR	Character(80)	VARCHAR2(80) NOT NULL	Page Title
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_UPD_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Disposition A=Add C=Change D=Delete
11	JPM_SORT1	Character(12)	VARCHAR2(12) NOT NULL	Sort
12	JPM_SORT2	Character(1)	VARCHAR2(1) NOT NULL	Sort