GVT_HIRE_SRCH

(SQL View)
 Index Back

Hire Search

This is a search record using Emplid or Empl record num.

SELECT EMPLID, EMPL_RCD FROM PS_GVT_EE_KEY

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

Default Value: NEW

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr