RC_CASEINFO_VW3 (SQL View)	Index Back
Call Center View for Reports Used in Call Center Crystal reports

RC_CASEINFO_VW3

(SQL View)

Call Center View for Reports

Used in Call Center Crystal reports

SELECT A.BUSINESS_UNIT , A.CASE_ID , E.NAME , E.ASSIGNED_TO , E.RC_LAST_NAME , E.RC_FIRST_NAME FROM PS_RC_CASE A , PS_RC_ASSIGN_VW E WHERE A.ASSIGNED_TO = E.ASSIGNED_TO (+)

# 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 ASSIGNED_TO Character(15) VARCHAR2(15) NOT NULL This is a field to store assignment information.

5 RC_LAST_NAME Character(30) VARCHAR2(30) NOT NULL RC_LAST_NAME

6 RC_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name

#	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	ASSIGNED_TO	Character(15)	VARCHAR2(15) NOT NULL	This is a field to store assignment information.
5	RC_LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	RC_LAST_NAME
6	RC_FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name