FP_YEAREFFDTSETIDDEPTIDFP_CORPS_CDFPADEPT_HD_VW2(SQL View) |
Index Back |
|---|---|
Headcount/Structure View 2 |
| SELECT FP_YEAR , EFFDT , SETID , DEPTID , FP_CORPS_CD , SUM(FP_HDCNT01) , SUM(FP_HDCNT02) , SUM(FP_HDCNT03) , SUM(FP_HDCNT04) , SUM(FP_HDCNT05) , SUM(FP_HDCNT06) , SUM(FP_HDCNT07) , SUM(FP_HDCNT08) , SUM(FP_HDCNT09) , SUM(FP_HDCNT10) , SUM(FP_HDCNT11) , SUM(FP_HDCNT12) , SUM(FP_HDCNTPCT01) , SUM(FP_HDCNTPCT02) , SUM(FP_HDCNTPCT03) , SUM(FP_HDCNTPCT04) , SUM(FP_HDCNTPCT05) , SUM(FP_HDCNTPCT06) , SUM(FP_HDCNTPCT07) , SUM(FP_HDCNTPCT08) , SUM(FP_HDCNTPCT09) , SUM(FP_HDCNTPCT10) , SUM(FP_HDCNTPCT11) , SUM(FP_HDCNTPCT12) FROM PS_FPADEPT_HDCNT WHERE FP_HDCNT_TYP = 'H' GROUP BY FP_YEAR, EFFDT, DEPTID, SETID, FP_CORPS_CD |
| # | 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_HDCNT01 | Number(6,0) | INTEGER NOT NULL | January |
| 7 | FP_HDCNT02 | Number(6,0) | INTEGER NOT NULL | February |
| 8 | FP_HDCNT03 | Number(6,0) | INTEGER NOT NULL | March |
| 9 | FP_HDCNT04 | Number(6,0) | INTEGER NOT NULL | April |
| 10 | FP_HDCNT05 | Number(6,0) | INTEGER NOT NULL | May |
| 11 | FP_HDCNT06 | Number(6,0) | INTEGER NOT NULL | June |
| 12 | FP_HDCNT07 | Number(6,0) | INTEGER NOT NULL | July |
| 13 | FP_HDCNT08 | Number(6,0) | INTEGER NOT NULL | August |
| 14 | FP_HDCNT09 | Number(6,0) | INTEGER NOT NULL | September |
| 15 | FP_HDCNT10 | Number(6,0) | INTEGER NOT NULL | October |
| 16 | FP_HDCNT11 | Number(6,0) | INTEGER NOT NULL | November |
| 17 | FP_HDCNT12 | Number(6,0) | INTEGER NOT NULL | December |
| 18 | FP_HDCNTPCT01 | Number(9,2) | DECIMAL(8,2) NOT NULL | % January |
| 19 | FP_HDCNTPCT02 | Number(9,2) | DECIMAL(8,2) NOT NULL | % February |
| 20 | FP_HDCNTPCT03 | Number(9,2) | DECIMAL(8,2) NOT NULL | % March |
| 21 | FP_HDCNTPCT04 | Number(9,2) | DECIMAL(8,2) NOT NULL | % April |
| 22 | FP_HDCNTPCT05 | Number(9,2) | DECIMAL(8,2) NOT NULL | % May |
| 23 | FP_HDCNTPCT06 | Number(9,2) | DECIMAL(8,2) NOT NULL | % June |
| 24 | FP_HDCNTPCT07 | Number(9,2) | DECIMAL(8,2) NOT NULL | % July |
| 25 | FP_HDCNTPCT08 | Number(9,2) | DECIMAL(8,2) NOT NULL | % August |
| 26 | FP_HDCNTPCT09 | Number(9,2) | DECIMAL(8,2) NOT NULL | % September |
| 27 | FP_HDCNTPCT10 | Number(9,2) | DECIMAL(8,2) NOT NULL | % October |
| 28 | FP_HDCNTPCT11 | Number(9,2) | DECIMAL(8,2) NOT NULL | % November |
| 29 | FP_HDCNTPCT12 | Number(9,2) | DECIMAL(8,2) NOT NULL | % December |