POSN_BUDGET(SQL Table) |
Index Back |
|---|---|
Dept Budget by Jobcode/Posn#POSN_BUDGET is the record which contains Position Budgets. The Budget Level flag on the Department Table controls the level of detail for the keys in this record. The available options are Department, Job Code, and Position Number. If, for example, Position Number is chosen, there will be one budget record for each position in the department. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SET_VLD_HR_01 |
| 2 | DEPTID |
Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | SETID_JOBCODE |
Character(5) | VARCHAR2(5) NOT NULL |
Job Code Set ID
Prompt Table: DEPT_JOBCODE_S |
| 5 | JOBCODE |
Character(6) | VARCHAR2(6) NOT NULL |
Job Code
Prompt Table: DEPT_JOBCODES |
| 6 | POSITION_NBR |
Character(8) | VARCHAR2(8) NOT NULL |
Position Number
Prompt Table: DEPT_POSITIONS2 |
| 7 | ACTION_DT | Date(10) | DATE |
Action Date
Default Value: %date |
| 8 | POSN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Position Status
A=Approved P=Proposed R=Frozen Default Value: P |
| 9 | REQUEST_HEADCOUNT | Number(3,0) | SMALLINT NOT NULL | Requested Head Count |
| 10 | REQUESTED_FTE | Number(6,2) | DECIMAL(5,2) NOT NULL | Requested FTE |
| 11 | REQUESTED_AMT | Number(19,3) | DECIMAL(18,3) NOT NULL | Requested Amount |
| 12 | REQUEST_DT | Date(10) | DATE | Request Date |
| 13 | APPRVD_HEADCOUNT | Number(5,0) | INTEGER NOT NULL | Approved Head Count |
| 14 | APPRVD_FTE | Number(6,2) | DECIMAL(5,2) NOT NULL | Approved FTE |
| 15 | APPRVD_AMT | Number(19,3) | DECIMAL(18,3) NOT NULL | Approved Amount |
| 16 | APPRVL_DT | Date(10) | DATE | Approval Date |
| 17 | ADJUSTMT_HEADCOUNT | Signed Number(4,0) | DECIMAL(3) NOT NULL | Adjustment Head Count YTD |
| 18 | ADJUSTMT_FTE | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Adjustment FTE YTD |
| 19 | ADJUSTMT_AMT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Adjustment Amount YTD |
| 20 | LAST_ADJUSTMENT_DT | Date(10) | DATE | Last Adjustment Date |
| 21 | CURR_BUDGET_COUNT | Number(4,0) | SMALLINT NOT NULL | Current Budget Head Count |
| 22 | CURR_BUDGET_FTE | Number(7,2) | DECIMAL(6,2) NOT NULL | Current Budget FTE |
| 23 | CURR_BUDGET_AMT | Number(19,3) | DECIMAL(18,3) NOT NULL | Current Budget Amount |
| 24 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL |