LM_HRROLE_VW (SQL View)	Index Back
Position / Jobcode view Position / Job Code view

LM_HRROLE_VW

(SQL View)

Position / Jobcode view

Position / Job Code view

SELECT DISTINCT B.LM_RLAT_KEY1 , B.LM_RLAT_NAME , B.SETID FROM PS_LM_PROFILES A , PS_LM_PROF_RVAL B WHERE A.LM_PROFILE_ID = B.LM_PROFILE_ID AND B.LM_RLAT_NAME IN ('JOB_CODE', 'POSITION')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_RLAT_KEY1 Character(30) VARCHAR2(30) NOT NULL Rlat Key

2 LM_RLAT_NAME Character(30) VARCHAR2(30) NOT NULL Relationship Name

3 SETID Character(5) VARCHAR2(5) NOT NULL SetID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_RLAT_KEY1	Character(30)	VARCHAR2(30) NOT NULL	Rlat Key
2	LM_RLAT_NAME	Character(30)	VARCHAR2(30) NOT NULL	Relationship Name
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID