RC_CASE_SOLVE_V (SQL View)	Index Back
Resolution View This view is used to project all cases and solutions that are solved.

RC_CASE_SOLVE_V

(SQL View)

Resolution View

This view is used to project all cases and solutions that are solved.

SELECT A.BUSINESS_UNIT , A.CASE_ID , B.SOLUTION_ID , A.RC_SUMMARY , A.RC_DESCRLONG , A.PRODUCT_ID FROM PS_RC_CASE A , PS_RC_RESOLUTION B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.CASE_ID = B.CASE_ID AND B.RSLN_STATE = '1' AND B.SOLUTION_ID > 0

# 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 SOLUTION_ID Number(15,0) DECIMAL(15) NOT NULL Solution ID

4 RC_SUMMARY Character(80) VARCHAR2(80) NOT NULL Typically a summary of a long field.

5 RC_DESCRLONG Long Character CLOB Long description used in CallCenter for Problem, Solution...

6 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

#	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	SOLUTION_ID	Number(15,0)	DECIMAL(15) NOT NULL	Solution ID
4	RC_SUMMARY	Character(80)	VARCHAR2(80) NOT NULL	Typically a summary of a long field.
5	RC_DESCRLONG	Long Character	CLOB	Long description used in CallCenter for Problem, Solution...
6	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID