PKG_MDL_EMPL_VW

(SQL View)
Index Back

Sal package - Mdl All view

View ao Applicants and Employee's Package Models

SELECT DISTINCT M.EMPLID , A.NAME FROM PS_PERSON_NAME A , PS_PKG_MDL_TBL M WHERE A.EMPLID = M.EMPLID

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