DEPT_BUDGET(SQL Table) |
Index Back |
|---|---|
Dept Budgets by diff. levelsDEPT_BUDGET is the record which contains the Department Budgets Levels and their respective caps. The available options are Department, Position Pool, Position Number, Job Code, and Appointment. There will be one budget record for each level that is chosen in the department. Furthermore, for each cap that is chosen the cap amount is checked against all higher level caps to assure that the lower level cap does not exceed its respective higher level caps. |
| # | 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: SETID_TBL |
| 2 | DEPTID |
Character(10) | VARCHAR2(10) NOT NULL | Department |
| 3 | FISCAL_YEAR |
Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 4 | POSITION_POOL_ID |
Character(3) | VARCHAR2(3) NOT NULL | Position Pool ID |
| 5 | SETID_JOBCODE |
Character(5) | VARCHAR2(5) NOT NULL | Job Code Set ID |
| 6 | JOBCODE |
Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 7 | POSITION_NBR |
Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 8 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 9 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 10 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 11 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL |
Effective Sequence
Default Value: 0 |
| 12 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 13 | BUDGET_LEVEL_INDC | Character(1) | VARCHAR2(1) NOT NULL |
Budget Level
A=Appointment D=Department J=Jobcode O=Position Pool P=Position Default Value: D |
| 14 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL |
| 15 | OVERALL_BDGT_CAP | Number(13,2) | DECIMAL(12,2) NOT NULL | Overall Budget Cap |
| 16 | ERN_BDGT_CAP | Number(13,2) | DECIMAL(12,2) NOT NULL | Earnings Budget Cap |
| 17 | DED_BDGT_CAP | Number(13,2) | DECIMAL(12,2) NOT NULL | Deduction Budget Cap |
| 18 | TAX_BDGT_CAP | Number(13,2) | DECIMAL(12,2) NOT NULL | Tax Budget Cap |
| 19 | ACTION_DT | Date(10) | DATE |
Action Date
Default Value: %date |