JPM_JP_WFSTS_VW (SQL View)	Index Back
Catalog Types in Profile Catalog Types in Profile

JPM_JP_WFSTS_VW

(SQL View)

Catalog Types in Profile

SELECT DISTINCT I.JPM_PROFILE_ID , I.JPM_CAT_TYPE , I.JPM_WF_STATUS FROM PS_JPM_JP_WF_ITEMS I

# 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_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

3 JPM_WF_STATUS Character(2) VARCHAR2(2) NOT NULL JPM Workflow Status field
A=Approved
D=Denied
N=New
P=Pending
S=Saved

#	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_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
3	JPM_WF_STATUS	Character(2)	VARCHAR2(2) NOT NULL	JPM Workflow Status field A=Approved D=Denied N=New P=Pending S=Saved