OPRROWS_LOC_VW

(SQL View)
Index Back

SELECT TMP.OPRID ,TMP.EMPLID ,TMP.EMPL_RCD FROM PS_OPRROWS_TMP TMP WHERE TMP.ITEMNAME = 'LOCATION_CHANGE' AND TMP.EMPLID <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr