RC_AGT_BK_DEL_V

(SQL View)
 Index Back

Agent Backlog PTSF Deletion

Closed Cases needs to be revmoed from search index for Agent Backlog Insights Dashboard. Refer to view RC_AGT_ESKB_V

SELECT A.CASE_ID , A.BUSINESS_UNIT , A.DISP_TMPL_FAM_CD ,B.RC_SHORT_DESCR AS STATUS , A.ASSIGNED_TO , A.CREATION_DATE , A.ROW_LASTMANT_DTTM FROM PS_RC_STATUS_TBL B , PS_RC_CASE A WHERE B.STATUS_CATEGORY IN ('C','D') AND B.RC_STATUS = A.RC_STATUS AND B.SETID = (%Sql(RC_SETID_BU, A.BUSINESS_UNIT, 'RC_STATUS_TBL')) AND A.DISP_TMPL_FAM_CD = 'CRM_HHD'

# 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 RC_SHORT_DESCR5 Character(20) VARCHAR2(20) NOT NULL Short Description
5 ASSIGNED_TO Character(15) VARCHAR2(15) NOT NULL This is a field to store assignment information.
6 CREATION_DATE Date(10) DATE Creation date of the case.
7 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.