LM_HR_JOBCD_VW (SQL View)	Index Back
Job Code Table Contains the valid HR jobcodes

LM_HR_JOBCD_VW

(SQL View)

Job Code Table

Contains the valid HR jobcodes

SELECT DISTINCT A.LM_HR_JOBCODE ,A.LM_JOBCD_DESCR FROM PS_LM_JOBCODE_TBL A WHERE A.EFFDT <= %CurrentDateIn AND A.LM_END_EFFDT >= %CurrentDateIn

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_HR_JOBCODE Character(15) VARCHAR2(15) NOT NULL Job Code in Human Resources

2 LM_JOBCD_DESCR Character(50) VARCHAR2(50) NOT NULL Job Code Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_HR_JOBCODE	Character(15)	VARCHAR2(15) NOT NULL	Job Code in Human Resources
2	LM_JOBCD_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Job Code Description