HRS_BIP_JEDEXVW (SQL View)	Index Back
Used in XMLP report for Job O Used for XMLP Report Print Job Opening. Education and Experience

HRS_BIP_JEDEXVW

(SQL View)

Used in XMLP report for Job O

Used for XMLP Report Print Job Opening. Education and Experience

SELECT A.HRS_JOB_OPENING_ID , A.HRS_JO_RQMT_SEQ , JOBCODE , A.HRS_JO_PRM_JCD_FLG , B.HIGHEST_EDUC_LVL , D.XLATLONGNAME , B.YEARS_OF_EXP FROM PS_HRS_JO_RQMT A , PS_HRS_JO_EDUC_EXP B , PSXLATITEM D WHERE A.HRS_JOB_OPENING_ID = B.HRS_JOB_OPENING_ID AND A.HRS_JO_RQMT_SEQ = B.HRS_JO_RQMT_SEQ AND A.HRS_JO_PRM_JCD_FLG = 'Y' AND D.FIELDNAME = 'HIGHEST_EDUC_LVL' AND D.FIELDVALUE = B.HIGHEST_EDUC_LVL AND D.EFF_STATUS = 'A' AND %EffdtCheck(PSXLATITEM E,D,%CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone

2 HRS_JO_RQMT_SEQ Number(3,0) SMALLINT NOT NULL Job opening requirement sequence

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

4 HRS_JO_PRM_JCD_FLG Character(1) VARCHAR2(1) NOT NULL Primary job code for job opening
N=No
Y=Yes

5 HIGHEST_EDUC_LVL Character(2) VARCHAR2(2) NOT NULL Highest Education Level

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

7 YEARS_OF_EXP Number(5,1) DECIMAL(4,1) NOT NULL Years of Work Experience

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_JOB_OPENING_ID	Number(15,0)	DECIMAL(15) NOT NULL	Job Opening Clone
2	HRS_JO_RQMT_SEQ	Number(3,0)	SMALLINT NOT NULL	Job opening requirement sequence
3	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
4	HRS_JO_PRM_JCD_FLG	Character(1)	VARCHAR2(1) NOT NULL	Primary job code for job opening N=No Y=Yes
5	HIGHEST_EDUC_LVL	Character(2)	VARCHAR2(2) NOT NULL	Highest Education Level
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	YEARS_OF_EXP	Number(5,1)	DECIMAL(4,1) NOT NULL	Years of Work Experience