SETIDPrompt Table: SETID_TBL
DEPTIDPrompt Table: DEPT_TBL
EFFDTDefault Value: %date
FP_SETID_RANKPrompt Table: FPM_CA_CTG01_VW
FP_CA_CATG_IDPrompt Table: FPM_CA_CTG02_VW
Prompt Table: FPMRANKGRP_TBL
Default Value: %Date
FPADPTCAHDCT_VW(SQL View) |
Index Back |
|---|---|
Hdcnt / CAEC and ServiceHeadcount by CAE Category and by Service |
| SELECT SETID , DEPTID , EFFDT , FP_SETID_RANK , FP_CA_CATG_ID , FP_RANK_GROUP , FP_HDCNT_BUDG , LAST_UPDATE_DATE FROM PS_FPADPTCAHDCNT01 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 2 | DEPTID |
Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | FP_SETID_RANK |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: FPM_CA_CTG01_VW |
| 5 | FP_CA_CATG_ID |
Character(6) | VARCHAR2(6) NOT NULL |
CAE Category
Prompt Table: FPM_CA_CTG02_VW |
| 6 | FP_RANK_GROUP | Character(6) | VARCHAR2(6) NOT NULL |
Grade Group
Prompt Table: FPMRANKGRP_TBL |
| 7 | FP_HDCNT_BUDG | Number(7,0) | INTEGER NOT NULL | Budget Headcount |
| 8 | LAST_UPDATE_DATE | Date(10) | DATE |
Date of last update
Default Value: %Date |