JPM_SRCH_NP_DP

(SQL Table)

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

2 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

3 PTSF_DP_NBR Number(4,0) SMALLINT NOT NULL Index By Data Partition

#	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.
2	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
3	PTSF_DP_NBR	Number(4,0)	SMALLINT NOT NULL	Index By Data Partition