RBD_PRSN_VW (SQL View)	Index Back
Person View The View returns all the Individual Objects. It is used to construct a message for the Dashboard Person Dimension.

RBD_PRSN_VW

(SQL View)

Person View

The View returns all the Individual Objects. It is used to construct a message for the Dashboard Person Dimension.

SELECT A.BO_ID , A.PERSON_ID , B.BO_NAME , A.SEX , A.EMPLID , A.ROW_ADDED_DTTM FROM PS_RD_PERSON A , PS_BO B WHERE A.BO_ID = B.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 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

3 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object

4 SEX Character(1) VARCHAR2(1) NOT NULL Gender of the person.
F=Female
M=Male
U=Unknown

5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

6 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

#	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	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
3	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object
4	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender of the person. F=Female M=Male U=Unknown
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
6	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.