HR_SRCH_JOBCDVW (SQL View)	Index Back
Job Code View Job Code view to get current effective dated rows from the Job Code table. This view will be used in Component search for Job Data.

HR_SRCH_JOBCDVW

(SQL View)

Job Code View

Job Code view to get current effective dated rows from the Job Code table. This view will be used in Component search for Job Data.

SELECT A.setid , a.jobcode ,a.effdt ,a.descr , a.lastupddttm FROM PS_JOBCODE_TBL A WHERE A.effdt=( SELECT MAX(A_ED.EFFDT) FROM PS_JOBCODE_TBL A_ED WHERE A_ED.setid=a.setid AND A_ED.jobcode=a.jobcode AND A_ED.effdt <=%CurrentDateIn)

Related Language Record: HR_SRCH_JC_LANG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

3 EFFDT Date(10) DATE Effective Date
Default Value: %date

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

5 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.