JPM_C_LIST_VW (SQL View)	Index Back
Current Active C List Values List of the current active custom list with the values in the list. Used to create the dropdown values by adding a where clause for the fieldname and list id.

JPM_C_LIST_VW

(SQL View)

Current Active C List Values

List of the current active custom list with the values in the list. Used to create the dropdown values by adding a where clause for the fieldname and list id.

SELECT A.JPM_C_LIST_ID , A.JPM_C_LIST_VALUE , A.DESCR100 FROM PS_JPM_C_LIST_ITEM A , PS_JPM_C_LIST_DEFN C WHERE A.JPM_C_LIST_ID = C.JPM_C_LIST_ID AND A.EFFDT = C.EFFDT AND C.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_JPM_C_LIST_DEFN B WHERE C.JPM_C_LIST_ID = B.JPM_C_LIST_ID AND B.EFFDT <=%CurrentDateIn ) AND C.EFF_STATUS = 'A'

Related Language Record: JPM_C_LIST_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 JPM_C_LIST_VALUE Character(12) VARCHAR2(12) NOT NULL List Value

3 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description

#	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	JPM_C_LIST_VALUE	Character(12)	VARCHAR2(12) NOT NULL	List Value
3	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description