SETIDPrompt Table: SETID_TBL
DEPTIDPrompt Table: DEPT_TBL
FP_YEARFP_CORPS_CDPrompt Table: FPMCORPS_TBL
Default Value: %Date
FPMDEPT_BUDG(SQL Table) |
Index Back |
|---|---|
Budgeted Headcount per BodyThis table stores the budgeted headcount per budget year and per body. It is used by the French Public Sector Commitment Accounting functionalities. |
| # | 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 | FP_YEAR |
Character(4) | VARCHAR2(4) NOT NULL | Year |
| 4 | FP_CORPS_CD |
Character(6) | VARCHAR2(6) NOT NULL |
Corps
Prompt Table: FPMCORPS_TBL |
| 5 | FP_HDCNT_BUDG | Number(7,0) | INTEGER NOT NULL | Budget Headcount |
| 6 | LAST_UPDATE_DATE | Date(10) | DATE |
Date of last update
Default Value: %Date |