PERSONAL_DTSAVW (SQL View)	Index Back
SA Personal Data View PERSONAL_DTSAVW is used by Student Admin to select Name when joining with records that contain EMPLID, in PS/Query. There's no Query Security record on this view and thus it should help query performance. Security will still be enforced by the other tables that are joined in.

PERSONAL_DTSAVW

(SQL View)

SA Personal Data View

PERSONAL_DTSAVW is used by Student Admin to select Name when joining with records that contain EMPLID, in PS/Query. There's no Query Security record on this view and thus it should help query performance. Security will still be enforced by the other tables that are joined in.

SELECT A.EMPLID , A.NAME , A.LAST_NAME_SRCH FROM PS_HCR_PERSON_NM_I A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name