JPM_APRCNT_VW (SQL View)	Index Back
Approval Item Count Fluid Approvals

JPM_APRCNT_VW

(SQL View)

Approval Item Count

Fluid Approvals

SELECT A.JPM_PROFILE_ID , A.JPM_JP_TRAN_NUM , A.JPM_CAT_TYPE , C.DESCR , COUNT(*) FROM PS_JPM_JP_WF_ITEMS A , PS_JPM_CAT_TYPES C WHERE C.JPM_CAT_TYPE = A.JPM_CAT_TYPE GROUP BY A.JPM_PROFILE_ID, A.JPM_JP_TRAN_NUM, A.JPM_CAT_TYPE, C.DESCR

Related Language Record: JPM_APRCNT_LVW

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

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

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 DESCR Character(30) VARCHAR2(30) NOT NULL Description

5 JPM_ROW_COUNT Number(3,0) SMALLINT NOT NULL

#	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. Prompt Table: JPM_PROFILE
2	JPM_JP_TRAN_NUM	Number(12,0)	DECIMAL(12) NOT NULL	Transaction Number assigned by JPM when Profile updates are submitted for approval.
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	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	JPM_ROW_COUNT	Number(3,0)	SMALLINT NOT NULL