RC_CASEINFO_VW4 (SQL View)	Index Back
Call Center View for Reports Used to get the assigned to agent name of the case.

RC_CASEINFO_VW4

(SQL View)

Call Center View for Reports

Used to get the assigned to agent name of the case.

SELECT A.BUSINESS_UNIT , A.CASE_ID , C.BO_NAME , E.NAME FROM PS_RC_CASE A , PS_RC_ASSIGN_VW E , PS_BO_NAME C WHERE A.ASSIGNED_TO = E.ASSIGNED_TO (+) AND A.BO_ID_CONTACT = C.BO_ID (+) AND 'Y' = C.PRIMARY_IND (+)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 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.

3 NAME Character(50) VARCHAR2(50) NOT NULL Name

4 NAME_ASSIGNED_TO Character(80) VARCHAR2(80) NOT NULL The name of the assigned agent.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	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.
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
4	NAME_ASSIGNED_TO	Character(80)	VARCHAR2(80) NOT NULL	The name of the assigned agent.