GVT_NM_DT_VW

(SQL View)
 Index Back

Personal Data Name View

GVT_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 A.EMPLID ,A.EMPL_RCD ,A.EFFDT ,A.EFFSEQ ,A.NAME_DISPLAY ,A.FIRST_NAME ,A.LAST_NAME ,A.MIDDLE_NAME , A.LAST_NAME_SRCH FROM PS_GVT_PERS_DATA A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
5 NAME Character(50) VARCHAR2(50) NOT NULL Name
6 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
7 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
8 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
9 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name