JPM_VISUALZE_VW (SQL View)	Index Back
scroll rec for Visualize Primary scroll record for Profile Type Content Visualize page.

JPM_VISUALZE_VW

(SQL View)

scroll rec for Visualize

Primary scroll record for Profile Type Content Visualize page.

SELECT JPM_JP_TYPE , EFFDT , JPM_JP_SECTION_ID FROM PS_JPM_JP_SECTION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 JPM_JP_TYPE Character(12) VARCHAR2(12) NOT NULL Profile Type name for a JPM Profile Type

2 EFFDT Date(10) DATE Effective Date
Default Value: %date

3 JPM_JP_SECTION_ID Number(4,0) SMALLINT NOT NULL JPM

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	JPM_JP_TYPE	Character(12)	VARCHAR2(12) NOT NULL	Profile Type name for a JPM Profile Type
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	JPM_JP_SECTION_ID	Number(4,0)	SMALLINT NOT NULL	JPM