JPM_JPTPACT_LVW (SQL View)	Index Back
Active Profile Types Lang View This is the language version of the search view that allows the user to select active, searchable Profile Types for inclusion in a Profile Group Type.

JPM_JPTPACT_LVW

(SQL View)

Active Profile Types Lang View

This is the language version of the search view that allows the user to select active, searchable Profile Types for inclusion in a Profile Group Type.

SELECT A.JPM_JP_TYPE , LANGUAGE_CD , A.DESCR FROM PS_JPM_JP_TYPE_LNG A WHERE %EffdtCheck(JPM_JP_TYPES, A, %CurrentDateIn)

Related Language Record for JPM_JPTYPACT_VW

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description