HP_BDGT_CTXCHG

(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 SetID
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 Rcd Nbr
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 PROVINCE Character(6) VARCHAR2(6) NOT NULL Province
15 TAX_CLASS_CAN Character(3) VARCHAR2(3) NOT NULL Canadian Tax Class
ALL=Total Gross
CBT=Canadian Bonus Tax
CIT=Canadian Income Tax (T4)
CPA=Pension Adjustment
CPP=Canada Pension Plan Employee
CPR=Canada Pension Plan Employer
EIE=Employment Insurance Employee
EIR=Employment Insurance Employer
HTX=Provincial Health Tax
PYT=Payroll Tax
QBT=Quebec Bonus Tax
QCD=Quebec Tax Deduction
QIE=Quebec Parental Plan Employee
QIR=Quebec Parental Plan Employer
QIT=Quebec Income Tax (RL-1)
QPP=Quebec Pension Plan Employee
QPR=Quebec Pension Plan Employer
RV2=Quebec Income Tax (RL-2)
T4A=Canadian Income Tax (T4A)
TRV=True RL
TT4=True T4
16 BUDGET_SEQ Number(2,0) SMALLINT NOT NULL Budget Sequence
17 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code

Prompt Table: ACCT_CD_CA_VW

18 HP_PRIOR_ACCT_CD Character(25) VARCHAR2(25) NOT NULL Previous Account Code before Change
19 HP_PREV_EFFDT Date(10) DATE Previous Effective Date
20 HP_PREV_EFFSEQ Number(3,0) SMALLINT NOT NULL Previous Effective Sequence
21 HP_NEXT_EFFDT Date(10) DATE Next Effective Date
22 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
23 PRIOR_EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Prior Effective Status