POSN_TOT_FTE_VW (SQL View)	Index Back
Position Incumbent Count

POSN_TOT_FTE_VW

(SQL View)

Position Incumbent Count

SELECT A.POSITION_NBR , A.EFFDT , A.EFFSEQ , COALESCE(( SELECT SUM(WS.FTE) FROM PS_POSN_INCUMB_WS3 WS WHERE WS.POSITION_NBR=A.POSITION_NBR),0) 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 TOTAL_POSN_FTE Number(13,2) DECIMAL(12,2) NOT NULL Total Position FTE

#	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	TOTAL_POSN_FTE	Number(13,2)	DECIMAL(12,2) NOT NULL	Total Position FTE