FP_YEARFP_SETID_RANKFP_RANK_CDFP_STATUSEE_CDSETID_DEPTDEPTIDSEXF=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
FP_HDCNT_TYPEH=Physical Headcount
J=Indexical Mass
P=Potential FTE
R=Paid FTE
T=Worked FTE
FP_PERIODEFPAHEADCNT02(SQL Table) |
Index Back |
|---|---|
Hdcnt/service/grade/gender/mthHeadcount by service, grade, gender and month for various types of counting. |
| # | 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_STATUSEE_CD |
Character(1) | VARCHAR2(1) NOT NULL | Employee status |
| 5 | SETID_DEPT |
Character(5) | VARCHAR2(5) NOT NULL | Department SetID |
| 6 | DEPTID |
Character(10) | VARCHAR2(10) NOT NULL | Department |
| 7 | SEX |
Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec |
| 8 | 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 |
| 9 | FP_PERIODE |
Character(7) | VARCHAR2(7) NOT NULL | Year and Month |
| 10 | FP_HEADCNT | Number(12,3) | DECIMAL(11,3) NOT NULL | Headcount |
| 11 | FP_BIRTHYEAR | Character(4) | VARCHAR2(4) NOT NULL | Birthyear |
| 12 | FP_ROOT | Character(1) | VARCHAR2(1) NOT NULL | Variable for Cube Manager |
| 13 | FP_FRSTDAY_YEAR | Date(10) | DATE | Fisrt Day of Year |