RC_RPRT_BY_SRCH (SQL View)	Index Back
Reported By search view Reported by search view used on support case search, it contains all contact and consumers.

RC_RPRT_BY_SRCH

(SQL View)

Reported By search view

Reported by search view used on support case search, it contains all contact and consumers.

SELECT n.BO_NAME_DISPLAY , n.FIRST_NAME , n.LAST_NAME , r.BO_ID FROM %Table(BO_ROLE) r , %Table(BO_NAME) n WHERE r.ROLE_TYPE_ID IN (8, 9) AND r.BO_ID = n.BO_ID AND n.PRIMARY_IND = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 NAME_REPORTED_BY Character(80) VARCHAR2(80) NOT NULL Reported by name. It's a name field contains the reported by person's name.

2 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name

3 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name

4 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	NAME_REPORTED_BY	Character(80)	VARCHAR2(80) NOT NULL	Reported by name. It's a name field contains the reported by person's name.
2	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
3	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
4	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID