RC_SS_HE_VW (SQL View)	Index Back
Self Service Higher Ed Cases This view is used to pull all the Cases that are currently open for a customer by using the CUST_ID.

RC_SS_HE_VW

(SQL View)

Self Service Higher Ed Cases

This view is used to pull all the Cases that are currently open for a customer by using the CUST_ID.

SELECT C.BO_ID_CUST ,C.BUSINESS_UNIT ,C.CASE_ID ,C.DISP_TMPL_FAM_CD ,S.RC_STATUS ,S.RC_DESCR_SS ,C.RC_PRIORITY ,C.RC_SUMMARY ,C.CASE_VISIBILITY ,C.CASE_TYPE ,C.CREATION_DATE ,C.ASSIGNED_TO FROM PS_RC_CASE C , PS_RC_STATUS_TBL S WHERE C.RC_VERTICAL = 'SW' AND C.RC_STATUS = S.RC_STATUS AND S.STATUS_CATEGORY IN ('O', 'H') AND S.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = C.BUSINESS_UNIT AND RECNAME = 'RC_STATUS_TBL')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.

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

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

4 DISP_TMPL_FAM_CD Character(30) VARCHAR2(30) NOT NULL Display Template Family Code

5 RC_STATUS Character(5) VARCHAR2(5) NOT NULL Case Status

6 RC_DESCR_SS Character(30) VARCHAR2(30) NOT NULL Description to be shown on Self-Service Pages

7 RC_PRIORITY Character(5) VARCHAR2(5) NOT NULL Case Priority

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

9 CASE_VISIBILITY Character(4) VARCHAR2(4) NOT NULL Field to capture the case visibility.
EXCL=Internal, exclude Case Contact
EXTL=External
INTL=Internal

10 CASE_TYPE Character(5) VARCHAR2(5) NOT NULL Case Type

11 CREATION_DATE Date(10) DATE Creation date of the case.

12 ASSIGNED_TO Character(15) VARCHAR2(15) NOT NULL This is a field to store assignment information.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	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.
4	DISP_TMPL_FAM_CD	Character(30)	VARCHAR2(30) NOT NULL	Display Template Family Code
5	RC_STATUS	Character(5)	VARCHAR2(5) NOT NULL	Case Status
6	RC_DESCR_SS	Character(30)	VARCHAR2(30) NOT NULL	Description to be shown on Self-Service Pages
7	RC_PRIORITY	Character(5)	VARCHAR2(5) NOT NULL	Case Priority
8	RC_SUMMARY	Character(80)	VARCHAR2(80) NOT NULL	Typically a summary of a long field.
9	CASE_VISIBILITY	Character(4)	VARCHAR2(4) NOT NULL	Field to capture the case visibility. EXCL=Internal, exclude Case Contact EXTL=External INTL=Internal
10	CASE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Case Type
11	CREATION_DATE	Date(10)	DATE	Creation date of the case.
12	ASSIGNED_TO	Character(15)	VARCHAR2(15) NOT NULL	This is a field to store assignment information.