HP_BDGT_DEDCHG(SQL Table) |
Index Back |
|---|---|
Budget Changes |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  ACTION_DTTM |
DateTime(26) | TIMESTAMP | Override Date Time |
| 2 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 3 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 4 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 5 | POSITION_POOL_ID | Character(3) | VARCHAR2(3) NOT NULL | Position Pool ID |
| 6 | SETID_JOBCODE | Character(5) | VARCHAR2(5) NOT NULL | Job Code Set ID |
| 7 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 8 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 9 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 10 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 11 | EFFDT | Date(10) | DATE NOT NULL | Effective Date |
| 12 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL |
Effective Sequence
Default Value: 0 |
| 13 | BUDGET_LEVEL_INDC | Character(1) | VARCHAR2(1) NOT NULL |
Budget Level
A=Appointment D=Department J=Jobcode O=Position Pool P=Position |
| 14 | BUDGET_SEQ | Number(2,0) | SMALLINT NOT NULL | Budget Sequence |
| 15 | ACCT_CD | Character(25) | VARCHAR2(25) NOT NULL |
Combination Code
Prompt Table: ACCT_CD_CA_VW |
| 16 | HP_PRIOR_ACCT_CD | Character(25) | VARCHAR2(25) NOT NULL | Previous Account Code before Change |
| 17 | PLAN_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans. |
| 18 | BENEFIT_PLAN | Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan |
| 19 | DEDCD | Character(6) | VARCHAR2(6) NOT NULL | Deduction Code |
| 20 | DED_CLASS | Character(1) | VARCHAR2(1) NOT NULL |
Deduction Classification
A=After-Tax B=Before-Tax L=QC Taxable Benefit N=Nontaxable Benefit P=Nontaxable Btax Benefit T=Taxable Benefit |
| 21 | HP_PREV_EFFDT | Date(10) | DATE | Previous Effective Date |
| 22 | HP_PREV_EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Previous Effective Sequence |
| 23 | HP_NEXT_EFFDT | Date(10) | DATE | Next Effective Date |
| 24 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 25 | PRIOR_EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Prior Effective Status |