FP_YEARFP_SETID_RANKFP_RANK_CDFP_CNT_MODEB=Budget Headcount
L=Statutory Headcount
SEXF=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
FP_STATUSEE_CDFPARANK_CNT_VW2(SQL View) |
Index Back |
|---|---|
Headcount/Grade - View |
| SELECT FP_YEAR , FP_SETID_RANK , FP_RANK_CD , FP_CNT_MODE , SEX , FP_STATUSEE_CD , FP_HDCNT01 , FP_HDCNT02 , FP_HDCNT03 , FP_HDCNT04 , FP_HDCNT05 , FP_HDCNT06 , FP_HDCNT07 , FP_HDCNT08 , FP_HDCNT09 , FP_HDCNT10 , FP_HDCNT11 , FP_HDCNT12 , FP_HDCNTPCT01 , FP_HDCNTPCT02 , FP_HDCNTPCT03 , FP_HDCNTPCT04 , FP_HDCNTPCT05 , FP_HDCNTPCT06 , FP_HDCNTPCT07 , FP_HDCNTPCT08 , FP_HDCNTPCT09 , FP_HDCNTPCT10 , FP_HDCNTPCT11 , FP_HDCNTPCT12 FROM PS_FPARANK_HDCNT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FP_YEAR |
Character(4) | VARCHAR2(4) NOT NULL | Year |
| 2 | FP_SETID_RANK |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | FP_RANK_CD |
Character(6) | VARCHAR2(6) NOT NULL | Grade |
| 4 | FP_CNT_MODE |
Character(1) | VARCHAR2(1) NOT NULL |
Counting Mode
B=Budget Headcount L=Statutory Headcount |
| 5 | SEX |
Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec |
| 6 | FP_STATUSEE_CD |
Character(1) | VARCHAR2(1) NOT NULL | Employee status |
| 7 | FP_HDCNT01 | Number(6,0) | INTEGER NOT NULL | January |
| 8 | FP_HDCNT02 | Number(6,0) | INTEGER NOT NULL | February |
| 9 | FP_HDCNT03 | Number(6,0) | INTEGER NOT NULL | March |
| 10 | FP_HDCNT04 | Number(6,0) | INTEGER NOT NULL | April |
| 11 | FP_HDCNT05 | Number(6,0) | INTEGER NOT NULL | May |
| 12 | FP_HDCNT06 | Number(6,0) | INTEGER NOT NULL | June |
| 13 | FP_HDCNT07 | Number(6,0) | INTEGER NOT NULL | July |
| 14 | FP_HDCNT08 | Number(6,0) | INTEGER NOT NULL | August |
| 15 | FP_HDCNT09 | Number(6,0) | INTEGER NOT NULL | September |
| 16 | FP_HDCNT10 | Number(6,0) | INTEGER NOT NULL | October |
| 17 | FP_HDCNT11 | Number(6,0) | INTEGER NOT NULL | November |
| 18 | FP_HDCNT12 | Number(6,0) | INTEGER NOT NULL | December |
| 19 | FP_HDCNTPCT01 | Number(9,2) | DECIMAL(8,2) NOT NULL | % January |
| 20 | FP_HDCNTPCT02 | Number(9,2) | DECIMAL(8,2) NOT NULL | % February |
| 21 | FP_HDCNTPCT03 | Number(9,2) | DECIMAL(8,2) NOT NULL | % March |
| 22 | FP_HDCNTPCT04 | Number(9,2) | DECIMAL(8,2) NOT NULL | % April |
| 23 | FP_HDCNTPCT05 | Number(9,2) | DECIMAL(8,2) NOT NULL | % May |
| 24 | FP_HDCNTPCT06 | Number(9,2) | DECIMAL(8,2) NOT NULL | % June |
| 25 | FP_HDCNTPCT07 | Number(9,2) | DECIMAL(8,2) NOT NULL | % July |
| 26 | FP_HDCNTPCT08 | Number(9,2) | DECIMAL(8,2) NOT NULL | % August |
| 27 | FP_HDCNTPCT09 | Number(9,2) | DECIMAL(8,2) NOT NULL | % September |
| 28 | FP_HDCNTPCT10 | Number(9,2) | DECIMAL(8,2) NOT NULL | % October |
| 29 | FP_HDCNTPCT11 | Number(9,2) | DECIMAL(8,2) NOT NULL | % November |
| 30 | FP_HDCNTPCT12 | Number(9,2) | DECIMAL(8,2) NOT NULL | % December |