POSN_CNT_INC_VW (SQL View)	Index Back
Position Incumbent Count

POSN_CNT_INC_VW

(SQL View)

Position Incumbent Count

SELECT A.POSITION_NBR , A.EFFDT , A.EFFSEQ , ( SELECT COUNT(*) FROM PS_POSN_INCUMB_WS3 WS WHERE WS.POSITION_NBR=A.POSITION_NBR) FROM PS_POSITION_DATA_E A

# 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 NOT NULL Effective Date
Default Value: %date

3 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

4 COUNT1 Number(12,0) DECIMAL(12) NOT NULL AUS WGEA counts

#	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 NOT NULL	Effective Date Default Value: %date
3	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
4	COUNT1	Number(12,0)	DECIMAL(12) NOT NULL	AUS WGEA counts