PC_PROJT_DELVW

(SQL View)
 Index Back

Projects Search Delete View

Projects Search Delete View used in Delete Query to remove the Search Index.

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , MAX(A.DTTM_STAMP) FROM PS_PC_DEL_AUDIT A WHERE NOT EXISTS ( SELECT 'X' FROM PS_PROJECT B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID) GROUP BY BUSINESS_UNIT,PROJECT_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
3 DELETE_DTTM DateTime(26) TIMESTAMP Delete DTTM