POSN_HEADCOUNT (SQL View)	Index Back
Current Headcount by Position POSN_HEADCOUNT is a view which retrieves the current headcount by position. It is included in the HR Query trees to facilitate access to this information in user reporting.

POSN_HEADCOUNT

(SQL View)

Current Headcount by Position

POSN_HEADCOUNT is a view which retrieves the current headcount by position. It is included in the HR Query trees to facilitate access to this information in user reporting.

SELECT A.Position_Nbr ,COUNT(*) FROM PS_JOB A WHERE A.Hr_Status = 'A' AND A.Position_Nbr <> ' ' AND A.Effdt = ( SELECT MAX(C.EffDt) FROM PS_JOB C WHERE C.Emplid = A.Emplid AND C.Empl_Rcd = A.Empl_Rcd AND C.EffDt <= %CurrentDateIn) AND A.EffSeq = ( SELECT MAX(D.EffSeq) FROM PS_JOB D WHERE D.Emplid = A.Emplid AND D.Empl_Rcd = A.Empl_Rcd AND D.EffDt = A.EffDt) GROUP BY Position_Nbr

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 HEAD_COUNT Number(6,0) INTEGER NOT NULL Head Count

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number Prompt Table: POSITION_DATA
2	HEAD_COUNT	Number(6,0)	INTEGER NOT NULL	Head Count