FPAHEADCNT02_VW

(SQL View)
 Index Back

Hdcnt/service/grade/gender/mth

Headcount by service, grade, gender 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 , A.SEX , 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 , A.FP_SETID_RANK , A.FP_RANK_CD , A.SEX

# 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 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
8 FP_HDCNTPCT01 Number(9,2) DECIMAL(8,2) NOT NULL % January
9 FP_HDCNTPCT02 Number(9,2) DECIMAL(8,2) NOT NULL % February
10 FP_HDCNTPCT03 Number(9,2) DECIMAL(8,2) NOT NULL % March
11 FP_HDCNTPCT04 Number(9,2) DECIMAL(8,2) NOT NULL % April
12 FP_HDCNTPCT05 Number(9,2) DECIMAL(8,2) NOT NULL % May
13 FP_HDCNTPCT06 Number(9,2) DECIMAL(8,2) NOT NULL % June
14 FP_HDCNTPCT07 Number(9,2) DECIMAL(8,2) NOT NULL % July
15 FP_HDCNTPCT08 Number(9,2) DECIMAL(8,2) NOT NULL % August
16 FP_HDCNTPCT09 Number(9,2) DECIMAL(8,2) NOT NULL % September
17 FP_HDCNTPCT10 Number(9,2) DECIMAL(8,2) NOT NULL % October
18 FP_HDCNTPCT11 Number(9,2) DECIMAL(8,2) NOT NULL % November
19 FP_HDCNTPCT12 Number(9,2) DECIMAL(8,2) NOT NULL % December