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

RC_PRI_HDSS_SVW

(SQL View)

Priority, SS HelpDesk Search

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

SELECT DISTINCT A.BO_ID_PERSON , A.RC_PRIORITY , B.RC_DESCR_SS FROM PS_RC_EMP_CASE A , PS_RC_PRIORITY_TBL B WHERE B.RC_PRIORITY = A.RC_PRIORITY AND B.SETID = ( SELECT E.SETID FROM PS_SET_CNTRL_REC E WHERE E.SETCNTRLVALUE = A.BUSINESS_UNIT AND E.RECNAME = 'RC_PRIORITY_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 RC_PRIORITY Character(5) VARCHAR2(5) NOT NULL Case Priority

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	RC_PRIORITY	Character(5)	VARCHAR2(5) NOT NULL	Case Priority
3	RC_DESCR_SS	Character(30)	VARCHAR2(30) NOT NULL	Description to be shown on Self-Service Pages