RC_INTPRT_SS_VW (SQL View)	Index Back
Interested Parties for SS This is a view off of the interested parties on a case - for self service management. The purpose of this view is to be used to create internal sql to select appropriate case records for interested parties without causing ambiguous references when sql is executed.

RC_INTPRT_SS_VW

(SQL View)

Interested Parties for SS

This is a view off of the interested parties on a case - for self service management. The purpose of this view is to be used to create internal sql to select appropriate case records for interested parties without causing ambiguous references when sql is executed.

SELECT CASE_ID , BUSINESS_UNIT , PERSON_ID , BO_NAME FROM PS_RC_INTEREST_PRT

Audit Record: RC_CASE_AUDIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CASE_ID_SS Number(15,0) DECIMAL(15) NOT NULL case id used to avoid conflict on self service managing view to avoid ambiguous references

2 BU_SS Character(5) VARCHAR2(5) NOT NULL business unit for self service view to avoid ambiguous references

3 PERSON_ID_SS Character(15) VARCHAR2(15) NOT NULL Person id for self service to be used in a view to avoid ambiguous references

4 BO_NAME_SS Character(50) VARCHAR2(50) NOT NULL name field for self service management to avoid ambiguous references

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CASE_ID_SS	Number(15,0)	DECIMAL(15) NOT NULL	case id used to avoid conflict on self service managing view to avoid ambiguous references
2	BU_SS	Character(5)	VARCHAR2(5) NOT NULL	business unit for self service view to avoid ambiguous references
3	PERSON_ID_SS	Character(15)	VARCHAR2(15) NOT NULL	Person id for self service to be used in a view to avoid ambiguous references
4	BO_NAME_SS	Character(50)	VARCHAR2(50) NOT NULL	name field for self service management to avoid ambiguous references