GVT_REQ_POSN_VW (SQL View)	Index Back
Positions for the Requisition All the positions in a job requisition in jobcode order.

GVT_REQ_POSN_VW

(SQL View)

Positions for the Requisition

All the positions in a job requisition in jobcode order.

SELECT A.JOB_REQ_NBR , A.JOBCODE , A.POSITION_NBR FROM PS_GVT_RQSN_POSN A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 JOB_REQ_NBR Character(6) VARCHAR2(6) NOT NULL Job requisition number

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

3 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
Prompt Table: POSITION_DATA

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	JOB_REQ_NBR	Character(6)	VARCHAR2(6) NOT NULL	Job requisition number
2	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
3	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number Prompt Table: POSITION_DATA