OI_EMPLID_VW

(SQL View)
 Index Back

OI Prompt Tbl - Personal Data

This is a view of the PS_PERSONAL_DATA table to be used as a prompt table for the open item key field values.

SELECT EMPLID , NAME FROM PS_PERSONAL_DATA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPEN_ITEM_KEY Character(30) VARCHAR2(30) NOT NULL Open Item Key
2 NAME Character(50) VARCHAR2(50) NOT NULL Name