SS_PERS_GRAD_VW (SQL View)	Index Back
Personal Data Name View PERSONAL_VW is a view of Personal Data which retrieves only the name. It is used for the incubent(s) name in Position Management, because the Personal Data record was already being accessed in the panel via work scrolls.

SS_PERS_GRAD_VW

(SQL View)

Personal Data Name View

PERSONAL_VW is a view of Personal Data which retrieves only the name. It is used for the incubent(s) name in Position Management, because the Personal Data record was already being accessed in the panel via work scrolls.

SELECT EMPLID ,NAME FROM PS_PEOPLE_SRCH

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PEOPLE_SRCH

2 NAME Character(50) VARCHAR2(50) NOT NULL Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PEOPLE_SRCH
2	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name