JPM_APRSUM_VW (SQL View)	Index Back
Profile Approval Summary 2 Fluid Approvals

JPM_APRSUM_VW

(SQL View)

Profile Approval Summary 2

Fluid Approvals

SELECT JPM_PROFILE_ID , JPM_JP_TRAN_NUM , '' FROM PS_JPM_JP_WF_HDR

# 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_TEXT1325_1 Long Character(1325) VARCHAR2(1325) Generic Text property for profile items

#	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_TEXT1325_1	Long Character(1325)	VARCHAR2(1325)	Generic Text property for profile items