PERSONAL_DATA (SQL View)	Index Back
Prompt View for Employee Prompt view used for the Employee User Profile Type

PERSONAL_DATA

(SQL View)

Prompt View for Employee

Prompt view used for the Employee User Profile Type

SELECT A.LM_HR_EMPLID , B.NAME , B.LM_NAME_DISPLAY FROM PS_LM_PERSON A , PS_LM_PERS_NAME_VW B WHERE A.LM_PERSON_ID = B.LM_PERSON_ID AND (A.LM_SOURCE_IND = 'HRMS' OR A.LM_SOURCE_IND = 'HR89')

# 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

3 LM_NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display field

#	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
3	LM_NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Name Display field