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 |