HRS_BIP_JPOSNVW (SQL View)	Index Back
Used in XMLP report for Job O XMLP report Print Job Opening Position

HRS_BIP_JPOSNVW

(SQL View)

Used in XMLP report for Job O

XMLP report Print Job Opening Position

SELECT A.HRS_JOB_OPENING_ID , A.POSITION_NBR , ' ' , A.HRS_JO_PRM_PSN_FLG , B.XLATLONGNAME FROM PS_HRS_JO_POSN_VW A , PSXLATITEM B WHERE B.FIELDVALUE = A.HRS_JO_PRM_PSN_FLG AND B.FIELDNAME = 'HRS_JO_PRM_PSN_FLG' AND %EffdtCheck(PSXLATITEM C,B,%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 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

3 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description

4 HRS_JO_PRM_PSN_FLG Character(1) VARCHAR2(1) NOT NULL Primary position number for job opening
N=No
Y=Yes

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

#	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	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
3	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
4	HRS_JO_PRM_PSN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Primary position number for job opening N=No Y=Yes
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description