FPAHEADCNT03_VW

(SQL View)
 Index Back

Hdcnt/service/body/month

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

SELECT A.FP_YEAR , A.SETID_DEPT , A.DEPTID , A.FP_HDCNT_TYPE , A.FP_CORPS_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_CORPS_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 Set ID
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_CORPS_CD Character(6) VARCHAR2(6) NOT NULL Corps
6 FP_HDCNTPCT01 Number(9,2) DECIMAL(8,2) NOT NULL % January
7 FP_HDCNTPCT02 Number(9,2) DECIMAL(8,2) NOT NULL % February
8 FP_HDCNTPCT03 Number(9,2) DECIMAL(8,2) NOT NULL % March
9 FP_HDCNTPCT04 Number(9,2) DECIMAL(8,2) NOT NULL % April
10 FP_HDCNTPCT05 Number(9,2) DECIMAL(8,2) NOT NULL % May
11 FP_HDCNTPCT06 Number(9,2) DECIMAL(8,2) NOT NULL % June
12 FP_HDCNTPCT07 Number(9,2) DECIMAL(8,2) NOT NULL % July
13 FP_HDCNTPCT08 Number(9,2) DECIMAL(8,2) NOT NULL % August
14 FP_HDCNTPCT09 Number(9,2) DECIMAL(8,2) NOT NULL % September
15 FP_HDCNTPCT10 Number(9,2) DECIMAL(8,2) NOT NULL % October
16 FP_HDCNTPCT11 Number(9,2) DECIMAL(8,2) NOT NULL % November
17 FP_HDCNTPCT12 Number(9,2) DECIMAL(8,2) NOT NULL % December