FP_YEARFP_SETID_RANKFP_RANK_CDFP_CORPS_CDFP_CATG_FPA=A
B=B
C=C
D=D
X=No Existing Category
FP_STATUSEE_CDSEXF=Female
M=Male
U=Unknown
FP_CNT_MODEB=Budget Headcount
L=Statutory Headcount
FPARANK_HDCNT(SQL Table) |
Index Back |
|---|---|
Headcount / Grade |
| # | 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 | Set ID |
| 3 | FP_RANK_CD |
Character(6) | VARCHAR2(6) NOT NULL | Grade |
| 4 | FP_CORPS_CD |
Character(6) | VARCHAR2(6) NOT NULL | Corps |
| 5 | FP_CATG_FP |
Character(2) | VARCHAR2(2) NOT NULL |
Category for FPS
A=A B=B C=C D=D X=No Existing Category |
| 6 | FP_STATUSEE_CD |
Character(1) | VARCHAR2(1) NOT NULL | Employee status |
| 7 | SEX |
Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown |
| 8 | FP_CNT_MODE |
Character(1) | VARCHAR2(1) NOT NULL |
Counting Mode
B=Budget Headcount L=Statutory Headcount |
| 9 | FP_HDCNT01 | Number(6,0) | INTEGER NOT NULL | January |
| 10 | FP_HDCNT02 | Number(6,0) | INTEGER NOT NULL | February |
| 11 | FP_HDCNT03 | Number(6,0) | INTEGER NOT NULL | March |
| 12 | FP_HDCNT04 | Number(6,0) | INTEGER NOT NULL | April |
| 13 | FP_HDCNT05 | Number(6,0) | INTEGER NOT NULL | May |
| 14 | FP_HDCNT06 | Number(6,0) | INTEGER NOT NULL | June |
| 15 | FP_HDCNT07 | Number(6,0) | INTEGER NOT NULL | July |
| 16 | FP_HDCNT08 | Number(6,0) | INTEGER NOT NULL | August |
| 17 | FP_HDCNT09 | Number(6,0) | INTEGER NOT NULL | September |
| 18 | FP_HDCNT10 | Number(6,0) | INTEGER NOT NULL | October |
| 19 | FP_HDCNT11 | Number(6,0) | INTEGER NOT NULL | November |
| 20 | FP_HDCNT12 | Number(6,0) | INTEGER NOT NULL | December |
| 21 | FP_HDCNTPCT01 | Number(9,2) | DECIMAL(8,2) NOT NULL | % January |
| 22 | FP_HDCNTPCT02 | Number(9,2) | DECIMAL(8,2) NOT NULL | % February |
| 23 | FP_HDCNTPCT03 | Number(9,2) | DECIMAL(8,2) NOT NULL | % March |
| 24 | FP_HDCNTPCT04 | Number(9,2) | DECIMAL(8,2) NOT NULL | % April |
| 25 | FP_HDCNTPCT05 | Number(9,2) | DECIMAL(8,2) NOT NULL | % May |
| 26 | FP_HDCNTPCT06 | Number(9,2) | DECIMAL(8,2) NOT NULL | % June |
| 27 | FP_HDCNTPCT07 | Number(9,2) | DECIMAL(8,2) NOT NULL | % July |
| 28 | FP_HDCNTPCT08 | Number(9,2) | DECIMAL(8,2) NOT NULL | % August |
| 29 | FP_HDCNTPCT09 | Number(9,2) | DECIMAL(8,2) NOT NULL | % September |
| 30 | FP_HDCNTPCT10 | Number(9,2) | DECIMAL(8,2) NOT NULL | % October |
| 31 | FP_HDCNTPCT11 | Number(9,2) | DECIMAL(8,2) NOT NULL | % November |
| 32 | FP_HDCNTPCT12 | Number(9,2) | DECIMAL(8,2) NOT NULL | % December |
| 33 | FP_FRSTDAY_YEAR | Date(10) | DATE | Fisrt Day of Year |