FP_YEARSETID_DEPTDEPTIDFP_HDCNT_TYPEH=Physical Headcount
J=Indexical Mass
P=Potential FTE
R=Paid FTE
T=Worked FTE
FPAHEADCNT00_VW(SQL View) |
Index Back |
|---|---|
Year/service type of counting |
| SELECT DISTINCT A.FP_YEAR , A.SETID_DEPT , A.DEPTID , A.FP_HDCNT_TYPE FROM PS_FPAHEADCNT01 A |
| # | 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 |