FPAHEADCNT01_VW

(SQL View)
 Index Back

Hdcnt / service / grade / mnth

Headcount by service, grade and month for various types of counting

SELECT A.FP_YEAR , A.SETID_DEPT , A.DEPTID , A.FP_HDCNT_TYPE , A.FP_SETID_RANK , A.FP_RANK_CD , SUM( A.FP_HDCNTPCT01) , SUM( A.FP_HDCNTPCT02) , SUM( A.FP_HDCNTPCT03) , SUM( A.FP_HDCNTPCT04) , SUM( A.FP_HDCNTPCT05) , SUM( A.FP_HDCNTPCT06) , SUM( A.FP_HDCNTPCT07) , SUM( A.FP_HDCNTPCT08) , SUM( A.FP_HDCNTPCT09) , SUM( A.FP_HDCNTPCT10) , SUM( A.FP_HDCNTPCT11) , SUM( A.FP_HDCNTPCT12) FROM PS_FPAHEADCNT01 A GROUP BY A.FP_YEAR , A.SETID_DEPT , A.DEPTID , A.FP_HDCNT_TYPE , A.FP_SETID_RANK , A.FP_RANK_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FP_YEAR Character(4) VARCHAR2(4) NOT NULL Year
2 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department SetID
3 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
4 FP_HDCNT_TYPE Character(1) VARCHAR2(1) NOT NULL Counting Mode
H=Physical Headcount
J=Indexical Mass
P=Potential FTE
R=Paid FTE
T=Worked FTE
5 FP_SETID_RANK Character(5) VARCHAR2(5) NOT NULL SetID
6 FP_RANK_CD Character(6) VARCHAR2(6) NOT NULL Grade
7 FP_HDCNTPCT01 Number(9,2) DECIMAL(8,2) NOT NULL % January
8 FP_HDCNTPCT02 Number(9,2) DECIMAL(8,2) NOT NULL % February
9 FP_HDCNTPCT03 Number(9,2) DECIMAL(8,2) NOT NULL % March
10 FP_HDCNTPCT04 Number(9,2) DECIMAL(8,2) NOT NULL % April
11 FP_HDCNTPCT05 Number(9,2) DECIMAL(8,2) NOT NULL % May
12 FP_HDCNTPCT06 Number(9,2) DECIMAL(8,2) NOT NULL % June
13 FP_HDCNTPCT07 Number(9,2) DECIMAL(8,2) NOT NULL % July
14 FP_HDCNTPCT08 Number(9,2) DECIMAL(8,2) NOT NULL % August
15 FP_HDCNTPCT09 Number(9,2) DECIMAL(8,2) NOT NULL % September
16 FP_HDCNTPCT10 Number(9,2) DECIMAL(8,2) NOT NULL % October
17 FP_HDCNTPCT11 Number(9,2) DECIMAL(8,2) NOT NULL % November
18 FP_HDCNTPCT12 Number(9,2) DECIMAL(8,2) NOT NULL % December