JPM_CAT_ITM_LNV (SQL View)	Index Back
Dynamic RL Content Item Prompt Used by AddProfileItem app class for dynamic Content Item Id prompt processing.

JPM_CAT_ITM_LNV

(SQL View)

Dynamic RL Content Item Prompt

Used by AddProfileItem app class for dynamic Content Item Id prompt processing.

SELECT L.JPM_CAT_TYPE , L.JPM_CAT_ITEM_ID , L.EFFDT , L.LANGUAGE_CD , B.EFF_STATUS , L.JPM_DESCR90 FROM PS_JPM_CAT_ITM_LNG L , PS_JPM_CAT_ITEMS B WHERE B.JPM_CAT_ITEM_ID = L.JPM_CAT_ITEM_ID AND B.JPM_CAT_TYPE = L.JPM_CAT_TYPE AND B.EFFDT = L.EFFDT UNION SELECT I.JPM_CAT_TYPE , I.JPM_CAT_ITEM_ID , I.EFFDT , ' ' , I.EFF_STATUS , I.JPM_DESCR90 FROM PS_JPM_CAT_ITEMS I

# 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.
Prompt Table: JPM_CT_NOHOC_VW

2 JPM_CAT_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.
Prompt Table: JPM_CAT_ITEMS

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

4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

6 JPM_DESCR90 Character(90) VARCHAR2(90) NOT NULL jpm

#	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. Prompt Table: JPM_CT_NOHOC_VW
2	JPM_CAT_ITEM_ID	Character(12)	VARCHAR2(12) NOT NULL	Catalog Item Id. Identifies a unique catalog item defintion within a catalog type. Prompt Table: JPM_CAT_ITEMS
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
6	JPM_DESCR90	Character(90)	VARCHAR2(90) NOT NULL	jpm