PERSONAL_DTA_VW(SQL View) |
Index Back |
---|---|
EE Personal Data ViewPERSONAL_DTA_VW is used by Position Management to do the cross-update to PERSONAL_DATA for Benefits Administration event maintenance and COBRA events. It was created to screen the PeopleCode on PERSONAL_DATA out of the Position Data panels and to remove unnecessary fields for efficiency purposes. This view can also be used to select Name when joining with other employment or job level records 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 EMPLID , NAME FROM PS_PERSON_NAME |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: NEW |
2 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |