LM_OWNERID_VW

(SQL View)
Index Back

Ownerid view

A view of ownerid to prompt from

SELECT LM_PERSON_ID , LAST_NAME , FIRST_NAME , LAST_NAME_SRCH , FIRST_NAME_SRCH , LM_NAME_DISPLAY , NAME , LM_HR_EMPLID FROM PS_LM_PERS_NAME_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_OWNER_ID Number(15,0) DECIMAL(15) NOT NULL Owner ID
2 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name Field
3 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name field
4 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
5 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
6 LM_NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display field
7 NAME Character(50) VARCHAR2(50) NOT NULL Name
8 LM_HR_EMPLID Character(11) VARCHAR2(11) NOT NULL EMPLID from the HR System