JPM_IDX_CTLVW (SQL View)	Index Back
Verity Index Triggers Select Profile Types for verity collection maintenance

JPM_IDX_CTLVW

(SQL View)

Verity Index Triggers

Select Profile Types for verity collection maintenance

SELECT JPM_JP_TYPE FROM PS_JPM_IDX_UPDCTL A , PS_JPM_PROFILE B WHERE A.JPM_PROFILE_ID = B.JPM_PROFILE_ID AND JPM_IDX_PROCESSED IN ('N',' ')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 JPM_JP_TYPE Character(12) VARCHAR2(12) NOT NULL Profile Type name for a JPM Profile Type