JPM_CT_NOHOCLVW (SQL View)	Index Back
Catalog Type No Adhoc Language This related language view defines the different types of Talent Management catalogs and exludes types that are defined as adhoc.

JPM_CT_NOHOCLVW

(SQL View)

Catalog Type No Adhoc Language

This related language view defines the different types of Talent Management catalogs and exludes types that are defined as adhoc.

SELECT B.JPM_CAT_TYPE , B.LANGUAGE_CD , B.DESCR FROM PS_JPM_CAT_TYPES A , PS_JPM_CAT_TYP_LNG B WHERE A.JPM_CAT_TYPE = B.JPM_CAT_TYPE AND A.JPM_ADHOC_FLG <> 'Y'

Related Language Record for JPM_CT_NOHOC_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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