RC_KBARCL_DEL_V

(SQL View)
 Index Back

Manager ARCL ES Deletion

Closed Cases needs to be revmoed from search index for Performance Insights. Refer to view RC_MGR_BK_ESQ_V

SELECT A.CASE_ID , A.BUSINESS_UNIT , A.DISP_TMPL_FAM_CD , 'Closure' , A.ROW_LASTMANT_DTTM FROM PS_RC_STATUS_TBL B ,PS_RC_CASE A WHERE A.PROVIDER_GRP_ID <> ' ' AND B.SETID = (%Sql(RC_SETID_BU, A.BUSINESS_UNIT, 'RC_STATUS_TBL')) AND B.STATUS_CATEGORY IN ('O','H') AND B.RC_STATUS = A.RC_STATUS AND A.DISP_TMPL_FAM_CD = 'CRM_HHD' AND EXISTS ( SELECT 1 FROM ps_rc_status_log STLOG WHERE STLOG.STATUS_CATEGORY IN ('C','D') AND A.BUSINESS_UNIT=STLOG.BUSINESS_UNIT AND A.CASE_ID=STLOG.CASE_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CASE_ID Number(15,0) DECIMAL(15) NOT NULL Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table.
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 DISP_TMPL_FAM_CD Character(30) VARCHAR2(30) NOT NULL Display Template Family Code
4 CASE_ARRIVALS Character(10) VARCHAR2(10) NOT NULL Contains the string 'Arrivals' for use with charting.
5 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.