RC_PT_HDSS_SVW (SQL View)	Index Back
Severity, SS HelpDesk Search This view will only show the existing Severities for the BO_ID_PERSON in the prompt on the HelpDesk Self-Service Search Page.

RC_PT_HDSS_SVW

(SQL View)

Severity, SS HelpDesk Search

This view will only show the existing Severities for the BO_ID_PERSON in the prompt on the HelpDesk Self-Service Search Page.

SELECT DISTINCT A.BO_ID_PERSON , A.PROBLEM_TYPE , B.RC_DESCR_SS FROM PS_RC_EMP_CASE A , PS_RC_PROBTYPE_TBL B WHERE B.PROBLEM_TYPE = A.PROBLEM_TYPE AND B.SETID = ( SELECT E.SETID FROM PS_SET_CNTRL_REC E WHERE E.SETCNTRLVALUE = A.BUSINESS_UNIT AND E.RECNAME = 'RC_PROBTYPE_TBL')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_ID_PERSON Number(31,0) DECIMAL(31) NOT NULL Business Object ID

2 PROBLEM_TYPE Character(8) VARCHAR2(8) NOT NULL Problem Type for Support Cases

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID_PERSON	Number(31,0)	DECIMAL(31) NOT NULL	Business Object ID
2	PROBLEM_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Problem Type for Support Cases
3	RC_DESCR_SS	Character(30)	VARCHAR2(30) NOT NULL	Description to be shown on Self-Service Pages