HRS_JBCD_FAM_I (SQL View)	Index Back
Job Code and Job Family View Job Code and Job Family View created for use in Job Posting Search Index Pre-Processing Library.

HRS_JBCD_FAM_I

(SQL View)

Job Code and Job Family View

Job Code and Job Family View created for use in Job Posting Search Index Pre-Processing Library.

SELECT B.JOBCODE ,G.SETCNTRLVALUE ,C.JOB_FAMILY ,B.JOB_FUNCTION ,C.HRS_DESCR FROM PS_JOBCODE_TBL B LEFT OUTER JOIN PS_HRS_JOB_FAM_I1 C ON B.JOB_FAMILY = C.JOB_FAMILY , PS_SET_CNTRL_GROUP G WHERE B.SETID = G.SETID AND G.REC_GROUP_ID = ( SELECT H.REC_GROUP_ID FROM PS_REC_GROUP_REC H WHERE H.RECNAME = 'JOBCODE_TBL') AND B.EFFDT = ( SELECT MAX(BE.EFFDT) FROM PS_JOBCODE_TBL BE WHERE BE.SETID = B.SETID AND BE.JOBCODE = B.JOBCODE AND BE.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 SETCNTRLVALUE Character(20) VARCHAR2(20) NOT NULL Tree Definition User Key Value

3 JOB_FAMILY Character(6) VARCHAR2(6) NOT NULL Job Family

4 JOB_FUNCTION Character(3) VARCHAR2(3) NOT NULL Job Function Code

5 HRS_JOB_FAMILY Character(30) VARCHAR2(30) NOT NULL Job family description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
2	SETCNTRLVALUE	Character(20)	VARCHAR2(20) NOT NULL	Tree Definition User Key Value
3	JOB_FAMILY	Character(6)	VARCHAR2(6) NOT NULL	Job Family
4	JOB_FUNCTION	Character(3)	VARCHAR2(3) NOT NULL	Job Function Code
5	HRS_JOB_FAMILY	Character(30)	VARCHAR2(30) NOT NULL	Job family description