FP_YEAREFFDTSETIDDEPTIDFP_CORPS_CDFP_STATUSEE_CDSEXF=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
FP_HDCNT_TYPH=Employees
I=Indexical Mass
FPADEPT_HDCNT(SQL Table) |
Index Back |
|---|---|
Headcount/Structure |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FP_YEAR |
Character(4) | VARCHAR2(4) NOT NULL | Year |
| 2 | EFFDT |
Date(10) | DATE | Effective Date |
| 3 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 4 | DEPTID |
Character(10) | VARCHAR2(10) NOT NULL | Department |
| 5 | FP_CORPS_CD |
Character(6) | VARCHAR2(6) NOT NULL | Corps |
| 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 X=Indeterminate/Intersex/Unspec |
| 8 | FP_HDCNT_TYP |
Character(1) | VARCHAR2(1) NOT NULL |
Head Count Type
H=Employees I=Indexical Mass |
| 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 |