POS_POOL_VW (SQL View)	Index Back
Position Pool View This view is a list of all positions with their corresponding position pool id's.

POS_POOL_VW

(SQL View)

Position Pool View

This view is a list of all positions with their corresponding position pool id's.

SELECT POSITION_NBR ,EFFDT ,POSITION_POOL_ID FROM PS_POSITION_DATA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

2 EFFDT Date(10) DATE Effective Date

3 POSITION_POOL_ID Character(3) VARCHAR2(3) NOT NULL Position Pool ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
2	EFFDT	Date(10)	DATE	Effective Date
3	POSITION_POOL_ID	Character(3)	VARCHAR2(3) NOT NULL	Position Pool ID