DEPT_BUDGET_ERN(SQL Table) |
Index Back |
|---|---|
Department Budget Earn DistDEPT_BUDGET_ERN is the record which contains the Earnings Distributions to Accounts for each of the specified Department Budget Levels. Each Expense can be budgeted differently and sequence numbers can be used to specify priority in the accounts to be charged. For each budget level record there will always be at least one default earnings distribution row. |
| # | 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 SetID |
| 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 Rcd Nbr |
| 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 | ERNCD |
Character(3) | VARCHAR2(3) NOT NULL |
Earnings Code
Prompt Table: EARNINGS_TBL |
| 13 | BUDGET_SEQ |
Number(2,0) | SMALLINT NOT NULL | Budget Sequence |
| 14 | ACCT_CD |
Character(25) | VARCHAR2(25) NOT NULL |
Combination Code
Prompt Table: ACCT_CD_CA_VW |
| 15 | GL_PAY_TYPE | Character(6) | VARCHAR2(6) NOT NULL | General Ledger Pay Type |
| 16 | BUDGET_AMT | Number(19,3) | DECIMAL(18,3) NOT NULL | Budget Amount |
| 17 | HP_EXCESS | Character(1) | VARCHAR2(1) NOT NULL |
Commitment Accounting allowed to exceed budget amount
N=No Y=Yes Y/N Table Edit Default Value: N |
| 18 | DIST_PCT | Number(7,3) | DECIMAL(6,3) NOT NULL | Percent of Distribution |
| 19 | PERCENT_EFFORT | Number(6,2) | DECIMAL(5,2) NOT NULL | % Effort |
| 20 | FUNDING_END_DT | Date(10) | DATE | Funding End Date |
| 21 | HP_USED_DISTRIBUTN | Character(1) | VARCHAR2(1) NOT NULL |
Field to represent if a set of budget earnings, deductions, or taxes have been distributed by the CA distribution process
N=Used only by Payroll Y=Used By Distribution Y/N Table Edit Default Value: N |
| 22 | HP_FRINGE_GROUP | Character(5) | VARCHAR2(5) NOT NULL |
Fringe Group
Prompt Table: HP_FRINGE_GROUP |
| 23 | HP_REDIRECT_ACCT | Character(25) | VARCHAR2(25) NOT NULL | Redirect Account Code |