RC_CAMPUSID_VW2 (SQL View)	Index Back
Campus ID View Campus ID View, used in BO Search Setup

RC_CAMPUSID_VW2

(SQL View)

Campus ID View

Campus ID View, used in BO Search Setup

SELECT A.BO_ID , A.CAMPUS_ID FROM PS_RD_CONSTITUENT A , PS_RD_PERSON B WHERE B.BO_ID = A.BO_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 CAMPUS_ID Character(16) VARCHAR2(16) NOT NULL Campus ID in the Student Administration database.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
2	CAMPUS_ID	Character(16)	VARCHAR2(16) NOT NULL	Campus ID in the Student Administration database.