GPBR_C_ITEMS_VW

(SQL View)
 Index Back

Content Item View for LIC

eSocial: Content Items view for Content Type of LIC.

SELECT A.JPM_CAT_ITEM_ID , A.JPM_DESCR90 FROM PS_JPM_CAT_ITEMS A WHERE A.JPM_CAT_TYPE = 'LIC' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_JPM_CAT_ITEMS B WHERE A.JPM_CAT_ITEM_ID = B.JPM_CAT_ITEM_ID AND B.EFF_STATUS = 'A' AND B.JPM_CAT_TYPE = 'LIC' ) AND A.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 JPM_CAT_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.
2 JPM_DESCR90 Character(90) VARCHAR2(90) NOT NULL jpm