RC_PHYLOC_VW (SQL View)	Index Back
Physical Location view Physical Location view. Used in BO Search Setup

RC_PHYLOC_VW

(SQL View)

Physical Location view

Physical Location view. Used in BO Search Setup

SELECT A.BO_ID , B.PHYSICAL_LOCATION FROM PS_RD_PERSON A , PS_RC_WRKR_JOB B WHERE A.PERSON_ID = B.PERSON_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 PHYSICAL_LOCATION Character(30) VARCHAR2(30) NOT NULL Physical Location (Free-Form)

#	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	PHYSICAL_LOCATION	Character(30)	VARCHAR2(30) NOT NULL	Physical Location (Free-Form)