PERSONAL_DTAAVW (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_DTAAVW

(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.LAST_NAME_SRCH , A.NAME 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_AA

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

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