JPM_CLST_DEF_VW (SQL View)	Index Back
All Custom Lists Prompt record for Custom List ID in Content Type Property record and Profile Type Property record.

JPM_CLST_DEF_VW

(SQL View)

All Custom Lists

Prompt record for Custom List ID in Content Type Property record and Profile Type Property record.

SELECT JPM_C_LIST_ID , DESCR , DESCRSHORT , JPM_CAT_MAX_LENGTH FROM PS_JPM_C_LIST_DEFN A WHERE EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_JPM_C_LIST_DEFN B WHERE A.JPM_C_LIST_ID = B.JPM_C_LIST_ID AND B.EFFDT <=%CurrentDateIn )

Related Language Record: JPM_CLSTDEF_LVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 JPM_C_LIST_ID Character(18) VARCHAR2(18) NOT NULL JPM Custom prompt list id

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

3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

4 JPM_CAT_MAX_LENGTH Number(4,0) SMALLINT NOT NULL Specifies the maximum length in characters that a property value in a Catalog Item or Profile Item may be.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	JPM_C_LIST_ID	Character(18)	VARCHAR2(18) NOT NULL	JPM Custom prompt list id
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
4	JPM_CAT_MAX_LENGTH	Number(4,0)	SMALLINT NOT NULL	Specifies the maximum length in characters that a property value in a Catalog Item or Profile Item may be.